I_TIMEDEPENDENTSTOCKBUFFER

CDS View
17 Fields 10 CDS Views

Product Time Dependent Stock Level

I_TIMEDEPENDENTSTOCKBUFFER is a CDS View in S/4HANA. Product Time Dependent Stock Level. It contains 17 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
A_ProductStockBuffer view_entity from COMPOSITE Actual Stock
I_TimeDependentStockBufferTP view_entity from TRANSACTIONAL Transactional View for Demand Driven Adopted Stock Levels
P_ProdBufLvlMicroChtAggrgn1 view left_outer CONSUMPTION Aggregations for Product Buffer Level Micro Chart
P_ProdBufLvlMicroChtAggrgn3 view_entity from CONSUMPTION MBL Micro Chart Horizon Values
P_ProductAdoptedBufferLevels view from COMPOSITE DDMRP Adopted Buffer Levels
P_ProductBufferMicroChart1 view left_outer CONSUMPTION DDR Buffer Level Micro Chart
P_TimeDependentBufferLevels view from CONSUMPTION Time Dependent Buffer Levels
P_TimeDependentStock view left_outer COMPOSITE Demand-Driven Time Dependent Stock
P_TimeDependentStockBuffer view from CONSUMPTION Private View for Demand driven Adopted Stock Levels
R_ProductTimeDepdntStockLvlTP view_entity from TRANSACTIONAL TP view for Product time dependent stock

Fields (17)

KeyField CDS FieldsUsed in Views
KEY BufferLevelStartDate BufferLevelStartDate 4
KEY Material Material 4
KEY MRPArea MRPArea 4
KEY Plant Plant 4
KEY ProposalStartDate ProposalStartDate 4
KEY ProposalVersion ProposalVersion 4
BaseUnit BaseUnit 4
BufferLevelEndDate BufferLevelEndDate 4
ChangeMode ChangeMode 2
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
MaterialMaxStockLevelQuantity MaterialMaxStockLevelQuantity 4
MaterialSafetyStockQty CurrentRedZone,MaterialSafetyStockQty 4
ReorderThresholdQuantity ReorderThresholdQuantity 4
StockLevelProposalID StockLevelProposalID 4

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.

-- Product Time Dependent Stock Level
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TIMEDEPENDENTSTOCKBUFFER (
    BUFFERLEVELSTARTDATE,
    MATERIAL,
    MRPAREA,
    PLANT,
    PROPOSALSTARTDATE,
    PROPOSALVERSION,
    BASEUNIT,
    BUFFERLEVELENDDATE,
    CHANGEMODE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIALMAXSTOCKLEVELQUANTITY,
    MATERIALSAFETYSTOCKQTY,
    REORDERTHRESHOLDQUANTITY,
    STOCKLEVELPROPOSALID,
    PRIMARY KEY (BUFFERLEVELSTARTDATE, MATERIAL, MRPAREA, PLANT, PROPOSALSTARTDATE, PROPOSALVERSION)
);

Learn More