Skip to Content
0
Former Member
May 08, 2008 at 05:14 AM

Urgent: Data not displayed in Report

17 Views

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.