I_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 I_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 I_CustSettlmt AS
SELECT
  CustSettlmt,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  LogisticsDataEntryCat,
  SettlmtCat,
  PostingDate,
  CustSettlmtAcctgTransfSts AS SettlmtMgmtAcctgTransfSts,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtApplSts,
  SettlmtApplStsGrp,
  PricingProcedure AS CustomerPricingProcedure,
  PricingDocument AS CustomerPricingDocument,
  BillToParty,
  PayerParty,
  CompanyCode AS CustSettlmtCompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  CustSettlmtCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  CustSettlmtTotalGrossAmount AS CustomerTotalGrossAmount,
  CustSettlmtTotalNetAmount AS CustomerTotalNetAmount,
  CustSettlmtTotalTaxAmount AS CustomerTotalTaxAmount,
  PaymentTerms AS CustomerPaymentTerms,
  CashDiscount1Days AS CustomerCashDiscount1Days,
  CashDiscount2Days AS CustomerCashDiscount2Days,
  NetPaymentDays AS CustomerNetPaymentDays,
  CashDiscount1Percent AS CustomerCashDiscount1Percent,
  CashDiscount2Percent AS CustomerCashDiscount2Percent,
  PaymentMethod AS CustomerPaymentMethod,
  CustTotEligibleAmtForCshDisc,
  CustSettlmtIsReversed AS CustSettlmtIsCanceled,
  ReversedCustomerSettlement AS CancldCustSettlmt,
  AdditionalValueDays AS CustomerAdditionalValueDays,
  FixedValueDate AS CustomerFixedValueDate,
  TaxDepartureCountry,
  TaxDestinationCountry,
  IsEUTriangularDeal,
  SettlmtCoCodeTaxCountry AS CustSettlmtCoCodeTaxCountry,
  VATRegistration AS CustomerVATRegistration,
  CreditControlArea,
  CreditControlAreaCurrency,
  ReleasedCreditAmount,
  CustSettlmtActivityReason AS SettlmtDocActivityReason,
  PaymentReference,
  CustSettlmtPaymentCurrency AS CustomerPaymentCurrency,
  CustSettlmtPaytCrcyExchRate AS CustomerPaytCurrencyExchRate,
  OneTimeCustomerAddressID,
  CndnContrType,
  SettlmtReltdCndnContr,
  FiscalPeriod,
  SettlmtDateCat,
  ActualSettlmtDate,
  SettlmtDateSequentialID,
  SettlmtDate,
  CustSettlmtIncmpltnsRsn,
  DocIntrastatRelevance,
  IntrastatDeclnGdsFlwCat,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  SettlmtBusProcVar,
  SettlmtBusProcCat,
  SEPAMandate,
  TotalSettlmtQuantity,
  TotalSettlmtQuantityUnit,
  TotalSettlmtNetWeight,
  TotalSettlmtGrossWeight,
  TotalSettlmtWeightUnit,
  TotalSettlmtVolume,
  TotalSettlmtVolumeUnit,
  TotalSettlmtPointsQty,
  TotalSettlmtPointsQtyUnit,
  SettlmtPeriodStartDate,
  SettlmtPeriodEndDate,
  CndnContrProcessCategory
FROM R_CustSettlmt
LEFT OUTER JOIN I_CustSettlmtItem AS _Item ON CustSettlmt = _Item.CustSettlmt  -- association [0..*]
LEFT OUTER JOIN I_CustSettlmtPlainLongText AS _CustSettlmtPlainLongText ON CustSettlmt = _CustSettlmtPlainLongText.CustSettlmt  -- association [0..*]
LEFT OUTER JOIN I_CustSettlmtPartner AS _Partner ON CustSettlmt = _Partner.CustSettlmt  -- association [0..*]
LEFT OUTER JOIN I_CustSettlmtBankData AS _BankData ON CustSettlmt = _BankData.CustSettlmt  -- 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_CustSettlmtPrcgElmnt AS _CustomerPricingElement ON CustSettlmt = _CustomerPricingElement.CustSettlmt  -- association [0..*]
LEFT OUTER JOIN I_CustomerCompany AS _BillToPartyCompany ON BillToParty = _BillToPartyCompany.Customer AND CustSettlmtCompanyCode = _BillToPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _PayerPartyCompany ON PayerParty = _PayerPartyCompany.Customer AND CustSettlmtCompanyCode = _PayerPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CustSettlmtCompanyCode ON CustSettlmtCompanyCode = _CustSettlmtCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _CustomerPaymentTerms ON CustomerPaymentTerms = _CustomerPaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_CustSettlmt AS _CancldCustSettlmt ON CancldCustSettlmt = _CancldCustSettlmt.CustSettlmt  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CustSettlmtCoCodeTaxCountry ON CustSettlmtCoCodeTaxCountry = _CustSettlmtCoCodeTaxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _SettlmtDocActivityReason ON SettlmtDocActivityReason = _SettlmtDocActivityReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CustomerPaymentCurrency ON CustomerPaymentCurrency = _CustomerPaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Address AS _OneTimeCustomerAddress ON OneTimeCustomerAddressID = _OneTimeCustomerAddress.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 CustSettlmt = _Extension.SettlmtMgmtDoc  -- association [1..1]
;