I_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 I_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 I_SettlmtDocList AS
SELECT
  SettlmtDocList,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  SettlmtDocListCat,
  LogisticsDataEntryCat,
  SettlmtDocListAcctgTransfSts AS SettlmtMgmtAcctgTransfSts,
  PostingDate,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtApplSts,
  SettlmtApplStsGrp,
  PricingProcedure,
  InvoicingParty,
  PayeeParty,
  AlternativeInvoicingParty,
  BillToParty,
  PayerParty,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  SettlmtDocListCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  SettlmtDocListTotalGrossAmount,
  SettlmtDocListTotalNetAmount,
  SettlmtDocListTotalTaxAmount,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PaymentMethod,
  EligibleAmountForCashDiscount,
  SettlmtDocListIsReversed AS SettlmtDocListIsCanceled,
  RvsdSettlmtDocList AS CancldSettlmtDocList,
  AdditionalValueDays AS SettlmtDocListAddlValDays,
  FixedValueDate AS SettlmtDocListFxdValDte,
  SupplyingCountry,
  TaxDepartureCountry,
  TaxDestinationCountry,
  IsEUTriangularDeal,
  SettlmtCoCodeTaxCountry AS SettlmtDocListCoCodeTaxCountry,
  VATRegistration,
  StateCentralBankPaymentReason,
  CreditControlArea,
  SettlmtDocListActivityReason AS SettlmtDocActivityReason,
  PaymentReference,
  SettlmtDocListPaymentCurrency,
  SettlmtDocListPaytCrcyExchRate,
  OneTimeSettlmtPartAddrID,
  FiscalPeriod,
  SettlmtDate,
  SettlmtDocListIncmpltnsRsn,
  DocIntrastatRelevance,
  IntrastatDeclnGdsFlwCat,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  SettlmtBusProcVar,
  SettlmtBusProcCat,
  SEPAMandate,
  SettlmtDocListType
FROM R_SettlmtDocList
LEFT OUTER JOIN I_SettlmtDocListItem AS _ListItem ON SettlmtDocList = _ListItem.SettlmtDocList  -- association [0..*]
LEFT OUTER JOIN I_SettlmtDocListPlainLongText AS _SettlmtDocListPlainLongText ON SettlmtDocList = _SettlmtDocListPlainLongText.SettlmtDocList  -- association [0..*]
LEFT OUTER JOIN I_SettlmtMgmtAcctgTransfSts AS _SettlmtMgmtAcctgTransfSts ON SettlmtMgmtAcctgTransfSts = _SettlmtMgmtAcctgTransfSts.SettlmtMgmtAcctgTransfSts  -- association [0..1]
LEFT OUTER JOIN I_SettlmtDocType AS _SettlmtDocType ON SettlmtDocType = _SettlmtDocType.SettlmtDocType  -- association [0..1]
LEFT OUTER JOIN I_SettlmtProcessType AS _SettlmtProcessType ON SettlmtProcessType = _SettlmtProcessType.SettlmtProcessType  -- association [0..1]
LEFT OUTER JOIN I_SettlmtApplSts AS _SettlmtApplSts ON SettlmtApplSts = _SettlmtApplSts.SettlmtApplSts  -- association [0..1]
LEFT OUTER JOIN I_SettlmtApplStsGrp AS _SettlmtApplStsGrp ON SettlmtApplStsGrp = _SettlmtApplStsGrp.SettlmtApplStsGrp  -- association [0..1]
LEFT OUTER JOIN I_SettlmtApplStsGrpStsAssgmt AS _SettlmtApplStsGrpStsAssgmt ON SettlmtApplStsGrp = _SettlmtApplStsGrpStsAssgmt.SettlmtApplStsGrp AND SettlmtApplSts = _SettlmtApplStsGrpStsAssgmt.SettlmtApplSts  -- association [0..1]
LEFT OUTER JOIN I_SettlmtDocListPartner AS _Partner ON SettlmtDocList = _Partner.SettlmtDocList  -- association [0..*]
LEFT OUTER JOIN I_SettlmtDocListBankData AS _BankData ON SettlmtDocList = _BankData.SettlmtDocList  -- association [0..*]
LEFT OUTER JOIN I_SettlmtDocList AS _CancldSettlmtDocList ON CancldSettlmtDocList = _CancldSettlmtDocList.SettlmtDocList  -- association [0..1]
LEFT OUTER JOIN I_Country AS _SettlmtDocListCoCodeTxCntry ON SettlmtDocListCoCodeTaxCountry = _SettlmtDocListCoCodeTxCntry.Country  -- association [0..1]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _SettlmtDocActivityReason ON SettlmtDocActivityReason = _SettlmtDocActivityReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_Address AS _OneTimeSettlmtPartAddr ON OneTimeSettlmtPartAddrID = _OneTimeSettlmtPartAddr.AddressID  -- association [0..1]
LEFT OUTER JOIN I_SettlmtBusProcVar AS _SettlmtBusProcVar ON SettlmtBusProcVar = _SettlmtBusProcVar.SettlmtBusProcVar  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON SettlmtDocList = _Extension.SettlmtMgmtDoc  -- association [1..1]
;