hi friends , iam new sap/reports got a assigment
credit note compare report i have to display
mblnr,matnr.charg,menge ,vbeln,fkdat,matnr,charg,batch.
till menge its from mseg and rest from vbrk and vbrp.
to display all records for line itmes also .
i selected all the fields from mseg one itab and distinct vbeln in one itab
and all the vrecords from vbrp.
my report had now is verrrrrrrrrrrrrry slow .
pls help me with code.
SELECT mkpf~bldat
mseg~werks
mseg~mblnr
mseg~matnr
mseg~charg
mseg~menge
INTO CORRESPONDING FIELDS OF TABLE imseg
FROM mkpf
INNER JOIN mseg
ON msegmblnr = mkpfmblnr
WHERE mkpf~bldat IN s_bldat
AND mseg~werks IN s_werks
AND mseg~mblnr IN s_mblnr
AND mseg~bwart = '972'.
SELECT DISTINCT vbeln
fkdat
FROM vbrk INTO CORRESPONDING FIELDS OF TABLE icnot.
SELECT vbrp~vbeln
vbrp~matnr
vbrp~charg
vbrp~fkimg
FROM vbrp INTO TABLE icnq.
LOOP AT icnot.
CLEAR icno.
icno-vbeln = icnot-vbeln.
icno-fkdat = icnot-fkdat.
READ TABLE icnq WITH KEY vbeln = icno-vbeln.
IF sy-subrc = 0.
icno-matnr = icnq-matnr.
icno-charg = icnq-charg.
icno-fkimg = icnq-fkimg.
ENDIF. "if sy-subrc
APPEND icno.
ENDLOOP." LOOP AT icnot
Bluesky
