C_ProdBufLvlDmndAdjmtFctrTP

DDL: C_PRODBUFLVLDMNDADJMTFCTRTP SQL: CBUFLVLDMDAFTP Type: view CONSUMPTION Package: ODATA_PP_DD_STLM
20 Fields 1 Data Sources 1 Associations

Product Buffer Level Demand Adjustment Factor - Transactions

C_ProdBufLvlDmndAdjmtFctrTP is a Consumption CDS View that provides data about "Product Buffer Level Demand Adjustment Factor - Transactions" in SAP S/4HANA. It reads from 1 data source (I_ProdBufLvlPrpslDmndTP) and exposes 20 fields with key fields Material, Plant, MRPArea, ProposalStartDate, ProposalVersion. It has 1 association to related views. Part of development package ODATA_PP_DD_STLM.

Data Sources (1)

SourceAliasJoin Type
I_ProdBufLvlPrpslDmndTP I_ProdBufLvlPrpslDmndTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_ProductBufferLevelMgmtTP _ProposalHeaderTP $projection.Material = _ProposalHeaderTP.Material and $projection.Plant = _ProposalHeaderTP.Plant and $projection.MRPArea = _ProposalHeaderTP.MRPArea and $projection.ProposalStartDate = _ProposalHeaderTP.ProposalStartDate and $projection.ProposalVersion = _ProposalHeaderTP.ProposalVersion

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CBUFLVLDMDAFTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Product Buffer Level Demand Adjustment Factor - Transactions view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
VDM.viewType #CONSUMPTION view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY MRPArea MRPArea MRP Area
KEY ProposalStartDate ProposalStartDate
KEY ProposalVersion ProposalVersion
KEY ProposalDmndAdjmtFctrStartDate ProposalDmndAdjmtFctrStartDate
PrpslDmndAdjmtFctrStrtDteEdit PrpslDmndAdjmtFctrStrtDteEdit
ProposalDmndAdjmtFctrEndDate ProposalDmndAdjmtFctrEndDate
DemandAdjustmentFactor DemandAdjustmentFactor
AverageDailyUsage AverageDailyUsage
AvgDailyUsageUnit AvgDailyUsageUnit
AdjustedAverageDailyUsage AdjustedAverageDailyUsage
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
ProductAuthorizationGroup ProductAuthorizationGroup
ProductTypeAuthorizationGroup ProductTypeAuthorizationGroup
ProductGroupAuthorizationGroup ProductGroupAuthorizationGroup
_ProposalHeaderTP _ProposalHeaderTP
_BufMatPlant I_ProdBufLvlPrpslDmndTP _BufMatPlant
_MatMRPArea _MatMRPArea

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_ProdBufLvlDmndAdjmtFctrTP.
-- 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: CBUFLVLDMDAFTP

CREATE VIEW C_ProdBufLvlDmndAdjmtFctrTP AS
SELECT
  Material,
  Plant,
  MRPArea,
  ProposalStartDate,
  ProposalVersion,
  ProposalDmndAdjmtFctrStartDate,
  PrpslDmndAdjmtFctrStrtDteEdit,
  ProposalDmndAdjmtFctrEndDate,
  DemandAdjustmentFactor,
  AverageDailyUsage,
  AvgDailyUsageUnit,
  AdjustedAverageDailyUsage,
  CreatedByUser,
  LastChangedByUser,
  ProductAuthorizationGroup,
  ProductTypeAuthorizationGroup,
  ProductGroupAuthorizationGroup,
  I_ProdBufLvlPrpslDmndTP._BufMatPlant AS _BufMatPlant
FROM I_ProdBufLvlPrpslDmndTP
LEFT OUTER JOIN C_ProductBufferLevelMgmtTP AS _ProposalHeaderTP ON Material = _ProposalHeaderTP.Material AND Plant = _ProposalHeaderTP.Plant AND MRPArea = _ProposalHeaderTP.MRPArea AND ProposalStartDate = _ProposalHeaderTP.ProposalStartDate AND ProposalVersion = _ProposalHeaderTP.ProposalVersion  -- association [1..1]
;

Learn More