Skip to Content

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

File content Conversion parameters

Hi Guys,

In our Requirement, Receiver payload is

<ns0:CustomerPORequest xmlns:ns0="http://www.planetretail.in/ERP/BS_CustomerPO">

<PurchaseOrder>

<OrderDetails>

<Marker>ABC</Marker>

<DeliveryDate>20/08/2008</DeliveryDate>

<Store>45</Store>

<RequisitionCode>AC120</RequisitionCode>

<ConsignmentNo>A85</ConsignmentNo>

<ItemDetails>

<Marker>ABC</Marker>

<ProductCode>A2536</ProductCode>

<Language>EN</Language>

<Quantity>200</Quantity>

<PackSize>20</PackSize>

<LineNumber>10</LineNumber>

</ItemDetails>

<ItemDetails>

<Marker>ABC</Marker>

<ProductCode>A2841</ProductCode>

<Language>EN</Language>

<Quantity>50</Quantity>

<PackSize>10</PackSize>

<LineNumber>15</LineNumber>

</ItemDetails>

</OrderDetails>

</PurchaseOrder>

<PurchaseOrder>

<OrderDetails>

<Marker>XYZ</Marker>

<DeliveryDate>24/09/2008</DeliveryDate>

<Store>50</Store>

<RequisitionCode>AC128</RequisitionCode>

<ConsignmentNo>A52</ConsignmentNo>

<ItemDetails>

<Marker>XYZ</Marker>

<ProductCode>A2533</ProductCode>

<Language>EN</Language>

<Quantity>300</Quantity>

<PackSize>50</PackSize>

<LineNumber>23</LineNumber>

</ItemDetails>

</OrderDetails>

</PurchaseOrder>

</ns0:CustomerPORequest>

In Receiver payload comes multiple PurchaseOrder and each purchase order comes multiple Item details. But we need Purcahse order details comes one line and each item details comes seprate line.So,now we using File Content Conversion, we need following output

ABC20/08/200845AC120A85

ABC*A2536EN20020*10

ABC*A2841EN5010*15

XYZ24/09/200850AC128A52

XYZ*A2533EN30050*23

Now we got this output

ABC

XYZ

So, please any one tell what are parameters i give in File content conversion

( Recordset structure , parameter name and value.)

Pls don't refer links.

Thanks & Regards

Vijay

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