I_CntrlPurOrderPrcgElementTP

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_CntrlPurOrderPrcgElementTP.
-- 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: ICPOPRICINGTP

CREATE VIEW I_CntrlPurOrderPrcgElementTP AS
SELECT
  Document.PurchaseOrder AS PurchaseOrder,
  Document.PurchaseOrderItem AS PurchaseOrderItem,
  Document.PricingDocument AS PricingDocument,
  Document.PricingDocumentItem AS PricingDocumentItem,
  Document.PricingProcedureStep AS PricingProcedureStep,
  Document.PricingProcedureCounter AS PricingProcedureCounter,
  Document.ExtSourceSystem AS ExtSourceSystem,
  Document.ConditionApplication AS ConditionApplication,
  Document.ConditionType AS ConditionType,
  Document.PricingDateTime AS PricingDateTime,
  Document.ConditionCalculationType AS ConditionCalculationType,
  Document.ConditionBaseValue AS ConditionBaseValue,
  Document.ConditionRateValue AS ConditionRateValue,
  Document.ConditionCurrency AS ConditionCurrency,
  Document.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  Document.AbsoluteExchangeRate AS AbsoluteExchangeRate,
  Document.ExchRateIsIndirectQuotation AS ExchRateIsIndirectQuotation,
  Document.EffectiveExchangeRate AS EffectiveExchangeRate,
  Document.ConditionQuantity AS ConditionQuantity,
  Document.ConditionQuantityUnit AS ConditionQuantityUnit,
  Document.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  Document.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  Document.ConditionCategory AS ConditionCategory,
  Document.ConditionIsForStatistics AS ConditionIsForStatistics,
  Document.PricingScaleType AS PricingScaleType,
  Document.IsRelevantForAccrual AS IsRelevantForAccrual,
  Document.CndnIsRelevantForInvoiceList AS CndnIsRelevantForInvoiceList,
  Document.ConditionOrigin AS ConditionOrigin,
  Document.IsGroupCondition AS IsGroupCondition,
  Document.AccessNumberOfAccessSequence AS AccessNumberOfAccessSequence,
  Document.ConditionRecord AS ConditionRecord,
  Document.ConditionSequentialNumber AS ConditionSequentialNumber,
  Document.AccountKeyForGLAccount AS AccountKeyForGLAccount,
  Document.GLAccount AS GLAccount,
  Document.TaxCode AS TaxCode,
  Document.AcctKeyForAccrualsGLAccount AS AcctKeyForAccrualsGLAccount,
  Document.AccrualsGLAccount AS AccrualsGLAccount,
  Document.WithholdingTaxCode AS WithholdingTaxCode,
  Document.FreightSupplier AS FreightSupplier,
  Document.CndnRoundingOffDiffAmount AS CndnRoundingOffDiffAmount,
  Document.ConditionAmount AS ConditionAmount,
  Document.TransactionCurrency AS TransactionCurrency,
  Document.ConditionControl AS ConditionControl,
  Document.ConditionInactiveReason AS ConditionInactiveReason,
  _ConditionInactiveReason._Text[ 1: Language = $session.system_language ].ConditionInactiveReasonName AS ConditionInactiveReasonName,
  Document.ConditionClass AS ConditionClass,
  Document.PrcgProcedureCounterForHeader AS PrcgProcedureCounterForHeader,
  Document.FactorForConditionBasisValue AS FactorForConditionBasisValue,
  Document.StructureCondition AS StructureCondition,
  Document.PeriodFactorForCndnBasisValue AS PeriodFactorForCndnBasisValue,
  Document.PricingScaleBasis AS PricingScaleBasis,
  Document.ConditionScaleBasisValue AS ConditionScaleBasisValue,
  Document.ConditionScaleBasisUnit AS ConditionScaleBasisUnit,
  Document.ConditionScaleBasisCurrency AS ConditionScaleBasisCurrency,
  Document.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  Document.ConditionAmountInLocalCrcy AS ConditionAmountInLocalCrcy,
  Document.CndnIsRelevantForIntcoBilling AS CndnIsRelevantForIntcoBilling,
  Document.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  Document.BillingPriceSource AS BillingPriceSource,
  Document.TaxJurisdictionLevel AS TaxJurisdictionLevel,
  Document.ConditionByteSequence AS ConditionByteSequence,
  Document.CndnIsRelevantForLimitValue AS CndnIsRelevantForLimitValue,
  Document.ConditionBasisLimitExceeded AS ConditionBasisLimitExceeded,
  Document.ConditionAmountLimitExceeded AS ConditionAmountLimitExceeded,
  Document.CumulatedConditionBasisValue AS CumulatedConditionBasisValue,
  Document.CustomerRebateRecipient AS CustomerRebateRecipient,
  Document.ConditionIsForConfiguration AS ConditionIsForConfiguration,
  Document.VariantCondition AS VariantCondition,
  Document.ConditionAcctAssgmtRelevance AS ConditionAcctAssgmtRelevance,
  Document.ConditionMatrixMaintRelevance AS ConditionMatrixMaintRelevance,
  Document.ConfigblParametersAndFormulas AS ConfigblParametersAndFormulas,
  Document.ConditionAdjustedQuantity AS ConditionAdjustedQuantity,
  Document.ConditionTypeName AS ConditionTypeName,
  Document.ConditionBaseValueIntlUnit AS ConditionBaseValueIntlUnit,
  Document.ConditionBaseValueUnit AS ConditionBaseValueUnit,
  Document.ConditionRateValueIntlUnit AS ConditionRateValueIntlUnit,
  Document.TaxCodeName AS TaxCodeName,
  Document.ConditionIsDeletable AS ConditionIsDeletable,
  Document.PricingProcedure AS PricingProcedure,
  Document.SuperordinateDocument AS SuperordinateDocument,
  Document.SuperordinateDocumentItem AS SuperordinateDocumentItem,
  Document.ConditionRateValueUnit AS ConditionRateValueUnit,
  Document._BillingPriceSource AS _BillingPriceSource,
  Document._ConditionAcctAssgmtRelevance AS _ConditionAcctAssgmtRelevance,
  Document._ConditionAlternativeCurrency AS _ConditionAlternativeCurrency,
  Document._ConditionAmountLimitExceeded AS _ConditionAmountLimitExceeded,
  Document._ConditionApplication AS _ConditionApplication,
  Document._ConditionBasisLimitExceeded AS _ConditionBasisLimitExceeded,
  Document._ConditionCalculationType AS _ConditionCalculationType,
  Document._ConditionCategory AS _ConditionCategory,
  Document._ConditionClass AS _ConditionClass,
  Document._ConditionControl AS _ConditionControl,
  Document._ConditionCurrency AS _ConditionCurrency,
  Document._ConditionInactiveReason AS _ConditionInactiveReason,
  Document._ConditionOrigin AS _ConditionOrigin,
  Document._Customer AS _Customer,
  Document._PricingScaleBasis AS _PricingScaleBasis,
  Document._ConditionQuantityUnit AS _ConditionQuantityUnit,
  Document._ScaleCurrency AS _ScaleCurrency,
  Document._ScaleUnitOfMeasure AS _ScaleUnitOfMeasure,
  Document._StructureCondition AS _StructureCondition,
  Document._Supplier AS _Supplier,
  Document._VariantCondition AS _VariantCondition
FROM I_CntrlPurOrderPrcgElement AS Document
LEFT OUTER JOIN I_CentralPurchaseOrderTP AS _CentralPurchaseOrderTP ON _CentralPurchaseOrderTP.PurchaseOrder = PurchaseOrder AND _CentralPurchaseOrderTP.ExtSourceSystem = ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_CentralPurchaseOrderItemTP AS _CentralPurchaseOrderItemTP ON _CentralPurchaseOrderItemTP.PurchaseOrder = PurchaseOrder AND _CentralPurchaseOrderItemTP.PurchaseOrderItem = PurchaseOrderItem AND _CentralPurchaseOrderItemTP.ExtSourceSystem = ExtSourceSystem  -- association [1..1]
;