Skip to Content
0
Former Member
Jul 31, 2017 at 11:30 AM

BW end routine lookup issue.

350 Views

Hi Team,

I'm trying to lookup in end routine:

1. Source Table (DSO) is : ZDSO_SLS

2. Target Table (Cube) is : ZIC_SLESS.

3. Lookup Table (DSO) is : ZDSO_NS

While loading from Source (ZDSO_SLS) to the Target (ZIC_SLESS), I have written end routine which is trying to fetch records of 'ZCUSTD' field from the lookup DSO (

ZDSO_NS).

But its giving me a dump " GETWA_NOT_ASSIGNED " while executing DTP. Please see the dump screen shot below:

And below is the end routine code, request you to kindly check the code and suggest what went wrong:

TYPES: BEGIN OF TY_NS,
ZCUSTD TYPE /BIC/AZDSO_NS00-/BIC/ZCUSTD,
ZCOMPC TYPE /BIC/AZDSO_NS00-/BIC/ZCOMPC,
ZCNTRYS TYPE /BIC/AZDSO_NS00-/BIC/ZCNTRYS,
ZSALORGS TYPE /BIC/AZDSO_NS00-/BIC/ZSALORGS,
END OF TY_NS.

DATA IT_NS TYPE TABLE OF TY_NS.
DATA IS_NS LIKE LINE OF IT_NS.

SELECT /BIC/ZCUSTD /BIC/ZCOMPC FROM /BIC/AZDSO_NS00 INTO TABLE IT_NS.
DATA N TYPE I.
LOOP AT RESULT_PACKAGE INTO <RESULT_FIELDS>.
READ TABLE IT_NS INTO IS_NS
WITH KEY ZCOMPC = <RESULT_FIELDS>-/BIC/ZCOMPC.
IF SY-SUBRC = 0.
<RESULT_FIELDS>-/BIC/ZCUSTD = IS_NS-ZCUSTD.
MODIFY RESULT_PACKAGE FROM <RESULT_FIELDS> INDEX N.
ENDIF.
ENDLOOP.

Thanks In Advance,

Ubaid.

Attachments

9mbwv.png (14.8 kB)