I_SettlmtDoc

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_SettlmtDoc.
-- 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_SettlmtDoc AS
SELECT
  SettlmtDoc,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  SettlmtProcessCat,
  LogisticsDataEntryCat,
  SettlmtCat,
  SupplierPricingProcedure,
  CustomerPricingProcedure,
  PostingDate,
  SettlmtMgmtAcctgTransfSts,
  InvoicingParty,
  PayeeParty,
  BillToParty,
  PayerParty,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SuplrSettlmtCompanyCode,
  CustSettlmtCompanyCode,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtDocCurrency,
  ExchangeRate,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  SupplierTotalGrossAmount,
  SupplierTotalNetAmount,
  CustomerTotalGrossAmount,
  CustomerTotalNetAmount,
  SupplierPaymentTerms,
  SupplierCashDiscount1Days,
  SupplierCashDiscount2Days,
  SupplierNetPaymentDays,
  SupplierCashDiscount1Percent,
  SupplierCashDiscount2Percent,
  SupplierPaymentMethod,
  CustomerPaymentTerms,
  CustomerCashDiscount1Days,
  CustomerCashDiscount2Days,
  CustomerNetPaymentDays,
  CustomerCashDiscount1Percent,
  CustomerCashDiscount2Percent,
  CustomerPaymentMethod,
  SuplrTotEligibleAmtForCshDisc,
  CustTotEligibleAmtForCshDisc,
  SettlmtDocIsCanceled,
  CanceledSettlmtDoc,
  SupplierPricingDocument,
  CustomerPricingDocument,
  SupplierAdditionalValueDays,
  SupplierFixedValueDate,
  CustomerAdditionalValueDays,
  CustomerFixedValueDate,
  SupplierTotalTaxAmount,
  CustomerTotalTaxAmount,
  TaxExchangeRate,
  IntercompanyTaxExchangeRate,
  SupplyingCountry,
  StateCentralBankPaymentReason,
  CreditControlArea,
  SettlmtDocActivityReason,
  PaymentReference,
  SupplierPaymentCurrency,
  SupplierPaytCurrencyExchRate,
  CustomerPaymentCurrency,
  CustomerPaytCurrencyExchRate,
  SettlmtApplSts,
  ExchangeRateType,
  SalesOffice,
  SalesGroup,
  OneTimeCustomerAddressID,
  OneTimeSupplierAddressID,
  SettlmtReltdCndnContr,
  SettlmtReltdTrdgContr,
  SettlmtReltdPurgDoc,
  SettlmtReltdBillgDoc,
  SettlmtDocSmmrznCat,
  CreditControlAreaCurrency,
  ReleasedCreditAmount,
  SettlmtClassificationCat,
  SettlmtPartnerCat,
  SupplierSettlmtStatus,
  CustomerSettlmtStatus,
  SupplierSettlmtDocCat,
  CustomerSettlmtDocCat,
  SupplierSettlmtBlkgReason,
  CustomerSettlmtBlkgReason,
  FiscalPeriod,
  TrdgExpnDocSettled,
  TrdgExpnCurrency,
  TrdgExpnAmount,
  TrdgExpnSupplier,
  TrdgExpnCustomer,
  CndnContrType,
  CndnContrProcVar,
  SettlmtDateCat,
  ActualSettlmtDate,
  SettlmtDateSequentialID,
  SettlmtDocIncmpltnsRsn,
  AlternativeInvoicingParty,
  CombinedSettlmtPostgSts,
  DocIntrastatRelevance,
  TaxDepartureCountry,
  TaxDestinationCountry,
  IsEUTriangularDeal,
  SupplierVATRegistration,
  CustomerVATRegistration,
  IntrastatDeclnGdsFlwCat,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  SettlmtDate,
  RefSettlmtDate,
  SettlmtBusProcVar,
  SettlmtDocCollSts,
  SettlmtDocIsCollvDoc,
  CollSettlmtBlkgReason,
  SuplrSettlmtCoCodeTaxCountry,
  CustSettlmtCoCodeTaxCountry,
  SettlmtBusProcCat,
  SEPAMandate,
  TotalSettlmtQuantity,
  TotalSettlmtQuantityUnit,
  TotalSettlmtNetWeight,
  TotalSettlmtGrossWeight,
  TotalSettlmtWeightUnit,
  TotalSettlmtVolume,
  TotalSettlmtVolumeUnit,
  TotalSettlmtPointsQty,
  TotalSettlmtPointsQtyUnit,
  PostingPartnerCat,
  SettlmtPeriodStartDate,
  SettlmtPeriodEndDate,
  CndnContrProcessCategory,
  SettlmtApplStsGrp,
  SettlmtDocAuthznCat,
  cast ( '0000' as wlf_entity_tag preserving type ) AS ETag,
  SettlmtDocChangeState
