Inventory report

[former_member190312]

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

[Former Member]

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

[Former Member]

Check the table

IKPF - Header: Physical Inventory Document

ISEG - Physical Inventory Document Items

Regards,

Prakash.

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

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

also check Fm

MB_CHECK_MATERIAL_STOCKS

MB_READ_MATERIAL_STOCKS

Regards

Amole

[Former Member]

Hi,

check out standard programs

RKCSE004

RKKBGEN2

RKKBGENH

RKKBGENI

RLABGL00

RLBEST00

RLDLVS10

RM07MKBS

RM07MKON

RM07MLBD

RM07MLBS

Regards

Amole