R_ProductTimeDepdntStockLvlTP

DDL: R_PRODUCTTIMEDEPDNTSTOCKLVLTP Type: view_entity TRANSACTIONAL
23 Fields 1 Data Sources 2 Associations

TP view for Product time dependent stock

R_ProductTimeDepdntStockLvlTP is a Transactional CDS View that provides data about "TP view for Product time dependent stock" in SAP S/4HANA. It reads from 1 data source (I_TimeDependentStockBuffer) and exposes 23 fields with key fields Product, Plant, MRPArea, StockLevelValidityStartDate. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TimeDependentStockBuffer _ProdStkLvl from

Associations (2)

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

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name ProductTimeDependentStockLevel view
EndUserText.label TP view for Product time dependent stock view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY Product Material Vehicle Model
KEY Plant Plant Valuation Area
KEY MRPArea MRPArea MRP Area
KEY StockLevelValidityStartDate BufferLevelStartDate Validity Start Date
StockLevelValidityEndDate BufferLevelEndDate Validity End Date
ProductSafetyStockLvlQuantity MaterialSafetyStockQty Safety Stock
ReorderThresholdQuantity ReorderThresholdQuantity Reorder Point
ProductMaxStockLevelQuantity MaterialMaxStockLevelQuantity
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
_UnitOfMeasure _UnitOfMeasure
_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 R_ProductTimeDepdntStockLvlTP.
-- 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_ProductTimeDepdntStockLvlTP AS
SELECT
  Material AS Product,
  Plant,
  MRPArea,
  BufferLevelStartDate AS StockLevelValidityStartDate,
  BufferLevelEndDate AS 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
FROM I_TimeDependentStockBuffer AS _ProdStkLvl
LEFT OUTER JOIN I_Material AS _Product ON _Product.Material = _ProdStkLvl.Material  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = _ProdStkLvl.BaseUnit  -- association [0..1]
;

Learn More