I_ProdBufLvlPrpslZnAdjmtFctr

DDL: I_PRODBUFLVLPRPSLZNADJMTFCTR SQL: IPRODBUFPRPSLADJ Type: view BASIC
14 Fields 2 Data Sources

Product Buffer Level Proposal Zone Adjustment Factors

I_ProdBufLvlPrpslZnAdjmtFctr is a Basic CDS View that provides data about "Product Buffer Level Proposal Zone Adjustment Factors" in SAP S/4HANA. It reads from 2 data sources (pph_dd_stpr_zadj, I_ProdBufLvlPrpslData) and exposes 14 fields with key fields Material, Plant, MRPArea, ProposalStartDate, ProposalVersion.

Data Sources (2)

SourceAliasJoin Type
pph_dd_stpr_zadj _ProposalAdjFactors left_outer
I_ProdBufLvlPrpslData _ProposalHeader from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPRODBUFPRPSLADJ view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
EndUserText.label Product Buffer Level Proposal Zone Adjustment Factors view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Material I_ProdBufLvlPrpslData Material Vehicle Model
KEY Plant I_ProdBufLvlPrpslData Plant Valuation Area
KEY MRPArea I_ProdBufLvlPrpslData MRPArea MRP Area
KEY ProposalStartDate I_ProdBufLvlPrpslData ProposalStartDate Proposal Valid From
KEY ProposalVersion I_ProdBufLvlPrpslData ProposalVersion Proposal Version
CreatedByUser created_by Version Created By
LastChangedByUser changed_by User Name
CreationDateTime created_time Time Stamp
LastChangeDateTime changed_time Time Stamp
ProductAuthorizationGroup I_ProdBufLvlPrpslData ProductAuthorizationGroup
ProductTypeAuthorizationGroup I_ProdBufLvlPrpslData ProductTypeAuthorizationGroup
ProductGroupAuthorizationGroup I_ProdBufLvlPrpslData ProductGroupAuthorizationGroup
_BufMatPlant _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 I_ProdBufLvlPrpslZnAdjmtFctr.
-- 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: IPRODBUFPRPSLADJ

CREATE VIEW I_ProdBufLvlPrpslZnAdjmtFctr AS
SELECT
  _ProposalHeader.Material AS Material,
  _ProposalHeader.Plant AS Plant,
  _ProposalHeader.MRPArea AS MRPArea,
  _ProposalHeader.ProposalStartDate AS ProposalStartDate,
  _ProposalHeader.ProposalVersion AS ProposalVersion,
  created_by AS CreatedByUser,
  changed_by AS LastChangedByUser,
  created_time AS CreationDateTime,
  changed_time AS LastChangeDateTime,
  _ProposalHeader.ProductAuthorizationGroup AS ProductAuthorizationGroup,
  _ProposalHeader.ProductTypeAuthorizationGroup AS ProductTypeAuthorizationGroup,
  _ProposalHeader.ProductGroupAuthorizationGroup AS ProductGroupAuthorizationGroup
FROM I_ProdBufLvlPrpslData AS _ProposalHeader
LEFT OUTER JOIN pph_dd_stpr_zadj AS _ProposalAdjFactors ON /* join condition not captured in parsed metadata */
;

Learn More