Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

problem in fetching the data for 1 plant

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 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.

Tags:
Not what you were looking for? View more on this topic or Ask a question