C_MatlTimeDependentStockList

DDL: C_MATLTIMEDEPENDENTSTOCKLIST Type: view_entity CONSUMPTION Package: ODATA_SAFETY_STK_PP_MRP
24 Fields 1 Data Sources 1 OData Services

Time Dependent Stk List Projection

C_MatlTimeDependentStockList is a Consumption CDS View that provides data about "Time Dependent Stk List Projection" in SAP S/4HANA. It reads from 1 data source (R_MatlTimeDependentStockListTP) and exposes 24 fields with key fields Material, MRPPlant, MRPArea, StockLevelValidityStartDate. It is exposed through 1 OData service (ASQL_F5726). Part of development package ODATA_SAFETY_STK_PP_MRP.

Data Sources (1)

SourceAliasJoin Type
R_MatlTimeDependentStockListTP R_MatlTimeDependentStockListTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Time Dependent Stk List Projection view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F5726 ASQL_F5726 C2 NOT_RELEASED

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY MRPPlant MRPPlant Plant
KEY MRPArea MRPArea MRP Area
KEY StockLevelValidityStartDate StockLevelValidityStartDate
StockLevelValidityEndDate StockLevelValidityEndDate
ProductSafetyStockLvlQuantity ProductSafetyStockLvlQuantity Safety Stock
ReorderThresholdQuantity ReorderThresholdQuantity Reorder Point
ProductMaxStockLevelQuantity ProductMaxStockLevelQuantity
ProductTargetStockLvlQuantity ProductTargetStockLvlQuantity
UnitOfMeasure UnitOfMeasure Unit Protected Qty
UnitOfMeasureNumberOfDecimals UnitOfMeasureNumberOfDecimals
UnitOfMeasureDspNmbrOfDcmls UnitOfMeasureDspNmbrOfDcmls
UnitOfMeasureISOCode UnitOfMeasureISOCode
ChangeMode ChangeMode
TargetSupplyDurationInDays TargetSupplyDurationInDays
MaxSupplyDurationInDays MaxSupplyDurationInDays
SafetySupplyDurationInDays SafetySupplyDurationInDays
StockLevelProposalID StockLevelProposalID
ProposalVersion ProposalVersion
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
_Product _Product

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MatlTimeDependentStockList.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_MatlTimeDependentStockList AS
SELECT
  Material,
  MRPPlant,
  MRPArea,
  StockLevelValidityStartDate,
  StockLevelValidityEndDate,
  ProductSafetyStockLvlQuantity,
  ReorderThresholdQuantity,
  ProductMaxStockLevelQuantity,
  ProductTargetStockLvlQuantity,
  UnitOfMeasure,
  UnitOfMeasureNumberOfDecimals,
  UnitOfMeasureDspNmbrOfDcmls,
  UnitOfMeasureISOCode,
  ChangeMode,
  TargetSupplyDurationInDays,
  MaxSupplyDurationInDays,
  SafetySupplyDurationInDays,
  StockLevelProposalID,
  ProposalVersion,
  CreatedByUser,
  LastChangedByUser,
  CreationDateTime,
  LastChangeDateTime
FROM R_MatlTimeDependentStockListTP
;

Learn More