Function module similar to BAPI_GOODSMVT_GETITEMS

[Former Member]

Hi,

My requirement is to get the data from MKPF and MSEG tables.

Selection- screen:

MSEG: matnr, werks, lgort, mtart, bwart.

MKPF: budat.

Report output:

MSEG: matnr, werks, lgort, menge, charg, shkzg.

MKPF: budat, xblnr.

To retrive the data from MKPF and MSEG tables If use in inner joins it takes huge amount of time. For this reason I used Function module 'BAPI_GOODSMVT_GETITEMS'.

I can pass all the select options into func. module.

I can retrive all the information from the function module except field SHKZG(Debit/Credit Indicator).

I am getting item data into the table BAPI2017_GM_ITEM_SHOW. But, SHKZG(Debit/Credit Indicator) filed is not available in this structure.

Please provide me if there any other fucntion module similar to this where in I can pass my selection screen data and retrieve required information to be displayed in output.

Or else please provide me the solution to retrieve data from MKPF & MSEG which takes less amount of time.

Regards,

vinod

[Former Member]

Hi,

Use these field MAT_DOC DOC_YEAR MATDOC_ITM from the structure BAPI2017_GM_ITEM_SHOW

and get the data from the SHKZG.

You have the whole primary key of table MSEG..then this should not be the performance issue.

[Former Member]

I used view for this.