‎2006 Sep 27 4:53 PM
Hello all,
How to solve this syntax error?
Error : LT_ORDKEYS is a table without header line 6 no compononet called locid.
data : LT_ORDKEYS TYPE /SAPAPO/OM_ORDKEY_TAB.
FIELD-SYMBOLS : <lt_ordkeys> TYPE /SAPAPO/ORDKEY.
LOOP AT LT_ORDKEYS ASSIGNING <LT_ORDKEYS>.
SELECT SINGLE MATID FROM /SAPAPO/MATLOC INTO WA_FINAL WHERE LOCID = LT_ORDKEYS-LOCID.
IF SY-SUBRC = 0.
SELECT SINGLE MATNR FROM /SAPAPO/MATKEY INTO WA_FINAL WHERE MATID = LT_ORDKEYS-MATID.
ENDIF.
ENDLOOP.
Error : LT_ORDKEYS is a table without header line.
‎2006 Sep 27 4:54 PM
Hi
LOOP AT LT_ORDKEYS ASSIGNING <LT_ORDKEYS>.
SELECT SINGLE MATID FROM /SAPAPO/MATLOC INTO WA_FINAL <b>WHERE LOCID = <LT_ORDKEYS>-LOCID.</b>
IF SY-SUBRC = 0.
SELECT SINGLE MATNR FROM /SAPAPO/MATKEY INTO WA_FINAL <b>WHERE MATID = <LT_ORDKEYS>-MATID.</b>
ENDIF.
ENDLOOP.
Max
‎2006 Sep 27 4:54 PM
Hi
LOOP AT LT_ORDKEYS ASSIGNING <LT_ORDKEYS>.
SELECT SINGLE MATID FROM /SAPAPO/MATLOC INTO WA_FINAL <b>WHERE LOCID = <LT_ORDKEYS>-LOCID.</b>
IF SY-SUBRC = 0.
SELECT SINGLE MATNR FROM /SAPAPO/MATKEY INTO WA_FINAL <b>WHERE MATID = <LT_ORDKEYS>-MATID.</b>
ENDIF.
ENDLOOP.
Max
‎2006 Sep 27 4:56 PM
‎2006 Sep 27 4:56 PM
Hi,
use the field-symbols <LT_ORDKEYS> instead of the internal table LT_ORDKEYS in the WHERE clause..
Thanks,
Naren
‎2006 Sep 27 5:13 PM
Hi,
use
data LT_ORDKEYS TYPE /SAPAPO/OM_ORDKEY_TAB with header line.
Regards
amole