TCJ_POSITIONS

Transparent Table Application Table
35 Fields 1 CDS Views

Positionen der Kassenbuchbelege

TCJ_POSITIONS is an SAP database table in S/4HANA. Positionen der Kassenbuchbelege. It contains 35 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CASHJOURNALPOSITION view from BASIC P view for cash journal position

Fields (35)

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
KEY position_number cjbuzei Item
position_type cjpostype Item Category
transact_number cjtransnumb Trans.number
transact_type cjtranstyp Bus. tran. type
posting_date budat Posting Date
currency waers Currency
p_receipts cjamount Amount
p_payments cjamount Amount
p_net_amount cjnet_amount Net amount
p_net_payment_wt cjnet_payment_wt Payment Amount
p_tax_amount wmwst Tax Amount
tax_code mwskz Tax Code
taxcalcdate txdat Tax Date
gl_account hkont G/L Acct
tax_percent msatz_f05l Tax rate
position_text cjpostext Text for item
vendor_no lifnr Supplier
customer kunnr Customer
taxjurcode txjcd Tax Jur.
alloc_nmbr dzuonr Assignment
branch filkd Branch
p_fwbas fwbas Base Amount
segment fb_segment Segment
psegment fb_psegment Partner Segment
stceg stceg VAT Reg. No.
umskz umskz Special G/L Ind
hbkid hbkid House Bank
hktid hktid Account ID
bvtyp bvtyp Part.bank type
tax_country fot_tax_country Tax Ctry/Reg.

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.

-- Positionen der Kassenbuchbelege
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCJ_POSITIONS (
    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]
    POSITION_NUMBER,   -- Item [cjbuzei]
    POSITION_TYPE,     -- Item Category [cjpostype]
    TRANSACT_NUMBER,   -- Trans.number [cjtransnumb]
    TRANSACT_TYPE,     -- Bus. tran. type [cjtranstyp]
    POSTING_DATE,      -- Posting Date [budat]
    CURRENCY,          -- Currency [waers]
    P_RECEIPTS,        -- Amount [cjamount]
    P_PAYMENTS,        -- Amount [cjamount]
    P_NET_AMOUNT,      -- Net amount [cjnet_amount]
    P_NET_PAYMENT_WT,  -- Payment Amount [cjnet_payment_wt]
    P_TAX_AMOUNT,      -- Tax Amount [wmwst]
    TAX_CODE,          -- Tax Code [mwskz]
    TAXCALCDATE,       -- Tax Date [txdat]
    GL_ACCOUNT,        -- G/L Acct [hkont]
    TAX_PERCENT,       -- Tax rate [msatz_f05l]
    POSITION_TEXT,     -- Text for item [cjpostext]
    VENDOR_NO,         -- Supplier [lifnr]
    CUSTOMER,          -- Customer [kunnr]
    TAXJURCODE,        -- Tax Jur. [txjcd]
    ALLOC_NMBR,        -- Assignment [dzuonr]
    BRANCH,            -- Branch [filkd]
    P_FWBAS,           -- Base Amount [fwbas]
    SEGMENT,           -- Segment [fb_segment]
    PSEGMENT,          -- Partner Segment [fb_psegment]
    STCEG,             -- VAT Reg. No. [stceg]
    UMSKZ,             -- Special G/L Ind [umskz]
    HBKID,             -- House Bank [hbkid]
    HKTID,             -- Account ID [hktid]
    BVTYP,             -- Part.bank type [bvtyp]
    TAX_COUNTRY,       -- Tax Ctry/Reg. [fot_tax_country]
    PRIMARY KEY (MANDT, COMP_CODE, CAJO_NUMBER, FISC_YEAR, POSTING_NUMBER, POSITION_NUMBER)
);

Learn More