BSEG聚集表为例,如下:\x0d\x0aSELECT bseg~kunnr bseg~lifnr bseg~belnr \x0d\x0aINTO TABLE itab_bseg \x0d\x0aFROM bseg FOR ALL ENTRIES IN itab_main\x0d\x0aWHERE bukrs in _bukrs and ( belnr = itab_main-belnr AND hkont = itab_main-hkont ).\x0d\x0a由于BSEG不能和BSIS做inner join所以先将BSIS内容放到itab_main 中,然后用 FOR ALL ENTRIES IN来串联。
BSEG聚集表为例,如下:
SELECT bseg~kunnr bseg~lifnr bseg~belnr
INTO TABLE itab_bseg
FROM bseg FOR ALL ENTRIES IN itab_main
WHERE bukrs in _bukrs and ( belnr = itab_main-belnr AND hkont = itab_main-hkont ).
由于BSEG不能和BSIS做inner join所以先将BSIS内容放到itab_main 中,然后用 FOR ALL ENTRIES IN来串联。