I_CntrlPurOrderPrcgElement

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_CntrlPurOrderPrcgElement.
-- 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: ICPOPRICING

CREATE VIEW I_CntrlPurOrderPrcgElement AS
SELECT
  P_CntrlPurOrderItemPrcgKey.PurchaseOrder AS PurchaseOrder,
  cast ( right(I_PurgDocPricingElement.kposn, 5 ) as ebelp ) AS PurchaseOrderItem,
  I_PurgDocPricingElement.knumv AS PricingDocument,
  I_PurgDocPricingElement.kposn AS PricingDocumentItem,
  I_PurgDocPricingElement.stunr AS PricingProcedureStep,
  I_PurgDocPricingElement.zaehk AS PricingProcedureCounter,
  I_PurgDocPricingElement.extsourcesystem AS ExtSourceSystem,
  I_PurgDocPricingElement.kappl AS ConditionApplication,
  I_PurgDocPricingElement.kschl AS ConditionType,
  I_PurgDocPricingElement.kdatu AS PricingDateTime,
  cast( left(I_PurgDocPricingElement.kdatu, 8) as abap.dats ) AS PriceConditionDeterminationDte,
  I_PurgDocPricingElement.krech AS ConditionCalculationType,
  cast(I_PurgDocPricingElement.kawrt as vfprc_value_in_curr ) AS ConditionBaseValue,
  cast(I_PurgDocPricingElement.kbetr as vfprc_value_in_curr ) AS ConditionRateValue,
  I_PurgDocPricingElement.waers AS ConditionCurrency,
  cast( I_PurgDocPricingElement.kkurs as fis_exchange_rate ) AS PriceDetnExchangeRate,
  cast(abs(I_PurgDocPricingElement.kkurs) as fis_absolute_exchangerate preserving type ) AS AbsoluteExchangeRate,
  I_PurgDocPricingElement.kpein AS ConditionQuantity,
  I_PurgDocPricingElement.kmein AS ConditionQuantityUnit,
  I_PurgDocPricingElement.kumza AS ConditionToBaseQtyNmrtr,
  I_PurgDocPricingElement.kumne AS ConditionToBaseQtyDnmntr,
  I_PurgDocPricingElement.kntyp AS ConditionCategory,
  I_PurgDocPricingElement.kstat AS ConditionIsForStatistics,
  I_PurgDocPricingElement.knprs AS PricingScaleType,
  I_PurgDocPricingElement.kruek AS IsRelevantForAccrual,
  I_PurgDocPricingElement.kreli AS CndnIsRelevantForInvoiceList,
  I_PurgDocPricingElement.kherk AS ConditionOrigin,
  I_PurgDocPricingElement.kgrpe AS IsGroupCondition,
  I_PurgDocPricingElement.kolnr AS AccessNumberOfAccessSequence,
  I_PurgDocPricingElement.knumh AS ConditionRecord,
  I_PurgDocPricingElement.kopos AS ConditionSequentialNumber,
  I_PurgDocPricingElement.kvsl1 AS AccountKeyForGLAccount,
  I_PurgDocPricingElement.sakn1 AS GLAccount,
  I_PurgDocPricingElement.mwsk1 AS TaxCode,
  I_PurgDocPricingElement.kvsl2 AS AcctKeyForAccrualsGLAccount,
  I_PurgDocPricingElement.sakn2 AS AccrualsGLAccount,
  I_PurgDocPricingElement.mwsk2 AS WithholdingTaxCode,
  I_PurgDocPricingElement.lifnr AS FreightSupplier,
  I_PurgDocPricingElement.kdiff AS CndnRoundingOffDiffAmount,
  I_PurgDocPricingElement.kwert AS ConditionAmount,
  I_PurgDocPricingElement.waerk AS TransactionCurrency,
  I_PurgDocPricingElement.ksteu AS ConditionControl,
  I_PurgDocPricingElement.kinak AS ConditionInactiveReason,
  I_PurgDocPricingElement.koaid AS ConditionClass,
  I_PurgDocPricingElement.zaeko AS PrcgProcedureCounterForHeader,
  I_PurgDocPricingElement.kfaktor AS FactorForConditionBasisValue,
  I_PurgDocPricingElement.kdupl AS StructureCondition,
  I_PurgDocPricingElement.kfaktor1 AS PeriodFactorForCndnBasisValue,
  I_PurgDocPricingElement.kzbzg AS PricingScaleBasis,
  I_PurgDocPricingElement.kstbs AS ConditionScaleBasisValue,
  I_PurgDocPricingElement.konms AS ConditionScaleBasisUnit,
  I_PurgDocPricingElement.konws AS ConditionScaleBasisCurrency,
  I_PurgDocPricingElement.kwaeh AS ConditionAlternativeCurrency,
  I_PurgDocPricingElement.kwert_k AS ConditionAmountInLocalCrcy,
  I_PurgDocPricingElement.kfkiv AS CndnIsRelevantForIntcoBilling,
  I_PurgDocPricingElement.kmprs AS ConditionIsManuallyChanged,
  I_PurgDocPricingElement.prsqu AS BillingPriceSource,
  I_PurgDocPricingElement.txjlv AS TaxJurisdictionLevel,
  I_PurgDocPricingElement.kbflag AS ConditionByteSequence,
  I_PurgDocPricingElement.koupd AS CndnIsRelevantForLimitValue,
  I_PurgDocPricingElement.kmxaw AS ConditionBasisLimitExceeded,
  I_PurgDocPricingElement.kmxwr AS ConditionAmountLimitExceeded,
  I_PurgDocPricingElement.kawrt_k AS CumulatedConditionBasisValue,
  I_PurgDocPricingElement.kunnr AS CustomerRebateRecipient,
  I_PurgDocPricingElement.kvarc AS ConditionIsForConfiguration,
  I_PurgDocPricingElement.varcond AS VariantCondition,
  I_PurgDocPricingElement.ktrel AS ConditionAcctAssgmtRelevance,
  I_PurgDocPricingElement.mdflg AS ConditionMatrixMaintRelevance,
  I_PurgDocPricingElement.cpf_guid AS ConfigblParametersAndFormulas,
  I_PurgDocPricingElement.kaqty AS ConditionAdjustedQuantity,
  _PricingConditionTypeText.ConditionTypeName AS ConditionTypeName,
  waers AS ConditionRateValueUnit,
  cast(' ' as price_element_tax_code_descr) AS TaxCodeName,
  cast(' ' as abap.char( 1 )) AS ConditionIsDeletable,
  cast(' ' as kalsm_d ) AS PricingProcedure,
  cast(' ' as abap.char ( 32 )) AS SuperordinateDocument,
  cast(' ' as abap.char ( 70 )) AS SuperordinateDocumentItem
