TCJ_POSITIONS

Transparent Table Application Table
94 Fields 1 CDS Views

Cash Journal Document Items

TCJ_POSITIONS is an SAP database table in S/4HANA. Cash Journal Document Items. It contains 94 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CASHJOURNALPOSITION view from BASIC

Fields (94)

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
gsber GSBER Business Area
pargb PARGB Trdg Part.BA
vbund RASSC Trading Partner
rmvct RMVCT Transact. Type
fkber FKBER Functional Area
kokrs KOKRS CO Area
kostl KOSTL Cost Center
lstar LSTAR Activity Type
aufnr AUFNR Order
afpos CO_POSNR Item Number
bemot BEMOT AcctIndicator
kstrg KSTRG Cost Object
prznr CO_PRZNR Business Process
prctr PRCTR Profit Center
pprctr PPRCTR Partner PC
ps_psp_pnr PS_PSP_PNR WBS Element
nplnr NPLNR Network
vornr VORNR Activity
anln1 BF_ANLN1 Asset
anln2 BF_ANLN2 Sub-number
bzdat BF_BZDAT Reference date
anbwa BF_ANBWA Trans. type
werks WERKS_D Plant
bwtar BWTAR_D Valuation Type
bwkey BWKEY Valuation Area
matnr MATNR Material
hrkft HRKFT Origin Group
hkmat HKMAT Material origin
kdauf KDAUF Sales Order
kdein KDEIN SOrder schedule
kdpos KDPOS Sales Ord. Item
vname JV_NAME Joint venture
recid JV_RECIND Recovery Ind.
recid_man JV_RECID_M Rec.Ind. Manual
egrup JV_EGROUP Equity group
etype JV_ETYPE Equity Type
vptnr JV_PART Partner
condi JV_CONDCOD CondKey
crpcal JV_CRPCAL CRP Calculation
fikrs FIKRS FM Area
fistl FISTL Funds Center
fipos FIPOS Commitment item
fipex FM_FIPEX Commitment Item
geber BP_GEBER Fund
kblnr KBLNR_FI Earmarked funds
kblpos KBLPOS Document Item
erlkz REFSETERLK Set "Completed"
pernr PERNR_D Personnel No.
paobjnr RKEOBJNR Profit. segment
imkey IMKEY Real Estate Key
kontt KONTT_FI Acct Assmt Cat.
kontl KONTL_FI Acct assignment
dummy_incl_eew_cobl CFD_DUMMY Dummy
smive SMIVE Lease-Out
grant_nbr GM_GRANT_NBR Grant
dabrz DABRBEZ Reference date
budget_pd FM_BUDGET_PERIOD Budget Period
monat MONAT Period
logsys_kdauf FINS_CFIN_LOGSYSTEM_SENDER Source System
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.

-- Cash Journal Document Items
-- 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]
    GSBER,                -- Business Area [GSBER]
    PARGB,                -- Trdg Part.BA [PARGB]
    VBUND,                -- Trading Partner [RASSC]
    RMVCT,                -- Transact. Type [RMVCT]
    FKBER,                -- Functional Area [FKBER]
    KOKRS,                -- CO Area [KOKRS]
    KOSTL,                -- Cost Center [KOSTL]
    LSTAR,                -- Activity Type [LSTAR]
    AUFNR,                -- Order [AUFNR]
    AFPOS,                -- Item Number [CO_POSNR]
    BEMOT,                -- AcctIndicator [BEMOT]
    KSTRG,                -- Cost Object [KSTRG]
    PRZNR,                -- Business Process [CO_PRZNR]
    PRCTR,                -- Profit Center [PRCTR]
    PPRCTR,               -- Partner PC [PPRCTR]
    PS_PSP_PNR,           -- WBS Element [PS_PSP_PNR]
    NPLNR,                -- Network [NPLNR]
    VORNR,                -- Activity [VORNR]
    ANLN1,                -- Asset [BF_ANLN1]
    ANLN2,                -- Sub-number [BF_ANLN2]
    BZDAT,                -- Reference date [BF_BZDAT]
    ANBWA,                -- Trans. type [BF_ANBWA]
    WERKS,                -- Plant [WERKS_D]
    BWTAR,                -- Valuation Type [BWTAR_D]
    BWKEY,                -- Valuation Area [BWKEY]
    MATNR,                -- Material [MATNR]
    HRKFT,                -- Origin Group [HRKFT]
    HKMAT,                -- Material origin [HKMAT]
    KDAUF,                -- Sales Order [KDAUF]
    KDEIN,                -- SOrder schedule [KDEIN]
    KDPOS,                -- Sales Ord. Item [KDPOS]
    VNAME,                -- Joint venture [JV_NAME]
    RECID,                -- Recovery Ind. [JV_RECIND]
    RECID_MAN,            -- Rec.Ind. Manual [JV_RECID_M]
    EGRUP,                -- Equity group [JV_EGROUP]
    ETYPE,                -- Equity Type [JV_ETYPE]
    VPTNR,                -- Partner [JV_PART]
    CONDI,                -- CondKey [JV_CONDCOD]
    CRPCAL,               -- CRP Calculation [JV_CRPCAL]
    FIKRS,                -- FM Area [FIKRS]
    FISTL,                -- Funds Center [FISTL]
    FIPOS,                -- Commitment item [FIPOS]
    FIPEX,                -- Commitment Item [FM_FIPEX]
    GEBER,                -- Fund [BP_GEBER]
    KBLNR,                -- Earmarked funds [KBLNR_FI]
    KBLPOS,               -- Document Item [KBLPOS]
    ERLKZ,                -- Set "Completed" [REFSETERLK]
    PERNR,                -- Personnel No. [PERNR_D]
    PAOBJNR,              -- Profit. segment [RKEOBJNR]
    IMKEY,                -- Real Estate Key [IMKEY]
    KONTT,                -- Acct Assmt Cat. [KONTT_FI]
    KONTL,                -- Acct assignment [KONTL_FI]
    DUMMY_INCL_EEW_COBL,  -- Dummy [CFD_DUMMY]
    SMIVE,                -- Lease-Out [SMIVE]
    GRANT_NBR,            -- Grant [GM_GRANT_NBR]
    DABRZ,                -- Reference date [DABRBEZ]
    BUDGET_PD,            -- Budget Period [FM_BUDGET_PERIOD]
    MONAT,                -- Period [MONAT]
    LOGSYS_KDAUF,         -- Source System [FINS_CFIN_LOGSYSTEM_SENDER]
    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