R_SuplrSettlmtList

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_SuplrSettlmtList.
-- 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_SuplrSettlmtList AS
SELECT
  cast( SettlmtMgmtDoc as wbeln_rglst preserving type ) AS SuplrSettlmtList,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  LogisticsDataEntryCat,
  PostingDate,
  SettlmtMgmtAcctgTransfSts AS SuplrSetlLstAcctgTransfSts,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtApplSts,
  SettlmtApplStsGrp,
  cast( SupplierPricingProcedure as wlf_kalsm preserving type ) AS PricingProcedure,
  InvoicingParty,
  PayeeParty,
  AlternativeInvoicingParty,
  cast( CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  SettlmtDocCurrency AS SuplrSettlmtListCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  cast( SupplierTotalGrossAmount as brtwr_lf preserving type ) AS SuplrSettlmtListTotGrossAmount,
  cast( SupplierTotalNetAmount as netwr_lf preserving type ) AS SuplrSettlmtListTotalNetAmount,
  cast( SupplierTotalTaxAmount as wlf_mwsbk preserving type ) AS SuplrSettlmtListTotalTaxAmount,
  SupplierPaymentTerms AS PaymentTerms,
  SupplierCashDiscount1Days AS CashDiscount1Days,
  SupplierCashDiscount2Days AS CashDiscount2Days,
  SupplierNetPaymentDays AS NetPaymentDays,
  SupplierCashDiscount1Percent AS CashDiscount1Percent,
  SupplierCashDiscount2Percent AS CashDiscount2Percent,
  SupplierPaymentMethod AS PaymentMethod,
  cast( SuplrTotEligibleAmtForCshDisc as wlf_total_skfbp preserving type ) AS SuplrTotEligibleAmtForCshDisc,
  cast( SettlmtMgmtDocIsCancelled as wlf_fksto_d preserving type ) AS SuplrSettlmtListIsReversed,
  CancelledSettlmtMgmtDoc AS RvsdSuplrSettlmtList,
  cast( SupplierAdditionalValueDays as wlf_valtg preserving type ) AS AdditionalValueDays,
  cast( SupplierFixedValueDate as wlf_valdt preserving type ) AS FixedValueDate,
  SupplyingCountry,
  TaxDepartureCountry,
  TaxDestinationCountry,
  IsEUTriangularDeal,
  SettlmtCoCodeTaxCountry,
  cast( SupplierVATRegistration as farp_stceg preserving type ) AS VATRegistration,
  StateCentralBankPaymentReason,
  CreditControlArea,
  SettlmtDocActivityReason AS SuplrSettlmtListActyReason,
  PaymentReference,
  cast( SupplierPaymentCurrency as wlf_pycur preserving type ) AS SuplrSettlmtListPaytCurrency,
  cast( SupplierPaytCurrencyExchRate as wlf_kurs_py_no_cnext preserving type ) AS SuplrSetlLstPaytCrcyExchRate,
  SEPAMandate,
  OneTimeSupplierAddressID,
  FiscalPeriod,
  SettlmtDate,
  SettlmtMgmtDocIncmpltnsRsn AS SuplrSettlmtListIncmpltnsRsn,
  DocIntrastatRelevance,
  IntrastatDeclnGdsFlwCat,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  SettlmtBusProcVar,
  SettlmtBusProcCat,
  SettlmtMgmtOutpCat AS SuplrSettlmtListOutpCat
FROM R_SettlmtMgmtDoc
LEFT OUTER JOIN R_SuplrSettlmtListItem AS _SuplrSettlmtListItem ON SuplrSettlmtList = _SuplrSettlmtListItem.SuplrSettlmtList  -- association [0..*]
LEFT OUTER JOIN I_SuplrSettlmtListPlainLongTxt AS _SuplrSettlmtListPlainLongText ON SuplrSettlmtList = _SuplrSettlmtListPlainLongText.SuplrSettlmtList  -- association [0..*]
LEFT OUTER JOIN I_SettlmtMgmtAcctgTransfSts AS _SuplrSetlLstAcctgTransfSts ON SuplrSetlLstAcctgTransfSts = _SuplrSetlLstAcctgTransfSts.SettlmtMgmtAcctgTransfSts  -- association [0..1]
LEFT OUTER JOIN R_SuplrSettlmtListPartner AS _SuplrSettlmtListPartner ON SuplrSettlmtList = _SuplrSettlmtListPartner.SuplrSettlmtList  -- association [0..*]
LEFT OUTER JOIN R_SuplrSettlmtListBankData AS _SuplrSettlmtListBankData ON SuplrSettlmtList = _SuplrSettlmtListBankData.SuplrSettlmtList  -- association [0..*]
LEFT OUTER JOIN I_SupplierCompany AS _InvoicingPartyCompany ON InvoicingParty = _InvoicingPartyCompany.Supplier AND CompanyCode = _InvoicingPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _PayeePartyCompany ON PayeeParty = _PayeePartyCompany.Supplier AND CompanyCode = _PayeePartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _AltvInvoicingPartyCompany ON AlternativeInvoicingParty = _AltvInvoicingPartyCompany.Supplier AND CompanyCode = _AltvInvoicingPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SuplrSettlmtListCurrency ON SuplrSettlmtListCurrency = _SuplrSettlmtListCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN R_SuplrSettlmtList AS _RvsdSuplrSettlmtList ON RvsdSuplrSettlmtList = _RvsdSuplrSettlmtList.SuplrSettlmtList  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocIncmpltnsRsnCd AS _SuplrSettlmtListIncmpltnsRsn ON SuplrSettlmtListIncmpltnsRsn = _SuplrSettlmtListIncmpltnsRsn.SettlmtMgmtDocIncmpltnsRsn  -- association [0..1]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea  -- association [0..*]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _SuplrSettlmtListActyReason ON SuplrSettlmtListActyReason = _SuplrSettlmtListActyReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SuplrSettlmtListPaytCurrency ON SuplrSettlmtListPaytCurrency = _SuplrSettlmtListPaytCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtOutpCat AS _SuplrSettlmtListOutpCat ON SuplrSettlmtListOutpCat = _SuplrSettlmtListOutpCat.SettlmtMgmtOutpCat  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON SuplrSettlmtList = _Extension.SettlmtMgmtDoc  -- association [1..1]
;