C_ProdBufLvlZnAdjmtFctrTP

DDL: C_PRODBUFLVLZNADJMTFCTRTP SQL: CBUFLVLADJFCTR Type: view CONSUMPTION
19 Fields 1 Data Sources 1 Associations

Product Buffer Level Zone Adjustment Factors - Transactions

C_ProdBufLvlZnAdjmtFctrTP is a Consumption CDS View that provides data about "Product Buffer Level Zone Adjustment Factors - Transactions" in SAP S/4HANA. It reads from 1 data source (I_ProdBufLvlPrpslZnAdjmtFctrTP) and exposes 19 fields with key fields Material, Plant, MRPArea, ProposalStartDate, ProposalVersion. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProdBufLvlPrpslZnAdjmtFctrTP I_ProdBufLvlPrpslZnAdjmtFctrTP 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 (12)

NameValueLevelField
AbapCatalog.sqlViewName CBUFLVLADJFCTR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Product Buffer Level Zone Adjustment Factors - Transactions 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 (19)

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 BufPrpslZoneAdjmtFctrStartDate BufPrpslZoneAdjmtFctrStartDate
BufPrpslZnAdjmtFctrStrtDteEdit BufPrpslZnAdjmtFctrStrtDteEdit
BufPrpslZoneAdjmtFctrEndDate BufPrpslZoneAdjmtFctrEndDate
RedZoneAdjustmentFactor RedZoneAdjustmentFactor
YellowZoneAdjustmentFactor YellowZoneAdjustmentFactor
GreenZoneAdjustmentFactor GreenZoneAdjustmentFactor
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
ProductAuthorizationGroup ProductAuthorizationGroup
ProductTypeAuthorizationGroup ProductTypeAuthorizationGroup
ProductGroupAuthorizationGroup ProductGroupAuthorizationGroup
_ProposalHeaderTP _ProposalHeaderTP
_BufMatPlant I_ProdBufLvlPrpslZnAdjmtFctrTP _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_ProdBufLvlZnAdjmtFctrTP.
-- 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: CBUFLVLADJFCTR

CREATE VIEW C_ProdBufLvlZnAdjmtFctrTP AS
SELECT
  Material,
  Plant,
  MRPArea,
  ProposalStartDate,
  ProposalVersion,
  BufPrpslZoneAdjmtFctrStartDate,
  BufPrpslZnAdjmtFctrStrtDteEdit,
  BufPrpslZoneAdjmtFctrEndDate,
  RedZoneAdjustmentFactor,
  YellowZoneAdjustmentFactor,
  GreenZoneAdjustmentFactor,
  CreatedByUser,
  LastChangedByUser,
  ProductAuthorizationGroup,
  ProductTypeAuthorizationGroup,
  ProductGroupAuthorizationGroup,
  I_ProdBufLvlPrpslZnAdjmtFctrTP._BufMatPlant AS _BufMatPlant
FROM I_ProdBufLvlPrpslZnAdjmtFctrTP
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