Skip to Content
0
Former Member
Mar 02, 2007 at 12:16 AM

ODS Start routine-Abap Code

19 Views

I have an ODS1 with key elements X1,X2 and I have another ODS2 with key elements X1 X3,I am not a ABAP guy but tried a start routine code that is not working ,which is trying to look up for field X3 which is same as field X2 in ODS1 using common field X1 in both ODS ,kindly help me on this .I have tried to debug it and it error out on selct statement,Here is my code.

Start routine

TABLES:/BIC/AZODS200.

data:begin of t_inttab occurs 0,

X1 like /BIC/AZODS200-X1,

X2 like /BIC/AZODS200-X2,

end of t_inttab.

select X1 X2 into corresponding fields of table t_inttab

from /BIC/AZODS200

where X1 = /BIC/AZODS200-X1.

ABORT = 0.

Routine for X3 field:

Read table t_inttab with key X2 = t_inttab-X2.

RESULT = t_inttab-RT_LOCATIO.

RETURNCODE = 0.

ABORT = 0.