Scribd
Upload
144 views4 pages

Stock Aging Report by Storage Location

The document outlines the Stock-Ageing Report by detailing the necessary input fields and corresponding tables for data retrieval, including company code, plant, store location, and material. It specifies the formulas for calculating quantities and values based on posting dates within specified day ranges. Additionally, it describes how to extract material type, description, and unit of measure from relevant tables.

Uploaded by

tyagibharat120
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
144 views4 pages

Stock Aging Report by Storage Location

The document outlines the Stock-Ageing Report by detailing the necessary input fields and corresponding tables for data retrieval, including company code, plant, store location, and material. It specifies the formulas for calculating quantities and values based on posting dates within specified day ranges. Additionally, it describes how to extract material type, description, and unit of measure from relevant tables.

Uploaded by

tyagibharat120
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Stock-Ageing Report storage location wise

Input TECHNICAL FIELD NAME TABLE NAME


Company code BUKRS T001
Plant WERKS T001W
Store Location LGORT T001L
Material MATNR MARD
[Link] MTART MARA
Posting Date BUDAT MKPF

Plant [Link] Material

Pass the Field WERKS


lnput the Field Pass the Field WERKS in
and LGORT in Table
WERKS from the Table T001L and get the
MARD and get the
Table T001w Field LGORT
Field MATNR

MJAHR
Pass the Field MATNR in table MSEG and get the Field MJAHR
MBLNR
Pass the Field MATNR in table MSEG and get the Field MBNR
BUDAT
Pass the Field MBLNR in table MKPF and get the Field BUDAT

Formula for finding


Quantity between (0-30)days
Current Date - Posting Date <= 30 then '0-30' days
Value between (0-30)days
Current Date - Posting Date <= 30 then '0-30' days
Quantity between (31-60)days
Current Date - Posting Date (Between 31 and 60 then = '31-60 days)
Value between (31-60)days
Current Date - Posting Date (Between 31 and 60 then = '31-60 days)
Input the Field BUKRS from the Table T001

Material Type Material Description UOM

Pass the Field


Pass the Field MATNR in Table Pass the Field MATNR in Table
MATNR in Table
MARA and get the Field MARA and get the Field
MARA and get the
MTART MAKTX
Field MEINS
Tot. Available Stock Total Stock Value Qty Bet. 0-30 Days Val. Bet. 0-30 Days

Pass the Field MATNR in Pass the Field MATNR


CALCULATED CALCULATED THROUGH
Table MBEW and get the in Table MBEW and get
THROUGH FORMULA FORMULA
Field LBKUM the Field SALK3
Qty Bet. 31-60 Days Val. Bet. 31-60 Days

CALCULATED THROUGH CALCULATED


FORMULA THROUGH FORMULA

You might also like