A_SettlmtDocItmCustPrcgElmnt

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 A_SettlmtDocItmCustPrcgElmnt.
-- 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 A_SettlmtDocItmCustPrcgElmnt AS
SELECT
  SettlmtDoc,
  SettlmtDocItem,
  PricingProcedureStep,
  PricingProcedureCounter,
  ConditionApplication,
  ConditionType,
  PriceConditionDeterminationDte,
  ConditionCalculationType,
  ConditionCurrency,
  ConditionQuantity,
  ConditionQuantityUnit,
  cast( _ConditionQuantityUnit.UnitOfMeasureISOCode as wlf_kvmei_iso preserving type ) AS ConditionQuantityUnitISOCode,
  cast( _ConditionQuantityUnit.UnitOfMeasureSAPCode as wlf_kvmei_sapcode preserving type ) AS ConditionQuantityUnitSAPCode,
  ConditionCategory,
  ConditionIsForStatistics,
  PricingScaleType,
  IsRelevantForAccrual,
  CndnIsRelevantForInvoiceList,
  ConditionOrigin,
  IsGroupCondition,
  ConditionRecord,
  ConditionSequentialNumber,
  TaxCode,
  WithholdingTaxCode,
  CndnRoundingOffDiffAmount,
  ConditionAmount,
  TransactionCurrency,
  ConditionControl,
  ConditionInactiveReason,
  ConditionClass,
  PrcgProcedureCounterForHeader,
  FactorForConditionBasisValue,
  StructureCondition,
  PeriodFactorForCndnBasisValue,
  PricingScaleBasis,
  ConditionScaleBasisUnit,
  cast( _ScaleUnitOfMeasure.UnitOfMeasureISOCode as wlf_konms_iso preserving type ) AS ConditionScaleBasisUnitISOCode,
  cast( _ScaleUnitOfMeasure.UnitOfMeasureSAPCode as wlf_konms_sapcode preserving type ) AS ConditionScaleBasisUnitSAPCode,
  ConditionScaleBasisCurrency,
  ConditionIsManuallyChanged,
  ConditionIsForConfiguration,
  VariantCondition,
  ConditionRateAmount,
  ConditionBaseAmount,
  ConditionBaseQuantity,
  ConditionRateRatio,
  ConditionRateRatioUnit,
  cast( _RatioUnitOfMeasure.UnitOfMeasureISOCode as wlf_ratiounit_iso preserving type ) AS ConditionRateRatioUnitISOCode,
  cast( _RatioUnitOfMeasure.UnitOfMeasureSAPCode as wlf_ratiounit_sapcode preserving type ) AS ConditionRateRatioUnitSAPCode,
  ConditionScaleBaseAmount,
  ConditionScaleBaseQuantity
FROM R_SettlmtDocItmCustPrcgElmntTP
;