R_SettlmtDocList

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_SettlmtDocList.
-- 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_SettlmtDocList AS
SELECT
  cast( SettlmtMgmtDoc as wbeln_rl preserving type ) AS SettlmtDocList,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  SettlmtMgmtDocCat AS SettlmtDocListCat,
  LogisticsDataEntryCat,
  SettlmtMgmtAcctgTransfSts AS SettlmtDocListAcctgTransfSts,
  PostingDate,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtApplSts,
  SettlmtApplStsGrp,
  InvoicingParty,
  PayeeParty,
  AlternativeInvoicingParty,
  BillToParty,
  PayerParty,
  cast( CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  SettlmtDocCurrency AS SettlmtDocListCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  cast( SettlmtMgmtDocIsCancelled as wlf_fksto_e preserving type ) AS SettlmtDocListIsReversed,
  CancelledSettlmtMgmtDoc AS RvsdSettlmtDocList,
  SupplyingCountry,
  TaxDepartureCountry,
  TaxDestinationCountry,
  IsEUTriangularDeal,
  StateCentralBankPaymentReason,
  CreditControlArea,
  SettlmtDocActivityReason AS SettlmtDocListActivityReason,
  PaymentReference,
  FiscalPeriod,
  SettlmtDate,
  SettlmtMgmtDocIncmpltnsRsn AS SettlmtDocListIncmpltnsRsn,
  DocIntrastatRelevance,
  IntrastatDeclnGdsFlwCat,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  SettlmtBusProcVar,
  SettlmtBusProcCat,
  SEPAMandate,
  SettlmtDocListType,
  SettlmtMgmtOutpCat AS SettlmtDocListOutpCat
FROM R_SettlmtMgmtDoc
LEFT OUTER JOIN R_SettlmtDocListItem AS _SettlmtDocListItem ON SettlmtDocList = _SettlmtDocListItem.SettlmtDocList  -- association [0..*]
LEFT OUTER JOIN I_SettlmtDocListPlainLongText AS _SettlmtDocListPlainLongText ON SettlmtDocList = _SettlmtDocListPlainLongText.SettlmtDocList  -- association [0..*]
LEFT OUTER JOIN I_SettlmtMgmtAcctgTransfSts AS _SettlmtDocListAcctgTransfSts ON SettlmtDocListAcctgTransfSts = _SettlmtDocListAcctgTransfSts.SettlmtMgmtAcctgTransfSts  -- association [0..1]
LEFT OUTER JOIN R_SettlmtDocListPartner AS _SettlmtDocListPartner ON SettlmtDocList = _SettlmtDocListPartner.SettlmtDocList  -- association [0..*]
LEFT OUTER JOIN R_SettlmtDocListBankData AS _SettlmtDocListBankData ON SettlmtDocList = _SettlmtDocListBankData.SettlmtDocList  -- 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_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_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SettlmtDocListCurrency ON SettlmtDocListCurrency = _SettlmtDocListCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN R_SettlmtDocList AS _RvsdSettlmtDocList ON RvsdSettlmtDocList = _RvsdSettlmtDocList.SettlmtDocList  -- association [0..1]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea  -- association [0..*]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _SettlmtDocListActivityReason ON SettlmtDocListActivityReason = _SettlmtDocListActivityReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocIncmpltnsRsnCd AS _SettlmtDocListIncmpltnsRsn ON SettlmtDocListIncmpltnsRsn = _SettlmtDocListIncmpltnsRsn.SettlmtMgmtDocIncmpltnsRsn  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocCat AS _SettlmtDocListCat ON SettlmtDocListCat = _SettlmtDocListCat.SettlmtMgmtDocCat  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SettlmtDocListPaymentCurrency ON SettlmtDocListPaymentCurrency = _SettlmtDocListPaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Country AS _SettlmtCoCodeTaxCountry ON SettlmtCoCodeTaxCountry = _SettlmtCoCodeTaxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtOutpCat AS _SettlmtDocListOutpCat ON SettlmtDocListOutpCat = _SettlmtDocListOutpCat.SettlmtMgmtOutpCat  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON SettlmtDocList = _Extension.SettlmtMgmtDoc  -- association [1..1]
;