Material Posting Date & Usage

[Former Member]

Hi Gurus,

My requirement is to desing a new sales and usage of Materials for a Paticular plant.

In this report i need to show Posting Date in selection screen,

And please let me know how we will find out the usage of the Materials.

Thankyou in advance.

[Former Member · Accepted solution]

You can get the Posting date from table MKPF for material documents.

That is for a material in sales order whenever u do a Post Goods Issue then the Tables MKPF and MSEG are updated.

U can find the material number in table MSEG( Line item table for material document)

and the Posting date corresponding to that mat. doc no. in MKPF ( Header table)

Similarly usage of material u can get by the stock available in MSEG table for that material. U can see these tables u will get a fair idea.

[Former Member · Accepted solution]

Thankyou for your response .

Can you please explain me clearly about the Material usage for a particular point.

what are the fields we need take consider in this.

Edited by: vinay raj on May 14, 2009 7:40 AM

[Former Member · Accepted solution]

MSEG-LBKUM (valuated stock)

MSEG-SALK3(total value)

[Former Member · Accepted solution]

thanku very much vijetasap.

pls let me know from where we will get the sales also.

U have solved my 80 % issue.

[Former Member · Accepted solution]

Hi Vinay,

I solved 80 % of ur issue but still no rewards, just kidding.

Anyways ur sales data:-

MSEG-KDAUF (sales order no.)

MSEG-KDPOS(sales order line item)

[Former Member · Accepted solution]

ha ha nice one.

I think these point are not enough .

Thanku very much dude.

will be in touch with u through this forum.

I will start implemeting this now.