Apply map - where is the bug

[maternmi]

Hi everybody,

I've tried the first time to use apply map instead of join statement but it is not working as I thought.  The reload works but I don't see in the VBEP table the REQ_Delivery_Date. Do you know where the mistake is?

Here the code

MappingEDDtoVBEP:

Mapping Load %VKANRHD%POSHD as %VBELN%UEPOS,

                        ZGS_SCM_MONITOR.EARLIEST_DELIV       

From

  ...Pickup_Reliability\QVDs\ZGS_SCM_MONITOR_01.qvd (qvd)

;     

VBEP:

Load *,

ApplyMap('MappingEDDtoVBEP',%VBELN%UEPOS) as REQ_Delivery_Date

;

Thank you in advance

BR

Michael

[Peter_Cammaert]

Another idea: in the keys, does POSHD carry leading zeroes while UEPOS does not, or vice versa? This is deadly to applymap.

[Jason_Michaelides]

Michael,

If you take the time to post an example app it is much easier for us to help you.

Jason

[Clever_Anjos]

Is it possible to you show us some sample of your data?

Sometimes mapping tables can be tricky if the values are numerical

[maternmi]

Hi Salto,

I know the problem and you helped me to find it. You did it as you add

VBEP:

Load *,

ApplyMap('MappingEDDtoVBEP',%VBELN%UEPOS, 'No match') as REQ_Delivery_Date

From [YOUR VBEP TABLE]

;

From my VBEP table, after I've thought about it, I tried to store my current VBEP before the above statement and it works. Sometimes very simple... Thanks!