Goods Movement type

[Former Member]

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

[Former Member]

Hi,

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

Regards, Andy

[Former Member]

Hi,

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

Pls provide more details about your requirement.

Regards,

Satya.

[Former Member]

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

[Former Member]

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.

[Former Member]

thank you very much......

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

how can i know the data.

thanks & regards

srinivas.