R_SettlmtDocDEX

DDL: R_SETTLMTDOCDEX Type: view COMPOSITE
278 Fields 1 Data Sources 1 Associations

Settlement Document Basic Extraction

R_SettlmtDocDEX is a Composite CDS View that provides data about "Settlement Document Basic Extraction" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDoc) and exposes 278 fields with key fields SettlmtDoc, SettlmtDocItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDoc SettlmtDoc from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_SettlmtDocItem _SettlmtDocItem $projection.SettlmtDoc = _SettlmtDocItem.SettlmtDoc

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName RWLFSDOCDEX view
AbapCatalog.compiler.compareFilter true view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Settlement Document Basic Extraction view
Metadata.ignorePropagatedAnnotations true view

Fields (278)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc SettlmtDoc Settlement Doc.
KEY SettlmtDocItem _SettlmtDocItem SettlmtDocItem Item
SettlmtDocType R_SettlmtDoc SettlmtDocType Settlement Document Type
SettlmtDocCat R_SettlmtDoc SettlmtDocCat Settlement Document Category
SettlmtProcessType R_SettlmtDoc SettlmtProcessType Settlement Process Type
SettlmtProcessCat R_SettlmtDoc SettlmtProcessCat Settlement Process Category
LogisticsDataEntryCat R_SettlmtDoc LogisticsDataEntryCat Entry Category
SettlmtCat R_SettlmtDoc SettlmtCat Settl. Category
SupplierPricingProcedure R_SettlmtDoc SupplierPricingProcedure SuplrPrcgProc.
CustomerPricingProcedure R_SettlmtDoc CustomerPricingProcedure CustPrcgProc.
PostingDate R_SettlmtDoc PostingDate Posting Date for GR
SettlmtMgmtAcctgTransfSts R_SettlmtDoc SettlmtMgmtAcctgTransfSts Posting Status
InvoicingParty R_SettlmtDoc InvoicingParty Supplier
PayeeParty R_SettlmtDoc PayeeParty Payee
BillToParty R_SettlmtDoc BillToParty Inv. Recipient
PayerParty R_SettlmtDoc PayerParty Payer
PurchasingOrganization R_SettlmtDoc PurchasingOrganization Purchasing Organization
PurchasingGroup R_SettlmtDoc PurchasingGroup Purchasing Group
SalesOrganization R_SettlmtDoc SalesOrganization Sales Organization
DistributionChannel R_SettlmtDoc DistributionChannel RefDistCh-Cust/Mat.
Division R_SettlmtDoc Division Internal Division ID
SuplrSettlmtCompanyCode R_SettlmtDoc SuplrSettlmtCompanyCode Suppl. Company Code
CustSettlmtCompanyCode R_SettlmtDoc CustSettlmtCompanyCode Cust. Company Code
CreatedByUser R_SettlmtDoc CreatedByUser User Name
CreationDate R_SettlmtDoc CreationDate Time Stamp
CreationTime R_SettlmtDoc CreationTime Time of Change
LastChangeDate R_SettlmtDoc LastChangeDate Time Stamp
DocumentDate R_SettlmtDoc DocumentDate Journal Entry Date
DocumentReferenceID R_SettlmtDoc DocumentReferenceID Reference
AssignmentReference R_SettlmtDoc AssignmentReference Assignment Reference
SettlmtDocCurrency R_SettlmtDoc SettlmtDocCurrency Doc. Currency
ExchangeRate R_SettlmtDoc ExchangeRate Exchange rate
ExchangeRateIsFixed R_SettlmtDoc ExchangeRateIsFixed Fixed Exch.Rate
ExchangeRateDate R_SettlmtDoc ExchangeRateDate Translatn Date
SupplierTotalGrossAmount R_SettlmtDoc SupplierTotalGrossAmount Supplier Total Gross Amount
SupplierTotalNetAmount R_SettlmtDoc SupplierTotalNetAmount Supplier Total Net Amount
CustomerTotalGrossAmount R_SettlmtDoc CustomerTotalGrossAmount Customer Total Gross Amount
CustomerTotalNetAmount R_SettlmtDoc CustomerTotalNetAmount Extracted Net Value
SupplierPaymentTerms R_SettlmtDoc SupplierPaymentTerms Supplier Payment Terms
SupplierCashDiscount1Days R_SettlmtDoc SupplierCashDiscount1Days Supplier First Payment in Days
SupplierCashDiscount2Days R_SettlmtDoc SupplierCashDiscount2Days Supplier Second Payment in Days
SupplierNetPaymentDays R_SettlmtDoc SupplierNetPaymentDays Supplier Cash Discount Days
SupplierCashDiscount1Percent R_SettlmtDoc SupplierCashDiscount1Percent Supplier Discount for 1st Payment in %
SupplierCashDiscount2Percent R_SettlmtDoc SupplierCashDiscount2Percent Supplier Discount for 2nd Payment in %
SupplierPaymentMethod R_SettlmtDoc SupplierPaymentMethod Supplier Payment Method
CustomerPaymentTerms R_SettlmtDoc CustomerPaymentTerms Pyt Terms
CustomerCashDiscount1Days R_SettlmtDoc CustomerCashDiscount1Days Customer 1st Payment in Days
CustomerCashDiscount2Days R_SettlmtDoc CustomerCashDiscount2Days Customer 2nd Payment in Days
CustomerNetPaymentDays R_SettlmtDoc CustomerNetPaymentDays Customer Cash Discount Days
CustomerCashDiscount1Percent R_SettlmtDoc CustomerCashDiscount1Percent Customer Discount for 1st Payment in %
CustomerCashDiscount2Percent R_SettlmtDoc CustomerCashDiscount2Percent Customer Discount for 2nd Payment in %
CustomerPaymentMethod R_SettlmtDoc CustomerPaymentMethod Cust Pmt Method
SuplrTotEligibleAmtForCshDisc R_SettlmtDoc SuplrTotEligibleAmtForCshDisc Suplr Cash Disc Bas
CustTotEligibleAmtForCshDisc R_SettlmtDoc CustTotEligibleAmtForCshDisc Cust Cash Disc Bas
SettlmtDocIsCanceled R_SettlmtDoc SettlmtDocIsCanceled Doc. Reversed
CanceledSettlmtDoc R_SettlmtDoc CanceledSettlmtDoc Reversed Document
SupplierPricingDocument R_SettlmtDoc SupplierPricingDocument Supplier Document Condition
CustomerPricingDocument R_SettlmtDoc CustomerPricingDocument Customer Document Condition
SupplierAdditionalValueDays R_SettlmtDoc SupplierAdditionalValueDays Supplier Additional Value Days
SupplierFixedValueDate R_SettlmtDoc SupplierFixedValueDate Supplier Fixed Value Date
CustomerAdditionalValueDays R_SettlmtDoc CustomerAdditionalValueDays Customer Additional Value Days
CustomerFixedValueDate R_SettlmtDoc CustomerFixedValueDate Customer Fixed Value Date
SupplierTotalTaxAmount R_SettlmtDoc SupplierTotalTaxAmount Supplier Total Tax Amount
CustomerTotalTaxAmount R_SettlmtDoc CustomerTotalTaxAmount Customer Total Tax Amount
SupplyingCountry R_SettlmtDoc SupplyingCountry Supplying Ctry/Reg.
StateCentralBankPaymentReason R_SettlmtDoc StateCentralBankPaymentReason SCB Ind.
CreditControlArea R_SettlmtDoc CreditControlArea Credit Control Area
SettlmtDocActivityReason R_SettlmtDoc SettlmtDocActivityReason Header Document Creation Activity Reason
PaymentReference R_SettlmtDoc PaymentReference Payment Reference
SupplierPaymentCurrency R_SettlmtDoc SupplierPaymentCurrency Payt Currency
SupplierPaytCurrencyExchRate R_SettlmtDoc SupplierPaytCurrencyExchRate Supp. Payt Currency Exch. Rate
CustomerPaymentCurrency R_SettlmtDoc CustomerPaymentCurrency Payt Currency
CustomerPaytCurrencyExchRate R_SettlmtDoc CustomerPaytCurrencyExchRate Cust. Payt Currency Exch. Rate
SettlmtApplSts R_SettlmtDoc SettlmtApplSts Appl. Status
ExchangeRateType R_SettlmtDoc ExchangeRateType Exch. Rate Type
SalesOffice R_SettlmtDoc SalesOffice Sales Office
SalesGroup R_SettlmtDoc SalesGroup Sales Group
OneTimeCustomerAddressID R_SettlmtDoc OneTimeCustomerAddressID
OneTimeSupplierAddressID R_SettlmtDoc OneTimeSupplierAddressID
SettlmtReltdRefDocCat R_SettlmtDoc SettlmtReltdRefDocCat Contract Cat.
SettlmtReltdRefDoc R_SettlmtDoc SettlmtReltdRefDoc Contract
SettlmtDocSmmrznCat R_SettlmtDoc SettlmtDocSmmrznCat Summarization
CreditControlAreaCurrency R_SettlmtDoc CreditControlAreaCurrency Credit Control Area Currency
ReleasedCreditAmount R_SettlmtDoc ReleasedCreditAmount Credit Value
SettlmtClassificationCat R_SettlmtDoc SettlmtClassificationCat Classification Cat.
SettlmtPartnerCat R_SettlmtDoc SettlmtPartnerCat Settlmt Part Cat
SupplierSettlmtStatus R_SettlmtDoc SupplierSettlmtStatus Settl. Status Supp.
CustomerSettlmtStatus R_SettlmtDoc CustomerSettlmtStatus Settl. Status Cust.
SupplierSettlmtDocCat R_SettlmtDoc SupplierSettlmtDocCat Doc. Type - Suppl.
CustomerSettlmtDocCat R_SettlmtDoc CustomerSettlmtDocCat Settlmt Doc Type
SupplierSettlmtBlkgReason R_SettlmtDoc SupplierSettlmtBlkgReason Supplier Settlement Blocking Reason
CustomerSettlmtBlkgReason R_SettlmtDoc CustomerSettlmtBlkgReason Customer Settlement Blocking Reason
FiscalPeriod R_SettlmtDoc FiscalPeriod Tax period
TrdgExpnDocSettled R_SettlmtDoc TrdgExpnDocSettled
TrdgExpnCurrency R_SettlmtDoc TrdgExpnCurrency
TrdgExpnAmount R_SettlmtDoc TrdgExpnAmount
TrdgExpnSupplier R_SettlmtDoc TrdgExpnSupplier
TrdgExpnCustomer R_SettlmtDoc TrdgExpnCustomer
CndnContrType R_SettlmtDoc CndnContrType Contract Type
SettlmtDateCat R_SettlmtDoc SettlmtDateCat Settlement Date Type
ActualSettlmtDate R_SettlmtDoc ActualSettlmtDate Actual Settl. Date
SettlmtDateSequentialID R_SettlmtDoc SettlmtDateSequentialID Settlement Date ID
SettlmtDocIncmpltnsRsn R_SettlmtDoc SettlmtDocIncmpltnsRsn Incomplete Rsn
AlternativeInvoicingParty R_SettlmtDoc AlternativeInvoicingParty Alternative Supplier
CombinedSettlmtPostgSts R_SettlmtDoc CombinedSettlmtPostgSts Posting Status 2
TaxDepartureCountry R_SettlmtDoc TaxDepartureCountry Tx Dep Ctry/Reg
TaxDestinationCountry R_SettlmtDoc TaxDestinationCountry Tx Des Ctry/Reg
IsEUTriangularDeal R_SettlmtDoc IsEUTriangularDeal Is EU Triangular Deal
SupplierVATRegistration R_SettlmtDoc SupplierVATRegistration VAT Registration No.
CustomerVATRegistration R_SettlmtDoc CustomerVATRegistration VAT Registration No.
IntrastatDeclnGdsFlwCat R_SettlmtDoc IntrastatDeclnGdsFlwCat Goods Flow
IncotermsVersion R_SettlmtDoc IncotermsVersion Inco. Version
IncotermsClassification R_SettlmtDoc IncotermsClassification Incoterms
IncotermsTransferLocation R_SettlmtDoc IncotermsTransferLocation Incoterms 2
IncotermsLocation1 R_SettlmtDoc IncotermsLocation1 Inco. Location1
IncotermsLocation2 R_SettlmtDoc IncotermsLocation2 Inco. Location2
SettlmtDate R_SettlmtDoc SettlmtDate Settlement Date
SettlmtBusProcVar R_SettlmtDoc SettlmtBusProcVar Proc. Category
SettlmtDocCollSts R_SettlmtDoc SettlmtDocCollSts Collective Settlement Status
SettlmtDocIsCollvDoc R_SettlmtDoc SettlmtDocIsCollvDoc Document is Collective Document
CollSettlmtBlkgReason R_SettlmtDoc CollSettlmtBlkgReason Collective Settlement Blocking Reason
SuplrSettlmtCoCodeTaxCountry R_SettlmtDoc SuplrSettlmtCoCodeTaxCountry Tax Ctry/Reg. CoCode
CustSettlmtCoCodeTaxCountry R_SettlmtDoc CustSettlmtCoCodeTaxCountry Tax Country/Region Company Code Customer
SettlmtBusProcCat R_SettlmtDoc SettlmtBusProcCat Use Case Type
SEPAMandate R_SettlmtDoc SEPAMandate SEPA Mandate
TotalSettlmtQuantity R_SettlmtDoc TotalSettlmtQuantity Total Quantity
TotalSettlmtQuantityUnit R_SettlmtDoc TotalSettlmtQuantityUnit UoM Total Quantity
TotalSettlmtNetWeight R_SettlmtDoc TotalSettlmtNetWeight Total Net Weight
TotalSettlmtGrossWeight R_SettlmtDoc TotalSettlmtGrossWeight Total Gross Weight
TotalSettlmtWeightUnit R_SettlmtDoc TotalSettlmtWeightUnit UoW Total Weight
TotalSettlmtVolume R_SettlmtDoc TotalSettlmtVolume Total Volume
TotalSettlmtVolumeUnit R_SettlmtDoc TotalSettlmtVolumeUnit Unit Total Volume
TotalSettlmtPointsQty R_SettlmtDoc TotalSettlmtPointsQty
TotalSettlmtPointsQtyUnit R_SettlmtDoc TotalSettlmtPointsQtyUnit
PostingPartnerCat R_SettlmtDoc PostingPartnerCat Posting Partner
SettlmtPeriodStartDate R_SettlmtDoc SettlmtPeriodStartDate Start Date of Period
SettlmtPeriodEndDate R_SettlmtDoc SettlmtPeriodEndDate End Date of Period
CndnContrProcessCategory R_SettlmtDoc CndnContrProcessCategory Process Category
SettlmtApplStsGrp R_SettlmtDoc SettlmtApplStsGrp Status Group
SettlmtDocAuthznCat R_SettlmtDoc SettlmtDocAuthznCat Authorization Cat.
Product _SettlmtDocItem Product Product Sold
ProductGroup _SettlmtDocItem ProductGroup Product Sold Group
Plant _SettlmtDocItem Plant Valuation Area
SupplierTaxCode _SettlmtDocItem SupplierTaxCode Supplier Tax Code
CustomerTaxCode _SettlmtDocItem CustomerTaxCode Customer Tax Code
PricingDate _SettlmtDocItem PricingDate Pricing Date
SettlmtQuantity _SettlmtDocItem SettlmtQuantity SettlmtQuantity
SettlmtQuantityUnit _SettlmtDocItem SettlmtQuantityUnit Settlement Unit
NetPriceAmount _SettlmtDocItem NetPriceAmount Net Price
NetPriceQuantity _SettlmtDocItem NetPriceQuantity Price Unit
NetPriceQuantityUnit _SettlmtDocItem NetPriceQuantityUnit SettlmtPrcUnit
SettlmtToBaseQuantityNmrtr _SettlmtDocItem SettlmtToBaseQuantityNmrtr Numerator Settlement UoM to Base UoM
SettlmtToBaseQuantityDnmntr _SettlmtDocItem SettlmtToBaseQuantityDnmntr Denominator Settlement UoM to Base UoM
SettlmtToNetPriceQtyNmrtr _SettlmtDocItem SettlmtToNetPriceQtyNmrtr Numerator: Sett. UoM to Sett. Price UoM
SettlmtToNetPriceQtyDnmntr _SettlmtDocItem SettlmtToNetPriceQtyDnmntr Denominator: Sett. UoM to Sett. PriceUoM
BaseUnit _SettlmtDocItem BaseUnit Unit of Measure
ItemNetWeight _SettlmtDocItem ItemNetWeight Net Weight
ItemGrossWeight _SettlmtDocItem ItemGrossWeight Gross Weight
ItemWeightUnit _SettlmtDocItem ItemWeightUnit Unit of Weight
ItemVolume _SettlmtDocItem ItemVolume Volume
ItemVolumeUnit _SettlmtDocItem ItemVolumeUnit Volume Unit
SupplierItemGrossAmount _SettlmtDocItem SupplierItemGrossAmount Supplier Item Gross Amount
SupplierItemNetAmount _SettlmtDocItem SupplierItemNetAmount Supplier Item Net Amount
SupplierSubtotal1Amount _SettlmtDocItem SupplierSubtotal1Amount
SupplierSubtotal2Amount _SettlmtDocItem SupplierSubtotal2Amount
SupplierSubtotal3Amount _SettlmtDocItem SupplierSubtotal3Amount
SupplierSubtotal4Amount _SettlmtDocItem SupplierSubtotal4Amount
SupplierSubtotal5Amount _SettlmtDocItem SupplierSubtotal5Amount
SupplierSubtotal6Amount _SettlmtDocItem SupplierSubtotal6Amount
SupplierRebateBasisAmount _SettlmtDocItem SupplierRebateBasisAmount Suplr Rebate Basis
SupplierEffectiveItemAmount _SettlmtDocItem SupplierEffectiveItemAmount Supplier Effective Item Amount
SuplrItmEligibleAmtForCshDisc _SettlmtDocItem SuplrItmEligibleAmtForCshDisc Csh.Disc.Bas
SupplierItemTaxAmount _SettlmtDocItem SupplierItemTaxAmount Suplr Item Tax Amnt
CustomerItemGrossAmount _SettlmtDocItem CustomerItemGrossAmount Customer Item Gross Amount
CustomerItemNetAmount _SettlmtDocItem CustomerItemNetAmount Customer Item Net Amount
CustomerSubtotal1Amount _SettlmtDocItem CustomerSubtotal1Amount
CustomerSubtotal2Amount _SettlmtDocItem CustomerSubtotal2Amount
CustomerSubtotal3Amount _SettlmtDocItem CustomerSubtotal3Amount
CustomerSubtotal4Amount _SettlmtDocItem CustomerSubtotal4Amount
CustomerSubtotal5Amount _SettlmtDocItem CustomerSubtotal5Amount
CustomerSubtotal6Amount _SettlmtDocItem CustomerSubtotal6Amount
CustomerRebateBasisAmount _SettlmtDocItem CustomerRebateBasisAmount Cust Rebate Basis
CustomerEffectiveItemAmount _SettlmtDocItem CustomerEffectiveItemAmount Customer Effective Item Amount
CustItmEligibleAmtForCshDisc _SettlmtDocItem CustItmEligibleAmtForCshDisc Cash Disc. Base
CustomerItemTaxAmount _SettlmtDocItem CustomerItemTaxAmount Customer Item Tax Amount
SettlmtItmStatisticalPrpty _SettlmtDocItem SettlmtItmStatisticalPrpty Statistical Prpty
CashDiscountIsDeductible _SettlmtDocItem CashDiscountIsDeductible Cash Discount
SettlmtRefDocReltdFiscalYear _SettlmtDocItem SettlmtRefDocReltdFiscalYear
SettlmtSourceDoc _SettlmtDocItem SettlmtSourceDoc Source Doc.
SettlmtSourceDocItem _SettlmtDocItem SettlmtSourceDocItem Item of the Source Document
SettlmtSourceDocCat _SettlmtDocItem SettlmtSourceDocCat SourceDocCat
SettlmtItemActivityReason _SettlmtDocItem SettlmtItemActivityReason Activity Reason
SettlmtDocItemText _SettlmtDocItem SettlmtDocItemText Short Text
SupplierProductID _SettlmtDocItem SupplierProductID Supp. Mat. No.
TaxJurisdiction _SettlmtDocItem TaxJurisdiction Tax Jurisdiction
ProductPurchasePointsQtyUnit _SettlmtDocItem ProductPurchasePointsQtyUnit Points Unit
ProductPurchasePointsQty _SettlmtDocItem ProductPurchasePointsQty Points
PriorSupplier _SettlmtDocItem PriorSupplier Prior Supplier
NonDeductibleInputTaxAmount _SettlmtDocItem NonDeductibleInputTaxAmount Non-deductible
InventoryValuationType _SettlmtDocItem InventoryValuationType Valuation Type
SuplrSettlmtBusinessArea _SettlmtDocItem SuplrSettlmtBusinessArea Business Area
CustSettlmtBusinessArea _SettlmtDocItem CustSettlmtBusinessArea Cust. Business Area
SuplrSettlmtControllingArea _SettlmtDocItem SuplrSettlmtControllingArea Controlling Area
SuplrSettlmtCostCenter _SettlmtDocItem SuplrSettlmtCostCenter Cost Center
SuplrSettlmtProfitCenter _SettlmtDocItem SuplrSettlmtProfitCenter Profit Center
CustSettlmtControllingArea _SettlmtDocItem CustSettlmtControllingArea Customer Ctrl Area
CustSettlmtCostCenter _SettlmtDocItem CustSettlmtCostCenter Cust Cost Ctr
CustSettlmtProfitCenter _SettlmtDocItem CustSettlmtProfitCenter Cust. Profit Center
Batch _SettlmtDocItem Batch Lot No.
SupplierPrcDetnIsIncmplt _SettlmtDocItem SupplierPrcDetnIsIncmplt Supplier Pricing Elements Incomplete
CustomerPrcDetnIsIncmplt _SettlmtDocItem CustomerPrcDetnIsIncmplt Customer Pricing Elements Incomplete
SettlmtPrecdgDoc _SettlmtDocItem SettlmtPrecdgDoc Pre. Document
SettlmtPrecdgDocItem _SettlmtDocItem SettlmtPrecdgDocItem Item of Preceding Document
SettlmtPrecdgDocCat _SettlmtDocItem SettlmtPrecdgDocCat PreDocCat
SettlmtDocItemCat _SettlmtDocItem SettlmtDocItemCat Item Category
SettlmtItemReltdRefDocCat
SettlmtItemReltdRefDoc
SettlmtItemReltdRefDocItem
SettlmtDocItemStatus _SettlmtDocItem SettlmtDocItemStatus Status
SettlmtDocItemCancld _SettlmtDocItem SettlmtDocItemCancld Item Canceled
SupplierSettlementOrder _SettlmtDocItem SupplierSettlementOrder Order
SupplierItemSettlmtStatus _SettlmtDocItem SupplierItemSettlmtStatus Sttlmnt Sts Itm Sup.
CustomerItemSettlmtStatus _SettlmtDocItem CustomerItemSettlmtStatus Settlmt StatusItemCu
SupplierItemSettlmtBlkgReason _SettlmtDocItem SupplierItemSettlmtBlkgReason Supplier Settlement Item Blocking Reason
CustomerItemSettlmtBlkgReason _SettlmtDocItem CustomerItemSettlmtBlkgReason Customer Settlement Item Blocking Reason
ItemSettlmtRelevance _SettlmtDocItem ItemSettlmtRelevance Itm Sttlm Relevance
ServicesRenderedDate _SettlmtDocItem ServicesRenderedDate Services Rendered Date
GLAccount _SettlmtDocItem GLAccount General Ledger
SettlementFiscalYear _SettlmtDocItem SettlementFiscalYear Fiscal Year of Settlement
HigherLevelItem _SettlmtDocItem HigherLevelItem Higher-Lev.Item
LowerLevelItemExists _SettlmtDocItem LowerLevelItemExists Subitems
ItemDistributionStatus _SettlmtDocItem ItemDistributionStatus Distributn Status
SettlmtRefDoc _SettlmtDocItem SettlmtRefDoc Settlmt. Ref. Doc.
SettlmtRefDocFiscalYear _SettlmtDocItem SettlmtRefDocFiscalYear Year of Reference Document
SettlmtRefDocLogicalSyst _SettlmtDocItem SettlmtRefDocLogicalSyst SM Ref Log Sys
SettlmtRefDocCompanyCode _SettlmtDocItem SettlmtRefDocCompanyCode Ref. Company Code
SettlmtRefDocItem _SettlmtDocItem SettlmtRefDocItem SettlmtRefDocItem
SettlmtRefDocCat _SettlmtDocItem SettlmtRefDocCat SettlmtRefDocCat
ItemIntrastatRelevance _SettlmtDocItem ItemIntrastatRelevance Item Intrastat Relevance
CustomerSettlementOrder _SettlmtDocItem CustomerSettlementOrder Customer Order
SuplrSettlmtWBSElmntInternalID _SettlmtDocItem SuplrSettlmtWBSElmntInternalID WBS Element
CustSettlmtWBSElmntInternalID _SettlmtDocItem CustSettlmtWBSElmntInternalID Customer WBS Element
SettlmtDocItemCollSts _SettlmtDocItem SettlmtDocItemCollSts Collective Settlement Status Item
CollSettlmtItemBlkgReason _SettlmtDocItem CollSettlmtItemBlkgReason Collective Settlement Item Block Reason
ItmSettlmtDocCollRelevance _SettlmtDocItem ItmSettlmtDocCollRelevance Collective Settlement Relevance
SettlmtAddlRefDoc _SettlmtDocItem SettlmtAddlRefDoc SettlmtAddlRefDoc
SettlmtAddlRefDocFiscalYear _SettlmtDocItem SettlmtAddlRefDocFiscalYear Year of Additional Reference Document
SettlmtAddlRefDocLogicalSyst _SettlmtDocItem SettlmtAddlRefDocLogicalSyst SM Addl Ref Log Sys
SettlmtAddlRefDocItem _SettlmtDocItem SettlmtAddlRefDocItem SettlmtAddlRefDocItm
SettlmtAddlRefDocCat _SettlmtDocItem SettlmtAddlRefDocCat SettlmtAddlRefDocCat
CustomerSettlmtRecipient _SettlmtDocItem CustomerSettlmtRecipient Cust Settlmt Recpnt
SupplierSubrange _SettlmtDocItem SupplierSubrange Suppl. Subrange
ProductHierarchy _SettlmtDocItem ProductHierarchy Prod.hierarchy
SalesSpcfcProductGroup1 _SettlmtDocItem SalesSpcfcProductGroup1 Sales-Specific Product Group 1
SalesSpcfcProductGroup2 _SettlmtDocItem SalesSpcfcProductGroup2 Sales-Specific Product Group 2
SalesSpcfcProductGroup3 _SettlmtDocItem SalesSpcfcProductGroup3 Sales-Specific Product Group 3
SalesSpcfcProductGroup4 _SettlmtDocItem SalesSpcfcProductGroup4 Sales-Specific Product Group 4
SalesSpcfcProductGroup5 _SettlmtDocItem SalesSpcfcProductGroup5 Sales-Specific Product Group 5
BusVolDocSalesOrganization _SettlmtDocItem BusVolDocSalesOrganization Sales Org in Business Volume Document
BusVolDocDistributionChannel _SettlmtDocItem BusVolDocDistributionChannel Distr Chnl in Business Volume Document
BusVolDocDivision _SettlmtDocItem BusVolDocDivision Division in Business Volume Document
ProductCommissionGroup _SettlmtDocItem ProductCommissionGroup Commission Grp
PriceSpecificationProductGroup _SettlmtDocItem PriceSpecificationProductGroup Prd.Price Grp
SalesVolumeRebateGroup _SettlmtDocItem SalesVolumeRebateGroup Volume Rebate Group
_BillToParty R_SettlmtDoc _BillToParty
_BillToPartyCompany R_SettlmtDoc _BillToPartyCompany
_PayerParty R_SettlmtDoc _PayerParty
_PayerPartyCompany R_SettlmtDoc _PayerPartyCompany
_InvoicingParty R_SettlmtDoc _InvoicingParty
_InvoicingPartyCompany R_SettlmtDoc _InvoicingPartyCompany
_PayeeParty R_SettlmtDoc _PayeeParty
_PayeePartyCompany R_SettlmtDoc _PayeePartyCompany
_AlternativeInvoicingParty R_SettlmtDoc _AlternativeInvoicingParty
_AltvInvoicingPartyCompany R_SettlmtDoc _AltvInvoicingPartyCompany
_TotalSettlmtQuantityUnit _TotalSettlmtQuantityUnit
_TotalSettlmtWeightUnit _TotalSettlmtWeightUnit
_TotalSettlmtVolumeUnit _TotalSettlmtVolumeUnit
_TotalSettlmtPointsQtyUnit _TotalSettlmtPointsQtyUnit

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_SettlmtDocDEX.
-- 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_SettlmtDocDEX AS
SELECT
  SettlmtDoc,
  _SettlmtDocItem.SettlmtDocItem AS SettlmtDocItem,
  SettlmtDoc.SettlmtDocType AS SettlmtDocType,
  SettlmtDoc.SettlmtDocCat AS SettlmtDocCat,
  SettlmtDoc.SettlmtProcessType AS SettlmtProcessType,
  SettlmtDoc.SettlmtProcessCat AS SettlmtProcessCat,
  SettlmtDoc.LogisticsDataEntryCat AS LogisticsDataEntryCat,
  SettlmtDoc.SettlmtCat AS SettlmtCat,
  SettlmtDoc.SupplierPricingProcedure AS SupplierPricingProcedure,
  SettlmtDoc.CustomerPricingProcedure AS CustomerPricingProcedure,
  SettlmtDoc.PostingDate AS PostingDate,
  SettlmtDoc.SettlmtMgmtAcctgTransfSts AS SettlmtMgmtAcctgTransfSts,
  SettlmtDoc.InvoicingParty AS InvoicingParty,
  SettlmtDoc.PayeeParty AS PayeeParty,
  SettlmtDoc.BillToParty AS BillToParty,
  SettlmtDoc.PayerParty AS PayerParty,
  SettlmtDoc.PurchasingOrganization AS PurchasingOrganization,
  SettlmtDoc.PurchasingGroup AS PurchasingGroup,
  SettlmtDoc.SalesOrganization AS SalesOrganization,
  SettlmtDoc.DistributionChannel AS DistributionChannel,
  SettlmtDoc.Division AS Division,
  SettlmtDoc.SuplrSettlmtCompanyCode AS SuplrSettlmtCompanyCode,
  SettlmtDoc.CustSettlmtCompanyCode AS CustSettlmtCompanyCode,
  SettlmtDoc.CreatedByUser AS CreatedByUser,
  SettlmtDoc.CreationDate AS CreationDate,
  SettlmtDoc.CreationTime AS CreationTime,
  SettlmtDoc.LastChangeDate AS LastChangeDate,
  SettlmtDoc.DocumentDate AS DocumentDate,
  SettlmtDoc.DocumentReferenceID AS DocumentReferenceID,
  SettlmtDoc.AssignmentReference AS AssignmentReference,
  SettlmtDoc.SettlmtDocCurrency AS SettlmtDocCurrency,
  SettlmtDoc.ExchangeRate AS ExchangeRate,
  SettlmtDoc.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  SettlmtDoc.ExchangeRateDate AS ExchangeRateDate,
  SettlmtDoc.SupplierTotalGrossAmount AS SupplierTotalGrossAmount,
  SettlmtDoc.SupplierTotalNetAmount AS SupplierTotalNetAmount,
  SettlmtDoc.CustomerTotalGrossAmount AS CustomerTotalGrossAmount,
  SettlmtDoc.CustomerTotalNetAmount AS CustomerTotalNetAmount,
  SettlmtDoc.SupplierPaymentTerms AS SupplierPaymentTerms,
  SettlmtDoc.SupplierCashDiscount1Days AS SupplierCashDiscount1Days,
  SettlmtDoc.SupplierCashDiscount2Days AS SupplierCashDiscount2Days,
  SettlmtDoc.SupplierNetPaymentDays AS SupplierNetPaymentDays,
  SettlmtDoc.SupplierCashDiscount1Percent AS SupplierCashDiscount1Percent,
  SettlmtDoc.SupplierCashDiscount2Percent AS SupplierCashDiscount2Percent,
  SettlmtDoc.SupplierPaymentMethod AS SupplierPaymentMethod,
  SettlmtDoc.CustomerPaymentTerms AS CustomerPaymentTerms,
  SettlmtDoc.CustomerCashDiscount1Days AS CustomerCashDiscount1Days,
  SettlmtDoc.CustomerCashDiscount2Days AS CustomerCashDiscount2Days,
  SettlmtDoc.CustomerNetPaymentDays AS CustomerNetPaymentDays,
  SettlmtDoc.CustomerCashDiscount1Percent AS CustomerCashDiscount1Percent,
  SettlmtDoc.CustomerCashDiscount2Percent AS CustomerCashDiscount2Percent,
  SettlmtDoc.CustomerPaymentMethod AS CustomerPaymentMethod,
  SettlmtDoc.SuplrTotEligibleAmtForCshDisc AS SuplrTotEligibleAmtForCshDisc,
  SettlmtDoc.CustTotEligibleAmtForCshDisc AS CustTotEligibleAmtForCshDisc,
  SettlmtDoc.SettlmtDocIsCanceled AS SettlmtDocIsCanceled,
  SettlmtDoc.CanceledSettlmtDoc AS CanceledSettlmtDoc,
  SettlmtDoc.SupplierPricingDocument AS SupplierPricingDocument,
  SettlmtDoc.CustomerPricingDocument AS CustomerPricingDocument,
  SettlmtDoc.SupplierAdditionalValueDays AS SupplierAdditionalValueDays,
  SettlmtDoc.SupplierFixedValueDate AS SupplierFixedValueDate,
  SettlmtDoc.CustomerAdditionalValueDays AS CustomerAdditionalValueDays,
  SettlmtDoc.CustomerFixedValueDate AS CustomerFixedValueDate,
  SettlmtDoc.SupplierTotalTaxAmount AS SupplierTotalTaxAmount,
  SettlmtDoc.CustomerTotalTaxAmount AS CustomerTotalTaxAmount,
  SettlmtDoc.SupplyingCountry AS SupplyingCountry,
  SettlmtDoc.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  SettlmtDoc.CreditControlArea AS CreditControlArea,
  SettlmtDoc.SettlmtDocActivityReason AS SettlmtDocActivityReason,
  SettlmtDoc.PaymentReference AS PaymentReference,
  SettlmtDoc.SupplierPaymentCurrency AS SupplierPaymentCurrency,
  SettlmtDoc.SupplierPaytCurrencyExchRate AS SupplierPaytCurrencyExchRate,
  SettlmtDoc.CustomerPaymentCurrency AS CustomerPaymentCurrency,
  SettlmtDoc.CustomerPaytCurrencyExchRate AS CustomerPaytCurrencyExchRate,
  SettlmtDoc.SettlmtApplSts AS SettlmtApplSts,
  SettlmtDoc.ExchangeRateType AS ExchangeRateType,
  SettlmtDoc.SalesOffice AS SalesOffice,
  SettlmtDoc.SalesGroup AS SalesGroup,
  SettlmtDoc.OneTimeCustomerAddressID AS OneTimeCustomerAddressID,
  SettlmtDoc.OneTimeSupplierAddressID AS OneTimeSupplierAddressID,
  SettlmtDoc.SettlmtReltdRefDocCat AS SettlmtReltdRefDocCat,
  SettlmtDoc.SettlmtReltdRefDoc AS SettlmtReltdRefDoc,
  SettlmtDoc.SettlmtDocSmmrznCat AS SettlmtDocSmmrznCat,
  SettlmtDoc.CreditControlAreaCurrency AS CreditControlAreaCurrency,
  SettlmtDoc.ReleasedCreditAmount AS ReleasedCreditAmount,
  SettlmtDoc.SettlmtClassificationCat AS SettlmtClassificationCat,
  SettlmtDoc.SettlmtPartnerCat AS SettlmtPartnerCat,
  SettlmtDoc.SupplierSettlmtStatus AS SupplierSettlmtStatus,
  SettlmtDoc.CustomerSettlmtStatus AS CustomerSettlmtStatus,
  SettlmtDoc.SupplierSettlmtDocCat AS SupplierSettlmtDocCat,
  SettlmtDoc.CustomerSettlmtDocCat AS CustomerSettlmtDocCat,
  SettlmtDoc.SupplierSettlmtBlkgReason AS SupplierSettlmtBlkgReason,
  SettlmtDoc.CustomerSettlmtBlkgReason AS CustomerSettlmtBlkgReason,
  SettlmtDoc.FiscalPeriod AS FiscalPeriod,
  SettlmtDoc.TrdgExpnDocSettled AS TrdgExpnDocSettled,
  SettlmtDoc.TrdgExpnCurrency AS TrdgExpnCurrency,
  SettlmtDoc.TrdgExpnAmount AS TrdgExpnAmount,
  SettlmtDoc.TrdgExpnSupplier AS TrdgExpnSupplier,
  SettlmtDoc.TrdgExpnCustomer AS TrdgExpnCustomer,
  SettlmtDoc.CndnContrType AS CndnContrType,
  SettlmtDoc.SettlmtDateCat AS SettlmtDateCat,
  SettlmtDoc.ActualSettlmtDate AS ActualSettlmtDate,
  SettlmtDoc.SettlmtDateSequentialID AS SettlmtDateSequentialID,
  SettlmtDoc.SettlmtDocIncmpltnsRsn AS SettlmtDocIncmpltnsRsn,
  SettlmtDoc.AlternativeInvoicingParty AS AlternativeInvoicingParty,
  SettlmtDoc.CombinedSettlmtPostgSts AS CombinedSettlmtPostgSts,
  SettlmtDoc.TaxDepartureCountry AS TaxDepartureCountry,
  SettlmtDoc.TaxDestinationCountry AS TaxDestinationCountry,
  SettlmtDoc.IsEUTriangularDeal AS IsEUTriangularDeal,
  SettlmtDoc.SupplierVATRegistration AS SupplierVATRegistration,
  SettlmtDoc.CustomerVATRegistration AS CustomerVATRegistration,
  SettlmtDoc.IntrastatDeclnGdsFlwCat AS IntrastatDeclnGdsFlwCat,
  SettlmtDoc.IncotermsVersion AS IncotermsVersion,
  SettlmtDoc.IncotermsClassification AS IncotermsClassification,
  SettlmtDoc.IncotermsTransferLocation AS IncotermsTransferLocation,
  SettlmtDoc.IncotermsLocation1 AS IncotermsLocation1,
  SettlmtDoc.IncotermsLocation2 AS IncotermsLocation2,
  SettlmtDoc.SettlmtDate AS SettlmtDate,
  SettlmtDoc.SettlmtBusProcVar AS SettlmtBusProcVar,
  SettlmtDoc.SettlmtDocCollSts AS SettlmtDocCollSts,
  SettlmtDoc.SettlmtDocIsCollvDoc AS SettlmtDocIsCollvDoc,
  SettlmtDoc.CollSettlmtBlkgReason AS CollSettlmtBlkgReason,
  SettlmtDoc.SuplrSettlmtCoCodeTaxCountry AS SuplrSettlmtCoCodeTaxCountry,
  SettlmtDoc.CustSettlmtCoCodeTaxCountry AS CustSettlmtCoCodeTaxCountry,
  SettlmtDoc.SettlmtBusProcCat AS SettlmtBusProcCat,
  SettlmtDoc.SEPAMandate AS SEPAMandate,
  SettlmtDoc.TotalSettlmtQuantity AS TotalSettlmtQuantity,
  SettlmtDoc.TotalSettlmtQuantityUnit AS TotalSettlmtQuantityUnit,
  SettlmtDoc.TotalSettlmtNetWeight AS TotalSettlmtNetWeight,
  SettlmtDoc.TotalSettlmtGrossWeight AS TotalSettlmtGrossWeight,
  SettlmtDoc.TotalSettlmtWeightUnit AS TotalSettlmtWeightUnit,
  SettlmtDoc.TotalSettlmtVolume AS TotalSettlmtVolume,
  SettlmtDoc.TotalSettlmtVolumeUnit AS TotalSettlmtVolumeUnit,
  SettlmtDoc.TotalSettlmtPointsQty AS TotalSettlmtPointsQty,
  SettlmtDoc.TotalSettlmtPointsQtyUnit AS TotalSettlmtPointsQtyUnit,
  SettlmtDoc.PostingPartnerCat AS PostingPartnerCat,
  SettlmtDoc.SettlmtPeriodStartDate AS SettlmtPeriodStartDate,
  SettlmtDoc.SettlmtPeriodEndDate AS SettlmtPeriodEndDate,
  SettlmtDoc.CndnContrProcessCategory AS CndnContrProcessCategory,
  SettlmtDoc.SettlmtApplStsGrp AS SettlmtApplStsGrp,
  SettlmtDoc.SettlmtDocAuthznCat AS SettlmtDocAuthznCat,
  _SettlmtDocItem.Product AS Product,
  _SettlmtDocItem.ProductGroup AS ProductGroup,
  _SettlmtDocItem.Plant AS Plant,
  _SettlmtDocItem.SupplierTaxCode AS SupplierTaxCode,
  _SettlmtDocItem.CustomerTaxCode AS CustomerTaxCode,
  _SettlmtDocItem.PricingDate AS PricingDate,
  _SettlmtDocItem.SettlmtQuantity AS SettlmtQuantity,
  _SettlmtDocItem.SettlmtQuantityUnit AS SettlmtQuantityUnit,
  _SettlmtDocItem.NetPriceAmount AS NetPriceAmount,
  _SettlmtDocItem.NetPriceQuantity AS NetPriceQuantity,
  _SettlmtDocItem.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  _SettlmtDocItem.SettlmtToBaseQuantityNmrtr AS SettlmtToBaseQuantityNmrtr,
  _SettlmtDocItem.SettlmtToBaseQuantityDnmntr AS SettlmtToBaseQuantityDnmntr,
  _SettlmtDocItem.SettlmtToNetPriceQtyNmrtr AS SettlmtToNetPriceQtyNmrtr,
  _SettlmtDocItem.SettlmtToNetPriceQtyDnmntr AS SettlmtToNetPriceQtyDnmntr,
  _SettlmtDocItem.BaseUnit AS BaseUnit,
  _SettlmtDocItem.ItemNetWeight AS ItemNetWeight,
  _SettlmtDocItem.ItemGrossWeight AS ItemGrossWeight,
  _SettlmtDocItem.ItemWeightUnit AS ItemWeightUnit,
  _SettlmtDocItem.ItemVolume AS ItemVolume,
  _SettlmtDocItem.ItemVolumeUnit AS ItemVolumeUnit,
  _SettlmtDocItem.SupplierItemGrossAmount AS SupplierItemGrossAmount,
  _SettlmtDocItem.SupplierItemNetAmount AS SupplierItemNetAmount,
  _SettlmtDocItem.SupplierSubtotal1Amount AS SupplierSubtotal1Amount,
  _SettlmtDocItem.SupplierSubtotal2Amount AS SupplierSubtotal2Amount,
  _SettlmtDocItem.SupplierSubtotal3Amount AS SupplierSubtotal3Amount,
  _SettlmtDocItem.SupplierSubtotal4Amount AS SupplierSubtotal4Amount,
  _SettlmtDocItem.SupplierSubtotal5Amount AS SupplierSubtotal5Amount,
  _SettlmtDocItem.SupplierSubtotal6Amount AS SupplierSubtotal6Amount,
  _SettlmtDocItem.SupplierRebateBasisAmount AS SupplierRebateBasisAmount,
  _SettlmtDocItem.SupplierEffectiveItemAmount AS SupplierEffectiveItemAmount,
  _SettlmtDocItem.SuplrItmEligibleAmtForCshDisc AS SuplrItmEligibleAmtForCshDisc,
  _SettlmtDocItem.SupplierItemTaxAmount AS SupplierItemTaxAmount,
  _SettlmtDocItem.CustomerItemGrossAmount AS CustomerItemGrossAmount,
  _SettlmtDocItem.CustomerItemNetAmount AS CustomerItemNetAmount,
  _SettlmtDocItem.CustomerSubtotal1Amount AS CustomerSubtotal1Amount,
  _SettlmtDocItem.CustomerSubtotal2Amount AS CustomerSubtotal2Amount,
  _SettlmtDocItem.CustomerSubtotal3Amount AS CustomerSubtotal3Amount,
  _SettlmtDocItem.CustomerSubtotal4Amount AS CustomerSubtotal4Amount,
  _SettlmtDocItem.CustomerSubtotal5Amount AS CustomerSubtotal5Amount,
  _SettlmtDocItem.CustomerSubtotal6Amount AS CustomerSubtotal6Amount,
  _SettlmtDocItem.CustomerRebateBasisAmount AS CustomerRebateBasisAmount,
  _SettlmtDocItem.CustomerEffectiveItemAmount AS CustomerEffectiveItemAmount,
  _SettlmtDocItem.CustItmEligibleAmtForCshDisc AS CustItmEligibleAmtForCshDisc,
  _SettlmtDocItem.CustomerItemTaxAmount AS CustomerItemTaxAmount,
  _SettlmtDocItem.SettlmtItmStatisticalPrpty AS SettlmtItmStatisticalPrpty,
  _SettlmtDocItem.CashDiscountIsDeductible AS CashDiscountIsDeductible,
  _SettlmtDocItem.SettlmtRefDocReltdFiscalYear AS SettlmtRefDocReltdFiscalYear,
  _SettlmtDocItem.SettlmtSourceDoc AS SettlmtSourceDoc,
  _SettlmtDocItem.SettlmtSourceDocItem AS SettlmtSourceDocItem,
  _SettlmtDocItem.SettlmtSourceDocCat AS SettlmtSourceDocCat,
  _SettlmtDocItem.SettlmtItemActivityReason AS SettlmtItemActivityReason,
  _SettlmtDocItem.SettlmtDocItemText AS SettlmtDocItemText,
  _SettlmtDocItem.SupplierProductID AS SupplierProductID,
  _SettlmtDocItem.TaxJurisdiction AS TaxJurisdiction,
  _SettlmtDocItem.ProductPurchasePointsQtyUnit AS ProductPurchasePointsQtyUnit,
  _SettlmtDocItem.ProductPurchasePointsQty AS ProductPurchasePointsQty,
  _SettlmtDocItem.PriorSupplier AS PriorSupplier,
  _SettlmtDocItem.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  _SettlmtDocItem.InventoryValuationType AS InventoryValuationType,
  _SettlmtDocItem.SuplrSettlmtBusinessArea AS SuplrSettlmtBusinessArea,
  _SettlmtDocItem.CustSettlmtBusinessArea AS CustSettlmtBusinessArea,
  _SettlmtDocItem.SuplrSettlmtControllingArea AS SuplrSettlmtControllingArea,
  _SettlmtDocItem.SuplrSettlmtCostCenter AS SuplrSettlmtCostCenter,
  _SettlmtDocItem.SuplrSettlmtProfitCenter AS SuplrSettlmtProfitCenter,
  _SettlmtDocItem.CustSettlmtControllingArea AS CustSettlmtControllingArea,
  _SettlmtDocItem.CustSettlmtCostCenter AS CustSettlmtCostCenter,
  _SettlmtDocItem.CustSettlmtProfitCenter AS CustSettlmtProfitCenter,
  _SettlmtDocItem.Batch AS Batch,
  _SettlmtDocItem.SupplierPrcDetnIsIncmplt AS SupplierPrcDetnIsIncmplt,
  _SettlmtDocItem.CustomerPrcDetnIsIncmplt AS CustomerPrcDetnIsIncmplt,
  _SettlmtDocItem.SettlmtPrecdgDoc AS SettlmtPrecdgDoc,
  _SettlmtDocItem.SettlmtPrecdgDocItem AS SettlmtPrecdgDocItem,
  _SettlmtDocItem.SettlmtPrecdgDocCat AS SettlmtPrecdgDocCat,
  _SettlmtDocItem.SettlmtDocItemCat AS SettlmtDocItemCat,
  cast( _SettlmtDocItem.SettlmtItemReltdRefDocCat as wlf_settlmt_itm_rel_refdoc_cat preserving type ) AS SettlmtItemReltdRefDocCat,
  cast( _SettlmtDocItem.SettlmtItemReltdRefDoc as wlf_settlmt_itm_rel_refdoc preserving type ) AS SettlmtItemReltdRefDoc,
  cast( _SettlmtDocItem.SettlmtItemReltdRefDocItem as wlf_settlmt_itm_rel_refdoc_itm preserving type ) AS SettlmtItemReltdRefDocItem,
  _SettlmtDocItem.SettlmtDocItemStatus AS SettlmtDocItemStatus,
  _SettlmtDocItem.SettlmtDocItemCancld AS SettlmtDocItemCancld,
  _SettlmtDocItem.SupplierSettlementOrder AS SupplierSettlementOrder,
  _SettlmtDocItem.SupplierItemSettlmtStatus AS SupplierItemSettlmtStatus,
  _SettlmtDocItem.CustomerItemSettlmtStatus AS CustomerItemSettlmtStatus,
  _SettlmtDocItem.SupplierItemSettlmtBlkgReason AS SupplierItemSettlmtBlkgReason,
  _SettlmtDocItem.CustomerItemSettlmtBlkgReason AS CustomerItemSettlmtBlkgReason,
  _SettlmtDocItem.ItemSettlmtRelevance AS ItemSettlmtRelevance,
  _SettlmtDocItem.ServicesRenderedDate AS ServicesRenderedDate,
  _SettlmtDocItem.GLAccount AS GLAccount,
  _SettlmtDocItem.SettlementFiscalYear AS SettlementFiscalYear,
  _SettlmtDocItem.HigherLevelItem AS HigherLevelItem,
  _SettlmtDocItem.LowerLevelItemExists AS LowerLevelItemExists,
  _SettlmtDocItem.ItemDistributionStatus AS ItemDistributionStatus,
  _SettlmtDocItem.SettlmtRefDoc AS SettlmtRefDoc,
  _SettlmtDocItem.SettlmtRefDocFiscalYear AS SettlmtRefDocFiscalYear,
  _SettlmtDocItem.SettlmtRefDocLogicalSyst AS SettlmtRefDocLogicalSyst,
  _SettlmtDocItem.SettlmtRefDocCompanyCode AS SettlmtRefDocCompanyCode,
  _SettlmtDocItem.SettlmtRefDocItem AS SettlmtRefDocItem,
  _SettlmtDocItem.SettlmtRefDocCat AS SettlmtRefDocCat,
  _SettlmtDocItem.ItemIntrastatRelevance AS ItemIntrastatRelevance,
  _SettlmtDocItem.CustomerSettlementOrder AS CustomerSettlementOrder,
  _SettlmtDocItem.SuplrSettlmtWBSElmntInternalID AS SuplrSettlmtWBSElmntInternalID,
  _SettlmtDocItem.CustSettlmtWBSElmntInternalID AS CustSettlmtWBSElmntInternalID,
  _SettlmtDocItem.SettlmtDocItemCollSts AS SettlmtDocItemCollSts,
  _SettlmtDocItem.CollSettlmtItemBlkgReason AS CollSettlmtItemBlkgReason,
  _SettlmtDocItem.ItmSettlmtDocCollRelevance AS ItmSettlmtDocCollRelevance,
  _SettlmtDocItem.SettlmtAddlRefDoc AS SettlmtAddlRefDoc,
  _SettlmtDocItem.SettlmtAddlRefDocFiscalYear AS SettlmtAddlRefDocFiscalYear,
  _SettlmtDocItem.SettlmtAddlRefDocLogicalSyst AS SettlmtAddlRefDocLogicalSyst,
  _SettlmtDocItem.SettlmtAddlRefDocItem AS SettlmtAddlRefDocItem,
  _SettlmtDocItem.SettlmtAddlRefDocCat AS SettlmtAddlRefDocCat,
  _SettlmtDocItem.CustomerSettlmtRecipient AS CustomerSettlmtRecipient,
  _SettlmtDocItem.SupplierSubrange AS SupplierSubrange,
  _SettlmtDocItem.ProductHierarchy AS ProductHierarchy,
  _SettlmtDocItem.SalesSpcfcProductGroup1 AS SalesSpcfcProductGroup1,
  _SettlmtDocItem.SalesSpcfcProductGroup2 AS SalesSpcfcProductGroup2,
  _SettlmtDocItem.SalesSpcfcProductGroup3 AS SalesSpcfcProductGroup3,
  _SettlmtDocItem.SalesSpcfcProductGroup4 AS SalesSpcfcProductGroup4,
  _SettlmtDocItem.SalesSpcfcProductGroup5 AS SalesSpcfcProductGroup5,
  _SettlmtDocItem.BusVolDocSalesOrganization AS BusVolDocSalesOrganization,
  _SettlmtDocItem.BusVolDocDistributionChannel AS BusVolDocDistributionChannel,
  _SettlmtDocItem.BusVolDocDivision AS BusVolDocDivision,
  _SettlmtDocItem.ProductCommissionGroup AS ProductCommissionGroup,
  _SettlmtDocItem.PriceSpecificationProductGroup AS PriceSpecificationProductGroup,
  _SettlmtDocItem.SalesVolumeRebateGroup AS SalesVolumeRebateGroup,
  SettlmtDoc._BillToParty AS _BillToParty,
  SettlmtDoc._BillToPartyCompany AS _BillToPartyCompany,
  SettlmtDoc._PayerParty AS _PayerParty,
  SettlmtDoc._PayerPartyCompany AS _PayerPartyCompany,
  SettlmtDoc._InvoicingParty AS _InvoicingParty,
  SettlmtDoc._InvoicingPartyCompany AS _InvoicingPartyCompany,
  SettlmtDoc._PayeeParty AS _PayeeParty,
  SettlmtDoc._PayeePartyCompany AS _PayeePartyCompany,
  SettlmtDoc._AlternativeInvoicingParty AS _AlternativeInvoicingParty,
  SettlmtDoc._AltvInvoicingPartyCompany AS _AltvInvoicingPartyCompany
FROM R_SettlmtDoc AS SettlmtDoc
LEFT OUTER JOIN R_SettlmtDocItem AS _SettlmtDocItem ON SettlmtDoc = _SettlmtDocItem.SettlmtDoc  -- association [0..*]
;

Learn More