I have a7 select option i/p fields(selection criteria) out of which one is mandatory
select op 1LTAK-BETYP
LTAK-BENUM
LTAK-BWLVS
LTAK-TANUM
LTAK-BDATU
mandatory select op 6LTAP-NLTYP
so i have written my query like
Select A B C D
from LTAK
into table lt_ltak
whereBDATU in so_BDATUandBETYP in SO_BETYPandBENUM in SO_BENUMandBWLVS in SO_BWLVSandTANUM in SO_TANUM.
So according the query above if the user gives mandatory field(bdatu) and any other fields from LTAK table it will work...
now the 2nd query
select X Y Z
from LTAP
into table lt_ltap
for all entries in LTAK
where lgnum = LT_LTAK-LGNUM and NLTYP IN SO_NLTYP and GRETR IN SO_GRETR.
My questions: Is the 2nd query correct..