I_SuplrSettlmt

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_SuplrSettlmt.
-- 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_SuplrSettlmt AS
SELECT
  SuplrSettlmt,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  LogisticsDataEntryCat,
  SettlmtCat,
  PostingDate,
  SuplrSettlmtAcctgTransfSts AS SettlmtMgmtAcctgTransfSts,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  StateCentralBankPaymentReason,
  SettlmtApplSts,
  SettlmtApplStsGrp,
  PricingProcedure AS SupplierPricingProcedure,
  PricingDocument AS SupplierPricingDocument,
  InvoicingParty,
  PayeeParty,
  AlternativeInvoicingParty,
  CompanyCode AS SuplrSettlmtCompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  SuplrSettlmtCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  SuplrSettlmtTotalGrossAmount AS SupplierTotalGrossAmount,
  SuplrSettlmtTotalNetAmount AS SupplierTotalNetAmount,
  SuplrSettlmtTotalTaxAmount AS SupplierTotalTaxAmount,
  PaymentTerms AS SupplierPaymentTerms,
  CashDiscount1Days AS SupplierCashDiscount1Days,
  CashDiscount2Days AS SupplierCashDiscount2Days,
  NetPaymentDays AS SupplierNetPaymentDays,
  CashDiscount1Percent AS SupplierCashDiscount1Percent,
  CashDiscount2Percent AS SupplierCashDiscount2Percent,
  PaymentMethod AS SupplierPaymentMethod,
  SuplrTotEligibleAmtForCshDisc,
  SuplrSettlmtIsReversed AS SuplrSettlmtIsCanceled,
  ReversedSupplierSettlement AS CancldSuplrSettlmt,
  AdditionalValueDays AS SupplierAdditionalValueDays,
  FixedValueDate AS SupplierFixedValueDate,
  SupplyingCountry,
  TaxDepartureCountry,
  TaxDestinationCountry,
  IsEUTriangularDeal,
  SettlmtCoCodeTaxCountry AS SuplrSettlmtCoCodeTaxCountry,
  VATRegistration AS SupplierVATRegistration,
  CreditControlArea,
  CreditControlAreaCurrency,
  ReleasedCreditAmount,
  SuplrSettlmtActivityReason AS SettlmtDocActivityReason,
  PaymentReference,
  SuplrSettlmtPaymentCurrency AS SupplierPaymentCurrency,
  SuplrSettlmtPaytCrcyExchRate AS SupplierPaytCurrencyExchRate,
  OneTimeSupplierAddressID,
  CndnContrType,
  SettlmtReltdCndnContr,
  FiscalPeriod,
  SettlmtDateCat,
  ActualSettlmtDate,
  SettlmtDateSequentialID,
  SettlmtDate,
  SuplrSettlmtIncmpltnsRsn,
  DocIntrastatRelevance,
  IntrastatDeclnGdsFlwCat,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  SettlmtBusProcVar,
  SettlmtBusProcCat,
  SEPAMandate,
  TotalSettlmtQuantity,
  TotalSettlmtQuantityUnit,
  TotalSettlmtNetWeight,
  TotalSettlmtGrossWeight,
  TotalSettlmtWeightUnit,
  TotalSettlmtVolume,
  TotalSettlmtVolumeUnit,
  TotalSettlmtPointsQty,
  TotalSettlmtPointsQtyUnit,
  SettlmtPeriodStartDate,
  SettlmtPeriodEndDate,
  CndnContrProcessCategory
FROM R_SuplrSettlmt
LEFT OUTER JOIN I_SuplrSettlmtItem AS _Item ON SuplrSettlmt = _Item.SuplrSettlmt  -- association [0..*]
LEFT OUTER JOIN I_SuplrSettlmtPlainLongText AS _SuplrSettlmtPlainLongText ON SuplrSettlmt = _SuplrSettlmtPlainLongText.SuplrSettlmt  -- association [0..*]
LEFT OUTER JOIN I_SuplrSettlmtPartner AS _Partner ON SuplrSettlmt = _Partner.SuplrSettlmt  -- association [0..*]
LEFT OUTER JOIN I_SuplrSettlmtBankData AS _BankData ON SuplrSettlmt = _BankData.SuplrSettlmt  -- association [0..*]
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_SettlmtMgmtAcctgTransfSts AS _SettlmtMgmtAcctgTransfSts ON SettlmtMgmtAcctgTransfSts = _SettlmtMgmtAcctgTransfSts.SettlmtMgmtAcctgTransfSts  -- 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_SuplrSettlmtPrcgElmnt AS _SupplierPricingElement ON SuplrSettlmt = _SupplierPricingElement.SuplrSettlmt  -- association [0..*]
LEFT OUTER JOIN I_SupplierCompany AS _InvoicingPartyCompany ON InvoicingParty = _InvoicingPartyCompany.Supplier AND SuplrSettlmtCompanyCode = _InvoicingPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _PayeePartyCompany ON PayeeParty = _PayeePartyCompany.Supplier AND SuplrSettlmtCompanyCode = _PayeePartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _AltvInvoicingPartyCompany ON AlternativeInvoicingParty = _AltvInvoicingPartyCompany.Supplier AND SuplrSettlmtCompanyCode = _AltvInvoicingPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _SuplrSettlmtCompanyCode ON SuplrSettlmtCompanyCode = _SuplrSettlmtCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _SupplierPaymentTerms ON SupplierPaymentTerms = _SupplierPaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_SuplrSettlmt AS _CancldSuplrSettlmt ON CancldSuplrSettlmt = _CancldSuplrSettlmt.SuplrSettlmt  -- association [0..1]
LEFT OUTER JOIN I_Country AS _SuplrSettlmtCoCodeTaxCountry ON SuplrSettlmtCoCodeTaxCountry = _SuplrSettlmtCoCodeTaxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _SettlmtDocActivityReason ON SettlmtDocActivityReason = _SettlmtDocActivityReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SupplierPaymentCurrency ON SupplierPaymentCurrency = _SupplierPaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Address AS _OneTimeSupplierAddress ON OneTimeSupplierAddressID = _OneTimeSupplierAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN I_CndnContrType AS _CndnContrType ON CndnContrType = _CndnContrType.CndnContrType  -- association [0..1]
LEFT OUTER JOIN I_ConditionContract AS _SettlmtReltdCndnContr ON SettlmtReltdCndnContr = _SettlmtReltdCndnContr.ConditionContract  -- 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 SuplrSettlmt = _Extension.SettlmtMgmtDoc  -- association [1..1]
;