R_CustSettlmt

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_CustSettlmt.
-- 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_CustSettlmt AS
SELECT
  cast( SettlmtMgmtDoc as wbeln_cu preserving type ) AS CustSettlmt,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  LogisticsDataEntryCat,
  SettlmtCat,
  PostingDate,
  SettlmtMgmtAcctgTransfSts AS CustSettlmtAcctgTransfSts,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtApplSts,
  SettlmtApplStsGrp,
  cast( CustomerPricingProcedure as wlf_kalsm preserving type ) AS PricingProcedure,
  cast( CustomerPricingDocument as wlf_knumv preserving type ) AS PricingDocument,
  BillToParty,
  PayerParty,
  cast( CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  SettlmtDocCurrency AS CustSettlmtCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  cast( SupplierTotalGrossAmount as brtwr_lf preserving type ) AS CustSettlmtTotalGrossAmount,
  cast( SupplierTotalNetAmount as netwr_lf preserving type ) AS CustSettlmtTotalNetAmount,
  cast( SupplierTotalTaxAmount as wlf_mwsbk preserving type ) AS CustSettlmtTotalTaxAmount,
  cast( CustomerPaymentTerms as farp_dzterm preserving type ) AS PaymentTerms,
  cast( CustomerCashDiscount1Days as farp_dzbd1t preserving type ) AS CashDiscount1Days,
  cast( CustomerCashDiscount2Days as farp_dzbd2t preserving type ) AS CashDiscount2Days,
  cast( CustomerNetPaymentDays as farp_dzbd3t preserving type ) AS NetPaymentDays,
  cast( CustomerCashDiscount1Percent as dzbd1p_farp preserving type ) AS CashDiscount1Percent,
  cast( CustomerCashDiscount2Percent as dzbd2p_farp preserving type ) AS CashDiscount2Percent,
  cast( CustomerPaymentMethod as farp_schzw_bseg preserving type ) AS PaymentMethod,
  cast( SuplrTotEligibleAmtForCshDisc as wlf_total_skfbp preserving type ) AS CustTotEligibleAmtForCshDisc,
  cast( SettlmtMgmtDocIsCancelled as wlf_fksto_g preserving type ) AS CustSettlmtIsReversed,
  CancelledSettlmtMgmtDoc AS ReversedCustomerSettlement,
  cast( CustomerAdditionalValueDays as wlf_valtg preserving type ) AS AdditionalValueDays,
  cast( CustomerFixedValueDate as wlf_valdt preserving type ) AS FixedValueDate,
  TaxDepartureCountry,
  TaxDestinationCountry,
  IsEUTriangularDeal,
  SettlmtCoCodeTaxCountry,
  cast( CustomerVATRegistration as farp_stceg preserving type ) AS VATRegistration,
  CreditControlArea,
  CreditControlAreaCurrency,
  cast( ReleasedCreditAmount as wlf_amtbl_cm preserving type ) AS ReleasedCreditAmount,
  SettlmtDocActivityReason AS CustSettlmtActivityReason,
  PaymentReference,
  cast( CustomerPaymentCurrency as wlf_pycur preserving type ) AS CustSettlmtPaymentCurrency,
  cast( CustomerPaytCurrencyExchRate as wlf_kurs_py_no_cnext preserving type ) AS CustSettlmtPaytCrcyExchRate,
  OneTimeCustomerAddressID,
  SettlmtReltdRefDocCat,
  SettlmtReltdRefDoc,
  CndnContrType,
  SettlmtReltdCndnContr,
  FiscalPeriod,
  SettlmtDateCat,
  ActualSettlmtDate,
  SettlmtDateSequentialID,
  SettlmtDate,
  SettlmtMgmtDocIncmpltnsRsn AS CustSettlmtIncmpltnsRsn,
  DocIntrastatRelevance,
  IntrastatDeclnGdsFlwCat,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  SettlmtBusProcVar,
  SettlmtBusProcCat,
  SEPAMandate,
  TotalSettlmtQuantity,
  TotalSettlmtQuantityUnit,
  TotalSettlmtNetWeight,
  TotalSettlmtGrossWeight,
  TotalSettlmtWeightUnit,
  TotalSettlmtVolume,
  TotalSettlmtVolumeUnit,
  TotalSettlmtPointsQty,
  TotalSettlmtPointsQtyUnit,
  SettlmtPeriodStartDate,
  SettlmtPeriodEndDate,
  CndnContrProcessCategory,
  SettlmtMgmtOutpCat AS CustSettlmtOutpCat
FROM R_SettlmtMgmtDoc
LEFT OUTER JOIN R_CustSettlmtItem AS _CustSettlmtItem ON CustSettlmt = _CustSettlmtItem.CustSettlmt  -- association [0..*]
LEFT OUTER JOIN I_CustSettlmtPlainLongText AS _CustSettlmtPlainLongText ON CustSettlmt = _CustSettlmtPlainLongText.CustSettlmt  -- association [0..*]
LEFT OUTER JOIN I_SettlmtMgmtAcctgTransfSts AS _CustSettlmtAcctgTransfSts ON CustSettlmtAcctgTransfSts = _CustSettlmtAcctgTransfSts.SettlmtMgmtAcctgTransfSts  -- association [0..1]
LEFT OUTER JOIN R_CustSettlmtPartner AS _CustSettlmtPartner ON CustSettlmt = _CustSettlmtPartner.CustSettlmt  -- association [0..*]
LEFT OUTER JOIN R_CustSettlmtBankData AS _CustSettlmtBankData ON CustSettlmt = _CustSettlmtBankData.CustSettlmt  -- association [0..*]
LEFT OUTER JOIN R_CustSettlmtPrcgElmnt AS _CustSettlmtPrcgElmnt ON CustSettlmt = _CustSettlmtPrcgElmnt.CustSettlmt  -- association [0..*]
LEFT OUTER JOIN I_CustomerCompany AS _BillToPartyCompany ON BillToParty = _BillToPartyCompany.Customer AND CompanyCode = _BillToPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _PayerPartyCompany ON PayerParty = _PayerPartyCompany.Customer AND CompanyCode = _PayerPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CustSettlmtCurrency ON CustSettlmtCurrency = _CustSettlmtCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN R_CustSettlmt AS _ReversedCustomerSettlement ON ReversedCustomerSettlement = _ReversedCustomerSettlement.CustSettlmt  -- association [0..1]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea  -- association [0..*]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _CustSettlmtActivityReason ON CustSettlmtActivityReason = _CustSettlmtActivityReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CustSettlmtPaymentCurrency ON CustSettlmtPaymentCurrency = _CustSettlmtPaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocIncmpltnsRsnCd AS _CustSettlmtIncmpltnsRsn ON CustSettlmtIncmpltnsRsn = _CustSettlmtIncmpltnsRsn.SettlmtMgmtDocIncmpltnsRsn  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtOutpCat AS _CustSettlmtOutpCat ON CustSettlmtOutpCat = _CustSettlmtOutpCat.SettlmtMgmtOutpCat  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON CustSettlmt = _Extension.SettlmtMgmtDoc  -- association [1..1]
;