fieldFixedLengths parameter

[Former Member]

hi,

i have a nested structure like,

<Record> "Super node"

f1 "field"

f2 "field"

<row1> "Subnode of Record"

f3 "field"

f4 "field"

<row2> "Subnode of Record"

f5 "field"

f6 "field"

<row3> "Subnode of row2"

f7 "field"

f8 "field"

for this structure i want flat file with fixed lengths.

i have tried with fieldFixedLengths but iam getting error "XML Structure having more fields than conversion parameters.

my question:Is it possible to get a falt file with fixedlengths for nested structure.

Thanks&Regards,

Sridhar.

[bhavesh_kantilal · Accepted solution]

Yiou can use content conversion with only a strcuture of the format shown in this link,

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

Regards

Bhavesh

[Former Member · Accepted solution]

hey Bhavesh

the SAP help says that we can't have nested structures like

<Record>

<Step1>

<Step2>

<Invoice>-----</Invoice>

</Step2>

</Step1>

</Record>

so in case we have to generate this,is there a way around for this?

thanx

ahmad

[Former Member · Accepted solution]

hi bhavesh,

iam getting csv format, but not fixed length format.

Thanks&Regards,

Sridhar

[Former Member · Accepted solution]

can u paste the sender XML from sxmb_moni along with the FCC parameters ur using

thanx

ahmad

[Former Member · Accepted solution]

Hi Ahmed,

This is my sende XML File.

<?xml version="1.0" encoding="UTF-8" ?>

- <Z_L_NL_OTC_EXT_DELVRY05>

- <IDOC BEGIN="1">

- <EDI_DC40 SEGMENT="1">

<TABNAM>EDI_DC40</TABNAM>

<MANDT>220</MANDT>

<DOCNUM>0000000000001309</DOCNUM>

<DOCREL>700</DOCREL>

<STATUS>30</STATUS>

<DIRECT>1</DIRECT>

<OUTMOD>2</OUTMOD>

<IDOCTYP>DELVRY05</IDOCTYP>

<CIMTYP>Z_L_NL_OTC_EXT_DELVRY05</CIMTYP>

<MESTYP>DESADV</MESTYP>

<STDMES>DESADV</STDMES>

<SNDPOR>SAPD10</SNDPOR>

<SNDPRT>LS</SNDPRT>

<SNDPRN>D10CLNT220</SNDPRN>

<RCVPOR>A000000001</RCVPOR>

<RCVPRT>LS</RCVPRT>

<RCVPRN>D40CLNT100</RCVPRN>

<CREDAT>20070518</CREDAT>

<CRETIM>010539</CRETIM>

</EDI_DC40>

- <E1EDL20 SEGMENT="1">

<VBELN>452632</VBELN>

<VSTEL>565</VSTEL>

<VKORG>889</VKORG>

<LSTEL>12</LSTEL>

<VKBUR>456</VKBUR>

<LGNUM>88</LGNUM>

<ABLAD>4526325698</ABLAD>

<INCO1>856</INCO1>

<INCO2>4562595856595633</INCO2>

<ROUTE>4526</ROUTE>

<VSBED>55</VSBED>

<BTGEW>452365</BTGEW>

<NTGEW>45263256</NTGEW>

<GEWEI>556</GEWEI>

<VOLUM>4526325</VOLUM>

<VOLEH>225</VOLEH>

<ANZPK>4563</ANZPK>

<BOLNR>5632659854652365985</BOLNR>

<TRATY>456</TRATY>

<TRAID>25632565852</TRAID>

<XABLN>456456</XABLN>

<LIFEX>12325659874</LIFEX>

<PARID>45865956656958</PARID>

<PODAT>4562</PODAT>

<POTIM>526</POTIM>

<LOC_SEQ>89</LOC_SEQ>

<HOLD>5</HOLD>

<MAX_ERR_TYPE>3</MAX_ERR_TYPE>

<LE_SCENARIO>9</LE_SCENARIO>

<RECIPIENT_CREATE>7</RECIPIENT_CREATE>

- <ZSEG_L_NL_OTC_DELVRY05_HDR SEGMENT="1">

<AUGRU>55</AUGRU>

</ZSEG_L_NL_OTC_DELVRY05_HDR>

<E1EDL20RET2 SEGMENT="1" />

<E1EDL22 SEGMENT="1" />

- <E1EDL21 SEGMENT="1">

<E1EDL23 SEGMENT="1" />

</E1EDL21>

<E1EDL51 SEGMENT="1" />

<E1EDD01 SEGMENT="1" />

<E1EDL18 SEGMENT="1" />

<E1EDL55 SEGMENT="1" />

- <E1ADRM1 SEGMENT="1">

<E1ADRE1 SEGMENT="1" />

</E1ADRM1>

- <E1EDT13 SEGMENT="1">

