PPH_DD_STK
Time Dependent Actual Stock Levels
PPH_DD_STK is an SAP database table in S/4HANA. Time Dependent Actual Stock Levels. It contains 23 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MatlTimeDependentStockList | view_entity | from | BASIC | Material Time Dependent Stock List |
| I_TimeDependentStockBuffer | view_entity | from | BASIC | Product Time Dependent Stock Level |
| I_TimeDependentStockLevel | view_entity | from | BASIC | Time Dependent Stock Level |
Fields (23)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | matnr | matnr | Material | |||
| KEY | werks | werks_d | Plant | |||
| KEY | berid | berid | MRP Area | |||
| KEY | date_from | pph_begda | Valid-From Date | |||
| date_to | pph_endda | Valid-To Date | ||||
| safety_stock | eisbe | Safety Stock | ||||
| reorder_point | minbe | Reorder Point | ||||
| target_stock | pp_target_stock | Target Stk Level | ||||
| max_stock | mabst | Max.Stock Level | ||||
| stock_unit | meins | Base Unit | ||||
| safety_dos | pp_safety_days_of_supply | Safety Days | ||||
| target_dos | pp_target_days_of_supply | Target Days | ||||
| max_dos | pp_max_days_of_supply | Max Days | ||||
| change_mode | pph_change_mode | Mode of Change | ||||
| prop_date_from | pph_proposal_begda | Proposal Valid From | ||||
| prop_ver | pph_proposal_ver | Proposal Version | ||||
| proposal_id | pph_proposal_id | Proposal Id | ||||
| created_by | ernam | Created By | ||||
| changed_by | aenam | Changed By | ||||
| created_time | timestamp | Time Stamp | ||||
| changed_time | timestamp | Time Stamp | ||||
| _dataaging | data_temperature | Data Aging |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Time Dependent Actual Stock Levels
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_DD_STK (
MANDT, -- Client [mandt]
MATNR, -- Material [matnr]
WERKS, -- Plant [werks_d]
BERID, -- MRP Area [berid]
DATE_FROM, -- Valid-From Date [pph_begda]
DATE_TO, -- Valid-To Date [pph_endda]
SAFETY_STOCK, -- Safety Stock [eisbe]
REORDER_POINT, -- Reorder Point [minbe]
TARGET_STOCK, -- Target Stk Level [pp_target_stock]
MAX_STOCK, -- Max.Stock Level [mabst]
STOCK_UNIT, -- Base Unit [meins]
SAFETY_DOS, -- Safety Days [pp_safety_days_of_supply]
TARGET_DOS, -- Target Days [pp_target_days_of_supply]
MAX_DOS, -- Max Days [pp_max_days_of_supply]
CHANGE_MODE, -- Mode of Change [pph_change_mode]
PROP_DATE_FROM, -- Proposal Valid From [pph_proposal_begda]
PROP_VER, -- Proposal Version [pph_proposal_ver]
PROPOSAL_ID, -- Proposal Id [pph_proposal_id]
CREATED_BY, -- Created By [ernam]
CHANGED_BY, -- Changed By [aenam]
CREATED_TIME, -- Time Stamp [timestamp]
CHANGED_TIME, -- Time Stamp [timestamp]
_DATAAGING, -- Data Aging [data_temperature]
PRIMARY KEY (MANDT, MATNR, WERKS, BERID, DATE_FROM)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA