I_QTNPricingElementWD

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_QTNPricingElementWD.
-- 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: IQTNPRICINGWD

CREATE VIEW I_QTNPricingElementWD AS
SELECT
  Document.PricingDocument AS PricingDocument,
  Document.PricingDocumentItem AS PricingDocumentItem,
  Document.PricingProcedureStep AS PricingProcedureStep,
  Document.PricingProcedureCounter AS PricingProcedureCounter,
  Document.SupplierQuotation AS SupplierQuotation,
  Document.SupplierQuotationItem AS SupplierQuotationItem,
  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,
  cast( Document.PriceDetnExchangeRate as kkurs preserving type ) AS PriceDetnExchangeRate,
  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,
  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._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._PricingConditionType AS _PricingConditionType,
  Document._ConditionQuantityUnit AS _ConditionQuantityUnit,
  Document._PricingScaleBasis AS _PricingScaleBasis,
  Document._ScaleCurrency AS _ScaleCurrency,
  Document._ScaleUnitOfMeasure AS _ScaleUnitOfMeasure,
  Document._StructureCondition AS _StructureCondition,
  Document._Supplier AS _Supplier,
  Document._VariantCondition AS _VariantCondition
FROM I_QTNPricingElement AS Document
LEFT OUTER JOIN I_SuplrQuotationEnhWD AS _SuplrQuotationEnhWD ON _SuplrQuotationEnhWD.SupplierQuotation = SupplierQuotation  -- association [1..1]
LEFT OUTER JOIN I_SuplrQuotationItemEnhWD AS _SuplrQuotationItemEnhWD ON _SuplrQuotationItemEnhWD.SupplierQuotation = SupplierQuotation AND _SuplrQuotationItemEnhWD.SupplierQuotationItem = SupplierQuotationItem  -- association [1..1]
;