TCJ_DOCUMENTS

Transparent Table Application Table
45 Fields 1 CDS Views

Cash Journal Documents (Header Data)

TCJ_DOCUMENTS is an SAP database table in S/4HANA. Cash Journal Documents (Header Data). It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CashJournalDocument view from BASIC View for table TCJ_DOCUMENTS

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY comp_code BUKRS Company Code
KEY cajo_number CJNR Cash Journal Number
KEY fisc_year GJAHR Fiscal Year
KEY posting_number CJBELNR Internal doc. number
currency WAERS Currency
h_receipts CJAMOUNT Amount
h_payments CJAMOUNT Amount
h_net_amount CJNET_AMOUNT Net amount
h_net_payment_wt CJNET_PAYMENT_WT Payment Amount
h_tax_amount WMWST Tax Amount
bp_name CJBPNAME Recpt recipient
document_date BLDAT Document Date
document_number XBLNR1 Reference
posting_date BUDAT Posting Date
document_status CJDOCSTAT Document status
accountant USNAM User Name
print_ind CJPRINTIND Print indicator
tax_percent MSATZ_F05L Tax rate
d_posting_numb CJBELNR_DISP Doc. Number
text1 CJDOCTEXT100 Addit.text 1
text2 CJDOCTEXT30 Addit.text 2
means_of_payment CJMOFPAYM Means of paymt
check_number SCKNR_EB 13-Digit Check Number
check_issuer CJCHECKISSUER Check issuer
bank_key BANKK Bank Key
bank_acct BANKN Bank Account
bank_ctry BANKS Bank Ctry/Reg.
check_stack CJCHECKSTACK Lot
check_status CJCHECKSTATUS Check status
revbelnr CJREVBELNR Reversal Doc.No
exch_rate KURSF Exchange rate
bupla BUPLA Business place
secco SECCO Section Code
split CJDOCSPLIT Split
lzbkz LZBKZ SCB Ind.
landl LANDL Supply C/R
check_fy CJCHECKSTACKFY Check Fiscal Year
valuta_date VALUT Value date
vatdate VATDATE Tax Reporting Date
bkont BKONT Control Key
bkref BKREF Reference
iban IBAN IBAN
cj_entry TCODEL Transaction
fulfilldate FOT_FULFILLDATE Tax Fulfill. Date

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 Documents (Header Data)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCJ_DOCUMENTS (
    MANDT,             -- Client [MANDT]
    COMP_CODE,         -- Company Code [BUKRS]
    CAJO_NUMBER,       -- Cash Journal Number [CJNR]
    FISC_YEAR,         -- Fiscal Year [GJAHR]
    POSTING_NUMBER,    -- Internal doc. number [CJBELNR]
    CURRENCY,          -- Currency [WAERS]
    H_RECEIPTS,        -- Amount [CJAMOUNT]
    H_PAYMENTS,        -- Amount [CJAMOUNT]
    H_NET_AMOUNT,      -- Net amount [CJNET_AMOUNT]
    H_NET_PAYMENT_WT,  -- Payment Amount [CJNET_PAYMENT_WT]
    H_TAX_AMOUNT,      -- Tax Amount [WMWST]
    BP_NAME,           -- Recpt recipient [CJBPNAME]
    DOCUMENT_DATE,     -- Document Date [BLDAT]
    DOCUMENT_NUMBER,   -- Reference [XBLNR1]
    POSTING_DATE,      -- Posting Date [BUDAT]
    DOCUMENT_STATUS,   -- Document status [CJDOCSTAT]
    ACCOUNTANT,        -- User Name [USNAM]
    PRINT_IND,         -- Print indicator [CJPRINTIND]
    TAX_PERCENT,       -- Tax rate [MSATZ_F05L]
    D_POSTING_NUMB,    -- Doc. Number [CJBELNR_DISP]
    TEXT1,             -- Addit.text 1 [CJDOCTEXT100]
    TEXT2,             -- Addit.text 2 [CJDOCTEXT30]
    MEANS_OF_PAYMENT,  -- Means of paymt [CJMOFPAYM]
    CHECK_NUMBER,      -- 13-Digit Check Number [SCKNR_EB]
    CHECK_ISSUER,      -- Check issuer [CJCHECKISSUER]
    BANK_KEY,          -- Bank Key [BANKK]
    BANK_ACCT,         -- Bank Account [BANKN]
    BANK_CTRY,         -- Bank Ctry/Reg. [BANKS]
    CHECK_STACK,       -- Lot [CJCHECKSTACK]
    CHECK_STATUS,      -- Check status [CJCHECKSTATUS]
    REVBELNR,          -- Reversal Doc.No [CJREVBELNR]
    EXCH_RATE,         -- Exchange rate [KURSF]
    BUPLA,             -- Business place [BUPLA]
    SECCO,             -- Section Code [SECCO]
    SPLIT,             -- Split [CJDOCSPLIT]
    LZBKZ,             -- SCB Ind. [LZBKZ]
    LANDL,             -- Supply C/R [LANDL]
    CHECK_FY,          -- Check Fiscal Year [CJCHECKSTACKFY]
    VALUTA_DATE,       -- Value date [VALUT]
    VATDATE,           -- Tax Reporting Date [VATDATE]
    BKONT,             -- Control Key [BKONT]
    BKREF,             -- Reference [BKREF]
    IBAN,              -- IBAN [IBAN]
    CJ_ENTRY,          -- Transaction [TCODEL]
    FULFILLDATE,       -- Tax Fulfill. Date [FOT_FULFILLDATE]
    PRIMARY KEY (MANDT, COMP_CODE, CAJO_NUMBER, FISC_YEAR, POSTING_NUMBER)
);

Learn More