File Content Conversation in PI7.1

[Former Member]

hi frends,

i have a prob in file content conversion in file to idoc scenario..

my flat file look like ths

100-100,3000,0001,201,1,ST,0000001000

03

20100430,20100430

my senderr fcc is :

Document Name : MT_GM_File_Sender

Document Namespace : http://a.com/xi/erp/n47/GoodsMovement

Recordset Structure : E1BP2017_GM_ITEM_CREATE,1,E1BP2017_GM_CODE,1,E1BP2017_GM_HEAD_01,1

Key field Name : key

E1BP2017_GM_ITEM_CREATE.fieldSeparator ,

E1BP2017_GM_ITEM_CREATE.fieldNames

key,MATERIAL,PLANT,STGE_LOC,MOVE_TYPE,ENTRY_QNT,ENTRY_UOM,COSTCENTER

E1BP2017_GM_ITEM_CREATE.keyFieldValue 01

E1BP2017_GM_ITEM_CREATE.keyFieldInStructure ignore

E1BP2017_GM_ITEM_CREATE.endSeparator 'nl'

E1BP2017_GM_CODE.fieldSeparator ,

E1BP2017_GM_CODE.fieldNames key,GM_CODE

E1BP2017_GM_CODE.keyFieldValue 02

E1BP2017_GM_CODE.keyFieldInStructure ignore

E1BP2017_GM_CODE.endSeparator 'nl'

E1BP2017_GM_HEAD_01.fieldSeparator ,

E1BP2017_GM_HEAD_01.fieldNames key,PSTNG_DATE,DOC_DATE

E1BP2017_GM_HEAD_01.keyFieldValue 03

E1BP2017_GM_HEAD_01.keyFieldInStructure ignore

E1BP2017_GM_HEAD_01.endSeparator 'nl'

ignoreRecordsetName true

my idoc is posted on receiver side...but values are mismatched...its stores in segment as

E1BP2017_GM_HEAD_01(1 segment ) : PSTNG_DATE 20100430

E1BP2017_GM_CODE (2 segment) : no values are thr

E1BP2017_GM_ITEM_CREATE(3 segment) : MATERIAL 3000(values are misplaced)

PLANT 0001

STGE_LOC 201

MOVE_TYPE 1

ENTRY_QNT ST

Kindly help me out to solve ths issue

With Regards,

Dinesh

[Former Member]

Hi Dinesh,

Can you post your Source and Target XML here.....

Cheers

Dhwani

[Former Member]

hi dhwani,

my flatfile values has to be conveted acording to ths xml

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

<ns0:MT_GM_File_Sender xmlns:ns0="http://autoscribe.com/xi/erp/n47/GoodsMovement">

<E1BP2017_GM_ITEM_CREATE>

<key/>

<MATERIAL>100-100</MATERIAL>

<PLANT>3000</PLANT>

<STGE_LOC>0001</STGE_LOC>

<MOVE_TYPE>201</MOVE_TYPE>

<ENTRY_QNT>1</ENTRY_QNT>

<ENTRY_UOM>ST</ENTRY_UOM>

<COSTCENTER>00000010000</COSTCENTER>

</E1BP2017_GM_ITEM_CREATE>

<E1BP2017_GM_CODE>

<key/>

<GM_CODE>03</GM_CODE>

</E1BP2017_GM_CODE>

<E1BP2017_GM_HEAD_01>

<key/>

<PSTNG_DATE>20100430</PSTNG_DATE>

<DOC_DATE>20100430</DOC_DATE>

</E1BP2017_GM_HEAD_01>

</ns0:MT_GM_File_Sender>

adn my target is..

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

- <MBGMCR01>

- <IDOC BEGIN="Constant">

- <EDI_DC40 SEGMENT="Constant">

<TABNAM>Constant</TABNAM>

<DIRECT>Constant</DIRECT>

<IDOCTYP>Constant</IDOCTYP>

<MESTYP>mbgmcr01</MESTYP>

<SNDPOR>Constant</SNDPOR>

<SNDPRT>Constant</SNDPRT>

<SNDPRN>Constant</SNDPRN>

<RCVPOR>Constant</RCVPOR>

<RCVPRN>Constant</RCVPRN>

</EDI_DC40>

- <E1BP2017_GM_HEAD_01 SEGMENT="Constant">

<PSTNG_DATE>20100430</PSTNG_DATE>

<DOC_DATE>20100430</DOC_DATE>

</E1BP2017_GM_HEAD_01>

- <E1BP2017_GM_CODE SEGMENT="Constant">

<GM_CODE>03</GM_CODE>

</E1BP2017_GM_CODE>

- <E1BP2017_GM_ITEM_CREATE SEGMENT="Constant">

<MATERIAL>100-100</MATERIAL>

<PLANT>3000</PLANT>

<STGE_LOC>0001</STGE_LOC>

<MOVE_TYPE>201</MOVE_TYPE>

<ENTRY_QNT>1</ENTRY_QNT>

<ENTRY_UOM>ST</ENTRY_UOM>

<COSTCENTER>0000001000</COSTCENTER>

</E1BP2017_GM_ITEM_CREATE>

</IDOC>

</MBGMCR01>

with Regards,

Dinesh

Edited by: Dineshbabu.M on May 20, 2010 10:03 AM

[Former Member]

Hi Dinesh

The problems is with the keyFieldValue .

keyFieldValue = Specify the value of the key field for the structure. 
This entry is mandatory if the key field name is set. Otherwise, the entry is ignored.

You need a value at the begin of the each line..otherwise if you can ignore then put NameA.fieldFixedLengths.

[Former Member]

hi frends my issue is solved i have given fixed length for every field...and i altered my flatfile accoeding it...thanks alot for everyone..

With Regards,

Dinesh