How to do Content Conversion for this structure?

[Former Member]

Hi,

Urgent required. I have the following structure as below. There is a headerData, itemData and textData. The data that wll come into headerData could be more than one, and the same applies to the itemData and textData. The File adapter is not able to pick this file structure. It is a fixed length file at the receiver end. Could any one tell me how to do the File Content Conversion (FCC) for the structure without using the FCC module. Points to be awarded to best answer. Thaanks in advance.

The structure :

<headerData>

aaaaa

bbbb

cccc

</headerData>

<headerData>

aaaaa

bbbb

cccc

</headerData>

<headerData>

aaaaa

bbbb

cccc

</headerData>

<itemData>

fff

ggg

hhh

</itemData>

<itemData>

fff

ggg

hhh

</itemData>

<itemData>

fff

ggg

hhh

</itemData>

<textData>

fff

ggg

hhh

</textData>

<textData>

fff

ggg

hhh

</textData>

<textData>

fff

ggg

hhh

</textData>

[Former Member]

HI,

Use the following content conversion:

I assume the data coming in the file is of below format:

Here the key field name is K for 01,02 and 03

01,aa,bb,cc

01,aa,bb,cc

02,ff,gg,hh

02,ff,gg,hh

03,hh,ff,hh

03,hh,ff,hh

If you data in the file is coming in the above way then your FCC will be

Recordse strucutre: headerData,,temData,,textData,*

Keyfield Name: K

headerData.fieldNames: a,b,c

headerData.fieldSeparator: ,

headerData.endSeparator: 'nl'

headerData.keyFieldValue: 01

Similarly for itemData and text Data

Refer the below weblog for the same:

/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 Gohil

[Former Member]

Hi,

I am able to get the file picked from the legacy system, But I want the receiver FCC parameters. Please let me know the receiver end FCC parameters.

[Former Member]

Hi ,

How can people tell you the receiver FCC parameters with out you telling them the structure of your inbound message.

Regards,

Sumit

[Former Member]

The structure given above is the target message structure. This structure's receiver FCC parameter is required.

[Former Member]

Hi,

Someone had already helped you with the source FCC parameters.

So your source & the target structure are the same. Do you think everyone out here would be able to assume that from your first message?

Believe me it is not hard for you to figure out the FCC parameters on your own.

Go to help.sap.com and search for File adapter. Next see the help for document conversions in receiver fiel adapter.

Give it a shot yourself after 2-3 times you would be able to figure out youself.

Regards,

Sumit

[Former Member]

Hi,

I have tried n number of times but unable to get the data into my structure. That was the reason why I wanted help from the forum. Please do help. The source structure is different from what you are currently looking at. The structure I have given above is that of the receiver end. And I want the receiver end FCC. So please if anybody is there to help, please do and not say to try and look in help.sap.com, where as I know where all to search and get the data.

It is because I am unable to get the transformation done, I am putting in the forum to get some help. So please do help an this is urgent. Sorry if I have hurt anyone in this regard.

[Former Member]

before that,please tell us what parameters you have given?

and what is the error you are getting in RWB?

i personally don't think anybody should be giving complete FCC parameters,we should only tell the mistakes and try to fix it rather than spoon feeding everything

Thanx

Aamir

[VijayKonam]

I absolutely second Aamir. Forum is to get a hint on to how to solve your problem.. but not to do your job.. hope every one understands..

VJ