Sender Adapter - Content Conversion Key Field Query

[Former Member]

Hi,

I have a flat file of the following structure I am attempting to convert to XML using a file sender adatper:

H1,H2,H3,H4

D1,D2,D3,D4,D5,D6

D1,D2,D3,D4,D5,D6

D1,D2,D3,D4,D5,D6

.

.

.

.

T1,T2,T3,T4

Within the Content Conversion tab I have a Recordset Structure of:

Header,1,Detail,*,Trailer,1

i.e one header record, multiple detail records and one trailer as per the above example.

It would seem that according to errors generated via Communication Channel Monitoring that this sort of Recordset Structure requires the Key Field Name to be set. I have searched around the forum and looked at the help.sap.com site and I'm struggling to understand what is required here.

Anyone help ?

[baskar_gopalakrishnan2 · Accepted solution]

>>It would seem that according to errors generated via Communication Channel Monitoring that this sort of Recordset Structure requires the Key Field Name to be set. I have searched around the forum and looked at the help.sap.com site and I'm struggling to understand what is required here.

Yes you need to set key field value for your Header, Detail and Trailer

Example:

Header.keyFieldValue    H1
Detail.keyFieldValue     D1
Trailer.keyFieldValue   T1

[Former Member · Accepted solution]

Ok. To do this I would need to have a Key Field Name of something like KeyField

Each of the three substructures would then need to have a field called KeyField at the start of their fieldNames parameter ie:

Header.fieldNames KeyField,............

Detail.fieldNames KeyField,............

Trailer.fieldNames KeyField,...........

Is this correct ?

[Former Member · Accepted solution]

Hi Paul

Yes, it's correct.

Then for each structure, you would need to define the key field value:

Header.keyFieldValue H1

Detail.keyFieldValue D1

Trailer.keyFieldValue T1

Regards,

Giuseppe

[baskar_gopalakrishnan2 · Accepted solution]

Just copy the syntax what I have given above. Thats all.

[Shabarish_Nair]

yes. you will need a key field name to be set in your case, H1, D1 and T1

Sample FCC refer:

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter