I_CustSettlmtItmPrcgElmnt

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_CustSettlmtItmPrcgElmnt.
-- 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 I_CustSettlmtItmPrcgElmnt AS
SELECT
  CustSettlmt,
  CustSettlmtItem,
  PricingProcedureStep,
  PricingProcedureCounter,
  ConditionApplication,
  ConditionType,
  cast( ' ' as vfprc_timestamp preserving type ) AS PricingDateTime,
  PriceConditionDeterminationDte,
  ConditionCalculationType,
  cast( ConditionBaseAmount as vfprc_element_base_value preserving type ) AS ConditionBaseValue,
  cast( ConditionRateAmount as vfprc_element_amount preserving type ) AS ConditionRateValue,
  ConditionBaseAmount,
  ConditionBaseQuantity,
  ConditionRateAmount,
  ConditionRateRatio,
  ConditionRateRatioUnit,
  ConditionCurrency,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionCategory,
  ConditionIsForStatistics,
  IsRelevantForAccrual,
  CndnIsRelevantForInvoiceList,
  ConditionOrigin,
  IsGroupCondition,
  ConditionRecord,
  ConditionSequentialNumber,
  TaxCode,
  WithholdingTaxCode,
  CndnRoundingOffDiffAmount,
  ConditionAmount,
  TransactionCurrency,
  ConditionControl,
  ConditionInactiveReason,
  ConditionClass,
  PrcgProcedureCounterForHeader,
  FactorForConditionBasisValue,
  StructureCondition,
  PeriodFactorForCndnBasisValue,
  PricingScaleType,
  PricingScaleBasis,
  cast (ConditionScaleBaseAmount as vfrpc_scale_base_value preserving type ) AS ConditionScaleBasisValue,
  ConditionScaleBaseAmount,
  ConditionScaleBaseQuantity,
  ConditionScaleBasisUnit,
  ConditionScaleBasisCurrency,
  CndnIsRelevantForIntcoBilling,
  ConditionIsManuallyChanged,
  ConditionIsForConfiguration,
  VariantCondition,
  AccountKeyForGLAccount,
  AcctKeyForAccrualsGLAccount
FROM R_CustSettlmtItmPrcgElmnt
LEFT OUTER JOIN I_CustSettlmt AS _CustSettlmt ON CustSettlmt = _CustSettlmt.CustSettlmt  -- association [1..1]
LEFT OUTER JOIN I_CustSettlmtItem AS _CustSettlmtItem ON CustSettlmt = _CustSettlmtItem.CustSettlmt AND CustSettlmtItem = _CustSettlmtItem.CustSettlmtItem  -- association [1..1]
;