Fields (86)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| _AlternativeInvoicingParty | _AlternativeInvoicingParty | 1 | |
| _AltvInvoicingPartyCompany | _AltvInvoicingPartyCompany | 1 | |
| _BillToParty | _BillToParty | 1 | |
| _BillToPartyCompany | _BillToPartyCompany | 1 | |
| _InvoicingParty | _InvoicingParty | 1 | |
| _InvoicingPartyCompany | _InvoicingPartyCompany | 1 | |
| _PayeeParty | _PayeeParty | 1 | |
| _PayeePartyCompany | _PayeePartyCompany | 1 | |
| _PayerParty | _PayerParty | 1 | |
| _PayerPartyCompany | _PayerPartyCompany | 1 | |
| _SettlmtDocListCurrency | _SettlmtDocListCurrency | 1 | |
| _SettlmtDocListPaymentCurrency | _SettlmtDocListPaymentCurrency | 1 | |
| AdditionalValueDays | AdditionalValueDays | 1 | |
| AlternativeInvoicingParty | AlternativeInvoicingParty | 1 | |
| AssignmentReference | AssignmentReference | 1 | |
| BillToParty | BillToParty | 1 | |
| CashDiscount1Days | CashDiscount1Days | 1 | |
| CashDiscount1Percent | CashDiscount1Percent | 1 | |
| CashDiscount2Days | CashDiscount2Days | 1 | |
| CashDiscount2Percent | CashDiscount2Percent | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| CreationTime | CreationTime | 1 | |
| CreditControlArea | CreditControlArea | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| Division | Division | 1 | |
| DocIntrastatRelevance | DocIntrastatRelevance | 1 | |
| DocumentReferenceID | DocumentReferenceID | 1 | |
| EligibleAmountForCashDiscount | EligibleAmountForCashDiscount | 1 | |
| ExchangeRate | ExchangeRate | 1 | |
| ExchangeRateDate | ExchangeRateDate | 1 | |
| ExchangeRateIsFixed | ExchangeRateIsFixed | 1 | |
| ExchangeRateType | ExchangeRateType | 1 | |
| FiscalPeriod | FiscalPeriod | 1 | |
| FixedValueDate | FixedValueDate | 1 | |
| IncotermsClassification | IncotermsClassification | 1 | |
| IncotermsLocation1 | IncotermsLocation1 | 1 | |
| IncotermsLocation2 | IncotermsLocation2 | 1 | |
| IncotermsTransferLocation | IncotermsTransferLocation | 1 | |
| IncotermsVersion | IncotermsVersion | 1 | |
| IntrastatDeclnGdsFlwCat | IntrastatDeclnGdsFlwCat | 1 | |
| InvoicingParty | InvoicingParty | 1 | |
| IsEUTriangularDeal | IsEUTriangularDeal | 1 | |
| LastChangeDate | LastChangeDate | 1 | |
| LogisticsDataEntryCat | LogisticsDataEntryCat | 1 | |
| NetPaymentDays | NetPaymentDays | 1 | |
| OneTimeSettlmtPartAddrID | OneTimeSettlmtPartAddrID | 1 | |
| PayeeParty | PayeeParty | 1 | |
| PayerParty | PayerParty | 1 | |
| PaymentMethod | PaymentMethod | 1 | |
| PaymentReference | PaymentReference | 1 | |
| PaymentTerms | PaymentTerms | 1 | |
| PostingDate | PostingDate | 1 | |
| PricingProcedure | PricingProcedure | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| RvsdSettlmtDocList | RvsdSettlmtDocList | 1 | |
| SalesOrganization | SalesOrganization | 1 | |
| SEPAMandate | SEPAMandate | 1 | |
| SettlmtApplSts | SettlmtApplSts | 1 | |
| SettlmtApplStsGrp | SettlmtApplStsGrp | 1 | |
| SettlmtBusProcCat | SettlmtBusProcCat | 1 | |
| SettlmtBusProcVar | SettlmtBusProcVar | 1 | |
| SettlmtCoCodeTaxCountry | SettlmtCoCodeTaxCountry | 1 | |
| SettlmtDate | SettlmtDate | 1 | |
| SettlmtDocCat | SettlmtDocCat | 1 | |
| SettlmtDocListAcctgTransfSts | SettlmtDocListAcctgTransfSts | 1 | |
| SettlmtDocListActivityReason | SettlmtDocListActivityReason | 1 | |
| SettlmtDocListCat | SettlmtDocListCat | 1 | |
| SettlmtDocListCurrency | SettlmtDocListCurrency | 1 | |
| SettlmtDocListIncmpltnsRsn | SettlmtDocListIncmpltnsRsn | 1 | |
| SettlmtDocListIsReversed | SettlmtDocListIsReversed | 1 | |
| SettlmtDocListPaymentCurrency | SettlmtDocListPaymentCurrency | 1 | |
| SettlmtDocListPaytCrcyExchRate | SettlmtDocListPaytCrcyExchRate | 1 | |
| SettlmtDocListTotalGrossAmount | SettlmtDocListTotalGrossAmount | 1 | |
| SettlmtDocListTotalNetAmount | SettlmtDocListTotalNetAmount | 1 | |
| SettlmtDocListTotalTaxAmount | SettlmtDocListTotalTaxAmount | 1 | |
| SettlmtDocListType | SettlmtDocListType | 1 | |
| SettlmtDocType | SettlmtDocType | 1 | |
| SettlmtProcessType | SettlmtProcessType | 1 | |
| StateCentralBankPaymentReason | StateCentralBankPaymentReason | 1 | |
| SupplyingCountry | SupplyingCountry | 1 | |
| TaxDepartureCountry | TaxDepartureCountry | 1 | |
| TaxDestinationCountry | TaxDestinationCountry | 1 | |
| VATRegistration | VATRegistration | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SETTLMTDOCLIST (
_ALTERNATIVEINVOICINGPARTY,
_ALTVINVOICINGPARTYCOMPANY,
_BILLTOPARTY,
_BILLTOPARTYCOMPANY,
_INVOICINGPARTY,
_INVOICINGPARTYCOMPANY,
_PAYEEPARTY,
_PAYEEPARTYCOMPANY,
_PAYERPARTY,
_PAYERPARTYCOMPANY,
_SETTLMTDOCLISTCURRENCY,
_SETTLMTDOCLISTPAYMENTCURRENCY,
ADDITIONALVALUEDAYS,
ALTERNATIVEINVOICINGPARTY,
ASSIGNMENTREFERENCE,
BILLTOPARTY,
CASHDISCOUNT1DAYS,
CASHDISCOUNT1PERCENT,
CASHDISCOUNT2DAYS,
CASHDISCOUNT2PERCENT,
COMPANYCODE,
CREATEDBYUSER,
CREATIONDATE,
CREATIONTIME,
CREDITCONTROLAREA,
DISTRIBUTIONCHANNEL,
DIVISION,
DOCINTRASTATRELEVANCE,
DOCUMENTREFERENCEID,
ELIGIBLEAMOUNTFORCASHDISCOUNT,
EXCHANGERATE,
EXCHANGERATEDATE,
EXCHANGERATEISFIXED,
EXCHANGERATETYPE,
FISCALPERIOD,
FIXEDVALUEDATE,
INCOTERMSCLASSIFICATION,
INCOTERMSLOCATION1,
INCOTERMSLOCATION2,
INCOTERMSTRANSFERLOCATION,
INCOTERMSVERSION,
INTRASTATDECLNGDSFLWCAT,
INVOICINGPARTY,
ISEUTRIANGULARDEAL,
LASTCHANGEDATE,
LOGISTICSDATAENTRYCAT,
NETPAYMENTDAYS,
ONETIMESETTLMTPARTADDRID,
PAYEEPARTY,
PAYERPARTY,
PAYMENTMETHOD,
PAYMENTREFERENCE,
PAYMENTTERMS,
POSTINGDATE,
PRICINGPROCEDURE,
PURCHASINGGROUP,
PURCHASINGORGANIZATION,
RVSDSETTLMTDOCLIST,
SALESORGANIZATION,
SEPAMANDATE,
SETTLMTAPPLSTS,
SETTLMTAPPLSTSGRP,
SETTLMTBUSPROCCAT,
SETTLMTBUSPROCVAR,
SETTLMTCOCODETAXCOUNTRY,
SETTLMTDATE,
SETTLMTDOCCAT,
SETTLMTDOCLISTACCTGTRANSFSTS,
SETTLMTDOCLISTACTIVITYREASON,
SETTLMTDOCLISTCAT,
SETTLMTDOCLISTCURRENCY,
SETTLMTDOCLISTINCMPLTNSRSN,
SETTLMTDOCLISTISREVERSED,
SETTLMTDOCLISTPAYMENTCURRENCY,
SETTLMTDOCLISTPAYTCRCYEXCHRATE,
SETTLMTDOCLISTTOTALGROSSAMOUNT,
SETTLMTDOCLISTTOTALNETAMOUNT,
SETTLMTDOCLISTTOTALTAXAMOUNT,
SETTLMTDOCLISTTYPE,
SETTLMTDOCTYPE,
SETTLMTPROCESSTYPE,
STATECENTRALBANKPAYMENTREASON,
SUPPLYINGCOUNTRY,
TAXDEPARTURECOUNTRY,
TAXDESTINATIONCOUNTRY,
VATREGISTRATION
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- 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
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA