File content conversion

[Former Member]

Hi,

I am doing a flat file to webservice scenario where I need to use file content conversion.There are L1,L2 and L3 by which I need to identify them.Can you help me how do I declare the parameters for content conversion in adapter.Sample file as below

L1PO#,Line#,Text,StDate,EndDate,Vendor,POValue,ExpectedValue,Plant,OrderType

L2WO#,Desc,StDate,EndDate,Plant,Priority,Status,ActStTime,ActEndTime,FuncLoc,FuncDesc,OrderType

L3OP#,OPDesc,StDate,EndDate,ActStDate,ActEndDate,WorkCenter,OrderType

L1PO#,Line#,Text,StDate,EndDate,Vendor,POValue,ExpectedValue,Plant,OrderType

L2WO#,Desc,StDate,EndDate,Plant,Priority,Status,ActStTime,ActEndTime,FuncLoc,FuncDesc,OrderType

L1PO#,Line#,Text,StDate,EndDate,Vendor,POValue,ExpectedValue,Plant,OrderType

L2WO#,Desc,StDate,EndDate,Plant,Priority,Status,ActStTime,ActEndTime,FuncLoc,FuncDesc,OrderType

L3OP#,OPDesc,StDate,EndDate,ActStDate,ActEndDate,WorkCenter,OrderType

L3OP#,OPDesc,StDate,EndDate,ActStDate,ActEndDate,WorkCenter,OrderType

Ll3OP#,OPDesc,StDate,EndDate,ActStDate,ActEndDate,WorkCenter,OrderType

L1PO#,Line#,Text,StDate,EndDate,Vendor,POValue,ExpectedValue,Plant,OrderType

L1PO#,Line#,Text,StDate,EndDate,Vendor,POValue,ExpectedValue,Plant,OrderType

L1<None>

L2WO#,Desc,StDate,EndDate,Plant,Priority,Status,ActStTime,ActEndTime,FuncLoc,FuncDesc,OrderType

L3OP#,OPDesc,StDate,EndDate,ActStDate,ActEndDate,WorkCenter,OrderType

L3OP#,OPDesc,StDate,EndDate,ActStDate,ActEndDate,WorkCenter,OrderType

Thanks

Points will be awarded

[nisarkhan_n]

Hello for you file layout:

Define the L1, L2,L3 strucutres in the Data type and the respective elements in the L1 Structure, L2 & L3.

Now

In the FCC

L1.Fieldnames : list fthe field names here

L1.endSeparator ','

L1.KeyfieldName Fieldname

L1.KeyfieldValue "L1PO#"

L2.Fieldnames

L2.endSeparator

L2.KeyfieldName

L2.KeyfieldValue "L2WO#"

L3.Fieldnames

L3.endSeparator

L3.KeyfieldName

L3.KeyfieldValue "L3OP#"

let me know if any concerns

[former_member859847]

Hi Quest,

can you update the Source data type.

if you have hierarcy

DT

- header

-data

then it's better to use Key field concept.

otherwise, let you know u r structure..then we will update FCC parameters.

regards

mahesh.

[Former Member]

sorry guys there is a change in source file name I will make necessary changes and post it

thanks for the response

[Former Member]

Why don't you search at this forum and blogs for content conversion.

Also make sure you have mentioned the encoding for File communication channel to process the # sign.

Regards,

AV

[Former Member]

Hi,

You Just reffer these threads which talks about content conversion

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Regards

Seshagiri

[Former Member]

Hi,

In FCC parameters use keyvalue.Check some links on FCC.

File content conversion sites

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Regards,

Phani

Reward points if Helpful

[Former Member]

Hi,

U need to use key field values in FCC.

Just refer the below link for more understanding.

Key value:

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

Thnx

Chirag