topic Re: Planning Report in Application Development and Automation Discussions

Planning Report

Former Member — Wed, 13 Jun 2007 20:33:05 GMT

I need the following Details to be fetched for the planning report. Could any tell from which table fields I can find the following details for the report?

Material

Material Desc.

Grid Value

Storage Loc.

Vendor

On Hand Qty

Passed Due

Customer Order No.

Purchase Order No.

Customer Order Qty

Purchase Order Qty

Re: Planning Report

Former Member — Wed, 13 Jun 2007 20:37:39 GMT

Material[EKKO]

Material Desc.[MAKT]

Grid Value

Storage Loc.[MARD]

Vendor[EKKO]

On Hand Qty

Passed Due

Customer Order No.

Purchase Order No.[EKKO]

Customer Order Qty

Purchase Order Qty [EKKO]

Hi,

Since i dont have access to SAP today, i could not able to provide for all the fields.

Regards,

*DJ

Reward, if its useful

Re: Planning Report

Former Member — Wed, 13 Jun 2007 20:38:52 GMT

Hi,

You will get all these details from tables EKKO, EKPO, MAKT, MARD. You will get all the details.

thanks,

sksingh

Re: Planning Report

Former Member — Wed, 13 Jun 2007 20:39:12 GMT

> I need the following Details to be fetched for the

> planning report. Could any tell from which table

> fields I can find the following details for the

> report?

> Material - MARA-MATNR

> Material Desc.- MAKT-MAKTX

> Grid Value

> Storage Loc. - MARD-LGORT

> Vendor - MSEG-LIFNR

> On Hand Qty - Could be sum of unrestricted stock + stock in transfer + stock in quality inspection + blocked stock etc and the fields are MARD-LABST + MARD-UMLME + MARD-INSME + MARD-SPEME = MSEG-MENGE

> Passed Due

> Customer Order No.

> Purchase Order No. - EKKO-EBELN

> Customer Order Qty

> Purchase Order Qty - EKPO-MENGE

Regards,

Naren

Message was edited by:

Naren Someneni

Re: Planning Report

Former Member — Wed, 13 Jun 2007 20:39:43 GMT

Please look at Ekko, ekpo, lfa1, makt, mara

Shreekant+

Re: Planning Report

Former Member — Tue, 28 Apr 2009 18:36:47 GMT

resolved