Message Mapping : Display Queue

[Former Member]

Hello,

I am trying to get a corresponding value in one segment for a value present in the same segment but in a different field.

E1EDKA1.PARVW values are 'AG','RE','LF','WE',

Corresponding

E1EDKA1.ORT01 values are null,'ABC',null,'XYZ'.

and i require the value of 'WE' so i have my mapping laid out in this way:

if E1EDKA1.PARVW = 'WE' then

i am checking if ORT01 exists are not and if exists then i get the value of E1EDKA1 if not a constant '[]'.

If i have values in all the E1EDKA1.ORT01 then i am getting the correct correspoding value of 'WE' which is 'XYZ'

but if i don't have all the values then its returning the constant '[]'.

How can i return the corresponding value of 'WE' if i don't values for all the fields in ORT01?

TIA,

Jerry

[Former Member]

Hi Jerry,

I am having the exact same issue when I am trying to map an ORDERS IDOC from SAP to an EDI format. I need to get the LIFNR segment from E1EDKA1 segment and it has null values which are deleted from the queue.

Did you use user defined functions and global containers in the end. Did you pass the whole queue to the UDF. Would appreciate it if you can post the user defined function code here.

Thanks

Chitra

[moorthy]

Hi,

In your case, ORT01 is a Segment under E1EDKA01 right?

<i>null,'ABC',null,'XYZ'</i>

>> According to this there are 4 fields under this Segment..

If so, check if the field1 not exists pass null value to the field, using node function Exists with if-else user defined function.. Then you can make sure that all the fields are populated under the ORT01 segment..

One more option you can think is using Global Container..

http://help.sap.com/saphelp_nw2004s/helpdata/en/78/b4ea10263c404599ec6edabf59aa6c/frameset.htm

Hope this helps,

Regards,

Moorthy

[Former Member]

Hello,

E1EDKA1 is the segment.

ORT01 is a field not a segment with values <i>null,'ABC',null,'XYZ'</i>

Does your solution still apply?

Thanks,

Jerry

[moorthy]

<i>ORT01 is a field not a segment with values null,'ABC',null,'XYZ'

Does your solution still apply?</i>

Can you try with Splitting this field value with small user defined Java function and put this value in to the global cotainer.. Then you can use this based on your condition.

Hope this helps,

Regards,

Moorthy

[Former Member]

Hello -

How would i split the field value using UDF?

If i check the display queue before doing anything the values that i get in the queue are

E1EDKA1.PARVW

SUPPRESS - highlighted

[AG]

[RE]

[LF]

[WE]

[WE] - highlighted

E1EDKA1.ORT01

SUPPRESS - highlighted

['ABC']

['XYZ']

['XYZ'] - highlighted

Though i use EXISTS and ifwithoutelse or if conditions, i am not able to get a corresponding value for each of PARVW.

If i can have the following output for E1EDKA1.ORT01

SUPPRESS - highlighted

[] or null

['ABC']

[] or null

['XYZ']

['XYZ'] - highlighted

then i can think of using the globalcontainer.

I don't know how to achieve the above output.

Help me.

Thanks,

Jerry

[Former Member]

Hello -

I solved this prolem by using SplitByValue(EmptyValue) after the 'IF' condition.

Thanks for being there.

Appreciate it.

- Jerry