Flat file conversion-Ignore data in incoming file(Sender)

[Former Member]

Hi All,

We have a below requirement for sender flat file:

In our datatype we have Recordset

- Item

In file we are getting as

Header(Values)

Item......

Item.....

Trailor(Values)

I want to ignore Header and Trailor data at channel level.Could you please tel me how Can i do that?

Thanks in Advance

Best Regards,

Harleen Kaur Chadha

[Former Member]

Hi Harleen,

> I want to ignore Header and Trailor data at channel level.Could you please tel me how Can i do that?

Ignore the header and trailer fields

without configuring the header and trailer fileds at the communication channel you can work. or you can use the ignore statement for header and trailer at the parameter level.

Regards

Ramesh

[Former Member]

1-Do not configure File content conversion with header and trailer information only configure it with detail records and key value to pick only Detail records.

2 - Use document ofset feature in FCC to ignore header.

chirag

Edited by: Chirag Gohil on Jul 30, 2010 12:26 PM

[Former Member]

Hi ,

Thanks for replying

Can you please povide me which FCC parameter I need to you for acheiving this

Thanks

Best Regards,

harleen Kaur Chadha

[Former Member]

Follow blog configuration

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

Use key field value and key field name in order to pick only detail record.

chirag

[Former Member]

Hi Harleen,

CHeck this links

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

/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts

http://www.riyaz.net/blog/xipi-file-content-conversion-for-complex-structures/ (For fixed length)

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter (Tab delemeter fields)

https://wiki.sdn.sap.com/wiki/display/XI/XI_File_Content

For every parameter and its meaning check this below link

http://help.sap.com/saphelp_srm40/helpdata/ru/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Regards

Ramesh

[Former Member]

Hi,

For the structure mentioned in query

we are receiving data from sender as

Header

Item....

Item...

Trailor

and we have set recordset per message as 1 in communication channel

In sender datatype we have

[Former Member]

harleen r u getting any problem in FCC or RWB file adapter

Which configuration u have used copy paste it here.

chirag

[Former Member]

Hi,

For the structure mentioned in query

we are receiving data from sender as

Records

Header(Values)

Item....

Item...

Trailor

and we have set recordset per message as 1 in communication channel

In sender datatype we have

Records

Header (Field1..1)

Item(Record 1...n)

Trailor(Field 1..1)

Records

We are using ignore parameter to ignore header and Trailor values it works if we are getting one item but if multiple items are coming its failing at channel level.

Could you please suggest which parameter we can use to ignore Header and Trailor using recordset per message as 1 as a option?

Thanks in advance

Best Regards,

Harleen Kaur Chadha

[Former Member]

First of all make the occrrance of header and trailer as 0-1 in data type.

by setting occurance 1 means header n trailer shud occure one time atleas.

As I have already explained u that u have to do only configuration of FCC for detail record using key field n value - weblog is also provided to u.

What configuration u did in FCC copy paste it.

Chirag.