TRACT_ACCITEM

Transparent Table Application Table
48 Fields 2 CDS Views

Accounting Items

TRACT_ACCITEM is an SAP database table in S/4HANA. Accounting Items. It contains 48 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TrsyAccountingItemBase view_entity from BASIC Treasury Accounting Item Base
P_TractAccitem view_entity from BASIC CDS view for Treasury table: TRACT_ACCITEM

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY document_guid tpm_db_os_guid DB Object ID
KEY item_number posnr_acc Position
pc_guid tpm_db_os_guid DB Object ID
dis_flowtype tpm_dis_flowtype Update Type
szart tpm_szart Pmnt Transact.
aa_ref tpm_aa_ref Acct Assignment Ref.
acc_symbol tpm_acc_symbol Account Symbol
posting_cat tpm_posting_cat Posting Categ.
posting_key bschl Posting Key
gl_account saknr G/L Account
position_amt tpm_foreign_amt Transact.Crcy Amount
position_curr tpm_foreign_curr Transaction Currency
local_amt tpm_local_amt Amount (Local Crcy)
local_curr tpm_local_curr Local Currency
trdflownr tpm_trdflownr Flow Number
belnr belnr_d Document Number
reversal_belnr belnr_d Document Number
buzei buzei Item
logvo logvo Log. Trans.
blart blart Document Type
payment_date tpm_payment_date Payt Date
kunnr kunnr Customer
zterm dzterm Pyt Terms
zlsch dzlsch Pymt Meth.
uzawe uzawe Pmnt Meth. Sup.
zlspr dzlspr Pmnt block
rpzahl tb_rpzahl_new Payer/Payee
rpbank tb_rpbank Partner Bank
house_bank tb_rhabki House Bank
house_bank_acc tb_rhktid House Bank Acct
sign tb_ssign Direction
lzbkz lzbkz SCB Ind.
landl landl Supply C/R
allocnr dzuonr Assignment
sgtxt sgtxt Text
gsber gsber Business Area
kostl kostl Cost Center
rmvct rmvct Transact. Type
vbund vbund Company ID
kontrahent tb_kunnr_new Partner
issuer repke_new Issuer
sub_flow_number tpm_trdflownr Flow Number
mndid sepa_mndid Mandate Ref.
spgl_ind umskz Special G/L Ind
tax_category idcfm_tax_category Tax Category
payment_reason farp_payt_rsn Payment Reason
lifnr tpm_lifnr Vendor

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.

-- Accounting Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRACT_ACCITEM (
    MANDT,            -- Client [mandt]
    DOCUMENT_GUID,    -- DB Object ID [tpm_db_os_guid]
    ITEM_NUMBER,      -- Position [posnr_acc]
    PC_GUID,          -- DB Object ID [tpm_db_os_guid]
    DIS_FLOWTYPE,     -- Update Type [tpm_dis_flowtype]
    SZART,            -- Pmnt Transact. [tpm_szart]
    AA_REF,           -- Acct Assignment Ref. [tpm_aa_ref]
    ACC_SYMBOL,       -- Account Symbol [tpm_acc_symbol]
    POSTING_CAT,      -- Posting Categ. [tpm_posting_cat]
    POSTING_KEY,      -- Posting Key [bschl]
    GL_ACCOUNT,       -- G/L Account [saknr]
    POSITION_AMT,     -- Transact.Crcy Amount [tpm_foreign_amt]
    POSITION_CURR,    -- Transaction Currency [tpm_foreign_curr]
    LOCAL_AMT,        -- Amount (Local Crcy) [tpm_local_amt]
    LOCAL_CURR,       -- Local Currency [tpm_local_curr]
    TRDFLOWNR,        -- Flow Number [tpm_trdflownr]
    BELNR,            -- Document Number [belnr_d]
    REVERSAL_BELNR,   -- Document Number [belnr_d]
    BUZEI,            -- Item [buzei]
    LOGVO,            -- Log. Trans. [logvo]
    BLART,            -- Document Type [blart]
    PAYMENT_DATE,     -- Payt Date [tpm_payment_date]
    KUNNR,            -- Customer [kunnr]
    ZTERM,            -- Pyt Terms [dzterm]
    ZLSCH,            -- Pymt Meth. [dzlsch]
    UZAWE,            -- Pmnt Meth. Sup. [uzawe]
    ZLSPR,            -- Pmnt block [dzlspr]
    RPZAHL,           -- Payer/Payee [tb_rpzahl_new]
    RPBANK,           -- Partner Bank [tb_rpbank]
    HOUSE_BANK,       -- House Bank [tb_rhabki]
    HOUSE_BANK_ACC,   -- House Bank Acct [tb_rhktid]
    SIGN,             -- Direction [tb_ssign]
    LZBKZ,            -- SCB Ind. [lzbkz]
    LANDL,            -- Supply C/R [landl]
    ALLOCNR,          -- Assignment [dzuonr]
    SGTXT,            -- Text [sgtxt]
    GSBER,            -- Business Area [gsber]
    KOSTL,            -- Cost Center [kostl]
    RMVCT,            -- Transact. Type [rmvct]
    VBUND,            -- Company ID [vbund]
    KONTRAHENT,       -- Partner [tb_kunnr_new]
    ISSUER,           -- Issuer [repke_new]
    SUB_FLOW_NUMBER,  -- Flow Number [tpm_trdflownr]
    MNDID,            -- Mandate Ref. [sepa_mndid]
    SPGL_IND,         -- Special G/L Ind [umskz]
    TAX_CATEGORY,     -- Tax Category [idcfm_tax_category]
    PAYMENT_REASON,   -- Payment Reason [farp_payt_rsn]
    LIFNR,            -- Vendor [tpm_lifnr]
    PRIMARY KEY (MANDT, DOCUMENT_GUID, ITEM_NUMBER)
);

Learn More