R_SETTLMTDOCLISTITEM

CDS View

Settlement Document List Item

R_SETTLMTDOCLISTITEM is a CDS View in S/4HANA. Settlement Document List Item. It contains 23 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_SettlmtDocListItemOutputForm view from CONSUMPTION Settlmt Document List Item Output Form
I_SettlmtDocListItem view from BASIC Settlement Document List Item
R_SettlmtDocListDEX view from COMPOSITE Settlement Doc List Basic Extraction

Fields (23)

KeyField CDS FieldsUsed in Views
KEY SettlmtDocList SettlmtDocList 1
KEY SettlmtDocListItem SettlmtDocListItem 1
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount 1
PrcDetnIsIncmplt PrcDetnIsIncmplt 1
RefCustSettlmt RefCustSettlmt 1
RefCustSettlmtList RefCustSettlmtList 1
RefExpnSettlmt RefExpnSettlmt 1
RefSettlmtDoc RefSettlmtDoc 1
RefSettlmtDocList RefSettlmtDocList 1
RefSuplrBillgDoc RefSuplrBillgDoc 1
RefSuplrSettlmt RefSuplrSettlmt 1
RefSuplrSettlmtList RefSuplrSettlmtList 1
SettlmtDocListItemCat SettlmtDocListItemCat 1
SettlmtDocListItemIsReversed SettlmtDocListItemIsReversed 1
SettlmtDocListItemNetAmount SettlmtDocListItemNetAmount 1
SettlmtDocListItemTaxAmount SettlmtDocListItemTaxAmount 1
SettlmtExtAcctgDoc SettlmtExtAcctgDoc 1
SettlmtExtAcctgDocCompanyCode SettlmtExtAcctgDocCompanyCode 1
SettlmtExtAcctgDocFiscalYear SettlmtExtAcctgDocFiscalYear 1
SettlmtExtAcctgDocItem SettlmtExtAcctgDocItem 1
SettlmtExtBillgDoc SettlmtExtBillgDoc 1
SettlmtRemunerationNetAmt SettlmtRemunerationNetAmt 1
SettlmtRemunerationTaxAmt SettlmtRemunerationTaxAmt 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.

-- Settlement Document List Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_SETTLMTDOCLISTITEM (
    SETTLMTDOCLIST,
    SETTLMTDOCLISTITEM,
    NONDEDUCTIBLEINPUTTAXAMOUNT,
    PRCDETNISINCMPLT,
    REFCUSTSETTLMT,
    REFCUSTSETTLMTLIST,
    REFEXPNSETTLMT,
    REFSETTLMTDOC,
    REFSETTLMTDOCLIST,
    REFSUPLRBILLGDOC,
    REFSUPLRSETTLMT,
    REFSUPLRSETTLMTLIST,
    SETTLMTDOCLISTITEMCAT,
    SETTLMTDOCLISTITEMISREVERSED,
    SETTLMTDOCLISTITEMNETAMOUNT,
    SETTLMTDOCLISTITEMTAXAMOUNT,
    SETTLMTEXTACCTGDOC,
    SETTLMTEXTACCTGDOCCOMPANYCODE,
    SETTLMTEXTACCTGDOCFISCALYEAR,
    SETTLMTEXTACCTGDOCITEM,
    SETTLMTEXTBILLGDOC,
    SETTLMTREMUNERATIONNETAMT,
    SETTLMTREMUNERATIONTAXAMT,
    PRIMARY KEY (SETTLMTDOCLIST, SETTLMTDOCLISTITEM)
);