P_ProposalValuesForAdopted

DDL: P_PROPOSALVALUESFORADOPTED SQL: PPROPVALFORADOP Type: view CONSUMPTION
9 Fields 1 Data Sources

P_ProposalValuesForAdopted is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_ProposedStockBuffer) and exposes 9 fields with key fields Material, Plant, MRPArea, ProposalStartDate.

Data Sources (1)

SourceAliasJoin Type
P_ProposedStockBuffer _StockBuffer from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPROPVALFORADOP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Material P_ProposedStockBuffer Material Vehicle Model
KEY Plant P_ProposedStockBuffer Plant Valuation Area
KEY MRPArea P_ProposedStockBuffer MRPArea MRP Area
KEY ProposalStartDate P_ProposedStockBuffer ProposalStartDate
StockLevelProposalID P_ProposedStockBuffer StockLevelProposalID
ProposedLeadTime P_ProposedStockBuffer ProposedLeadTime
ProposedAverageDailyUsage P_ProposedStockBuffer ProposedAverageDailyUsage
ProposedVariabilityFactor P_ProposedStockBuffer ProposedVariabilityFactor
ReferenceDate

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 P_ProposalValuesForAdopted.
-- 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: PPROPVALFORADOP

CREATE VIEW P_ProposalValuesForAdopted AS
SELECT
  _StockBuffer.Material AS Material,
  _StockBuffer.Plant AS Plant,
  _StockBuffer.MRPArea AS MRPArea,
  _StockBuffer.ProposalStartDate AS ProposalStartDate,
  _StockBuffer.StockLevelProposalID AS StockLevelProposalID,
  _StockBuffer.ProposedLeadTime AS ProposedLeadTime,
  _StockBuffer.ProposedAverageDailyUsage AS ProposedAverageDailyUsage,
  _StockBuffer.ProposedVariabilityFactor AS ProposedVariabilityFactor,
  $session.system_date AS ReferenceDate
FROM P_ProposedStockBuffer AS _StockBuffer
;

Learn More