Need to get STOCK related tables in SAP

[Former Member]

Hello Friends,

I am creating Custom tables for one of the requirements and need your help.

<b>Requirment is to create Custom tables <u>to get STOCK related data</u> from SAP into the tables mentioned below.

</b>

<b>1) Z_STKHDR - Stock header data by material and location</b>

The structure of the table is

Material
Location
Quantity
PeriodUnitCarryingCost
SafetyStock
PeriodUnitViolationCost

<b>2) Z_STKCARYCOST -

STK_Carrying_Cost which is Time phased inventory carrying cost</b>

The structure of the table is

Material
Location
ToDate
PeriodUnitCarryingCost

<b>3) Z_STK_SAFSTK_TIME -

Time phased safety stock values and violation cost.</b>

The structure of the table is

Material
Location
ToDate
SafetyStock
PeriodUnitViolationCost
CycleStock

Thank you in advance.

[Former Member]

if you once go thru the flow of MM03(material display),

you can find all the fields related to stock.

for any field you can press f1 , f9 to get its table name.

[Former Member]

Take a look at table MARD.

[Former Member]

Please note stocks in SAP are stored in MARD at storagelocation level..Hence your location field would be either plant code or plant+sloc depending on your requirement.

<u>Lets say it is plant level</u>

Z_STKHDR - Stock header data by material and location

Material - MARC-matnr

Location - MARC-werks

Quantity - SUM of MARD-LABST for the particular plant

PeriodUnitCarryingCost

SafetyStock - MARC-EISBE

PeriodUnitViolationCost

[Former Member]

Thanks Experts for the HELP!!!!

[Former Member]

Hello Ranjan,

Could you please share information on what tables you used to calculate the inventory carrying costs?

I am actually looking for tables related to storage space costs, cost of capital etc information but not able to find it.

Any suggestions would be appreciated.

Thanks and Regards
Sangamesh