Master data look up using AMDP

[former_member327592]

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.

[k_chandra1]

Hi Mano,

Please check :Link

Outtab should match with the declaration part which is available from the standard code. You can see which fields are present in out tab structure.

If you would like to try the above code in ABAP. then delete start and end routines in transformation and change transformation run time to "ABAP Mode" in general tab.

Then you can write ABAP code.

Thanks,

Chandra