R_SettlmtDocListDEX
Settlement Doc List Basic Extraction
R_SettlmtDocListDEX is a Composite CDS View that provides data about "Settlement Doc List Basic Extraction" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDocListItem) and exposes 109 fields with key fields SettlmtDocList, SettlmtDocListItem.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_SettlmtDocListItem | SettlmtDocListItem | from |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | RWLFSMTDOCLSTDEX | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| EndUserText.label | Settlement Doc List Basic Extraction | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| ObjectModel.compositionRoot | true | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.dataClass | #MIXED | 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 | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Metadata.allowExtensions | false | view |
Fields (109)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SettlmtDocList | R_SettlmtDocListItem | SettlmtDocList | |
| KEY | SettlmtDocListItem | R_SettlmtDocListItem | SettlmtDocListItem | |
| SettlmtDocType | SettlmtDocList | SettlmtDocType | Settlement Document Type | |
| SettlmtDocCat | SettlmtDocList | SettlmtDocCat | Settlement Document Category | |
| SettlmtProcessType | SettlmtDocList | SettlmtProcessType | Settlement Process Type | |
| SettlmtDocListCat | SettlmtDocList | SettlmtDocListCat | ||
| LogisticsDataEntryCat | SettlmtDocList | LogisticsDataEntryCat | Entry Category | |
| SettlmtDocListAcctgTransfSts | SettlmtDocList | SettlmtDocListAcctgTransfSts | ||
| PostingDate | SettlmtDocList | PostingDate | Posting Date for GR | |
| DocumentReferenceID | SettlmtDocList | DocumentReferenceID | Reference | |
| AssignmentReference | SettlmtDocList | AssignmentReference | Assignment Reference | |
| SettlmtApplSts | SettlmtDocList | SettlmtApplSts | Appl. Status | |
| SettlmtApplStsGrp | SettlmtDocList | SettlmtApplStsGrp | Status Group | |
| PricingProcedure | SettlmtDocList | PricingProcedure | Procedure | |
| InvoicingParty | SettlmtDocList | InvoicingParty | Supplier | |
| PayeeParty | SettlmtDocList | PayeeParty | Payee | |
| AlternativeInvoicingParty | SettlmtDocList | AlternativeInvoicingParty | Alternative Supplier | |
| BillToParty | SettlmtDocList | BillToParty | Inv. Recipient | |
| PayerParty | SettlmtDocList | PayerParty | Payer | |
| CompanyCode | SettlmtDocList | CompanyCode | Receiver Company Code | |
| PurchasingOrganization | SettlmtDocList | PurchasingOrganization | Purchasing Organization | |
| PurchasingGroup | SettlmtDocList | PurchasingGroup | Purchasing Group | |
| SalesOrganization | SettlmtDocList | SalesOrganization | Sales Organization | |
| DistributionChannel | SettlmtDocList | DistributionChannel | RefDistCh-Cust/Mat. | |
| Division | SettlmtDocList | Division | Internal Division ID | |
| CreatedByUser | SettlmtDocList | CreatedByUser | User Name | |
| CreationDate | SettlmtDocList | CreationDate | Time Stamp | |
| CreationTime | SettlmtDocList | CreationTime | Time of Change | |
| LastChangeDate | SettlmtDocList | LastChangeDate | Time Stamp | |
| SettlmtDocListCurrency | SettlmtDocList | SettlmtDocListCurrency | Doc. Currency | |
| ExchangeRate | SettlmtDocList | ExchangeRate | Exchange rate | |
| ExchangeRateType | SettlmtDocList | ExchangeRateType | Exch. Rate Type | |
| ExchangeRateIsFixed | SettlmtDocList | ExchangeRateIsFixed | Fixed Exch.Rate | |
| ExchangeRateDate | SettlmtDocList | ExchangeRateDate | Translatn Date | |
| SettlmtDocListTotalGrossAmount | SettlmtDocList | SettlmtDocListTotalGrossAmount | ||
| SettlmtDocListTotalNetAmount | SettlmtDocList | SettlmtDocListTotalNetAmount | ||
| SettlmtDocListTotalTaxAmount | SettlmtDocList | SettlmtDocListTotalTaxAmount | ||
| PaymentTerms | SettlmtDocList | PaymentTerms | Pyt Terms | |
| CashDiscount1Days | SettlmtDocList | CashDiscount1Days | Days from Baseline Date for Payment | |
| CashDiscount2Days | SettlmtDocList | CashDiscount2Days | Days from Baseline Date for Payment | |
| NetPaymentDays | SettlmtDocList | NetPaymentDays | Net Pmt Terms Period | |
| CashDiscount1Percent | SettlmtDocList | CashDiscount1Percent | Disc. Percent 1 | |
| CashDiscount2Percent | SettlmtDocList | CashDiscount2Percent | Disc. Percent 2 | |
| PaymentMethod | SettlmtDocList | PaymentMethod | Pymt Meth. | |
| EligibleAmountForCashDiscount | SettlmtDocList | EligibleAmountForCashDiscount | ||
| SettlmtDocListIsReversed | SettlmtDocList | SettlmtDocListIsReversed | ||
| RvsdSettlmtDocList | SettlmtDocList | RvsdSettlmtDocList | ||
| AdditionalValueDays | SettlmtDocList | AdditionalValueDays | Add. Value Days | |
| FixedValueDate | SettlmtDocList | FixedValueDate | Fixed Val. Date | |
| TaxDepartureCountry | SettlmtDocList | TaxDepartureCountry | Tx Dep Ctry/Reg | |
| TaxDestinationCountry | SettlmtDocList | TaxDestinationCountry | Tx Des Ctry/Reg | |
| IsEUTriangularDeal | SettlmtDocList | IsEUTriangularDeal | Is EU Triangular Deal | |
| SettlmtCoCodeTaxCountry | SettlmtDocList | SettlmtCoCodeTaxCountry | Tax Ctry/Reg. CoCode | |
| VATRegistration | SettlmtDocList | VATRegistration | VAT Registration No. | |
| SupplyingCountry | SettlmtDocList | SupplyingCountry | Supplying Ctry/Reg. | |
| StateCentralBankPaymentReason | SettlmtDocList | StateCentralBankPaymentReason | SCB Ind. | |
| CreditControlArea | SettlmtDocList | CreditControlArea | Credit Control Area | |
| SettlmtDocListActivityReason | SettlmtDocList | SettlmtDocListActivityReason | ||
| PaymentReference | SettlmtDocList | PaymentReference | Payment Reference | |
| SettlmtDocListPaymentCurrency | SettlmtDocList | SettlmtDocListPaymentCurrency | ||
| SettlmtDocListPaytCrcyExchRate | SettlmtDocList | SettlmtDocListPaytCrcyExchRate | ||
| OneTimeSettlmtPartAddrID | SettlmtDocList | OneTimeSettlmtPartAddrID | ||
| FiscalPeriod | SettlmtDocList | FiscalPeriod | Tax period | |
| SettlmtDate | SettlmtDocList | SettlmtDate | Settlement Date | |
| SettlmtDocListIncmpltnsRsn | SettlmtDocList | SettlmtDocListIncmpltnsRsn | ||
| DocIntrastatRelevance | SettlmtDocList | DocIntrastatRelevance | Intrastat Rel. | |
| IntrastatDeclnGdsFlwCat | SettlmtDocList | IntrastatDeclnGdsFlwCat | Goods Flow | |
| IncotermsVersion | SettlmtDocList | IncotermsVersion | Inco. Version | |
| IncotermsClassification | SettlmtDocList | IncotermsClassification | Incoterms | |
| IncotermsTransferLocation | SettlmtDocList | IncotermsTransferLocation | Incoterms 2 | |
| IncotermsLocation1 | SettlmtDocList | IncotermsLocation1 | Inco. Location1 | |
| IncotermsLocation2 | SettlmtDocList | IncotermsLocation2 | Inco. Location2 | |
| SettlmtBusProcVar | SettlmtDocList | SettlmtBusProcVar | Proc. Category | |
| SettlmtBusProcCat | SettlmtDocList | SettlmtBusProcCat | Use Case Type | |
| SEPAMandate | SettlmtDocList | SEPAMandate | SEPA Mandate | |
| SettlmtDocListType | SettlmtDocList | SettlmtDocListType | ||
| SettlmtDocListItemNetAmount | R_SettlmtDocListItem | SettlmtDocListItemNetAmount | ||
| SettlmtDocListItemTaxAmount | R_SettlmtDocListItem | SettlmtDocListItemTaxAmount | ||
| NonDeductibleInputTaxAmount | R_SettlmtDocListItem | NonDeductibleInputTaxAmount | Non-deductible | |
| SettlmtRemunerationNetAmt | R_SettlmtDocListItem | SettlmtRemunerationNetAmt | ||
| SettlmtRemunerationTaxAmt | R_SettlmtDocListItem | SettlmtRemunerationTaxAmt | ||
| SettlmtDocListItemCat | R_SettlmtDocListItem | SettlmtDocListItemCat | ||
| RefSuplrBillgDoc | R_SettlmtDocListItem | RefSuplrBillgDoc | ||
| RefSettlmtDoc | R_SettlmtDocListItem | RefSettlmtDoc | ||
| RefCustSettlmtList | R_SettlmtDocListItem | RefCustSettlmtList | ||
| RefSuplrSettlmtList | R_SettlmtDocListItem | RefSuplrSettlmtList | ||
| RefSettlmtDocList | R_SettlmtDocListItem | RefSettlmtDocList | ||
| RefCustSettlmt | R_SettlmtDocListItem | RefCustSettlmt | ||
| RefExpnSettlmt | R_SettlmtDocListItem | RefExpnSettlmt | ||
| RefSuplrSettlmt | R_SettlmtDocListItem | RefSuplrSettlmt | ||
| SettlmtExtBillgDoc | R_SettlmtDocListItem | SettlmtExtBillgDoc | ||
| SettlmtExtAcctgDocCompanyCode | R_SettlmtDocListItem | SettlmtExtAcctgDocCompanyCode | ||
| SettlmtExtAcctgDoc | R_SettlmtDocListItem | SettlmtExtAcctgDoc | ||
| SettlmtExtAcctgDocFiscalYear | R_SettlmtDocListItem | SettlmtExtAcctgDocFiscalYear | ||
| SettlmtExtAcctgDocItem | R_SettlmtDocListItem | SettlmtExtAcctgDocItem | ||
| SettlmtDocListItemIsReversed | R_SettlmtDocListItem | SettlmtDocListItemIsReversed | ||
| PrcDetnIsIncmplt | R_SettlmtDocListItem | PrcDetnIsIncmplt | Price Determination Is Incomplete | |
| _BillToParty | SettlmtDocList | _BillToParty | ||
| _BillToPartyCompany | SettlmtDocList | _BillToPartyCompany | ||
| _InvoicingParty | SettlmtDocList | _InvoicingParty | ||
| _InvoicingPartyCompany | SettlmtDocList | _InvoicingPartyCompany | ||
| _AlternativeInvoicingParty | SettlmtDocList | _AlternativeInvoicingParty | ||
| _AltvInvoicingPartyCompany | SettlmtDocList | _AltvInvoicingPartyCompany | ||
| _PayeeParty | SettlmtDocList | _PayeeParty | ||
| _PayeePartyCompany | SettlmtDocList | _PayeePartyCompany | ||
| _PayerParty | SettlmtDocList | _PayerParty | ||
| _PayerPartyCompany | SettlmtDocList | _PayerPartyCompany | ||
| _SettlmtDocListCurrency | SettlmtDocList | _SettlmtDocListCurrency | ||
| _SettlmtDocListPaymentCurrency | SettlmtDocList | _SettlmtDocListPaymentCurrency |
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_SettlmtDocListDEX.
-- 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_SettlmtDocListDEX AS
SELECT
SettlmtDocListItem.SettlmtDocList AS SettlmtDocList,
SettlmtDocListItem.SettlmtDocListItem AS SettlmtDocListItem,
SettlmtDocList.SettlmtDocType AS SettlmtDocType,
SettlmtDocList.SettlmtDocCat AS SettlmtDocCat,
SettlmtDocList.SettlmtProcessType AS SettlmtProcessType,
SettlmtDocList.SettlmtDocListCat AS SettlmtDocListCat,
SettlmtDocList.LogisticsDataEntryCat AS LogisticsDataEntryCat,
SettlmtDocList.SettlmtDocListAcctgTransfSts AS SettlmtDocListAcctgTransfSts,
SettlmtDocList.PostingDate AS PostingDate,
SettlmtDocList.DocumentReferenceID AS DocumentReferenceID,
SettlmtDocList.AssignmentReference AS AssignmentReference,
SettlmtDocList.SettlmtApplSts AS SettlmtApplSts,
SettlmtDocList.SettlmtApplStsGrp AS SettlmtApplStsGrp,
SettlmtDocList.PricingProcedure AS PricingProcedure,
SettlmtDocList.InvoicingParty AS InvoicingParty,
SettlmtDocList.PayeeParty AS PayeeParty,
SettlmtDocList.AlternativeInvoicingParty AS AlternativeInvoicingParty,
SettlmtDocList.BillToParty AS BillToParty,
SettlmtDocList.PayerParty AS PayerParty,
SettlmtDocList.CompanyCode AS CompanyCode,
SettlmtDocList.PurchasingOrganization AS PurchasingOrganization,
SettlmtDocList.PurchasingGroup AS PurchasingGroup,
SettlmtDocList.SalesOrganization AS SalesOrganization,
SettlmtDocList.DistributionChannel AS DistributionChannel,
SettlmtDocList.Division AS Division,
SettlmtDocList.CreatedByUser AS CreatedByUser,
SettlmtDocList.CreationDate AS CreationDate,
SettlmtDocList.CreationTime AS CreationTime,
SettlmtDocList.LastChangeDate AS LastChangeDate,
SettlmtDocList.SettlmtDocListCurrency AS SettlmtDocListCurrency,
SettlmtDocList.ExchangeRate AS ExchangeRate,
SettlmtDocList.ExchangeRateType AS ExchangeRateType,
SettlmtDocList.ExchangeRateIsFixed AS ExchangeRateIsFixed,
SettlmtDocList.ExchangeRateDate AS ExchangeRateDate,
SettlmtDocList.SettlmtDocListTotalGrossAmount AS SettlmtDocListTotalGrossAmount,
SettlmtDocList.SettlmtDocListTotalNetAmount AS SettlmtDocListTotalNetAmount,
SettlmtDocList.SettlmtDocListTotalTaxAmount AS SettlmtDocListTotalTaxAmount,
SettlmtDocList.PaymentTerms AS PaymentTerms,
SettlmtDocList.CashDiscount1Days AS CashDiscount1Days,
SettlmtDocList.CashDiscount2Days AS CashDiscount2Days,
SettlmtDocList.NetPaymentDays AS NetPaymentDays,
SettlmtDocList.CashDiscount1Percent AS CashDiscount1Percent,
SettlmtDocList.CashDiscount2Percent AS CashDiscount2Percent,
SettlmtDocList.PaymentMethod AS PaymentMethod,
SettlmtDocList.EligibleAmountForCashDiscount AS EligibleAmountForCashDiscount,
SettlmtDocList.SettlmtDocListIsReversed AS SettlmtDocListIsReversed,
SettlmtDocList.RvsdSettlmtDocList AS RvsdSettlmtDocList,
SettlmtDocList.AdditionalValueDays AS AdditionalValueDays,
SettlmtDocList.FixedValueDate AS FixedValueDate,
SettlmtDocList.TaxDepartureCountry AS TaxDepartureCountry,
SettlmtDocList.TaxDestinationCountry AS TaxDestinationCountry,
SettlmtDocList.IsEUTriangularDeal AS IsEUTriangularDeal,
SettlmtDocList.SettlmtCoCodeTaxCountry AS SettlmtCoCodeTaxCountry,
SettlmtDocList.VATRegistration AS VATRegistration,
SettlmtDocList.SupplyingCountry AS SupplyingCountry,
SettlmtDocList.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
SettlmtDocList.CreditControlArea AS CreditControlArea,
SettlmtDocList.SettlmtDocListActivityReason AS SettlmtDocListActivityReason,
SettlmtDocList.PaymentReference AS PaymentReference,
SettlmtDocList.SettlmtDocListPaymentCurrency AS SettlmtDocListPaymentCurrency,
SettlmtDocList.SettlmtDocListPaytCrcyExchRate AS SettlmtDocListPaytCrcyExchRate,
SettlmtDocList.OneTimeSettlmtPartAddrID AS OneTimeSettlmtPartAddrID,
SettlmtDocList.FiscalPeriod AS FiscalPeriod,
SettlmtDocList.SettlmtDate AS SettlmtDate,
SettlmtDocList.SettlmtDocListIncmpltnsRsn AS SettlmtDocListIncmpltnsRsn,
SettlmtDocList.DocIntrastatRelevance AS DocIntrastatRelevance,
SettlmtDocList.IntrastatDeclnGdsFlwCat AS IntrastatDeclnGdsFlwCat,
SettlmtDocList.IncotermsVersion AS IncotermsVersion,
SettlmtDocList.IncotermsClassification AS IncotermsClassification,
SettlmtDocList.IncotermsTransferLocation AS IncotermsTransferLocation,
SettlmtDocList.IncotermsLocation1 AS IncotermsLocation1,
SettlmtDocList.IncotermsLocation2 AS IncotermsLocation2,
SettlmtDocList.SettlmtBusProcVar AS SettlmtBusProcVar,
SettlmtDocList.SettlmtBusProcCat AS SettlmtBusProcCat,
SettlmtDocList.SEPAMandate AS SEPAMandate,
SettlmtDocList.SettlmtDocListType AS SettlmtDocListType,
SettlmtDocListItem.SettlmtDocListItemNetAmount AS SettlmtDocListItemNetAmount,
SettlmtDocListItem.SettlmtDocListItemTaxAmount AS SettlmtDocListItemTaxAmount,
SettlmtDocListItem.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
SettlmtDocListItem.SettlmtRemunerationNetAmt AS SettlmtRemunerationNetAmt,
SettlmtDocListItem.SettlmtRemunerationTaxAmt AS SettlmtRemunerationTaxAmt,
SettlmtDocListItem.SettlmtDocListItemCat AS SettlmtDocListItemCat,
SettlmtDocListItem.RefSuplrBillgDoc AS RefSuplrBillgDoc,
SettlmtDocListItem.RefSettlmtDoc AS RefSettlmtDoc,
SettlmtDocListItem.RefCustSettlmtList AS RefCustSettlmtList,
SettlmtDocListItem.RefSuplrSettlmtList AS RefSuplrSettlmtList,
SettlmtDocListItem.RefSettlmtDocList AS RefSettlmtDocList,
SettlmtDocListItem.RefCustSettlmt AS RefCustSettlmt,
SettlmtDocListItem.RefExpnSettlmt AS RefExpnSettlmt,
SettlmtDocListItem.RefSuplrSettlmt AS RefSuplrSettlmt,
SettlmtDocListItem.SettlmtExtBillgDoc AS SettlmtExtBillgDoc,
SettlmtDocListItem.SettlmtExtAcctgDocCompanyCode AS SettlmtExtAcctgDocCompanyCode,
SettlmtDocListItem.SettlmtExtAcctgDoc AS SettlmtExtAcctgDoc,
SettlmtDocListItem.SettlmtExtAcctgDocFiscalYear AS SettlmtExtAcctgDocFiscalYear,
SettlmtDocListItem.SettlmtExtAcctgDocItem AS SettlmtExtAcctgDocItem,
SettlmtDocListItem.SettlmtDocListItemIsReversed AS SettlmtDocListItemIsReversed,
SettlmtDocListItem.PrcDetnIsIncmplt AS PrcDetnIsIncmplt,
SettlmtDocList._BillToParty AS _BillToParty,
SettlmtDocList._BillToPartyCompany AS _BillToPartyCompany,
SettlmtDocList._InvoicingParty AS _InvoicingParty,
SettlmtDocList._InvoicingPartyCompany AS _InvoicingPartyCompany,
SettlmtDocList._AlternativeInvoicingParty AS _AlternativeInvoicingParty,
SettlmtDocList._AltvInvoicingPartyCompany AS _AltvInvoicingPartyCompany,
SettlmtDocList._PayeeParty AS _PayeeParty,
SettlmtDocList._PayeePartyCompany AS _PayeePartyCompany,
SettlmtDocList._PayerParty AS _PayerParty,
SettlmtDocList._PayerPartyCompany AS _PayerPartyCompany,
SettlmtDocList._SettlmtDocListCurrency AS _SettlmtDocListCurrency,
SettlmtDocList._SettlmtDocListPaymentCurrency AS _SettlmtDocListPaymentCurrency
FROM R_SettlmtDocListItem AS SettlmtDocListItem
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA