How to use the Target Position Variable functionality in Managed Gateway for Spend&Network?

You can follow the steps below to add a Target Position Variable Looping:

1. Right-click on the mapping line.
2. Click Target Variable > Add Position Variable.
3. Click the parent field of the target field.
4. Repeat step 1 and click Add Source Condition.
5. Place the condition on the respective parent field on the source structure.
6. Click Position Variable > OK.

For more information about this functionality, refer to the guide SAP Help Portal > SAP Integration Suite, Managed Gateway for Spend Management and SAP Business Network > SAP Integration Suite, Managed Gateway for Spend Management and SAP Business Network Configuration Guide > Managing Custom Mappings > Editing Custom Mappings > Adding Target Position Variable | SAP Help Portal.

Also, to have more details with screenshots, refer to Target Field concatenating instead of creating multiple lines in Managed Gateway for Spend&Network Mapping Tool - SAP Integration Suite, managed gateway for spend management and SAP Business Network.

We have also delivered a webcast on this topic. You can find the recording in the SAP Article How to access CIG Mapping Tool webcast recording.

There is another way to perform the loop in Managed Gateway for Spend&Network Mapping Tool using the Target Value Variable. You can find the steps to perform this in the KBA How to use the Target Value Variable functionality in Managed Gateway for Spend&Network?

When using the loop functionality in Managed Gateway for Spend&Network Mapping Tool, it is a good practice to always set it after all source and target conditions. It is more certain to work if this is followed, since the Managed Gateway for the Spend&Network Mapping Tool performs the mappings in the order they are maintained. So if the loop has a condition that must be met, it won't run if that condition is set after it.

SAP Integration Suite Managed Gateway > Managed Gateway - Portal > Managed Gateway - Buy Side Mapping tool