What is I_PrepaymentDocPrcgQtanRule in SAP S/4HANA?

I_PrepaymentDocPrcgQtanRule is a composite CDS view in SAP S/4HANA. CPE Quotation Rule details It contains 15 fields.

Which tables does I_PrepaymentDocPrcgQtanRule read from?

I_PrepaymentDocPrcgQtanRule reads data from: I_PpaytCmmdtyQtnRule, I_PpaytCmmdtyPricingTerm, I_CmmdtyPricingTermGrouping.

What VDM layer is I_PrepaymentDocPrcgQtanRule?

I_PrepaymentDocPrcgQtanRule is classified as a Composite view that combines data from multiple basic views.

I_PrepaymentDocPrcgQtanRule

DDL: I_PREPAYMENTDOCPRCGQTANRULE SQL: IPPMGDOCQTAN Type: view COMPOSITE

15 Fields 3 Data Sources

CPE Quotation Rule details

I_PrepaymentDocPrcgQtanRule is a Composite CDS View that provides data about "CPE Quotation Rule details" in SAP S/4HANA. It reads from 3 data sources (I_PpaytCmmdtyQtnRule, I_PpaytCmmdtyPricingTerm, I_CmmdtyPricingTermGrouping) and exposes 15 fields with key fields PricingConditionFormulaKey, CommodityPricingConditionType.

Data Sources (3)

Source	Alias	Join Type
I_PpaytCmmdtyQtnRule	QuoteRule	inner
I_PpaytCmmdtyPricingTerm	Term	inner
I_CmmdtyPricingTermGrouping	TermGrp	from

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	IPPMGDOCQTAN	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	CPE Quotation Rule details	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	I_PrepaymentDocTermQuoteData	view

Fields (15)

Key	Field	Source Table	Source Field	Description
KEY	PricingConditionFormulaKey	I_CmmdtyPricingTermGrouping	PricingConditionFormulaKey	Formula Key
KEY	CommodityPricingConditionType	I_CmmdtyPricingTermGrouping	ConditionType	Condition type
	PricingConditionTermKey	I_PpaytCmmdtyPricingTerm	PricingConditionTermKey	Term Key
	PrcgCndnTermQuotationRule	I_PpaytCmmdtyQtnRule	PrcgCndnTermQuotationRule	Quotation Rule
	DerivativeContrSpecification	I_PpaytCmmdtyQtnRule	DerivativeContrSpecification	DCS ID
	MarketIdentifierCode	I_PpaytCmmdtyQtnRule	MarketIdentifierCode	MIC
	BasisType	I_PpaytCmmdtyQtnRule	BasisType	Basis Type
	QuotationPriceType	I_PpaytCmmdtyQtnRule	QuotationPriceType	Price Type
	PrepaymentRefDocFuturePrice	_future	PrepaymentRefDocFuturePrice
	PrepaymentRefDocFuturePrcCrcy	_future	PrepaymentRefDocFuturePrcCrcy
	MaturityKeyDate	_future	MaturityKeyDate	Maturity Key Date
	PrepaymentRefDocBasisPrice	_basis	PrepaymentRefDocBasisPrice
	PrepaymentRefDocBasisPrcCrcy	_basis	PrepaymentRefDocBasisPrcCrcy
	BasisID	_basis	BasisID	Basis ID
	CalculationPeriodEndDate	_basis	CalculationPeriodEndDate

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_PrepaymentDocPrcgQtanRule.
-- 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: IPPMGDOCQTAN

CREATE VIEW I_PrepaymentDocPrcgQtanRule AS
SELECT
  TermGrp.PricingConditionFormulaKey AS PricingConditionFormulaKey,
  TermGrp.ConditionType AS CommodityPricingConditionType,
  Term.PricingConditionTermKey AS PricingConditionTermKey,
  QuoteRule.PrcgCndnTermQuotationRule AS PrcgCndnTermQuotationRule,
  QuoteRule.DerivativeContrSpecification AS DerivativeContrSpecification,
  QuoteRule.MarketIdentifierCode AS MarketIdentifierCode,
  QuoteRule.BasisType AS BasisType,
  QuoteRule.QuotationPriceType AS QuotationPriceType,
  _future.PrepaymentRefDocFuturePrice AS PrepaymentRefDocFuturePrice,
  _future.PrepaymentRefDocFuturePrcCrcy AS PrepaymentRefDocFuturePrcCrcy,
  _future.MaturityKeyDate AS MaturityKeyDate,
  _basis.PrepaymentRefDocBasisPrice AS PrepaymentRefDocBasisPrice,
  _basis.PrepaymentRefDocBasisPrcCrcy AS PrepaymentRefDocBasisPrcCrcy,
  _basis.BasisID AS BasisID,
  _basis.CalculationPeriodEndDate AS CalculationPeriodEndDate
FROM I_CmmdtyPricingTermGrouping AS TermGrp
INNER JOIN I_PpaytCmmdtyPricingTerm AS Term ON /* join condition not captured in parsed metadata */
INNER JOIN I_PpaytCmmdtyQtnRule AS QuoteRule ON /* join condition not captured in parsed metadata */
;

Depth:

I_PrepaymentDocPrcgQtanRule view