TCJ_TRANSACTIONS

Transparent Table Customizing Table
11 Fields 2 CDS Views

Cash Journal Business Transactions

TCJ_TRANSACTIONS is an SAP database table in S/4HANA. Cash Journal Business Transactions. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
Fac_Ad_Cds_Cj_Tran view from cds view for cash journal transaction
P_CASHJOURNALTRANSACTION view from BASIC

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY comp_code BUKRS Company Code
KEY transact_number CJTRANSNUMB Trans.number
transact_type CJTRANSTYP Bus. tran. type
gl_account SAKNR G/L Account
tax_code MWSKZ Tax Code
cjtransclosed CJTRANSCLOSED Bus. Trans. Blocked
umskz UMSKZ Special G/L Ind
cjaccchange CJACCCHANGE Acct Modifiable
cjtaxchange CJTAXCHANGE Tax Modifiable
transact_clas CJTRANSCLAS Trans.Classifn

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.

-- Cash Journal Business Transactions
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCJ_TRANSACTIONS (
    MANDT,            -- Client [MANDT]
    COMP_CODE,        -- Company Code [BUKRS]
    TRANSACT_NUMBER,  -- Trans.number [CJTRANSNUMB]
    TRANSACT_TYPE,    -- Bus. tran. type [CJTRANSTYP]
    GL_ACCOUNT,       -- G/L Account [SAKNR]
    TAX_CODE,         -- Tax Code [MWSKZ]
    CJTRANSCLOSED,    -- Bus. Trans. Blocked [CJTRANSCLOSED]
    UMSKZ,            -- Special G/L Ind [UMSKZ]
    CJACCCHANGE,      -- Acct Modifiable [CJACCCHANGE]
    CJTAXCHANGE,      -- Tax Modifiable [CJTAXCHANGE]
    TRANSACT_CLAS,    -- Trans.Classifn [CJTRANSCLAS]
    PRIMARY KEY (MANDT, COMP_CODE, TRANSACT_NUMBER)
);

Learn More