C_ProdBufLvlZnAdjmtFctr

DDL: C_PRODBUFLVLZNADJMTFCTR SQL: CPRODBUFZNFCT Type: view CONSUMPTION Package: ODATA_PP_DD_STLM
13 Fields 2 Data Sources 1 OData Services

Buffer Level Management - Zone Adjustment Factors

C_ProdBufLvlZnAdjmtFctr is a Consumption CDS View that provides data about "Buffer Level Management - Zone Adjustment Factors" in SAP S/4HANA. It reads from 2 data sources (I_ProdBufLvlPrpsl, I_ProdBufLvlPrpslZnAdjmtFctr) and exposes 13 fields with key fields Material, Plant, MRPArea, ProposalStartDate, ProposalVersion. It is exposed through 1 OData service (ASQL_F3653). Part of development package ODATA_PP_DD_STLM.

Data Sources (2)

SourceAliasJoin Type
I_ProdBufLvlPrpsl _ProposalHeader inner
I_ProdBufLvlPrpslZnAdjmtFctr ZoneAdjustments from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CPRODBUFZNFCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Buffer Level Management - Zone Adjustment Factors view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3653 ASQL_F3653 C2 NOT_RELEASED

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Material I_ProdBufLvlPrpslZnAdjmtFctr Material Vehicle Model
KEY Plant I_ProdBufLvlPrpslZnAdjmtFctr Plant Valuation Area
KEY MRPArea I_ProdBufLvlPrpslZnAdjmtFctr MRPArea MRP Area
KEY ProposalStartDate I_ProdBufLvlPrpslZnAdjmtFctr ProposalStartDate
KEY ProposalVersion I_ProdBufLvlPrpslZnAdjmtFctr ProposalVersion
KEY BufPrpslZoneAdjmtFctrStartDate BufPrpslZoneAdjmtFctrStartDate
KEY BufPrpslZoneAdjmtFctrEndDate BufPrpslZoneAdjmtFctrEndDate
RedZoneAdjustmentFactor I_ProdBufLvlPrpslZnAdjmtFctr RedZoneAdjustmentFactor
YellowZoneAdjustmentFactor I_ProdBufLvlPrpslZnAdjmtFctr YellowZoneAdjustmentFactor
GreenZoneAdjustmentFactor I_ProdBufLvlPrpslZnAdjmtFctr GreenZoneAdjustmentFactor
ProductAuthorizationGroup I_ProdBufLvlPrpslZnAdjmtFctr ProductAuthorizationGroup
ProductTypeAuthorizationGroup I_ProdBufLvlPrpslZnAdjmtFctr ProductTypeAuthorizationGroup
ProductGroupAuthorizationGroup I_ProdBufLvlPrpslZnAdjmtFctr ProductGroupAuthorizationGroup

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_ProdBufLvlZnAdjmtFctr.
-- 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: CPRODBUFZNFCT

CREATE VIEW C_ProdBufLvlZnAdjmtFctr AS
SELECT
  ZoneAdjustments.Material AS Material,
  ZoneAdjustments.Plant AS Plant,
  ZoneAdjustments.MRPArea AS MRPArea,
  ZoneAdjustments.ProposalStartDate AS ProposalStartDate,
  ZoneAdjustments.ProposalVersion AS ProposalVersion,
  BufPrpslZoneAdjmtFctrStartDate,
  BufPrpslZoneAdjmtFctrEndDate,
  ZoneAdjustments.RedZoneAdjustmentFactor AS RedZoneAdjustmentFactor,
  ZoneAdjustments.YellowZoneAdjustmentFactor AS YellowZoneAdjustmentFactor,
  ZoneAdjustments.GreenZoneAdjustmentFactor AS GreenZoneAdjustmentFactor,
  ZoneAdjustments.ProductAuthorizationGroup AS ProductAuthorizationGroup,
  ZoneAdjustments.ProductTypeAuthorizationGroup AS ProductTypeAuthorizationGroup,
  ZoneAdjustments.ProductGroupAuthorizationGroup AS ProductGroupAuthorizationGroup
FROM I_ProdBufLvlPrpslZnAdjmtFctr AS ZoneAdjustments
INNER JOIN I_ProdBufLvlPrpsl AS _ProposalHeader ON /* join condition not captured in parsed metadata */
;

Learn More