FCC problem

[Former Member]

Hi all,

I'm doing IDOC-File(csv) without BPM.

This is the target structure:

MT

-Recordset (0..unbounded)

--field1 (1)

--field2 (1)

--field3 (1)

--field4 (1)

--field5 (1)

--Record (0..unbounded)

---field6 (0..1)

---field7 (0..1)

Target structure after mapping:

MT

-Recordset (0..unbounded)

--field1 (1)

--field2 (1)

--field3 (1)

--field4 (1)

--field5 (1)

--Record (0..unbounded)

---field6 (0..1)

---field7 (0..1)

-Recordset (0..unbounded)

--field1 (1)

--field2 (1)

--field3 (1)

--field4 (1)

--field5 (1)

--Record (0..unbounded)

---field6 (0..1)

---field7 (0..1)

-Recordset (0..unbounded)

--field1 (1)

--field2 (1)

--field3 (1)

--field4 (1)

--field5 (1)

--Record (0..unbounded)

---field6 (0..1)

---field7 (0..1)

I want an output in this way:

field1,field2,field3,field4,field5,field6,field7 (all field names as a row like header just once and append all the records)

f1,f2,f3,f4,f5,f6,f7

f1,f2,f3,f4,f5,f6,f7

f1,f2,f3,f4,f5,f6,f7

f1,f2,f3,f4,f5,f6,f7

f1,f2,f3,f4,f5,f6,f7

f1,f2,f3,f4,f5,f6,f7

f1,f2,f3,f4,f5,f6,f7

f1,f2,f3,f4,f5,f6,f7

f1,f2,f3,f4,f5,f6,f7

I have tried using xml.addHeaderLine =1, but not working also used xml.processFieldNames = fromConfiguration but with no luck.

I'm getting something like this:

field1,field2,field3,field4,field5,Record

Is there any way to do this?

Thanks,

Srini

Edited by: Srinivas Davuluri on Jul 9, 2008 10:05 AM

[Former Member]

In your structure you have 2 nodes - Recordset and Record

As help.sap.com says, NameA.addHeaderLine specification is only permitted if exactly one structure is defined.

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

But you have 2 structures

So I think to get column header, try to modify your target structure

[Former Member]

Ya I have seen that but isn't there any work around like running OS command before processing to fix all the fields as constant(Header).

[Former Member]

You can try this,

Add one more node to your DT like Headings... with occurrence 1..1

In that create those many fields and assign them Constant of there fieldnames only.. that means if the fieldname is field1 then in mapping assign it a constant field1

It should work as your content conversion would support..

[Former Member]

Mugdha,

field1,field2,field3,field4,field5,field6,field7 (all field names as a row like header just once and append all the records)

But, if I do it the way you suggested I will have the Header (headings) for each IDOC, all I want to do is have the fields names as a Header and append all the IDOCs processed as rows.

--

Srini