Skip to Content
author's profile photo Former Member
Former Member

Need to get STOCK related tables in SAP

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 10:34 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 10:35 AM

    Take a look at table MARD.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 10:48 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 03, 2008 at 10:25 AM

    Thanks Experts for the HELP!!!!

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.