TCJ_BALANCE

Transparent Table Application Table
9 Fields 1 CDS Views

FI-Kassenbuch: Summensätze

TCJ_BALANCE is an SAP database table in S/4HANA. FI-Kassenbuch: Summensätze. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CashJournalBalance view from BASIC View for table TCJ_BALANCE

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY comp_code bukrs Company Code
KEY cajo_number cjnr Cash Journal Number
KEY rec_type cjrec_type Totals rec.type
KEY time_stamp cjtime_stamp Time stamp
currency waers Currency
closing_sum tslxx Transactn curr.
accountant usnam User Name
sarch sarch Arch. CJ Totals Rec.

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.

-- FI-Kassenbuch: Summensätze
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCJ_BALANCE (
    MANDT,        -- Client [mandt]
    COMP_CODE,    -- Company Code [bukrs]
    CAJO_NUMBER,  -- Cash Journal Number [cjnr]
    REC_TYPE,     -- Totals rec.type [cjrec_type]
    TIME_STAMP,   -- Time stamp [cjtime_stamp]
    CURRENCY,     -- Currency [waers]
    CLOSING_SUM,  -- Transactn curr. [tslxx]
    ACCOUNTANT,   -- User Name [usnam]
    SARCH,        -- Arch. CJ Totals Rec. [sarch]
    PRIMARY KEY (MANDT, COMP_CODE, CAJO_NUMBER, REC_TYPE, TIME_STAMP)
);

Learn More