Deprecated
This CDS view is deprecated in S/4HANA. Use I_PrepaymentDocTermQuoteData instead. View all deprecated CDS views →

I_PrepaymentDocPrcgQtanRule

DDL: I_PREPAYMENTDOCPRCGQTANRULE SQL: IPPMGDOCQTAN Type: view COMPOSITE

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)

SourceAliasJoin Type
I_PpaytCmmdtyQtnRule QuoteRule inner
I_PpaytCmmdtyPricingTerm Term inner
I_CmmdtyPricingTermGrouping TermGrp from

Annotations (13)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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 */
;