topic Re: Inventory report in Application Development and Automation Discussions

Inventory report

former_member190312 — Tue, 19 Sep 2006 13:39:34 GMT

hi all,

i want to develop a report for physical inventory i.e a report which can show the quantity of materials present in inventory.it is a daily or weekly basis report.

so, what r the tables , i need to use for this report?

Thanks for ur help

Regards

pabitra

Re: Inventory report

Former Member — Tue, 19 Sep 2006 13:41:04 GMT

Y do you need that when you have MMBE transaction which does the same for you.

Refer tables:

MARC. Material in plant

MARD. Material in storage location

MKOL, MKOP. "material at vendor consignment..

REgards,

Ravi

Re: Inventory report

Former Member — Tue, 19 Sep 2006 13:46:09 GMT

Check the table

IKPF - Header: Physical Inventory Document

ISEG - Physical Inventory Document Items

Regards,

Prakash.

Re: Inventory report

Former Member — Tue, 19 Sep 2006 13:47:34 GMT

Hi Pabitra,

Below are the tables required for Physical Inventory report.

TABLES: IKPF, "Header: Physical Inventory Document

ISEG, "Physical Inventory Document Items

MBEW, "Material Valuation

T001L, "Storage Locations

MARA. "General Material Data

Re: Inventory report

Former Member — Tue, 19 Sep 2006 13:59:07 GMT

MARD is the table where physical inventory is stored at storage location level....the unrestricted stock field is MARD-LABST.

Re: Inventory report

Former Member — Tue, 19 Sep 2006 14:09:18 GMT

Hi,

use table mara,marac,marv,marm,mseg.

also check Fm

MB_CHECK_MATERIAL_STOCKS

MB_READ_MATERIAL_STOCKS

Regards

Amole

Re: Inventory report

Former Member — Tue, 19 Sep 2006 14:13:03 GMT

Hi,

check out standard programs

RKCSE004

RKKBGEN2

RKKBGENH

RKKBGENI

RLABGL00

RLBEST00

RLDLVS10

RM07MKBS

RM07MKON

RM07MLBD

RM07MLBS

Regards

Amole