Sender File Adapter (1 Header only, Multiple Detail) withour keyfield ?

[Former Member]

Hi,

is that possible to read file with content converstion for this file structure below :

100,200,10-AUG-2010

ABC,500,100

DEF,400,200

GFD,400,200

Since every file only contain 1 headers there is no idicator header and detail.

Please advise how to achieve this scenario in the sender content conversion parameters.

Best Regards

Fernand

[former_member518917 · Accepted solution]

Hi,

you can go for generic xml structure.

Link: [http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/2174] [original link is broken] [original link is broken] [original link is broken];

steps:

1. content conversion to generix xml structure.

2. Mesage Mapping1 between Generic structure and Sender structure

3. Mesage Mapping2 between Sender structure and target structure

4. Operation Mapping : register both the mapping in sequence.

Thanks

Ritu

[Former Member]

U can do with file content conversion pick up all the data in detail node structure and in Mapping u know that first record is always header then map it accordingly.

chirag

[Former Member]

Hi Chirag,

Actually, the total of header column might not be the same like detail.

100,abc,20-JAN-2011

DEF,ABC,1000,500,2000,300

DEF,ABC,1000,500,2000,300

DEF,ABC,1000,500,2000,300

any advise ?

Best Regards

Fernand

[Former Member]

U create the structure for ur detail record....watever header fields are present in file it will be filled according to ur detail structure and map it accordingly.

chirag

[markangelo_dihiansan]

Hi,

This is possible via FCC as Chirag suggested. You just need to play with the parameters of the content conversion to achieve your requirement, Example:

100,abc,20-JAN-2011
DEF,ABC,1000,500,2000,300
DEF,ABC,1000,500,2000,300
DEF,ABC,1000,500,2000,300

Recordset Structure: header,1,details,*

Recordsets Per Message: 1

Key Fields are left blank

main.fieldSeparator ,

main.endSeparator 'nl'

main.fieldNames field1,field2,date

details.fieldSeparator ,

details.endSeparator 'nl'

details.fieldNames field3,field4,field5,field6,field7,field8

for more information, please refer to this page:

http://help.sap.com/saphelp_nwpi71/helpdata/EN/44/658abd344a4de0e10000000a1553f7/frameset.htm

Hope this helps,

Mark

[Former Member]

Hi Mark,

without Keyfield indicator between header and detail. I am always got this below error in communication channel.

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Mandatory parameter 'xml.keyfieldName': no value found 

Thank You and Best Regards

Fernand

[Former Member]

U dont have to put key field in FCC parameter just confi without Key values.

chirag