problem in fetching the data for 1 plant

[Former Member]

Hi,

I had made a report in which i am taking data from QALS table and then from QMEL. by taking common values MAWERK ,WERK,PRUEFLOS,MATNR.

The problem is this the data is coming right for the 1 plant and when i check the data for another plant it is not coming.

I checked in the SE16 the data about them by having the values of it and the data is present in that.

why the data is not coming for the other plant . here's d code :-

SELECT A_{MATNR A}WERK A_{PRUEFLOS A}PAENDTERM A_{LOSMENGE B}MAWERK B_{CHARG B}LGORTCHARG B_{MGEIN B}MGEIG B_{QMNUM C}NTGEW C_{MEINS C}GEWEI

FROM QALS AS A

LEFT OUTER JOIN QMEL AS B ON B_{MATNR = A}MATNR AND B_{PRUEFLOS = A}PRUEFLOS AND B_{MAWERK = A}WERK

INNER JOIN MARA AS C ON C_{MATNR = A}MATNR

INTO TABLE STIT WHERE A_{WERK = P_WERKS AND A}MATNR IN P_MATNR

AND A_{PAENDTERM IN I_DATE AND A}LAGORTCHRG IN P_LGORT AND A~CHARG IN P_CHARG.

plzz provide me guidelines for solving it.

[Former Member]

U should get the data correctly as far as I can see there is nothing in it(but wait for the experts to answer).I can suggest u to go for 'for all entries' rather inner join.I always do 'trial and error'.

[Former Member]

hi,

but the thing is the right data is coming for the plant only by using OUTER JOIN .even i had done a lot of study of the problem but it is displaying the dat for 1 plant accuratley ,when i enter any other plant it is not displaying the data.

[Former Member]

Hi Rock,

Could u please tell me as per performence which one is good

for all entries or joins?

regrds

Kiran

[Former Member]

hi,,

plz provide me guidelines for this problem.

[P561888]

Hi,

here is the sample code for ur problem.

SELECT MATNR WERK PRUEFLOS PAENDTERM LOSMENGE FROM QALS INTO IT_QALS WHERE WERK = P_WERKS AND MATNR IN P_MATNR.

IF NOT IT_QALS[] IS INITIAL.

SELECT MAWERK CHARG LGORTCHARG MGEIN MGEIG QMNUM FROM QMEL INTO IT_QMEL FOR ALL ENTRIES IN IT_QALS WHERE

MATNR = IT_QALS-MATNR AND PRUEFLOS = IT_QALS-PRUEFLOS AND MAWERK = IT_QALS-WERK.

IF SY-SUBRC = 0 .

SORT THE INTERNAL TABLE.

ENDIF.

ENDIF.

IF NOT IT_QALS[] IS INITIAL.

SELECT NTGEW MEINS GEWEI FROM MARA INTO TABLE IT_MARA FOR ALL ENTRIES IN IT_QALS WHERE MATNR = IT_QALS-MATNR.

IF SY-SUBRC = 0 .

SORT THE INTERNAL TABLE.

ENDIF.

ENDIF.

this is sample code only...

check it out..

Regards,

Bharani