my 1st int. table itab_qmsa contains list of vendor number, audit year, etc. In the select statement i want to fetch all the details from zqalsqave table pertained to all the vendors in itab_qmsa..here itab_qmsa table contains 100 vendors..for each vendor, there are about 1000 records in zqalsqave...i expect the for all entries addition to fetch all the records from zqalsqave for each and every vendor..as this is not in a loop, will the statement correctly identify each and every vendor in the zqalsqave table? i.e. fetch records from zqalsqave for vendor 1 in itab-qmsa, fetch records from zqalsqave for vendor 2 in itab-qmsa, etc like this for all the 100 vendors...the order of the fields in the select statement and my int. table are in the same manner.so i haven't used "corresponding fields of" addition or should i use that? the problem is, it's going to dump after an inevitably long time saying "ABAP/4 processor: DBIF_RSQL_SQL_ERROR" -- SNAP NO NEW ENTRY..where am i wrong?
SELECT PRUEFLOS WERK LIFNR MATNR LMENGEIST LMENGE01 LMENGE02 LMENGE03 LMENGE04 LMENGE05 LMENGE06 LMENGE07 VCODE VDATUM INTO TABLE ITAB_ZQALSQAVE FROM ZQALSQAVE
FOR ALL ENTRIES IN ITAB_QMSA
WHERE LIFNR EQ ITAB_QMSA-LIFNR AND
WERK EQ S_WERKS AND
VDATUM BETWEEN STQ_DATE AND EN1_DATE.