Hi,
i had made a report in which 90 % of the data coming right for the materails but whne i chekc few materails it is not coming right.
Actually i am using 2 tables MSEG n Zstocksum.
the code will fetch 1st records from the Zstocksum and then it will take lines from MSEG . the part code is shown below:-
SELECT BBUDAT AMATNR AWERKS ALGORT AMENGE APBAMG
CMEINS CMTART CMATKL CNTGEW CGEWEI cntgew
FROM MSEG AS A INNER JOIN MKPF AS B ON AMBLNR = BMBLNR AND AMJAHR = BMJAHR
INNER JOIN MARA AS C ON AMATNR = CMATNR
INTO TABLE ITMSEGDR WHERE AWERKS = P_WERKS AND MTART IN MAT_TYPE AND AMATNR IN P_MATNR
AND BUDAT between AA and P_DATE
AND ( MTART = 'FERT' OR MTART = 'HALB' OR MTART = 'ZBOP' OR MTART = 'ZSCR' OR MTART = 'ROH' )
AND A~LGORT IN P_STLOC
AND A~SHKZG = 'S'.
here the problem lies when the bold condition above get executed as it displays the majority of data right but not for few .
The p_date = ztsocksum-stldate. and AA is the max dat coming from ZMONTHST.
plzz provide me some guide lines so dat it can display the whole data as help will be deinfately rewarded.