Planning Report

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

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

thanks,

sksingh

[Former Member]

> 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

[Former Member]

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

Shreekant+

[Former Member]

resolved