Transformations
Create data transformation for the network table (Signal Link)
Go back to the “SAP O2C - Full Transformation” data job and create a new transformation called “Create Table: Shipment Network (Signal Link)”. Afterwards, perform the following intermediate steps:
Step 1: Insert the SQL script listed in Appendix C.
Step 2: Create transformation parameters for transport modes.
Go to Parameters and create a transformation parameter for each of the four transport modes:
Create a parameter with the name “Shipping_Type_Road”.
Create a parameter with the name “Shipping_Type_Air”.
Create a parameter with the name “Shipping_Type_Sea”.
Create a parameter with the name “Shipping_Type_Rail”.
In total, four transformation parameters should now have been created.
Step 3: Run the data job.