Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

create multiple records from single xml file.

Hi Friends,

 

   My scenario is file to proxy.

   i need pick the xml file from source and send to the ECC(Ztable)

   In xml file having multiple records.

   example

   

- <InventoryResponse xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" MajorVersion="1" xmlns="http://retalix.com/R10/services">

- <Header>

<Response ResponseCode="OK" />

</Header>

- <InventoryAction ActionCode="Get" Type="Receiving">

<Id>c5af721a-5bcf-46c3-ad79-e4d2debd9cd5</Id>

<Description>Alcoholic Beverages</Description>

<GenerationMethod Source="Nex">Generated</GenerationMethod>

<DateTime TypeCode="EffectiveDate">2014-10-20T22:09:10.0997822+03:00</DateTime>

<DateTime TypeCode="CreationDate">2014-05-07T10:37:27</DateTime>

<DateTime TypeCode="DeliveryDate">2010-01-28T00:00:00</DateTime>

- <InventoryItem>

<ItemID Name="Red Merlot Wine">484129</ItemID>

<Quantity>0</Quantity>

<QuantityForInventoryBalance xsi:type="InventoryItemQuantityType">0</QuantityForInventoryBalance>

<CostForInventoryBalance>8.4</CostForInventoryBalance>

<InventoryBalance>58.000</InventoryBalance>

- <InventoryPackage>

<Package Ratio="5.00000" UnitOfMeasure="Pack" Name="Red Wine S Case" Cost="43.00000" EntityKey="484129RATIO5">10048412951</Package>

<GeneratedCost>42.0000</GeneratedCost>

<GeneratedCost Source="ASN">42.0000</GeneratedCost>

<AdditionalQuantity>1</AdditionalQuantity>

<Operator>admin</Operator>

<DateTime TypeCode="EffectiveDate">2014-05-07T10:37:27</DateTime>

<GenerationMethod Source="Order">Generated</GenerationMethod>

<GeneratedQuantity>5.000</GeneratedQuantity>

<GeneratedQuantity Source="ASN">5.000</GeneratedQuantity>

<IsDefault>true</IsDefault>

</InventoryPackage>

- <InventoryPackage>

<Package Ratio="1" UnitOfMeasure="Each" Name="Red Merlot Wine" Cost="9.50000" EntityKey="484129">10048412911</Package>

<GeneratedCost>9.5000</GeneratedCost>

<GeneratedCost Source="ASN">9.5000</GeneratedCost>

<AdditionalQuantity>1</AdditionalQuantity>

<Operator>admin</Operator>

<DateTime TypeCode="EffectiveDate">2014-05-07T10:37:27</DateTime>

<GenerationMethod Source="Order">Generated</GenerationMethod>

<GeneratedQuantity>100.000</GeneratedQuantity>

<GeneratedQuantity Source="ASN">90.000</GeneratedQuantity>

<IsDefault>false</IsDefault>

</InventoryPackage>

</InventoryItem>

- <InventoryItem>

<ItemID Name="Riesling White Wine">484123</ItemID>

<Quantity>0</Quantity>

<QuantityForInventoryBalance xsi:type="InventoryItemQuantityType">0</QuantityForInventoryBalance>

<CostForInventoryBalance>9.0000</CostForInventoryBalance>

<InventoryBalance>2.000</InventoryBalance>

- <InventoryPackage>

<Package Ratio="1" UnitOfMeasure="Each" Name="Riesling White Wine" Cost="9.20000" EntityKey="484123">1004841231</Package>

<GeneratedCost>9.0000</GeneratedCost>

<GeneratedCost Source="ASN">9.0000</GeneratedCost>

<AdditionalQuantity>1</AdditionalQuantity>

<Operator>admin</Operator>

<DateTime TypeCode="EffectiveDate">2014-05-07T10:37:27</DateTime>

<GenerationMethod Source="Order">Generated</GenerationMethod>

<GeneratedQuantity>45.000</GeneratedQuantity>

<GeneratedQuantity Source="ASN">40.000</GeneratedQuantity>

<IsDefault>true</IsDefault>

</InventoryPackage>

- <InventoryPackage>

  <Package Ratio="10.00000" UnitOfMeasure="Pack" Name="White Wine M Case" Cost="85.00000" EntityKey="484123RATIO10">1004841231101</Package>

  <GeneratedCost>85.0000</GeneratedCost>

  <GeneratedCost Source="ASN">85.0000</GeneratedCost>

  <AdditionalQuantity>1</AdditionalQuantity>

  <Operator>admin</Operator>

  <DateTime TypeCode="EffectiveDate">2014-05-07T10:37:27</DateTime>

  <GenerationMethod Source="Order">Generated</GenerationMethod>

  <GeneratedQuantity>20.000</GeneratedQuantity>

  <GeneratedQuantity Source="ASN">20.000</GeneratedQuantity>

  <IsDefault>false</IsDefault>

  </InventoryPackage>

</InventoryItem>

- <InventoryItem>

<ItemID Name="Bamba">12345</ItemID>

<Quantity>0</Quantity>

<QuantityForInventoryBalance xsi:type="InventoryItemQuantityType">0</QuantityForInventoryBalance>

<CostForInventoryBalance>1.725</CostForInventoryBalance>

<InventoryBalance>2.000</InventoryBalance>

- <InventoryPackage>

<Package Ratio="10.00000" UnitOfMeasure="Pack" Name="10 pack Bamba 50 gr" EntityKey="12345RATIO10">22222</Package>

<GeneratedCost Source="ASN">17.2500</GeneratedCost>

<AdditionalQuantity>1</AdditionalQuantity>

<Operator>admin</Operator>

<DateTime TypeCode="EffectiveDate">2014-10-20T21:42:31</DateTime>

<GenerationMethod Source="AdvancedShipmentNotice">Generated</GenerationMethod>

<GeneratedQuantity Source="ASN">1.000</GeneratedQuantity>

<IsDefault>true</IsDefault>

</InventoryPackage>

</InventoryItem>

<Operator>admin</Operator>

<ApproveOperator>admin</ApproveOperator

In this XML Inventory package is comming multiple times. we need to split each inventory package in to one record and put in Ztables.

Can we do this in Mapping. if its possible please let me know me logic.

i tried but its created only one record.

Thanks,

Bhanu.

Former Member
Not what you were looking for? View more on this topic or Ask a question