Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
If yes Goto->SQ02.. Then click extras->Create. a pop-up will come asking additional fields/additional table etc.. Choose field and code it . Don’t forget to give the sequence of field . give sequence of field accordingly .
OK - you may not need the subquery. See if this helps:
REPORT ztest NO STANDARD PAGE HEADING LINE-SIZE 255
MESSAGE-ID 00.
TABLES pa0001, ztab.
SELECT-OPTIONS: s_gsber FOR pa0001-gsber,
s_btrtl FOR pa0001-btrtl.
DATA: BEGIN OF itab OCCURS 0,
gsber LIKE pa0001-gsber,
btrtl LIKE pa0001-btrtl,
END OF itab.
DATA: BEGIN OF itab1 OCCURS 0,
gsber LIKE pa0001-gsber,
btrtl LIKE pa0001-btrtl,
room LIKE ztab-room,
END OF itab1.
SELECT gsber btrtl
FROM pa0001
INTO TABLE itab
WHERE gsber IN s_gsber
AND btrtl IN s_btrtl.
CHECK NOT itab[] IS INITIAL.
SELECT gsber btrtl room
FROM ztab
INTO TABLE itab1
FOR ALL ENTRIES IN itab
WHERE gsber = itab-gsber
AND btrtl = itab-btrtl.
That's entirely up to your requirements. Without them, I really can't say. What I've written is a complete program that uses select-options to try to mimic what you are trying to do. You will have to adapt the code to fit your situation.
Bluesky