FROM P_CntrlPurOrderItemPrcgKey
INNER JOIN mmpur_ext_prcd_e AS I_PurgDocPricingElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CentralPurchaseOrder AS _PurchaseOrder ON _PurchaseOrder.PurchaseOrder = PurchaseOrder AND _PurchaseOrder.ExtSourceSystem = ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_CentralPurchaseOrderItem AS _PurchaseOrderItem ON _PurchaseOrderItem.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItem.PurchaseOrderItem = PurchaseOrderItem AND _PurchaseOrderItem.ExtSourceSystem = ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_ConditionTypeText AS _PricingConditionTypeText ON _PricingConditionTypeText.ConditionApplication = ConditionApplication AND _PricingConditionTypeText.ConditionType = ConditionType AND _PricingConditionTypeText.ConditionUsage = 'A' AND _PricingConditionTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ConditionApplication AS _ConditionApplication ON ConditionApplication = _ConditionApplication.ConditionApplication  -- association [0..1]
LEFT OUTER JOIN I_PricingConditionType AS _PricingConditionType ON ConditionApplication = _PricingConditionType.ConditionApplication AND ConditionType = _PricingConditionType.ConditionType  -- association [0..1]
LEFT OUTER JOIN I_ConditionCalculationType AS _ConditionCalculationType ON ConditionCalculationType = _ConditionCalculationType.ConditionCalculationType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ConditionCurrency ON ConditionCurrency = _ConditionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionQuantityUnit ON ConditionQuantityUnit = _ConditionQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ConditionCategory AS _ConditionCategory ON ConditionCategory = _ConditionCategory.ConditionCategory  -- association [0..1]
LEFT OUTER JOIN I_ConditionOrigin AS _ConditionOrigin ON ConditionOrigin = _ConditionOrigin.ConditionOrigin  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON FreightSupplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_ConditionControl AS _ConditionControl ON ConditionControl = _ConditionControl.ConditionControl  -- association [0..1]
LEFT OUTER JOIN I_ConditionInactiveReason AS _ConditionInactiveReason ON ConditionInactiveReason = _ConditionInactiveReason.ConditionInactiveReason  -- association [0..1]
LEFT OUTER JOIN I_ConditionClass AS _ConditionClass ON ConditionClass = _ConditionClass.ConditionClass  -- association [0..1]
LEFT OUTER JOIN I_PricingScaleBasis AS _PricingScaleBasis ON PricingScaleBasis = _PricingScaleBasis.PricingScaleBasis  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ScaleUnitOfMeasure ON ConditionScaleBasisUnit = _ScaleUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ScaleCurrency ON ConditionScaleBasisCurrency = _ScaleCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ConditionAlternativeCurrency ON ConditionAlternativeCurrency = _ConditionAlternativeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_BillingPriceSource AS _BillingPriceSource ON BillingPriceSource = _BillingPriceSource.BillingPriceSource  -- association [0..1]
LEFT OUTER JOIN I_VariantCondition AS _VariantCondition ON VariantCondition = _VariantCondition.VariantCondition  -- association [0..1]
LEFT OUTER JOIN I_StructureCondition AS _StructureCondition ON StructureCondition = _StructureCondition.StructureCondition  -- association [0..1]
LEFT OUTER JOIN I_ConditionAmountLimitExceeded AS _ConditionAmountLimitExceeded ON ConditionAmountLimitExceeded = _ConditionAmountLimitExceeded.ConditionAmountLimitExceeded  -- association [0..1]
LEFT OUTER JOIN I_ConditionBasisLimitExceeded AS _ConditionBasisLimitExceeded ON ConditionBasisLimitExceeded = _ConditionBasisLimitExceeded.ConditionBasisLimitExceeded  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON CustomerRebateRecipient = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_ConditionAcctAssgmtRelevance AS _ConditionAcctAssgmtRelevance ON ConditionAcctAssgmtRelevance = _ConditionAcctAssgmtRelevance.ConditionAcctAssgmtRelevance  -- association [0..1]
;