I_CFinReplicatedPricingElement

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_CFinReplicatedPricingElement.
-- 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: ICFINRPRCELEM

CREATE VIEW I_CFinReplicatedPricingElement AS
SELECT
  cfin_av_prc_elem.fins_logsys AS SenderLogicalSystem,
  cast(cfin_av_prc_elem.knumv as fins_cfin_av_rpld_pricing_doc preserving type ) AS CFinRpldPricingDocument,
  cast(cfin_av_prc_elem.kposn as fins_cfin_av_rpld_prcg_doc_itm preserving type ) AS CFinRpldPricingDocumentItem,
  cfin_av_prc_elem.stunr AS PricingProcedureStep,
  cfin_av_prc_elem.zaehk AS PricingProcedureCounter,
  cfin_av_prc_elem.kappl AS ConditionApplication,
  cfin_av_prc_elem.kschl AS ConditionType,
  cfin_av_prc_elem.kdatu AS PricingDateTime,
  cfin_av_prc_elem.krech AS ConditionCalculationType,
  cfin_av_prc_elem.kawrt AS ConditionBaseValue,
  cfin_av_prc_elem.kbetr AS ConditionRateValue,
  cfin_av_prc_elem.waers AS ConditionCurrency,
  cfin_av_prc_elem.kkurs AS PriceDetnExchangeRate,
  cfin_av_prc_elem.kpein AS ConditionQuantity,
  cfin_av_prc_elem.kmein AS ConditionQuantityUnit,
  cfin_av_prc_elem.kumza AS ConditionToBaseQtyNmrtr,
  cfin_av_prc_elem.kumne AS ConditionToBaseQtyDnmntr,
  cfin_av_prc_elem.kntyp AS ConditionCategory,
  cfin_av_prc_elem.kstat AS ConditionIsForStatistics,
  cfin_av_prc_elem.knprs AS PricingScaleType,
  cfin_av_prc_elem.kruek AS IsRelevantForAccrual,
  cfin_av_prc_elem.kreli AS CndnIsRelevantForInvoiceList,
  cfin_av_prc_elem.kherk AS ConditionOrigin,
  cfin_av_prc_elem.kgrpe AS IsGroupCondition,
  cfin_av_prc_elem.koupd AS CndnIsRelevantForLimitValue,
  cfin_av_prc_elem.kolnr AS AccessNumberOfAccessSequence,
  cfin_av_prc_elem.knumh AS ConditionRecord,
  cfin_av_prc_elem.kopos AS ConditionSequentialNumber,
  cfin_av_prc_elem.mwsk1 AS TaxCode,
  cfin_av_prc_elem.mwsk2 AS WithholdingTaxCode,
  cfin_av_prc_elem.kunnr AS CustomerRebateRecipient,
  cfin_av_prc_elem.kdiff AS CndnRoundingOffDiffAmount,
  cfin_av_prc_elem.kwert AS ConditionAmount,
  cfin_av_prc_elem.ksteu AS ConditionControl,
  cfin_av_prc_elem.kinak AS ConditionInactiveReason,
  cfin_av_prc_elem.koaid AS ConditionClass,
  cfin_av_prc_elem.zaeko AS PrcgProcedureCounterForHeader,
  cfin_av_prc_elem.kmxaw AS ConditionBasisLimitExceeded,
  cfin_av_prc_elem.kmxwr AS ConditionAmountLimitExceeded,
  cfin_av_prc_elem.kfaktor AS FactorForConditionBasisValue,
  cfin_av_prc_elem.kdupl AS StructureCondition,
  cfin_av_prc_elem.kfaktor1 AS PeriodFactorForCndnBasisValue,
  cfin_av_prc_elem.kzbzg AS PricingScaleBasis,
  cfin_av_prc_elem.kstbs AS ConditionScaleBasisValue,
  cfin_av_prc_elem.konms AS ConditionScaleBasisUnit,
  cfin_av_prc_elem.konws AS ConditionScaleBasisCurrency,
  cfin_av_prc_elem.kawrt_k AS CumulatedConditionBasisValue,
  cfin_av_prc_elem.kwaeh AS ConditionAlternativeCurrency,
  cfin_av_prc_elem.kwert_k AS ConditionAmountInLocalCrcy,
  cfin_av_prc_elem.kfkiv AS CndnIsRelevantForIntcoBilling,
  cfin_av_prc_elem.kvarc AS ConditionIsForConfiguration,
  cfin_av_prc_elem.kmprs AS ConditionIsManuallyChanged,
  cfin_av_prc_elem.prsqu AS BillingPriceSource,
  cfin_av_prc_elem.varcond AS VariantCondition,
  cfin_av_prc_elem.ktrel AS ConditionAcctAssgmtRelevance,
  cfin_av_prc_elem.mdflg AS ConditionMatrixMaintRelevance,
  cfin_av_prc_elem.txjlv AS TaxJurisdictionLevel,
  cfin_av_prc_elem.waerk AS TransactionCurrency,
  kvsl1 AS AccountKeyForGLAccount
FROM cfin_av_prc_elem
LEFT OUTER JOIN I_ConditionApplication AS _ConditionApplication ON ConditionApplication = _ConditionApplication.ConditionApplication  -- 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_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_ConditionClass AS _ConditionClass ON ConditionClass = _ConditionClass.ConditionClass  -- association [0..1]
LEFT OUTER JOIN I_ConditionAmountLimitExceeded AS _ConditionAmountLimitExceeded ON ConditionAmountLimitExceeded = _ConditionAmountLimitExceeded.ConditionAmountLimitExceeded  -- association [0..1]
LEFT OUTER JOIN I_StructureCondition AS _StructureCondition ON StructureCondition = _StructureCondition.StructureCondition  -- 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_PricingConditionType AS _PricingConditionType ON ConditionApplication = _PricingConditionType.ConditionApplication AND ConditionType = _PricingConditionType.ConditionType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ConditionAcctAssgmtRelevance AS _ConditionAcctAssgmtRelevance ON ConditionAcctAssgmtRelevance = _ConditionAcctAssgmtRelevance.ConditionAcctAssgmtRelevance  -- 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_BillingPriceSource AS _BillingPriceSource ON BillingPriceSource = _BillingPriceSource.BillingPriceSource  -- association [0..1]
LEFT OUTER JOIN I_ConditionBasisLimitExceeded AS _ConditionBasisLimitExceeded ON ConditionBasisLimitExceeded = _ConditionBasisLimitExceeded.ConditionBasisLimitExceeded  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionQuantityUnit ON ConditionQuantityUnit = _ConditionQuantityUnit.UnitOfMeasure  -- association [0..1]
;