Help - is this segment of code correct?

[Former Member]

SELECT MARA_{MATNR MSEG}MENGE MSEG~BWART

INTO CORRESPONDING FIELDS OF TABLE ITAB_SHIP_QTY

FROM MARA INNER JOIN MSEG ON MSEG_{MATNR = MARA}MATNR

INNER JOIN MKPF ON MKPF_{MBLNR = MSEG}MBLNR

AND MKPF_{MJAHR = MSEG}MJAHR

WHERE MARA_{MATNR IN Z_MATNR AND MKPF}BUDAT IN SHIP_D

AND ( ( MSEG~LGORT = 'L002' AND

MSEG~BWART IN ('901','902','101','102','105','106') ) OR

( MSEG_{LGORT = 'L001' AND MSEG}BWART = '311' ) OR

( MSEG_{UMLGO = 'L001' AND MSEG}BWART = '312' ) ).

Dear all,is the above code correct? coz i get the internal table wif more than 2000records with same material number,same movement type and same storage location...only some of the quantity is different. Thx all

[Former Member]

SELECT MARA_{MATNR MSEG}MENGE MSEG~BWART

INTO CORRESPONDING FIELDS OF TABLE ITAB_SHIP_QTY

FROM MARA INNER JOIN MSEG ON MSEG_{MATNR = MARA}MATNR

INNER JOIN MKPF ON MKPF_{MBLNR = MSEG}MBLNR

AND MKPF_{MJAHR = MSEG}MJAHR

WHERE MARA_{MATNR IN Z_MATNR AND MKPF}BUDAT IN SHIP_D

AND ( ( MSEG~LGORT = 'L002' AND

MSEG~BWART IN ('901','902','101','102','105','106') ) OR

( MSEG_{LGORT = 'L001' AND MSEG}BWART = '311' ) OR

( MSEG_{UMLGO = 'L001' AND MSEG}BWART = '312' ) ).

Dear all,is the above code correct? coz i get the internal table wif more than 2000records with same material number,same movement type and same storage location...only some of the quantity is different. Thx all

[Former Member]

Hi

After this select write

sort itab_ship_qty by matnr .

delete adjacent duplicates from itab_ship_qty comparing matnr menge bwart.

[Former Member]

Hi Joan

The SELECT statement is absolutely correct.

There may be huge data for that meterial. If you want to X check, just check it out in MSEG table by providing the material only. The number of records in the MSEG should be either >= number of records your SELECT populates.

Regards

Surya.

[Former Member]

thx rk

hi surya,if the data really are tat huge....should i use the method as suggested by Rk? coz in the end i need to sum up the menge ( qty )

sort itab_ship_qty by matnr .

delete adjacent duplicates from itab_ship_qty comparing matnr menge bwart.

[former_member283648]

Hi,

You can do the following.

1. Do an innerjoin separately with MSEG and MKPF for all entries selected from MARA (MARA~MATNR IN Z_MATNR). This willl give u a control on your record fetching.

2. You can use your present query with distinct addition to the BWART field and sum addition to the MENGE field as you will get some of quantities for the same movment types.

3. Otherwise manipulate your output internal table based on the filter criteria you have.

[Former Member]

hie balachandran,can u elaborate more on how to do the following?

1. Do an innerjoin separately with MSEG and MKPF for all entries selected from MARA (MARA~MATNR IN Z_MATNR). This willl give u a control on your record fetching.

2. You can use your present query with distinct addition to the BWART field and sum addition to the MENGE field as you will get some of quantities for the same movment types.

thx..

[Former Member]

thanks all for the infor..i manage to solve it d ^^

[Former Member]

hi

good

i hope the inner join is correct, but the procedure of writing is bit confusing, if you r getting more than 2000 records than your one of the condition is satisfying the criteria but some of the condition is not satisfying, if you have use the select statement than insterad of using OR make them AND which i think more appropriate.

thanks

mrutyun^