FROM R_SettlmtDoc
LEFT OUTER JOIN I_SettlmtDocItem AS _Item ON SettlmtDoc = _Item.SettlmtDoc  -- association [0..*]
LEFT OUTER JOIN I_SettlmtDocPartner AS _Partner ON SettlmtDoc = _Partner.SettlmtDoc  -- association [0..*]
LEFT OUTER JOIN I_SettlmtDocBankData AS _BankData ON SettlmtDoc = _BankData.SettlmtDoc  -- association [0..*]
LEFT OUTER JOIN I_SettlmtDoc AS _CanceledSettlmtDoc ON CanceledSettlmtDoc = _CanceledSettlmtDoc.SettlmtDoc  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocIncmpltnsRsnCd AS _SettlmtDocIncmpltnsRsn ON SettlmtDocIncmpltnsRsn = _SettlmtDocIncmpltnsRsn.SettlmtMgmtDocIncmpltnsRsn  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocCollSts AS _SettlmtDocCollSts ON SettlmtDocCollSts = _SettlmtDocCollSts.SettlmtMgmtDocCollSts  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocIsCollvDocCode AS _SettlmtDocIsCollvDoc ON SettlmtDocIsCollvDoc = _SettlmtDocIsCollvDoc.SettlmtMgmtDocIsCollvDoc  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CustSettlmtCompanyCode ON CustSettlmtCompanyCode = _CustSettlmtCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Country AS _SuplrSettlmtCoCodeTaxCountry ON SuplrSettlmtCoCodeTaxCountry = _SuplrSettlmtCoCodeTaxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CustSettlmtCoCodeTaxCountry ON CustSettlmtCoCodeTaxCountry = _CustSettlmtCoCodeTaxCountry.Country  -- association [0..1]
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_SettlmtDocSuplrPrcgElmnt AS _SupplierPricingElement ON SettlmtDoc = _SupplierPricingElement.SettlmtDoc  -- association [0..*]
LEFT OUTER JOIN I_SettlmtDocCustPrcgElmnt AS _CustomerPricingElement ON SettlmtDoc = _CustomerPricingElement.SettlmtDoc  -- association [0..*]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea  -- association [0..*]
LEFT OUTER JOIN I_SettlmtDocPlainLongText AS _SettlmtDocPlainLongText ON SettlmtDoc = _SettlmtDocPlainLongText.SettlmtDoc  -- association [0..*]
LEFT OUTER JOIN I_ConditionContract AS _SettlmtReltdCndnContr ON SettlmtReltdCndnContr = _SettlmtReltdCndnContr.ConditionContract  -- 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_CndnContrType AS _CndnContrType ON CndnContrType = _CndnContrType.CndnContrType  -- association [0..1]
LEFT OUTER JOIN I_SettlmtBusProcVar AS _SettlmtBusProcVar ON SettlmtBusProcVar = _SettlmtBusProcVar.SettlmtBusProcVar  -- 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_TrdgExpnDocSettledCode AS _TrdgExpnDocSettled ON TrdgExpnDocSettled = _TrdgExpnDocSettled.TrdgExpnDocSettled  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON SettlmtDoc = _Extension.SettlmtMgmtDoc  -- association [1..1]
;