Inconsistent Data for File Content Conversion

[Former Member]

HI XI Friends,

Its IDOC to File Scanario,

File is of .txt file..

my IDOC contains 14 segments

some times some segements will not come with Idoc..

first three characters represent segment numbers..

structure of txt file

00112345 address1 street1

00212345 office1 street1

00312345 homw2 city2 street2

if that IDOC doent contain 002..then .txt file should be..

00112345 address1 street1

00312345 homw2 city2 street2

all Segement in that idoc are optional..

if I use Fixed lengh in File Content Conversion then ther would be blank row for 002 if that IDOc doent Conatin

00112345 address1 street1

00312345 homw2 city2 street2

please guide me...how to use content conversion in this case..

regards

Munna

[Former Member]

hi xi friends,
in my idoc to file ..
please help me in content conversion parameter for unequal number of rows .

the message type for external system..
root
 row1
    f1
    f2
    f3
 row2
    f4
    f5
 row3
    f6
	
if i send idoc with data for all three rows
 the resultant txt file 

 f1-valuef2-value f3-value
 f4-valuef5-value

 if i send idoc with data for row1 and row3
 the resultant txt file

  f1-valuef2-value f3-value
  f6-value
 
if i send data for row2 and row3
the resultant txt file

   f4valuef-5vaue
   f6-value

in static message mapping ,i eleminated the rows which are not getting the data from idoc

eg:if the data for row2 does not exist ,then i elimated in message mapping.

all the fileds are fixed lenths like f1 3char and f2 8char etc..

and i dont require header names.

please guide me how to declare in Content Conversion for this unequal number of rows of fixed lenth columns.

regards

Munna

[Former Member]

Hi Chandra .

thank you very much for your responses..

if it elemintes in Message Mapping..please guide me how to decalre in Content Conversion for this unequal number of rows of the Idoc..

please help me

regards

Munna

[Former Member]

Hi Munna,

Please Check this blog for configuring File Content Conversion for a Flat File with Fixed Lengths.

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

Hope this Helps............Reward points if helpful.

Regards,

Mili.

[Former Member]

Hi ,

Thank you very much for your response..

.txt file is of fixed lenths with no field Seperator

IDOC contains number segements..

the resultant txt file if we created first 3 segements data..

00112345 address1 street1

00212345 office1 street1

00312345 homw2 city2 street2

if we create 001 segment and 003 segement the text file should be

00112345 address1 street1

00312345 homw2 city2 street2

but for new row of each segment ... endseperator 'nl' after first segemnt in Content conversion parameter and 002 segement values..and again endSeperator 'nl'...

if we are not sending 002 segement data in the IDOC ..then it will give blank

00112345 address1 street1

00312345 homw2 city2 street2

my requirement is if we dont send 002 segement data then no blank row .how to check if the segement is having data or not and also how to declare it in Content Conversion parameters of File Adapters.

please guide me

regards

Munna

[Former Member]

HI,

Check in mapping , are ayou able to see the empty segment for 002 segment?

if yes , check to eliminate inMM itself..

Regards

Chilla

[Former Member]

HI,

Check in mapping , are ayou able to see the empty segment?

In general , we can suppress , if the message is empty , similarly we can handle the NameA.fixedLengthTooShortHandling , see in the below link

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

Regards

Chilla