Skip to Content
avatar image
Former Member

How to remove Header, Details, Trailer column name(description) from csv file in FCC

Hi Experts,

What is the parameter to remove the header and details column names in FCC?

my csv structure is:

H|OrderNo|Vendor|ShipToGLN|Date

H|407654598|3422091143478|221544671|20150501

D|LineNumber|Code

D|00001|32

T|OrderVal

T|1122.65

I don't want highlighted(bold) values in xml. please suggest how to achieve that.

Thanks

Navneet.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • May 27, 2015 at 05:44 AM

    Hello Navneet,

    I would like to echo Chandrabhan's statement.

    Making Document offset as 1 should solve your problem.

    Please see below snapshot :

    Thanks,

    Satanik


    pastedImage_2.png (63.2 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 27, 2015 at 05:26 AM

    Hi Navneet,

    In channel FCC paramters make document offset as 1.

    That would wok

    Add comment
    10|10000 characters needed characters exceeded

  • May 27, 2015 at 07:58 AM

    Hi,

    Well there is no standard feature in FCC parameters to ignore intermediate rows. You should allow them into your XML with FCC and ignore the unnecessary data from XML using simple conditions with standard graphical mapping functions

    And as others pointed out, I hope now you know about "Document Offset" and it's purpose


    //BR,

    Praveen Gujjeti

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 27, 2015 at 10:43 AM

    Thanks All for your answers.

    As Ambuj said, Document offset is applicable only on the starting rows and not the intermediate ones and i have tried that.

    If there is no way to handle it in FCC, the last option would be mapping.

    still, i was wondering if we can do it using key field in FCC as this is a very common requirement and SAP should provide a parameter for this.

    Thanks

    Navneet.

    Add comment
    10|10000 characters needed characters exceeded