R_MatlTimeDependentStockListTP

DDL: R_MATLTIMEDEPENDENTSTOCKLISTTP Type: view_entity TRANSACTIONAL
26 Fields 1 Data Sources 2 Associations

TP View Material Time Dependent Stk Lvls

R_MatlTimeDependentStockListTP is a Transactional CDS View that provides data about "TP View Material Time Dependent Stk Lvls" in SAP S/4HANA. It reads from 1 data source (I_MatlTimeDependentStockList) and exposes 26 fields with key fields Material, MRPPlant, MRPArea, StockLevelValidityStartDate. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MatlTimeDependentStockList _MaterialStkLvl from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Material _Product _Product.Material = _MaterialStkLvl.Material
[0..1] I_UnitOfMeasure _UnitOfMeasure _UnitOfMeasure.UnitOfMeasure = _MaterialStkLvl.BaseUnit

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label TP View Material Time Dependent Stk Lvls view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY MRPPlant MRPPlant Plant
KEY MRPArea MRPArea MRP Area
KEY StockLevelValidityStartDate StockLevelValidityStartDate Validity Start Date
StockLevelValidityEndDate StockLevelValidityEndDate Validity End Date
ProductSafetyStockLvlQuantity MaterialSafetyStockQty Safety Stock
ReorderThresholdQuantity ReorderThresholdQuantity Reorder Point
ProductMaxStockLevelQuantity MaterialMaxStockLevelQuantity Max.Stock Level
ProductTargetStockLvlQuantity MaterialTargetStockLvlQuantity Target Stock
UnitOfMeasure BaseUnit Unit of Measure
ChangeMode ChangeMode Mode of Change
TargetSupplyDurationInDays TargetSupplyDurationInDays Target Days
MaxSupplyDurationInDays MaxSupplyDurationInDays Max Days
SafetySupplyDurationInDays SafetySupplyDurationInDays Safety Days
StockLevelProposalID StockLevelProposalID Proposal ID
ProposalVersion ProposalVersion Proposal Version
ProposalStartDate ProposalStartDate Proposal Valid From
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
UnitOfMeasureNumberOfDecimals _UnitOfMeasure UnitOfMeasureNumberOfDecimals
UnitOfMeasureDspNmbrOfDcmls _UnitOfMeasure UnitOfMeasureDspNmbrOfDcmls
UnitOfMeasureISOCode _UnitOfMeasure UnitOfMeasureISOCode
_Product _Product
_StkLvlMaterial _StkLvlMaterial

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 R_MatlTimeDependentStockListTP.
-- 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 R_MatlTimeDependentStockListTP AS
SELECT
  Material,
  MRPPlant,
  MRPArea,
  StockLevelValidityStartDate,
  StockLevelValidityEndDate,
  MaterialSafetyStockQty AS ProductSafetyStockLvlQuantity,
  ReorderThresholdQuantity,
  MaterialMaxStockLevelQuantity AS ProductMaxStockLevelQuantity,
  MaterialTargetStockLvlQuantity AS ProductTargetStockLvlQuantity,
  BaseUnit AS UnitOfMeasure,
  ChangeMode,
  TargetSupplyDurationInDays,
  MaxSupplyDurationInDays,
  SafetySupplyDurationInDays,
  StockLevelProposalID,
  ProposalVersion,
  ProposalStartDate,
  CreatedByUser,
  LastChangedByUser,
  CreationDateTime,
  LastChangeDateTime,
  _UnitOfMeasure.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  _UnitOfMeasure.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  _UnitOfMeasure.UnitOfMeasureISOCode AS UnitOfMeasureISOCode
FROM I_MatlTimeDependentStockList AS _MaterialStkLvl
LEFT OUTER JOIN I_Material AS _Product ON _Product.Material = _MaterialStkLvl.Material  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = _MaterialStkLvl.BaseUnit  -- association [0..1]
;

Learn More