Skip to Content
0
Dec 02, 2022 at 02:12 PM

XML Iteration Rule in SAP CI-DS

323 Views

Hi All,

Could you please explain the below XML iteration rule concept applied in Standard CI-DS task.

Please find the details attached.

Iteration Rule "*" applied on AggregatePackageNo and AggregateMaxPackageNo

image.pngThree Input Transforms used in Input (Mapping, AggregateMaxPackageNo and AggregatePackageNo) and mapped to Output XML structure.

image.png

image.png

Sample Input data from View Design Time Data

Mapping Transform (with filter applied for Package Number "51")

image.png

AggregateMaxPackageNo Transform

image.png

AggregatePackageNo transform

image.png

Sample Output data ("15" records with Package Number "51" are grouped) from View Design Time Data

image.png

Here with Iteration Rule (all Records with same Package Number grouped under one XML Node).

As per SAP Help portal "*" is Cross Join

* - Cross operation
Performs a Cartesian product of two or more sources.
When the sources have no parent-child relationship, the behavior is the same as a standard SQL CROSS JOIN.
When the sources have a parent-child relationship, the Cartesian operation provides a mechanism to iterate through all instances of the repeatable elements identified by the source schemas in the operation in the document order.

Could someone explain this XML Iteration Rule behavior.

Attachments

image.png (90.9 kB)
image.png (92.2 kB)
image.png (96.4 kB)
image.png (62.0 kB)
image.png (52.8 kB)
image.png (53.2 kB)
image.png (14.0 kB)
image.png (15.8 kB)
image.png (34.4 kB)