Skip to Content
0
Former Member
Feb 17, 2011 at 01:54 AM

Select statement error in Start Routine

40 Views

Hi experts

In a Start Routine, the change log table of DSO will be used. but for the

same DSO, the change log table name may be different between in DEV and Test

environment after transporting. So I get the change log table name as follow.

DATA: WA_ODSNAME_TECH(20) TYPE C,

CTABLE_NAME TYPE STRING .

CONCATENATE '8ZPSFID_*' '%' INTO CTABLE_NAME.

*****get change log table ODSNAME_TECH from RSTSODS

SELECT SINGLE ODSNAME_TECH INTO WA_ODSNAME_TECH

FROM RSTSODS

WHERE ODSNAME LIKE CTABLE_NAME.

*****select fields from change log table

SELECT /BIC/ZFISCYEAR PCOMP_CODE AC_DOC_NO

INTO TABLE A

FROM (WA_ODSNAME_TECH)

WHERE RECORDMODE = 'N'.

above code i have made testing in SE80 and it was successful and

in start routine there is no syntax error for these codes.

but there is an error when loading date,

error message: Exceptions in Substep:Start Routine,

double click the error messages and go to Start Routine code:

SELECT /BIC/ZFISCYEAR PCOMP_CODE AC_DOC_NO

INTO TABLE A

FROM (WA_ODSNAME_TECH)

WHERE RECORDMODE = 'N'.

Anyone can give some advise for this issue?

Thanks a lot.