Skip to Content
0
Jan 22, 2023 at 10:10 PM

Master data look up using AMDP

215 Views

Hi,

I need your help please I need to pick up a field and populate data from a master data by comparing GUID.

I have wrote this logic in the start routine to select from table. but this is throwing error message. The start routine is a new one so it is going into AMDP rather than old BW logic like SOURCE_PACKAGE

outTab = SELECT * FROM "/BIC/PZCGUIDIR" INNERJOIN :inTab ON "/BIC/PZCGUIDIR"."/BIC/ZCGUIDIR" =:inTab."CRM_ACGUID";

In the end routine, i would like to populate data using Read table if possible . In the end routine , I have a structure with RESULT_PACKAGE so i could use old code.Can you please correct my logic here.

LOOP AT RESULT_PACKAGE ASSIGNING <result_fields>.

READ TABLE :inTab INTO WA_ZCTRGIRN

WITH KEY

/BIC/ZCGUIDIR = <result_fields>-/BIC/ZCTRGGUID.

IF sy-subrc = 0.

<result_fields>-/BIC/ZCTRGIRN = WA_ZCTRGIRN-CRM_OBJ_ID .

ENDIF.

ENDLOOP.

image.png

Attachments

image.png (6.6 kB)
image.png (6.6 kB)