XML structure and FCC parameters

[Former Member]

Hi Experts,

Kindly help me with the XML structure and FCC parameters for the following sample of text file

I am new to Text Files and FCC.

=================================================================================

Header

" name of the company " ,1

" abc 2,10/01/1972",4

Line items

"ADFERT",KARNATAKA,CHIPS,G,45.560000,72.190000,100.983000,76.266000,J

"GHTJEN",KERALA,BANANAS,G,1.135000,0.714850,1,0.755000,J

Trailer

DDDDDDDDD,B

================================================================================

It is a CSV

Header 1st line , first field is Variable length and 2nd field is 1 char

Header 2nd line , first field is Variable length and 2nd field is date and last field is 1 char

Line items

first field fixed length 6 char but

2nd field can be of any length

3rd field can be of any length

4th field 1 char

5th field can be of any length

6th field can be of any length

7th field can be of any length

8th field can be of any length

9th field 1 char

and then the Trailer

Please help in the structure and content conversion parameters

also following questions :

a) I have to pick up this file and pass to a proxy in AbAP on target side , so do i just create a service interface and in ECC --> Sproxy and identify my SI and do a Create Proxy ? or is there anything else required ?

b) The Date in the header needs to be passed onto ECC as a parameter so in my XML structure in the data type do i include that as a field in the mapping ..Can any one please guide me to create the Data type structure for the above file ?

c) DO I NEED A MAPPING FOR THIS ?? THERE ARE NO CONVERSIONS required ? what are the IR and ID steps required

if it is a FILE to Proxy scenario with no mappings

Please help

thanks

Dev

[Former Member · Accepted solution]

Hi Dev,

> a) I have to pick up this file and pass to a proxy in AbAP on target side , so do i just create a service interface and in ECC --> >Sproxy and identify my SI and do a Create Proxy ? or is there anything else required ?

Yes you need to create the service interface and go to the sproxy code and generate the proxy code.

> b) The Date in the header needs to be passed onto ECC as a parameter so in my XML structure in the data type do i include >that as a field in the mapping ..Can any one please guide me to create the Data type structure for the above file ?

In this case mapping is required.

data type structure:

Sendet_DT

Header 0..1

date 0.1

... (if any other fields are there)

Item 0..unbound

itemfield1

.....

> c) DO I NEED A MAPPING FOR THIS ?? THERE ARE NO CONVERSIONS required ? what are the IR and ID steps required

> if it is a FILE to Proxy scenario with no mappings

Mapping is not mandatory, but date field is there so mapping required.

Receiver side is proxy so you have to create the receiver CC with adapter as XI.

Remaining ateps all are normal.

Regards

Ramesh

[Former Member · Accepted solution]

Thanks Ramesh

Is the below DT structure ok ?

Sender_DT

Header 0..1

date 0.1

... Item 0..unbound

itemfield1

......

......

......

item field N .....

Trailer 0. ..1

What about the File Content conversion parameters , can you help me with those

My question regarding the structure you gave was .. header contains two lines and the 2nd line has Date so should i just include Date under header in my DT ? what about the other strings ?

b) In FCC what will be the values for fieldnames ?

I am having issues figuring out what will be the FCC parameters in order to pick up the date from the header and also to pass the fields in Linte items if they have 5 fields in each line items

thanks

Dev

[Former Member · Accepted solution]

Hi Dev,

Full Data type is as follows

Sender_DT

order_recordset 0..1

order_header 0..1

header-1 0..1

date 0..1

order_Item 0..unbound

item-1 0..1

item-2 0..1

item-3 0..1

....

item-n 0..1

order_Trailer 0..1

trailer-1 0..1

trailer-2 0..1

.......

trailer-n 0..1

> What about the File Content conversion parameters , can you help me with those

order_header.fieldNames : f1,date

order_header.fieldSeparator : <give the fiels separater , [if it is comma])

order_header.endSeparator : 'nl' (if it is new line characters)

order_item.fieldNames : i1,i2,.....

order_item.fieldSeparator : :

order_item.endSeparator : 'nl'

order_Trailer.fieldNames : t1,t2,.....

order_Trailer.fieldSeparator : :

order_Trailer.endSeparator : 'nl'

If any of the two structures (header, item or trailer) in the field name is same then we have to use the key field

Check this link

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417600)ID1157374550DB11273870171440820710End...

> b) In FCC what will be the values for fieldnames ?

Check this link

https://wiki.sdn.sap.com/wiki/display/XI/XI_File_Content

Regards

Ramesh

[sunil_singh13 · Accepted solution]

Hi sd,

b) In FCC what will be the values for fieldnames ?

u need not to provide the filed values in FCC as these values will be read from the file(.csv).

Thanks,

Sunil Singh

[Former Member · Accepted solution]

Thanks Ramesh for your inputs

Solved !