How to write using for all entries instead of innerjoin

[Former Member]

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

[Former Member]

Hai,

SELECT NETWR

VGBEL

AUBEL

VBELN

FROM VBRP

INTO TABLE IT_VBRP

WHERE VBELN IN S_VBELN AND ERDAT IN S_ERDAT.

SELECT MATNR

ARKTX

VBELN

FROM LIPS

INTO TABLE IT_LIPS FOR ALL ENTRIES IN IT_VBRP

WHERE VBELN = IT_VBRP-VGBEL.

[Former Member]

Hi,

Thank you given answer.But in my problem is using inner join extracting the fields 17570 are come to the internal table but using for all entries 17520 records are came. i try to using delete adjacent records itab .but it is not come exactly records.

Thanks & Regards

Balakrishna