Sender File- FCC

[Former Member]

Hi Experts,

I am working on a file to file scenario., where structure at sender side is as follows:

Recordset 0..unbounded

EmpName 0..1

Detail 0..1

ID 0..1

Address 0..1

Can somebosy pls help to write FCC for this?

-Tanaya.

[former_member187339 · Accepted solution]

Hi Tanya,

Try this:

Recordset Structure : Recordset,*

Recordset.fieldNames = EmpName, Detail, ID, Address

Recordset.fieldSeparator = ,

Recordset.endSeparator = 'nl'

Also check help.sap link

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

Regards

Suraj

[Former Member]

Hi,

Thanks sateesh for your inputs!!

But still it is not working...It seems, reading this structure inside FCC is not possible.

Is there any workaround for this?

-Tanaya.

[Former Member]

Hi Tanaya,

As per sateesh suggestion have you tried. will you please post how the xml data is formatted in your case with sateesh suggestions. Because, that is the correct FCC. Otherwise, kindly do it as suraj has suggested you to change the structure.

Regards,

Nutan

[Former Member]

Hi ,

Source File example is,

abc

20

banglore

xyz

30

Chennai

Any help?

-Tanaya.

[Former Member]

Hi Tanaya,

Can you please try this.

Recordset Name= Recordset

Recordset Structure: Recordset,*,Details,1

Recordset.fieldNames=Empname

Recordset.endSeparator='nl'

Details.fieldNames=ID,Address

Details.endSeparator='nl'

Thanks,

Sateesh.

[Former Member]

Hi Suraj,

Still it is not working...

The blog which you have given, is also for 3 level structure.

How can we handle this situation?

-Tanaya.

[former_member187339]

Hi Tanya,

Can you give an example for the input file, may be we can try to see if the source structure can be altered to meet the 3 level hierarchy.

Regards

Suraj

[Former Member]

Hi Suraj,

Thanks for ypur reply!

But Empame and Detail are at the same level, and ID, Address are under Detail node.

Any help?

-Tanaya.

[former_member187339]

Hi Tanya,

>>But Empame and Detail are at the same level, and ID, Address are under Detail node.

Sorry, but by your question it was not clear..

so your structure is like

MessageType
-Recordset 0..unbounded
--EmpName 0..1
--Detail 0..1
----ID 0..1
----Address 0..1

So the ID and Address are on the 4th level, FCC is possibel till three levels.. I will suggest you to check this blog http://www.riyaz.net/blog/xipi-file-content-conversion-for-complex-structures/ and try to create a workaround

Regards

Suraj

[former_member187339]

Hi Tanya,

Change your source structure to

MessageType
-Recordset 0..unbounded
--EmpName 0..1
--ID 0..1
--Address 0..1

and try this FCC parameters in communication channel

Recordset Structure : Recordset,*

Recordset.fieldNames = EmpName,ID, Address
Recordset.fieldSeparator = ,
Recordset.endSeparator = 'nl'

Regards

Suraj