I_TimeDependentStockBufferTP

DDL: I_TIMEDEPENDENTSTOCKBUFFERTP SQL: IDDSTBUFTP Type: view TRANSACTIONAL
18 Fields 1 Data Sources

Transactional View for Demand Driven Adopted Stock Levels

I_TimeDependentStockBufferTP is a Transactional CDS View that provides data about "Transactional View for Demand Driven Adopted Stock Levels" in SAP S/4HANA. It reads from 1 data source (I_TimeDependentStockBuffer) and exposes 18 fields with key fields Material, Plant, MRPArea, BufferLevelStartDate.

Data Sources (1)

SourceAliasJoin Type
I_TimeDependentStockBuffer StockBuffer from

Annotations (16)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
AbapCatalog.sqlViewName IDDSTBUFTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence DDSTKBUFTP_D view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Transactional View for Demand Driven Adopted Stock Levels view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Material I_TimeDependentStockBuffer Material Vehicle Model
KEY Plant I_TimeDependentStockBuffer Plant Valuation Area
KEY MRPArea I_TimeDependentStockBuffer MRPArea MRP Area
KEY BufferLevelStartDate I_TimeDependentStockBuffer BufferLevelStartDate Validity Start Date
BufferLevelEndDate I_TimeDependentStockBuffer BufferLevelEndDate Validity End Date
MaterialSafetyStockQty I_TimeDependentStockBuffer MaterialSafetyStockQty Safety Stock
ReorderThresholdQuantity I_TimeDependentStockBuffer ReorderThresholdQuantity Reorder Point
MaterialMaxStockLevelQuantity I_TimeDependentStockBuffer MaterialMaxStockLevelQuantity
BaseUnit I_TimeDependentStockBuffer BaseUnit Unit of Measure
ChangeMode I_TimeDependentStockBuffer ChangeMode Mode of Change
StockLevelProposalID I_TimeDependentStockBuffer StockLevelProposalID Proposal ID
CreatedByUser I_TimeDependentStockBuffer CreatedByUser User Name
LastChangedByUser I_TimeDependentStockBuffer LastChangedByUser User Name
CreationDateTime I_TimeDependentStockBuffer CreationDateTime Timestamp
LastChangeDateTime I_TimeDependentStockBuffer LastChangeDateTime Timestamp
_BufMatPlant _BufMatPlant
_MatMRPArea _MatMRPArea
_ChgModeText _ChgModeText

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 I_TimeDependentStockBufferTP.
-- 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.
-- SQL view name: IDDSTBUFTP

CREATE VIEW I_TimeDependentStockBufferTP AS
SELECT
  StockBuffer.Material AS Material,
  StockBuffer.Plant AS Plant,
  StockBuffer.MRPArea AS MRPArea,
  StockBuffer.BufferLevelStartDate AS BufferLevelStartDate,
  StockBuffer.BufferLevelEndDate AS BufferLevelEndDate,
  StockBuffer.MaterialSafetyStockQty AS MaterialSafetyStockQty,
  StockBuffer.ReorderThresholdQuantity AS ReorderThresholdQuantity,
  StockBuffer.MaterialMaxStockLevelQuantity AS MaterialMaxStockLevelQuantity,
  StockBuffer.BaseUnit AS BaseUnit,
  StockBuffer.ChangeMode AS ChangeMode,
  StockBuffer.StockLevelProposalID AS StockLevelProposalID,
  StockBuffer.CreatedByUser AS CreatedByUser,
  StockBuffer.LastChangedByUser AS LastChangedByUser,
  StockBuffer.CreationDateTime AS CreationDateTime,
  StockBuffer.LastChangeDateTime AS LastChangeDateTime
FROM I_TimeDependentStockBuffer AS StockBuffer
;

Learn More