08-07-2019 6:39 AM
REPORT zmanoj3.
TABLES mara.
TYPES: BEGIN OF manoj,
a TYPE mara-mandt,
b TYPE mara-matnr,
c TYPE mara-mtart,
d TYPE mara-bstme,
e TYPE mara-matkl,
END OF manoj.
DATA: it_manoj TYPE TABLE OF manoj,
wa_manoj TYPE manoj.
SELECT-OPTIONS smanoj FOR mara-matnr.
SELECT mandt matnr mtart bstme matkl FROM mara INTO TABLE it_manoj WHERE matnr EQ smanoj.
LOOP AT it_manoj INTO wa_manoj.
WRITE : wa_manoj.
WRITE: / wa_manoj-a, 20 wa_manoj-b, 30 wa_manoj-c, 40 wa_manoj-d, 50 wa_manoj-e.
ENDLOOP.
08-07-2019 6:47 AM
SELECT-OPTIONS is not a simple value, it is a range
and a range in a SELECT statement must uses the operator IN
WHERE MATNR IN SMANOJ
08-07-2019 6:47 AM
SELECT-OPTIONS is not a simple value, it is a range
and a range in a SELECT statement must uses the operator IN
WHERE MATNR IN SMANOJ
08-07-2019 7:29 AM
i am getting error if i used your select statements..
'smanoj is not a internal table'
thank you..
08-07-2019 7:49 AM
And the OP should debug his program, so the question would become "why is IT_MANOJ empty after SELECT" instead of "output is not displaying".
08-07-2019 7:12 AM
08-07-2019 7:20 AM
SELECT mandt matnr mtart bstme matkl FROM mara INTOTABLE it_manoj WHERE matnr IN smanoj.
08-07-2019 7:48 AM
Please use COMMENT button to post. As you can see in the box beside "your answer", SAP says:
You should only submit an answer when you are proposing a solution to the poster's problem.