TRACT_ACCITEM

Transparent Table Application Table
52 Fields 2 CDS Views

Accounting Items

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TrsyAccountingItemBase view from BASIC Treasury Accounting Item Base
P_TractAccitem view from BASIC

Fields (52)

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
mwskz MWSKZ Tax Code
ktosl KTOSL Transaction
kschl KSCHL Condition Type
hsn_sac J_1IG_HSN_SAC HSN/SAC Code
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]
    MWSKZ,            -- Tax Code [MWSKZ]
    KTOSL,            -- Transaction [KTOSL]
    KSCHL,            -- Condition Type [KSCHL]
    HSN_SAC,          -- HSN/SAC Code [J_1IG_HSN_SAC]
    PAYMENT_REASON,   -- Payment Reason [FARP_PAYT_RSN]
    LIFNR,            -- Vendor [TPM_LIFNR]
    PRIMARY KEY (MANDT, DOCUMENT_GUID, ITEM_NUMBER)
);

Learn More