I_PpaytDocCmmdtyPrcValPO

DDL: I_PPAYTDOCCMMDTYPRCVALPO Type: view_entity COMPOSITE
37 Fields 4 Data Sources 2 Associations

Document Condition Market Prices for PO

I_PpaytDocCmmdtyPrcValPO is a Composite CDS View that provides data about "Document Condition Market Prices for PO" in SAP S/4HANA. It reads from 4 data sources (I_PrepaymentDocCmmdtyPrcgData, I_PrepayWrkCtrAllowedDocTypes, I_PurchasingDocument, I_PrepaymentWrkCtrLinkConfign) and exposes 37 fields with key fields PrepaymentRefDocCondition, PrepaymentRefDocConditionItem, ConditionType, PurchasingDocument. It has 2 associations to related views.

Data Sources (4)

SourceAliasJoin Type
I_PrepaymentDocCmmdtyPrcgData cpedata inner
I_PrepayWrkCtrAllowedDocTypes DocTypes from
I_PurchasingDocument Document inner
I_PrepaymentWrkCtrLinkConfign WCPrcConfig inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PrepaymentDocTermQuoteData cpeconf cpeconf.PricingConditionFormulaKey = cpedata.PricingConditionFormulaKey and cpeconf.CommodityPricingConditionType = cpedata.CommodityPricingConditionType
[0..1] I_PrepaymentDocTermQuoteData cpetermconf cpetermconf.PricingConditionTermKey = cpedata.PricingConditionTermKey and cpetermconf.CommodityPricingConditionType = cpedata.CommodityPricingConditionType and cpetermconf.PricingConditionTermKey is not initial

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Document Condition Market Prices for PO view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentRefDocCondition I_PrepaymentDocCmmdtyPrcgData PrepaymentRefDocCondition Doc. Condition
KEY PrepaymentRefDocConditionItem I_PrepaymentDocCmmdtyPrcgData PrepaymentRefDocConditionItem Number
KEY ConditionType I_PrepaymentDocCmmdtyPrcgData ConditionType Condition type
KEY PurchasingDocument I_PurchasingDocument PurchasingDocument Purchasing Document
CompanyCode I_PurchasingDocument CompanyCode Receiver Company Code
Counterparty I_PurchasingDocument Supplier Supplier
PurchasingDocumentType I_PurchasingDocument PurchasingDocumentType RFQ Type
DocItemCommodityPricingUUID I_PrepaymentDocCmmdtyPrcgData DocItemCommodityPricingUUID GUID
CommodityPricingConditionType I_PrepaymentDocCmmdtyPrcgData CommodityPricingConditionType Demurrage rate
MarketConditionType I_PrepaymentDocCmmdtyPrcgData MarketConditionType Demurrage rate
PricingCndnTermExtensionGroup I_PrepaymentDocCmmdtyPrcgData PricingCndnTermExtensionGroup Extension Group
PricingConditionFormulaKey I_PrepaymentDocCmmdtyPrcgData PricingConditionFormulaKey Formula Key
ConditionTermExtensionUsage I_PrepaymentDocCmmdtyPrcgData ConditionTermExtensionUsage Extension Usage
BasisTypeendasBasisType
BasisID I_PrepaymentDocCmmdtyPrcgData BasisID Basis ID
MaturityKeyDate I_PrepaymentDocCmmdtyPrcgData MaturityKeyDate Maturity Key Date
ConditionTermStatus I_PrepaymentDocCmmdtyPrcgData ConditionTermStatus Term Status
CalculationPeriodEndDate I_PrepaymentDocCmmdtyPrcgData CalculationPeriodEndDate
PrcgCndnFmlaCommodityQuantity I_PrepaymentDocCmmdtyPrcgData PrcgCndnFmlaCommodityQuantity Comm.Qty Item
PrcgCndnFmlaCmmdtyQuantityUnit I_PrepaymentDocCmmdtyPrcgData PrcgCndnFmlaCmmdtyQuantityUnit Commodity UoM
PrepaymentRefDocFixedPrice I_PrepaymentDocCmmdtyPrcgData PrepaymentRefDocFixedPrice Term Value
PrepaymentRefDocFixedPriceCrcy I_PrepaymentDocCmmdtyPrcgData PrepaymentRefDocFixedPriceCrcy Doc. Currency
CalcdPrcgConditionTermQuantity I_PrepaymentDocCmmdtyPrcgData CalcdPrcgConditionTermQuantity Commodity Quantity
PrepaymentDocCmmdtyMktQtyUnit I_PrepaymentDocCmmdtyPrcgData PrepaymentDocCmmdtyMktQtyUnit Calc. Comm. UoM
ACMPrcgCndnTermInputPrice I_PrepaymentDocCmmdtyPrcgData ACMPrcgCndnTermInputPrice Fixed Rate
PrcgCndnFmlaFixedRateCurrency I_PrepaymentDocCmmdtyPrcgData PrcgCndnFmlaFixedRateCurrency Currency Fixed Rate
ConditionTermRate I_PrepaymentDocCmmdtyPrcgData ConditionTermRate Term Rate
ConditionTermRateCurrency I_PrepaymentDocCmmdtyPrcgData ConditionTermRateCurrency Term Currency
PrcgCndnTermCnvrsnFxdExchRate I_PrepaymentDocCmmdtyPrcgData PrcgCndnTermCnvrsnFxdExchRate
PrcgCndnTermCnvrsnSourceCrcy I_PrepaymentDocCmmdtyPrcgData PrcgCndnTermCnvrsnSourceCrcy Curr:Conv. from
PrcgCndnTermCnvrsnTargetCrcy I_PrepaymentDocCmmdtyPrcgData PrcgCndnTermCnvrsnTargetCrcy Curr.: Conv. to
PricingConditionTermInputUUID I_PrepaymentDocCmmdtyPrcgData PricingConditionTermInputUUID Term Input GUID
PrcgCndnTermFixationOptnStatus I_PrepaymentDocCmmdtyPrcgData PrcgCndnTermFixationOptnStatus Price Fix. Status
CndnTrmFixationOptnNonFixedQty I_PrepaymentDocCmmdtyPrcgData CndnTrmFixationOptnNonFixedQty Qty for Price Fix.
TrmFixationOptnNonFixedQtyUnit I_PrepaymentDocCmmdtyPrcgData TrmFixationOptnNonFixedQtyUnit Quantity UoM
MTMCalculationGroup I_PrepaymentDocCmmdtyPrcgData MTMCalculationGroup
PrepaymentWrkCtrDocPricingOptn I_PrepaymentWrkCtrLinkConfign PrepaymentWrkCtrDocPricingOptn Pricing Option

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_PpaytDocCmmdtyPrcValPO.
-- 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_PpaytDocCmmdtyPrcValPO AS
SELECT
  cpedata.PrepaymentRefDocCondition AS PrepaymentRefDocCondition,
  cpedata.PrepaymentRefDocConditionItem AS PrepaymentRefDocConditionItem,
  cpedata.ConditionType AS ConditionType,
  Document.PurchasingDocument AS PurchasingDocument,
  Document.CompanyCode AS CompanyCode,
  Document.Supplier AS Counterparty,
  Document.PurchasingDocumentType AS PurchasingDocumentType,
  cpedata.DocItemCommodityPricingUUID AS DocItemCommodityPricingUUID,
  cpedata.CommodityPricingConditionType AS CommodityPricingConditionType,
  cpedata.MarketConditionType AS MarketConditionType,
  cpedata.PricingCndnTermExtensionGroup AS PricingCndnTermExtensionGroup,
  cpedata.PricingConditionFormulaKey AS PricingConditionFormulaKey,
  cpedata.ConditionTermExtensionUsage AS ConditionTermExtensionUsage,
  case when cpedata.BasisType is not initial then cpedata.BasisType when cpeconf.BasisType is not initial then cpeconf.BasisType when cpetermconf.BasisType is not initial then cpetermconf.BasisType end as BasisType AS BasisTypeendasBasisType,
  cpedata.BasisID AS BasisID,
  cpedata.MaturityKeyDate AS MaturityKeyDate,
  cpedata.ConditionTermStatus AS ConditionTermStatus,
  cpedata.CalculationPeriodEndDate AS CalculationPeriodEndDate,
  cpedata.PrcgCndnFmlaCommodityQuantity AS PrcgCndnFmlaCommodityQuantity,
  cpedata.PrcgCndnFmlaCmmdtyQuantityUnit AS PrcgCndnFmlaCmmdtyQuantityUnit,
  cpedata.PrepaymentRefDocFixedPrice AS PrepaymentRefDocFixedPrice,
  cpedata.PrepaymentRefDocFixedPriceCrcy AS PrepaymentRefDocFixedPriceCrcy,
  cpedata.CalcdPrcgConditionTermQuantity AS CalcdPrcgConditionTermQuantity,
  cpedata.PrepaymentDocCmmdtyMktQtyUnit AS PrepaymentDocCmmdtyMktQtyUnit,
  cpedata.ACMPrcgCndnTermInputPrice AS ACMPrcgCndnTermInputPrice,
  cpedata.PrcgCndnFmlaFixedRateCurrency AS PrcgCndnFmlaFixedRateCurrency,
  cpedata.ConditionTermRate AS ConditionTermRate,
  cpedata.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  cpedata.PrcgCndnTermCnvrsnFxdExchRate AS PrcgCndnTermCnvrsnFxdExchRate,
  cpedata.PrcgCndnTermCnvrsnSourceCrcy AS PrcgCndnTermCnvrsnSourceCrcy,
  cpedata.PrcgCndnTermCnvrsnTargetCrcy AS PrcgCndnTermCnvrsnTargetCrcy,
  cpedata.PricingConditionTermInputUUID AS PricingConditionTermInputUUID,
  cpedata.PrcgCndnTermFixationOptnStatus AS PrcgCndnTermFixationOptnStatus,
  cpedata.CndnTrmFixationOptnNonFixedQty AS CndnTrmFixationOptnNonFixedQty,
  cpedata.TrmFixationOptnNonFixedQtyUnit AS TrmFixationOptnNonFixedQtyUnit,
  cpedata.MTMCalculationGroup AS MTMCalculationGroup,
  WCPrcConfig.PrepaymentWrkCtrDocPricingOptn AS PrepaymentWrkCtrDocPricingOptn
FROM I_PrepayWrkCtrAllowedDocTypes AS DocTypes
INNER JOIN I_PurchasingDocument AS Document ON /* join condition not captured in parsed metadata */
INNER JOIN I_PrepaymentWrkCtrLinkConfign AS WCPrcConfig ON /* join condition not captured in parsed metadata */
INNER JOIN I_PrepaymentDocCmmdtyPrcgData AS cpedata ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PrepaymentDocTermQuoteData AS cpeconf ON cpeconf.PricingConditionFormulaKey = cpedata.PricingConditionFormulaKey AND cpeconf.CommodityPricingConditionType = cpedata.CommodityPricingConditionType  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentDocTermQuoteData AS cpetermconf ON cpetermconf.PricingConditionTermKey = cpedata.PricingConditionTermKey AND cpetermconf.CommodityPricingConditionType = cpedata.CommodityPricingConditionType AND cpetermconf.PricingConditionTermKey is not initial  -- association [0..1]
;

Learn More