Hi experts,
I am creating vendor's stock report. I am facing problem i am not getting all material for perticular vendor in MSEG but when i am checking standard report ME2O or MB5B it showing the material at vendor. so how can i get all material for perticular vendor. any FM or somthing else plz giv me solution.
SELECT * FROM MKPF
INTO TABLE IT_MKPF
WHERE BUDAT IN PODATE.
IF NOT IT_MKPF[] IS INITIAL.
SELECT * FROM MSEG
INTO TABLE IT_MSEG
FOR ALL ENTRIES IN IT_MKPF
WHERE MBLNR = IT_MKPF-MBLNR AND
MJAHR = IT_MKPF-MJAHR AND
WERKS = PLANT AND
LIFNR = VENDOR AND
( BWART = '541' AND SHKZG = 'S' OR
BWART = '542' AND SHKZG = 'H' OR
BWART = '543' AND SHKZG = 'H' OR
BWART = '544' AND SHKZG = 'S' OR
BWART = '548' AND SHKZG = 'H' OR
BWART = '549' AND SHKZG = 'S' ) .
ENDIF. plz giv me solution.
Thanks,
Vishal.