Hello

[Former Member]

How to create a report using given details

Development of Material stock report, which shows the opening stock closing stock, goods receipt qty, goods issue qty, Total stock value of a material at given date.

By which tables and mandatory fields .

[Former Member]

Check tables

MKPF, MSEG

MBEW, MBEWH,

Also search for MM tables relations.

Regards,

Arek

[Former Member]

Hi,

mara(mat master)

makt(description)

mard(mat storage loc)

marc(mat plant data)

mbew(valueation)

mvke sales data for mat

Also,

mbew-LBKUM( total valuated stock) and mbew-LVORM(deletion indicator) = space

mara-mtart( material Type ) and mara-MATKL( material group ) and mara-LVORM(deletion indicator) = space

marc-werks( plant) and marc-LVORM(deletion indicator) = space

MARD-LGORT( storage Location ) and mard-labst( unrestricted stock) and mard-LVORM(deletion indicator) = space

makt-maktx( material Descriptions) and makt-spras = sy-langu.

Please check the sample code for this requiment.

https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=15856

Below are few important Common Tables used in Materials Management Modules:

EINA Purchasing Info Record- General Data

EINE Purchasing Info Record- Purchasing Organization Data

MAKT Material Descriptions

MARA General Material Data

MARC Plant Data for Material

MARD Storage Location Data for Material

MAST Material to BOM Link

MBEW Material Valuation

MKPF Header- Material Document

MSEG Document Segment- Material

MVER Material Consumption

MVKE Sales Data for materials

RKPF Document Header- Reservation

T023 Mat. groups

T024 Purchasing Groups

T156 Movement Type

T157H Help Texts for Movement Types

MOFF Lists what views have not been created

A501 Plant/Material

EBAN Purchase Requisition

EBKN Purchase Requisition Account Assignment

EKAB Release Documentation

EKBE History per Purchasing Document

EKET Scheduling Agreement Schedule Lines

EKKN Account Assignment in Purchasing Document

EKKO Purchasing Document Header

EKPO Purchasing Document Item

IKPF Header- Physical Inventory Document

ISEG Physical Inventory Document Items

LFA1 Vendor Master (General section)

LFB1 Vendor Master (Company Code)

NRIV Number range intervals

RESB Reservation/dependent requirements

T161T T exts for Purchasing Document Types

Reward Points if found helpfull..

Cheers,

Chandra Sekhar.