on 08-12-2008 11:48 AM
Hi,
In the file, the header does not containing the key field name as well key field value. but where as in my body those are availble, is it possible to read the file with the FCC adapter if so how it is else say it is not possible.
regards,
Satya.
Hi,
Can u use the option Document offset in FCC.
Under Document Offset, specify the number of lines that are to be ignored at the beginning of the document.
This enables you to skip comment lines or column names during processing. If you do not make an entry, the default value is zero lines.
Chirag
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you dont have any value in file to identify header,
you can create source structure as
MT_Test
-
File ..... 0..Unbounded
-
Record....1
Then you can read entire file in Record, then you will have to apply mapping in order to diff header from Body, as you body contains key field value... Lets say it is B
Then in mapping you will get header elements those are not beginning with 'B'
For all target elements you will have to apply this mapping logic... you can write common UDF and use it wherever possible
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
could you post sample Header and Body Data over here...
so that we can suggest you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for all.
Sample data:
"adfjajfdaskljfadklj"
"adfadfdasfad"
"adfadfa"
"aadfaafasdfaf"
"2";"adfafda";"adfkjadaf";"afdaf";"afdadf"
"2";"adfafda";"adfkjadaf";"afdaf";"afdadf"
"2";"adfafda";"adfkjadaf";"afdaf";"afdadf"
"2";"adfafda";"adfkjadaf";"afdaf";"afdadf"
"2";"adfafda";"adfkjadaf";"afdaf";"afdadf"
in the first 4 lines are header, but in live header is upto maximum 10 lines we don't know how many header lines we are getting at runtime and in header only one field we are considering and field separator and endseparatro for header is 'nl' only. Coming to the body the keyfield name is there and the key field value is 2.
So here the problem is shall we read the body into IS with out header but how to achieve with out reading header. Ofcourse we can use the document offset attribute but the header lines are dynamic between 1 to 10 so we do not have the certain number for the header.
So can any one have any idea on this?
hi satya,
two things look mixed to me...
if you want to ask if 'key field' for sender is mandatory in FCC or not...
ans is: it is not mandatory.
if you mean if you can create a flat file at receiver side without a header or not....
ans is: you can create it. specify <NameA>.addHeaderLine as 0
plz refer
http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm
hope it helps.
thanks.
latika.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
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.