Skip to Content
0
Former Member
Dec 03, 2008 at 01:08 PM

vendor's material

109 Views

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.