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.