on 03-02-2008 11:40 AM
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Paste your input file strucutre?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.