file to file scenario

[Former Member]

hi,

in file to file scenario,how to differnitated the header and item when keyvalue is not specified separatetly.

i have flat file like

ord100 1000 10 00

mat1 10 kg

mat2 20 pc

mat3 30 lb

ord200 1000 10 00

mat1 20 pc

mat4 40 kg

first three letters of ord100 (order no) should be identified as keyvalue.similarly with mat1,mat2..

pls help on this.

advance thanks

ravi

[Former Member]

Hi,

Take ORD as the key for the Header data and MAT as the itemdata.

check some links on FCC parameters.

File content conversion sites

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

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

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

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

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Regards,

Phani

[nisarkhan_n]

hhmmm

Is it an fixed length file?

then you can use ORD and MAT as identifier....

if ORD100 is single value then read this in 2 field and concatenate it in mapping.....with this it will be easy...to read

[nisarkhan_n]

Ravi

Key field and the value is snecessary to identiy the recordset strucutre like HEADER and ITEM if you dnt have the keyfiled and its value you cannot places the specific record in header and ITEM you have....

in your case you need to use

ORD

MAT as keyfiled but these are coming with differenet values which makes it difficult to read as it is....

else you need to read the whole row one field and take care in UDF or write an Module which will append the Kayfield agaisnt HEADER row or ITEM row....

if leaagacy is feeding file to XI then ask legacy to add the kayfield value ahead of each row to identoy it as header amd item

[former_member190313]

hi

you have to identify key as first 3 letters that is ord for header & mat for data.

any further questiions

do ask me

Regards

Sheetal