Skip to Content
0
Former Member
Dec 01, 2009 at 12:14 PM

XML structure and FCC parameters

39 Views

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