cancel
Showing results for 
Search instead for 
Did you mean: 

Sender File Content Conversion Issue

Former Member
0 Kudos

I have the following flat file

BAPIAAHDR,,,,,
CO_AREA,DOCDATE,POSTGDATE,VARIANT  ,DOC_HDR_TX,USERNAME
1000,20071130,20071130,10SAP,SLA-GS Nov 2007,24254
,,,,,
BAPIAAITM,,,,,
SEND_CCTR,ACTTYPE,ACTVTY_QTY,REC_CCTR,REC_ORDER,REC_WBS_EL
0606010101,61002C,40,0202041011,,
0606010102,61003C,20,0202041001,,
0606010201,61002C,32,0202041401,,

I want to send this file as XML using the file content conversion.

I was able to to read the headers correctly using KeyFieldValue.

However I didn't figure out away to read the transactions line 0606010101,61002C,40,0202041011.

is there any way I can start reading the transactions from a specific line (e.g. Line 7)??

any other useful ideas will be appreciated

Regards,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI,

In File adapter there is option to ignore Header line

Refer parameters

FCC

Ref:

Sender -

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

Key value:

/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/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

Receiver FCC no need of Endseparator

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

Receiver-

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

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

Please see the below links for file content conversion..

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

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

File Content Conversion for Unequal Number of Columns

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

Content Conversion (Pattern/Random content in input file)

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

/people/harrison.holland5/blog/2006/12/20/xi-configuration-for-mdm-integration--sample-scenario - FCC - MDM

XI in the role of a FTP

/people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp - FCC

File to R/3 via ABAP Proxy

/people/prateek.shah/blog/2005/06/14/file-to-r3-via-abap-proxy - FCC

/people/mickael.huchet/blog/2006/09/18/xipi-how-to-exclude-files-in-a-sender-file-adapter - EOIO - File

http://help.sap.com/saphelp_nw04/helpdata/en/ee/c9f0b4925af54cb17c454788d8e466/frameset.htm - cc

http://help.sap.com/saphelp_erp2005vp/helpdata/en/95/bb623c6369f454e10000000a114084/content.htm - fcc cOUNTER

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/da1e7c16-0c01-0010-278a-eaed5eae... - conversion agent

Thanks

Swarup

Answers (6)

Answers (6)

Former Member
0 Kudos

Since there is no other way to identify the transaction line I had to ask the legacy team to include a key field before every line of the transactions.

Former Member
0 Kudos

Hi Nisar,

there is already a header just before line 7 as you can see from the source:

BAPIAAHDR,,,,,
CO_AREA,DOCDATE,POSTGDATE,VARIANT  ,DOC_HDR_TX,USERNAME
1000,20071130,20071130,10SAP,SLA-GS Nov 2007,24254
,,,,,
BAPIAAITM,,,,,
SEND_CCTR,ACTTYPE,ACTVTY_QTY,REC_CCTR,REC_ORDER,REC_WBS_EL
0606010101,61002C,40,0202041011,,
0606010102,61003C,20,0202041001,,
0606010201,61002C,32,0202041401,,

is there away to tell the communication channel that whatever comes after this header is a transaction record ?

Regards,

nisarkhan_n
Active Contributor
0 Kudos

i doubt there is a way.....but i am not sure....possible solution would be ask the legacy to attach and Heade beofre the transcation set data....

wait for others reply also....

Former Member
0 Kudos

Guys

thank you very much for the useful links,

Venkat,

The offset parameters will be applicable to the whole file, Can I limit it to the transaction part only?

my problem I don't have auniqe value that I can use as a keyFieldValue the transaction part, but the transactions always start from line 7.

nisarkhan_n
Active Contributor
0 Kudos

you cannot read that line with out any keyfield value...since you have multiple recrdset strucutre you need an identifier to push it to an particular recordset....ask the legacy to attach an header beofre line 7 to identify and dnt pass that value to target.

nisarkhan_n
Active Contributor
0 Kudos

Paste your input file strucutre?

Former Member
0 Kudos

Yes we can start reading the transactions from a specific line.

In the communication channel, after you select file content then you will get the file content parameters, on that document offset column is there, here we specify the row and column position.

By default it is 1,1(first row and first column)

EX : If we give 7,5 then it will takes the data from 7th line 5th column on words.

VijayKonam
Active Contributor
0 Kudos

Depending on the key field, you have to define to record sets in the FCC parameters and then mentions their occurances as Header,1, LineItem,*.

One more thing here is you might have to ask the user not to give the line item header in the middle of the file. Otherwise, you would have to get rid of this in mapping.

Refer to -

http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm

VJ