I_ProdBufLvlPrpslZnAdjmtFctr

DDL: I_PRODBUFLVLPRPSLZNADJMTFCTR Type: view_entity BASIC Package: PPH_DD_VDM_STLM
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. Part of development package PPH_DD_VDM_STLM.

Data Sources (2)

SourceAliasJoin Type
pph_dd_stpr_zadj _ProposalAdjFactors left_outer
I_ProdBufLvlPrpslData _ProposalHeader from

Annotations (6)

NameValueLevelField
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 pph_dd_stpr_zadj created_by Version Created By
LastChangedByUser pph_dd_stpr_zadj changed_by User Name
CreationDateTime pph_dd_stpr_zadj created_time Time Stamp
LastChangeDateTime pph_dd_stpr_zadj changed_time Time Stamp
ProductAuthorizationGroup I_ProdBufLvlPrpslData ProductAuthorizationGroup AuthorizGroup
ProductTypeAuthorizationGroup I_ProdBufLvlPrpslData ProductTypeAuthorizationGroup
ProductGroupAuthorizationGroup I_ProdBufLvlPrpslData ProductGroupAuthorizationGroup
_BufMatPlant I_ProdBufLvlPrpslData _BufMatPlant
_MatMRPArea I_ProdBufLvlPrpslData _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.

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,
  _ProposalAdjFactors.created_by AS CreatedByUser,
  _ProposalAdjFactors.changed_by AS LastChangedByUser,
  _ProposalAdjFactors.created_time AS CreationDateTime,
  _ProposalAdjFactors.changed_time AS LastChangeDateTime,
  _ProposalHeader.ProductAuthorizationGroup AS ProductAuthorizationGroup,
  _ProposalHeader.ProductTypeAuthorizationGroup AS ProductTypeAuthorizationGroup,
  _ProposalHeader.ProductGroupAuthorizationGroup AS ProductGroupAuthorizationGroup,
  _ProposalHeader._BufMatPlant AS _BufMatPlant,
  _ProposalHeader._MatMRPArea AS _MatMRPArea
FROM I_ProdBufLvlPrpslData AS _ProposalHeader
LEFT OUTER JOIN pph_dd_stpr_zadj AS _ProposalAdjFactors ON /* join condition not captured in parsed metadata */
;

Learn More