R_SetlMgmtDocCustPrcgElmnt

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 R_SetlMgmtDocCustPrcgElmnt.
-- 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.

CREATE VIEW R_SetlMgmtDocCustPrcgElmnt AS
SELECT
  SettlmtMgmtDoc.SettlmtMgmtDoc AS SettlmtMgmtDoc,
  PricingElement.PricingProcedureStep AS PricingProcedureStep,
  cast( PricingElement.PricingProcedureCounter as wlf_vfprc_cond_count preserving type ) AS PricingProcedureCounter,
  PricingElement.ConditionApplication AS ConditionApplication,
  PricingElement.ConditionType AS ConditionType,
  cast( PricingElement.PriceConditionDeterminationDte as wlf_kdatu preserving type ) AS PriceConditionDeterminationDte,
  PricingElement.ConditionCalculationType AS ConditionCalculationType,
  cast( PricingElement.ConditionBaseAmount as wlf_prcg_element_base_amount preserving type ) AS ConditionBaseAmount,
  PricingElement.ConditionRateAmount AS ConditionRateAmount,
  cast( PricingElement.ConditionRateRatio as wlf_prcg_element_ratio preserving type ) AS ConditionRateRatio,
  cast( PricingElement.ConditionRateRatioUnit as wlf_ratiounit preserving type ) AS ConditionRateRatioUnit,
  PricingElement.ConditionCurrency AS ConditionCurrency,
  case when PricingElement.ConditionQuantityUnit is initial then 0 else PricingElement.ConditionQuantity end as ConditionQuantity AS ConditionQuantityendasConditionQuantity,
  PricingElement.ConditionQuantityUnit AS ConditionQuantityUnit,
  PricingElement.ConditionCategory AS ConditionCategory,
  PricingElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  PricingElement.IsRelevantForAccrual AS IsRelevantForAccrual,
  cast( PricingElement.CndnIsRelevantForInvoiceList as wlf_settlmt_doc_list_cndn preserving type ) AS CndnIsRelevantForInvoiceList,
  PricingElement.ConditionOrigin AS ConditionOrigin,
  PricingElement.IsGroupCondition AS IsGroupCondition,
  PricingElement.ConditionRecord AS ConditionRecord,
  PricingElement.ConditionSequentialNumber AS ConditionSequentialNumber,
  PricingElement.TaxCode AS TaxCode,
  PricingElement.WithholdingTaxCode AS WithholdingTaxCode,
  PricingElement.CndnRoundingOffDiffAmount AS CndnRoundingOffDiffAmount,
  PricingElement.ConditionAmount AS ConditionAmount,
  PricingElement.TransactionCurrency AS TransactionCurrency,
  PricingElement.ConditionControl AS ConditionControl,
  PricingElement.ConditionInactiveReason AS ConditionInactiveReason,
  PricingElement.ConditionClass AS ConditionClass,
  cast( PricingElement.PrcgProcedureCounterForHeader as wlf_vfprc_cond_count_head preserving type ) AS PrcgProcedureCounterForHeader,
  cast( PricingElement.FactorForConditionBasisValue as wlf_kfaktor preserving type ) AS FactorForConditionBasisValue,
  PricingElement.StructureCondition AS StructureCondition,
  cast( PricingElement.PeriodFactorForCndnBasisValue as wlf_kfaktor1 preserving type ) AS PeriodFactorForCndnBasisValue,
  PricingElement.PricingScaleType AS PricingScaleType,
  PricingElement.PricingScaleBasis AS PricingScaleBasis,
  PricingElement.ConditionScaleBaseAmount AS ConditionScaleBaseAmount,
  PricingElement.ConditionScaleBaseQuantity AS ConditionScaleBaseQuantity,
  PricingElement.ConditionScaleBasisUnit AS ConditionScaleBasisUnit,
  PricingElement.ConditionScaleBasisCurrency AS ConditionScaleBasisCurrency,
  PricingElement.CndnIsRelevantForIntcoBilling AS CndnIsRelevantForIntcoBilling,
  PricingElement.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  PricingElement.ConditionIsForConfiguration AS ConditionIsForConfiguration,
  PricingElement.VariantCondition AS VariantCondition,
  PricingElement.ConditionBasisLimitExceeded AS ConditionBasisLimitExceeded,
  PricingElement.ConditionAmountLimitExceeded AS ConditionAmountLimitExceeded,
  PricingElement.CndnIsRelevantForLimitValue AS CndnIsRelevantForLimitValue,
  PricingElement.TaxCountry AS TaxCountry,
  PricingElement.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  PricingElement.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  PricingElement.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  cast( PricingElement.ConditionAmountInLocalCrcy as wlf_cndn_cumltv_amt preserving type ) AS ConditionAmountInLocalCrcy,
  cast( PricingElement.FreightSupplier as wlf_expense_supplier preserving type ) AS ExpenseSupplier,
  cast( PricingElement.CustomerRebateRecipient as wlf_expense_customer preserving type ) AS ExpenseCustomer,
  cast( PricingElement.PriceDetnExchangeRate as wlf_kkurs_curr_no_cnext preserving type ) AS PriceDetnExchangeRate,
  SettlmtMgmtDoc.SettlmtMgmtDocCat AS SettlmtMgmtDocCat,
  SettlmtMgmtDoc.SettlmtPartnerCat AS SettlmtPartnerCat,
  SettlmtMgmtDoc.SettlmtBusProcCat AS SettlmtBusProcCat,
  PricingElement._ConditionApplication AS _ConditionApplication,
  PricingElement._PricingConditionType AS _PricingConditionType,
  PricingElement._ConditionCalculationType AS _ConditionCalculationType,
  PricingElement._ConditionCurrency AS _ConditionCurrency,
  PricingElement._Currency AS _Currency,
  PricingElement._ConditionQuantityUnit AS _ConditionQuantityUnit,
  PricingElement._ConditionCategory AS _ConditionCategory,
  PricingElement._ConditionOrigin AS _ConditionOrigin,
  PricingElement._ConditionControl AS _ConditionControl,
  PricingElement._ConditionInactiveReason AS _ConditionInactiveReason,
  PricingElement._ConditionClass AS _ConditionClass,
  PricingElement._PricingScaleBasis AS _PricingScaleBasis,
  PricingElement._ScaleUnitOfMeasure AS _ScaleUnitOfMeasure,
  PricingElement._ScaleCurrency AS _ScaleCurrency,
  PricingElement._VariantCondition AS _VariantCondition,
  PricingElement._StructureCondition AS _StructureCondition,
  PricingElement._ConditionBasisLimitExceeded AS _ConditionBasisLimitExceeded,
  PricingElement._ConditionAmountLimitExceeded AS _ConditionAmountLimitExceeded,
  PricingElement._ConditionAlternativeCurrency AS _ConditionAlternativeCurrency,
  PricingElement._Supplier AS _Supplier,
  PricingElement._Customer AS _Customer
FROM I_PricingElement AS PricingElement
INNER JOIN R_SettlmtMgmtDoc AS SettlmtMgmtDoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SettlmtMgmtDoc AS _SettlmtMgmtDoc ON SettlmtMgmtDoc = _SettlmtMgmtDoc.SettlmtMgmtDoc  -- association [1..1]
;