SETTLMTDOCLIST

SETTLMTDOCLIST is an SAP database table in S/4HANA. It contains 86 fields.

Fields (86)

KeyField CDS FieldsUsed 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
);