How to write using for all entries instead of innerjoin

Select a_{mblnr a}mjahr a_{budat b}bwart b_{lgort b}matnr b~erfmg

INTO CORRESPONDING FIELDS OF TABLE itab From mkpf as A

INNER JOIN mseg as B ON a_{mblnr = b}mblnr AND a_{mjahr = b}mjahr

WHERE a~budat BETWEEN from_yr AND to_yr AND

b~shkzg = 'S' AND

b~werks = 'HIP' AND

b~lgort = 'BSR' AND

b~bwart IN ('BSR', '521').

DELETE ADJACENT DUPLICATES FROM itab COMPARING ALL FIELDS.

• Reverse Movement Type 522 **********************

Select a_{mblnr a}mjahr a_{budat b}bwart b_{lgort b}matnr b~erfmg

INTO CORRESPONDING FIELDS OF TABLE it_522r From mkpf as A

INNER JOIN mseg as B ON a_{mblnr = b}mblnr AND a_{mjahr = b}mjahr

WHERE a~budat BETWEEN from_yr AND to_yr AND

b~shkzg = 'H' AND

b~werks = 'HIP' AND

b~lgort = 'BSR' AND

b~bwart IN ('522').

• Added to remove Sales Return ************************

Select a_{mblnr a}mjahr a_{budat b}bwart b_{lgort b}matnr b~erfmg

INTO CORRESPONDING FIELDS OF TABLE it_slrr From mkpf as A

INNER JOIN mseg as B ON a_{mblnr = b}mblnr AND a_{mjahr = b}mjahr

WHERE a~budat BETWEEN from_yr AND to_yr AND

b~shkzg = 'H' AND

b~werks = 'HIP' AND

b~lgort = 'SLR' AND

b~bwart IN ('BSR').

Moderator Message: Use the resources available at your desposal.

Edited by: kishan P on Dec 20, 2011 2:39 PM