Function Module for get data from mkpf mseg.

[Former Member]

Hi Experts,

In sap any function module to get data from mkpf and mseg

or BAPI module to get above details on posting date/ Plant/ storage location.

[Former Member]

Hi,

SELECT MBLNR

MJAHR

FROM MSEG

INTO TABLE I_MKPF

WHERE MBLNR IN S_MBLNR AND

MJAHR IN S_MJAHR.

IF I_MKPF IS NOT INITIAL.

SELECT * FROM MSEG INTO TABLE O_MSEG FOR ALL ENTRIES IN I_MKPF

WHERE MBLNR = I_MKPF-MBLNR

AND MJAHR = I_MKPF-MJAHR

AND MATNR IN I_MATNR

AND WERKS IN I_WERKS

AND LGORT IN I_LGORT.

ENDIF.

ALSO CHECK FM u2018/BEV2/ED_REA_MSEG_MKPFu2019.

Regards,

Deepa Kulkarni

[RaymondGiuseppi]

Try [BAPI_GOODSMVT_GETITEMS|https://forums.sdn.sap.com/search.jspa?objID=c42&q=BAPI_GOODSMVT_GETITEMS].

Regards,

Raymond

[Former Member]

Hi,

SELECT MBLNR

MJAHR

FROM MSEG

INTO TABLE I_MKPF

WHERE MBLNR IN S_MBLNR AND

MJAHR IN S_MJAHR.

IF I_MKPF IS NOT INITIAL.

SELECT * FROM MSEG INTO TABLE O_MSEG FOR ALL ENTRIES IN I_MKPF

WHERE MBLNR = I_MKPF-MBLNR

AND MJAHR = I_MKPF-MJAHR

AND MATNR IN I_MATNR

AND WERKS IN I_WERKS

AND LGORT IN I_LGORT.

ENDIF.

ALSO CHECK FM u2018/BEV2/ED_REA_MSEG_MKPFu2019.

Regards,

Deepa Kulkarni

[Former Member]

hi,

you can use view

WB2_V_MKPF_MSEG2

chek tis link

[Former Member]

Hi

Look this FM FU_READ_MKPFMSEG

Regards

Gregory

[Former Member]

I HAVE BUILD OWN FM USING INNER JOIN QUERIES.