- <E1EDL40 SEGMENT="1">

<E1ADRM2 SEGMENT="1" />

</E1EDL40>

- <E1TXTH0 SEGMENT="1">

<E1TXTP0 SEGMENT="1" />

</E1TXTH0>

</E1EDT13>

- <E1TXTH8 SEGMENT="1">

<E1TXTP8 SEGMENT="1" />

</E1TXTH8>

- <E1EDDH2 SEGMENT="1">

<E1EDDP2 SEGMENT="1" />

</E1EDDH2>

- <E1EDL33 SEGMENT="1">

<E1EDL34 SEGMENT="1" />

</E1EDL33>

- <E1EDL28 SEGMENT="1">

<E1EDL29 SEGMENT="1" />

- <E1EDL30 SEGMENT="1">

<E1EDL31 SEGMENT="1" />

- <E1EDL32 SEGMENT="1">

<E1EDL45 SEGMENT="1" />

<E1ADRM3 SEGMENT="1" />

</E1EDL32>

</E1EDL30>

</E1EDL28>

- <E1EDL47 SEGMENT="1">

<E1EDL48 SEGMENT="1" />

</E1EDL47>

- <E1EDL24 SEGMENT="1">

<ZSEG_L_NL_OTC_DELVRY05_ITM SEGMENT="1" />

<E1EDL56 SEGMENT="1" />

<E1EDL24RET2 SEGMENT="1" />

<E1EDL25 SEGMENT="1" />

- <E1EDL26 SEGMENT="1">

<E1EDL27 SEGMENT="1" />

</E1EDL26>

<E1EDL52 SEGMENT="1" />

<E1EDL53 SEGMENT="1" />

- <E1EDD10 SEGMENT="1">

<E1EDD11 SEGMENT="1" />

<E1EDD15 SEGMENT="1" />

- <E1EDD12 SEGMENT="1">

<E1EDD16 SEGMENT="1" />

</E1EDD12>

<E1EDD13 SEGMENT="1" />

- <E1EDDH3 SEGMENT="1">

<E1EDDP3 SEGMENT="1" />

</E1EDDH3>

<E1EDD17 SEGMENT="1" />

<E1EDD18 SEGMENT="1" />

- <E1EDDH4 SEGMENT="1">

<E1EDDP4 SEGMENT="1" />

</E1EDDH4>

</E1EDD10>

<E1EDD14 SEGMENT="1" />

<E1EDL19 SEGMENT="1" />

<E1EDL11 SEGMENT="1" />

- <E1EPC01 SEGMENT="1">

<E1IDC01 SEGMENT="1" />

</E1EPC01>

<E1EDL15 SEGMENT="1" />

- <E1EDL35 SEGMENT="1">

<E1EDL36 SEGMENT="1" />

</E1EDL35>

<E1EDL43 SEGMENT="1" />

- <E1EDL41 SEGMENT="1">

<E1EDL42 SEGMENT="1" />

</E1EDL41>

- <E1TXTH9 SEGMENT="1">

<E1TXTP9 SEGMENT="1" />

</E1TXTH9>

<E1EDL12 SEGMENT="1" />

</E1EDL24>

- <E1EDL37 SEGMENT="1">

<E1EDL39 SEGMENT="1" />

<E1EDL38 SEGMENT="1" />

- <E1EPC02 SEGMENT="1">

<E1IDC02 SEGMENT="1" />

</E1EPC02>

- <E1EDL49 SEGMENT="1">

<E1EDL50 SEGMENT="1" />

</E1EDL49>

- <E1EDL44 SEGMENT="1">

<E1EDL46 SEGMENT="1" />

- <E1EPC03 SEGMENT="1">

<E1IDC03 SEGMENT="1" />

</E1EPC03>

</E1EDL44>

</E1EDL37>

<E1EDL54 SEGMENT="1" />

</E1EDL20>

<E1UPSLINK SEGMENT="1" />

</IDOC>

</Z_L_NL_OTC_EXT_DELVRY05>

I have used fallowing FCC parameters:

E1EDL20.fieldFixedLengths

E1EDL20.enfSeparator

ZTEST_DELVRY.fieldFixedLengths

ZTEST_DELVRY.endSparator

Thanks,

Sridhar

[Former Member]

Hi Shidhar,

><i>>>>>for this structure i want flat file with fixed lengths

</i>

No....u cant covert this nested structure to flat file.

The expected XML structure contains the structure as nodes filled with any number of elements <b>without additional subnodes</b>.

one way is covert ur nested stucture to simple structure in message mapping...then convert this to ftal file using CC in reciver file adapter.

Thanks,

Maheshwari.

[Former Member]

hey

>>XML Structure having more fields than conversion parameters

this means there is something wrong in ur FCC parameters,cross check them again.

thanx

ahmad

Message was edited by:

Ahmad