Skip to Content
avatar image
Former Member

file to file scenario

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 04, 2008 at 03:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 04, 2008 at 03:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 04, 2008 at 03:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 04, 2008 at 05:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded