on 10-09-2007 3:02 PM
Hi,
I am working with Idoc to File Scenario.
Where my Input is like:
ABC#/XYZ#/m#/po#/ ls#/aq#/anmbe#/cfr#/tre#/~........
My output should be
ABC#/XYZ#/m#/
po#/ ls#/
aq#/anmbe#/cfr#/tre#/
.
.
.
I trying to use UDF to break the ~ and seperate like individual record.
Question 1.
Is there any possibility to work out with out using UDF.
Question 2.
What should be my FCC for this?
Regards,
Manoj
hi Manoj,
check this link
http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/frameset.htm
and use
Record.fieldSeprator=~
if ~ didn't work use the ASCII key for it.
Sachin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
answered
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
At the reciving side for reciving the file use FCC
Record.fieldSeprator=~
Thanks
sudhir sharma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manoj,
Clarify your Scenario...
If it is file at the sender then u can work around with the FCC parameters..
NameA.enclosureSign
NameA.enclosureSignEscape
FCC at Sender Side
http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm
Regards
San
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manoj,
>>File is the receiver in the scenario.
>>I think you have given me details for file Sender.
Yes, I made a statement " If your file is an Sender" in my previous post.
and back to the issue.. for the IDoc adaptere u cannot use any content conversion.
So the solution would be to workaround with the UDF.
I would suggest u to declare an global variable of array type and split your input at ~ only once in one UDF and in the other UDF just return the global array variable with the corresponding Index.
Regards
San
Hi Santosh,
I have used the UDF for this and now able to work. But i have one more issue here at the file reciever.
I need to map the Host_file field details as the output file name in the scenario.
I am collecting a dynamic file name using variable substitution parameter
I am using the content conversions as:
MTmatmas.fieldSeparator ,
ItemList.fieldSeparator ,
ItemList.endSeparator 'nl'
FileName.fieldFixedLengths 0
FileName.endSeparator '0'
FileName.fixedLengthTooShortHandling Cut
I am using a UDF for this. The input for this is:
abcd |
My output should be
a
b
c
d
I am getting the expected output. As we used the end seperator as 'nl' the cursor is on the next line after "d".
My requirement is the cursor should stay after the CRLF function at "d" and do not come to the next line.
Is there any FCC parameter to control this?
Please let me know.
Regards,
Manoj Kumar Musunuri
Hi
you can use the following FCC at the sender side
RECORD.fieldFixedLengths :10,10(suppose)
RECORD.fieldNames :KEY,FNAME,LNAME,AGE
RECORD.keyFieldValue :1
DETAIL.FixedLengths :10,10(suppose)
DETAIL.fieldNames :KEY,SALARY,EMPID
DETAIL.fieldNames :2
Note:these parameters are accoding to the structure given below.
suppose you have a structure like as below
data (0..unbounded)
record (0..unbounded)
key (1..1)
fname (1..1)
lname (1..1)
age (1..1)
detail (0..unbounded)
key (1..1)
salary (1..1)
empid (1..1)
and the input file will look like as below
1,aaa,bbb,23
2,12000,10838
1,ccc,ddd,23
2,13000,10830
n the following FCC at the recever side
childnodename.fieldFixedLength:10,10
childnodename.endSeparator:'nl'
parentnodename.endSeparator:'nl'
if you still face the problemplease reply me back
alsoplease can you provide the source structue and the target structure
Thanks
Rinku
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
U said idoc to file. And then u said ur input is like
ABC#/XYZ#/m#/po#/ ls#/aq#/anmbe#/cfr#/tre#/~...
Please clarify.
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.