Regarding FCC

[Former Member]

Hi Experts,

There is file to RFC scenario to create PO in ECC system.

The file format is .asc.

The required structure is

<?xml version="1.0" encoding="UTF-8"?>

<ns0:XXXxmlns:ns0="http://sdn.com">

<Recordset>

<Record>

<Key/>

<Vendor/>

<Purchase_Org/>

<Purchase_Group/>

<Company_Code/>

<Doc_Type/>

<Item>

<Key/>

<Material/>

<Plant/>

<Storage_Loc/>

<Quantity/>

<UOM/>

</Item>

<Item>

<Key/>

<Material/>

<Plant/>

<Storage_Loc/>

<Quantity/>

<UOM/>

</Item>

</Record>

</Recordset>

</ns0:XXX>

The input file fomat is

RR3TE001R3TERTER3TENB

2239910300011EA

2239910300012EA

The Record will occur 1 and the item level will occur may times.

I have mentioned the parameter of Recordset Structure as Record,1,Item,*

Key Field name as Key

The following parameter as

Record.fieldFixedLengths 1,7,4,3,4,2

Record.fieldNames Key,Vendor,Purchase_Org,Purchase_Group,Company_Code,Doc_Type

Record.keyFieldValue R

Record.keyFieldInStructure ignore

Item.fieldFixedLengths 1,3,4,4,1,2

Item.fieldNames Key,Material,Plant,Storage_Loc,Quantity,UOM

Item.keyFieldValue 2

Item.keyFieldInStructure ignore

ignoreRecordsetName true

But the file is created as

<?xml version="1.0" encoding="utf-8"?>

<ns:MT_SLSPA_PO_Input_File xmlns:ns="http://project.stylespa.com">

<Recordset>

<Record>

<Vendor>R3TE001</Vendor>

<Purchase_Org>R3TE</Purchase_Org>

<Purchase_Group>RTE</Purchase_Group>

<Company_Code>R3TE</Company_Code>

<Doc_Type>NB</Doc_Type>

</Record>

<Item>

<Material>239</Material>

<Plant>9103</Plant>

<Storage_Loc>0001</Storage_Loc>

<Quantity>1</Quantity>

<UOM>EA</UOM>

</Item>

<Item>

<Material>239</Material>

<Plant>9103</Plant>

<Storage_Loc>0001</Storage_Loc>

<Quantity>2</Quantity>

<UOM>EA</UOM>

</Item>

</Recordset>

</ns:MT_SLSPA_PO_Input_File>

The end tag of <Record>,XII want after </Item>

Otherwise the mapping is getting failure of item due to source XML structure.

Please help to solve the problem where one Record may have multiple item of PO.

Regards,

Amit

[Former Member]

This is solved.

It was my mistake to create the data type.

[Former Member]

...