topic Re: Goods Movement type in Application Development and Automation Discussions

Goods Movement type

Former Member — Fri, 02 May 2008 14:46:36 GMT

hi friends,

i am developing the report which displays stock overview at particular date.

when we consider the MBBS( its based on table EBEW ) transaction it displays current stock overview. i am taking the data from MSEG table for current date.

i calculated the stock based on field shkbz

but i am getting some extra stock

please tell me which movement type we have credit and debit

thanks & regards

srinivas

Re: Goods Movement type

Former Member — Fri, 02 May 2008 19:16:40 GMT

Hi,

I'm not sure what the field is you listed but SHKZG indicates credit/debit.

Regards, Andy

Re: Goods Movement type

Former Member — Sat, 03 May 2008 12:54:03 GMT

Hi,

Try using MBEW table for current stock(MBEW-LBKUM) for a particular plant.

Pls provide more details about your requirement.

Regards,

Satya.

Re: Goods Movement type

Former Member — Sun, 04 May 2008 12:32:31 GMT

thank for your responce.......

i want to diaplay the stock report based on sales order at a particular date......

i.e i want to display the stcok at particular date

thanks regards

srinivas

Re: Goods Movement type

Former Member — Sun, 04 May 2008 13:52:20 GMT

Check movement types for GI-Goods Isuue (ex: 231, 251,261etc.) with Debit/credit indicator MSEG-SHKZG = 'H' , which means credit to account.

Similarly movement types for Returns (ex: 232, 252,262 etc) with MSEG-SHKZG = ' S', which means debit.

Also GR (goods receipt ) done against a sales order is also debit to account.(SHKZG = S).

Also check the table S031 'Statistics: Movements for current stocks', it might be useful for you.

Regards,

Satya.

Re: Goods Movement type

Former Member — Mon, 05 May 2008 09:41:35 GMT

thank you very much......

if i want to calculate the project stock for past dates,

how can i know the data.

thanks & regards

srinivas.