problem in fetching the data for 1 plant
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 AMATNR AWERK APRUEFLOS APAENDTERM ALOSMENGE BMAWERK BCHARG BLGORTCHARG BMGEIN BMGEIG BQMNUM CNTGEW CMEINS CGEWEI
FROM QALS AS A
LEFT OUTER JOIN QMEL AS B ON BMATNR = AMATNR AND BPRUEFLOS = APRUEFLOS AND BMAWERK = AWERK
INNER JOIN MARA AS C ON CMATNR = AMATNR
INTO TABLE STIT WHERE AWERK = P_WERKS AND AMATNR IN P_MATNR
AND APAENDTERM IN I_DATE AND ALAGORTCHRG IN P_LGORT AND A~CHARG IN P_CHARG.
plzz provide me guidelines for solving it.