topic Re: material qantity in Application Development and Automation Discussions

material qantity

Former Member — Mon, 30 Jul 2007 11:49:19 GMT

hi every body

can anybody help me? from which table i can get

opening stock/qty,

JW Cons. Qty,

JW Waste. Qty,

IH Waste. Qty,

Receipt Qty,

Issue Qty,

Mat. Trans Qty,

Mat. Cons Qty,

Jobwork Qty,

Others Qty,

Closing Stock Qty,

Net_Wt ,

Wunit ,

Production Qty ,

Sam. Prod. Qty ,

Sal. Trans Qty ,

Sales Dom Qty ,

Sales RTD Qty ,

Sales EXP Qty,

plz plz help me its very urgent.

thank you.

Re: material qantity

Former Member — Mon, 30 Jul 2007 11:53:33 GMT

Be more clear with your requirements? What's the requirement is?

then it is easier to tell the exact tables

check the tables MARD,MSEG,MKPF,MBEW with respect to different qty's of a material

Reward points for useful Answers

Regards

Anji

Re: material qantity

Vijay — Mon, 30 Jul 2007 11:57:09 GMT

hi ANKITA

check from following tables

MARA

MAKT

MARM

MBEW

MLAN

MARC

hope it clears ur doubt

regards

VIJAY

plz dont forget to reward points if useful

Re: material qantity

Former Member — Mon, 30 Jul 2007 11:57:50 GMT

u need to check various tables like MARA, MARC, MARD,MSEG,MKPF,MBEW, VBAP, VBPA etc...

Be specific to ur requirement and to fields as u can get all fields if u search the above tables.

Re: material qantity

Former Member — Tue, 31 Jul 2007 03:59:20 GMT

hi all,

There is one formula to calculate Average quantity of total stock.

beginning stock + n stock at month´s end

n + 1

and consignment stock for total stock.

For this formula I need beginning stock and stock at month end .

from which table i can get value for this two stock.

thank you

Re: material qantity

Former Member — Tue, 31 Jul 2007 04:09:12 GMT

Hi Ankita,

Check if table MBEW and MSEG can give you this information.

Regards,

Atish