topic Re: Goods movement in Application Development and Automation Discussions

Goods movement

Former Member — Thu, 17 Nov 2005 11:35:53 GMT

Hi Friends,

I would like to know how to generate a goods movement report which has the select-options for material number,(plant & posting date )which are mandatory,movement type,material type,material group.

My output would contain:

plant,material no,description,unit ofmeasure,

openingstocks(qty & amt),goods receipts(qty & amt),goods issues(qty&amt),closing stocks(qty & amt). i would like if anybody could throw some light on this issue.

Thanks,

Vinay

Re: Goods movement

Former Member — Thu, 17 Nov 2005 11:56:30 GMT

Hi,

Check if this helps.......

BAPI_GOODSMVT_GETITEMS

Re: Goods movement

Former Member — Thu, 17 Nov 2005 11:59:40 GMT

Hi,

You can create Goods movement with the help of the following BAPI

CALL FUNCTION 'BAPI_GOODSMVT_CREATE'

EXPORTING

GOODSMVT_HEADER = GOODSMVT_HEADER

GOODSMVT_CODE = GOODSMVT_CODE

TESTRUN = ' '

IMPORTING

GOODSMVT_HEADRET = GOODSMVT_HEADRET

MATERIALDOCUMENT =
MATDOCUMENTYEAR =

TABLES

GOODSMVT_ITEM = GOODSMVT_ITEM

GOODSMVT_SERIALNUMBER =

RETURN = IT_ERRMSG.

And regarding the population of all the BAPI structures,

Its clearly given in the BAPI FM Documentation.

You can have clear look at the Documentation.

Re: Goods movement

Former Member — Thu, 17 Nov 2005 12:26:33 GMT

hi,

To give goods movement report you can use MKPF and MSEG ( Material document) tables. this table will contain all your selection screen fields. Based on those values you can read all the goods movents details.

rajkumar abbu

Re: Goods movement

Former Member — Thu, 17 Nov 2005 12:31:12 GMT

HI Vinayak,

Here is a skeleton of the program you need to have

Start-of-selection.

Select data from MKPF and MSEG tables into internal tables based on the select options defined.

End-of-selection.

Write the report.

Regards,

Ravi

Re: Goods movement

Former Member — Thu, 17 Nov 2005 15:03:47 GMT

Hi,

Yoc can select the data from MKPF & MSEG base on the selection criteria you mention.

or used the FM BAPI_GOODSMVT_GETITEMS to get the details.

Thanks

Rajeev

Re: Goods movement

Former Member — Thu, 17 Nov 2005 15:16:22 GMT

Or you could just look at transaction MB51 as a great place to start.

Good luck!

Terry