I_PricingElement

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_PricingElement.
-- 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: IPRICINGELEMENT

CREATE VIEW I_PricingElement AS
SELECT
  knumv AS PricingDocument,
  kposn AS PricingDocumentItem,
  stunr AS PricingProcedureStep,
  zaehk AS PricingProcedureCounter,
  kappl AS ConditionApplication,
  kschl AS ConditionType,
  cast( left(kdatu, 8) as kdatu ) AS PriceConditionDeterminationDte,
  krech AS ConditionCalculationType,
  kawrt AS ConditionBaseValue,
  kbetr AS ConditionRateValue,
  waers AS ConditionCurrency,
  kkurs AS PriceDetnExchangeRate,
  kpein AS ConditionQuantity,
  kmein AS ConditionQuantityUnit,
  kumza AS ConditionToBaseQtyNmrtr,
  kumne AS ConditionToBaseQtyDnmntr,
  kntyp AS ConditionCategory,
  kstat AS ConditionIsForStatistics,
  knprs AS PricingScaleType,
  kruek AS IsRelevantForAccrual,
  kreli AS CndnIsRelevantForInvoiceList,
  kherk AS ConditionOrigin,
  kgrpe AS IsGroupCondition,
  kolnr AS AccessNumberOfAccessSequence,
  knumh AS ConditionRecord,
  kopos AS ConditionSequentialNumber,
  kvsl1 AS AccountKeyForGLAccount,
  sakn1 AS GLAccount,
  mwsk1 AS TaxCode,
  kvsl2 AS AcctKeyForAccrualsGLAccount,
  sakn2 AS AccrualsGLAccount,
  mwsk2 AS WithholdingTaxCode,
  lifnr AS FreightSupplier,
  kdiff AS CndnRoundingOffDiffAmount,
  kwert AS ConditionAmount,
  waerk AS TransactionCurrency,
  ksteu AS ConditionControl,
  kinak AS ConditionInactiveReason,
  koaid AS ConditionClass,
  zaeko AS PrcgProcedureCounterForHeader,
  kfaktor AS FactorForConditionBasisValue,
  kdupl AS StructureCondition,
  kfaktor1 AS PeriodFactorForCndnBasisValue,
  kzbzg AS PricingScaleBasis,
  kstbs AS ConditionScaleBasisValue,
  konms AS ConditionScaleBasisUnit,
  konws AS ConditionScaleBasisCurrency,
  kwaeh AS ConditionAlternativeCurrency,
  kwert_k AS ConditionAmountInLocalCrcy,
  kfkiv AS CndnIsRelevantForIntcoBilling,
  kmprs AS ConditionIsManuallyChanged,
  prsqu AS BillingPriceSource,
  txjlv AS TaxJurisdictionLevel,
  kbflag AS ConditionByteSequence,
  koupd AS CndnIsRelevantForLimitValue,
  kmxaw AS ConditionBasisLimitExceeded,
  kmxwr AS ConditionAmountLimitExceeded,
  kawrt_k AS CumulatedConditionBasisValue,
  kunnr AS CustomerRebateRecipient,
  kvarc AS ConditionIsForConfiguration,
  varcond AS VariantCondition,
  ktrel AS ConditionAcctAssgmtRelevance,
  mdflg AS ConditionMatrixMaintRelevance,
  cpf_guid AS ConfigblParametersAndFormulas,
  kaqty AS ConditionAdjustedQuantity,
  val_zero AS CndnValueZeroProcgCode,
  is_acct_detn_relevant AS CndnIsAcctDetnRelevant,
  tax_country AS TaxCountry,
  common_suppl_data AS PriceConditionHasSuplmntyData,
  PricingSubProcedure
FROM prcd_elements
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]
LEFT OUTER JOIN I_ConditionRateRatioUnit AS _ConditionRateRatioUnit ON ConditionRateRatioUnit = _ConditionRateRatioUnit.ConditionRateRatioUnit  -- association [0..1]
;