Problem with FCC

[Former Member]

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

[former_member184619 · Accepted solution]

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

[Former Member]

answered

[Former Member]

Hi

At the reciving side for reciving the file use FCC

Record.fieldSeprator=~

Thanks

sudhir sharma

[santhosh_kumarv]

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

[Former Member]

Hi Santosh,

File is the receiver in the scenario.

I think you have given me details for file Sender.

Regards,

Manoj

[santhosh_kumarv]

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

[Former Member]

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:

a_bc_d |

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

[Former Member]

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

[prateek]

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