TJ01

Transparent Table System Table (transport)

Business Transactions

TJ01 is an SAP database table in S/4HANA. Business Transactions. It contains 26 fields. 44 CDS views read from this table.

CDS Views using this table (44)

ViewTypeJoinVDMDescription
fac_opp_cds_co_biz_trans view from CDS View for CO business transaction
FCO_MIG_ACDOCA view inner CO Delta Entries - Aggregated ACDOCA Records
FCO_MIG_COEP view inner CO Delta Entries - Line Items after sFIN 1.0 (src. COEP)
FCO_MIG_COEP11 view inner CO Delta Entries - Statistical Line Items
FCO_MIG_CUR view inner CO Delta Entries - Currency Handling (src. COEP+COSP+COSS)
fco_ovhd_cost_acdoca view_entity inner Overhead costs from acdoca
fco_ovhd_cost_co_values1 view_entity inner Overhead costs from acdoca to fields for CO-Version
fco_ovhd_cost_co_values1_l view_entity inner Overhead costs from acdoca to fields for CO-Version
I_ControllingBusTransacType view from BASIC Controlling Business Transaction Type
Kkag_Cos_Item_View view left_outer Itemized view for RA relevant input data
V_Cosp_3_Ddl_Age_view view inner Cold Data: Primary Actuals from ACDOCA per period
v_cosp_3_view view inner CO Object: Cost Totals for External Postings (part 3)
V_Cosp_D_as_Coep_Age_View view inner Cold Data: Totals - Migrated Deltas (primary)
v_cosp_d2_coep_view view inner COSP Difference from Migration as COEP - BSTAT=C
v_cosp_epa_l1_view view left_outer Rebuild COSP for archived COEP from ACDOCA - part 1
V_COSP_KSII_1_VIEW view inner COSP for TA KSII, WRTTP=04 only - 1
V_COSP_LVP_1_VIEW view inner COSP totals: all currencies/valuations - 1
v_cosp_ori_4_view view inner CO Object: Cost Totals for External Postings (part 4)
v_cosp_ori_6_view view inner CO Object: Cost Totals for External Postings (part 6)
V_COSP_PER_1_VIEW view inner COSP totals: all currencies/valuations - 1
V_Cosp_R_3s_View view inner CO Object: Cost Totals for External Postings ("Rev.") Part3s
V_Cosp_R_8_View view inner CO Object: Cost Totals for External Postings ("Rev.") Part 8
v_cosp_wdv_1_view view inner COSP with delta versions (parallel valuation/COGM) - part 1
V_COSP_WO_MUV_1_view view inner
v_cosp_wodelta_3_view view inner Cost Totals for External Postings without records BSTAT=C (part 3)
V_Coss_3_Ddl_Age_view view inner Cold Data: Actuals from ACDOCA per period
v_coss_3_view view inner CO Object: Cost Totals for Internal Postings (part 3)
V_Coss_D_as_Coep_Age_View view inner Cold Data: Totals - Migrated Deltas (secondary)
v_coss_d2_coep_view view inner COSS Difference from Migration as COEP - BSTAT=C
v_coss_epa_l1_view view left_outer Rebuild COSS for archived COEP from ACDOCA - part 1
V_COSS_KSII_1_VIEW view inner COSS for TA KSII, WRTTP=04 only - 1
V_COSS_LVP_1_VIEW view inner COSS totals: all currencies/valuations - 1
v_coss_ori_4_view view inner CO Object: Cost Totals for Internal Postings (part 4)
v_coss_ori_6_view view inner CO Object: Cost Totals for Internal Postings (part 6)
V_COSS_PER_1_VIEW view inner COSS totals in all currencies/valuations - 1
V_Coss_R_3s_View view inner CO Object: Cost Totals for Internal Postings ("Rev.") Part3s
V_Coss_R_8_View view inner CO Object: Cost Totals for Internal Postings ("Rev.") Part 8
V_COSS_W11_1_VIEW view inner COSS for WRTTP=11 only - part 1
v_coss_wdv_1_view view inner COSS with delta versions (parallel valuation/COGM) - part 1
V_COSS_WO_MUV_1_view view inner
v_coss_wodelta_3_view view inner Cost Totals for Internal Postings without records BSTAT=C (part 3)
V_COSS_X_PER_1_VIEW view inner COSS totals in all currencies/valuations - 1
V_COSX_ACDOCA_VIEW view inner COSP/COSS data on ACDOCA wo delta logic
v_cosx_wof_1_view view inner calculation WOF value for COSP/COSS on ACDOCA basis - part 1

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY vrgng J_VORGANG Bus.transaction
vrgsv VRGNG_SV Status admin.
anwst J_ANWST Chng Usr Status
prvrg J_PRVRG Check procedure
vrgjv J_VRGJV Joint venture
vrgco VRGNG_CO CO doc. numbers
nvvrg CO_NVVRG Tn f.COdocNrass
persp CO_PERSP CO period lock
psikz CO_PSIKZ Pri/Sec/IAA
wtkat CO_WTKAT Value category
actgrp ACTGRP Activity group
subgrp SUBGRP Subactivity
xcoep CO_XCOEP COEP
xcoej CO_XCOEJ COEJ
xcooi CO_XCOOI COOI
xcosp CO_XCOSP COSP
xcoss CO_XCOSS COSS
xcoepl CO_XCOEPL COEPL
xcoejl CO_XCOEJL COEJL
xcoepr CO_XCOEPR COEPR
xcoejr CO_XCOEJR COEJR
xcoept CO_XCOEPT COEPT
xcoejt CO_XCOEJT COEJT
xcoepb CO_XCOEPB COEPB
xcofp CO_XCOFP COFP
xfmgm FM_XFMGM FM

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.

-- Business Transactions
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TJ01 (
    VRGNG,   -- Bus.transaction [J_VORGANG]
    VRGSV,   -- Status admin. [VRGNG_SV]
    ANWST,   -- Chng Usr Status [J_ANWST]
    PRVRG,   -- Check procedure [J_PRVRG]
    VRGJV,   -- Joint venture [J_VRGJV]
    VRGCO,   -- CO doc. numbers [VRGNG_CO]
    NVVRG,   -- Tn f.COdocNrass [CO_NVVRG]
    PERSP,   -- CO period lock [CO_PERSP]
    PSIKZ,   -- Pri/Sec/IAA [CO_PSIKZ]
    WTKAT,   -- Value category [CO_WTKAT]
    ACTGRP,  -- Activity group [ACTGRP]
    SUBGRP,  -- Subactivity [SUBGRP]
    XCOEP,   -- COEP [CO_XCOEP]
    XCOEJ,   -- COEJ [CO_XCOEJ]
    XCOOI,   -- COOI [CO_XCOOI]
    XCOSP,   -- COSP [CO_XCOSP]
    XCOSS,   -- COSS [CO_XCOSS]
    XCOEPL,  -- COEPL [CO_XCOEPL]
    XCOEJL,  -- COEJL [CO_XCOEJL]
    XCOEPR,  -- COEPR [CO_XCOEPR]
    XCOEJR,  -- COEJR [CO_XCOEJR]
    XCOEPT,  -- COEPT [CO_XCOEPT]
    XCOEJT,  -- COEJT [CO_XCOEJT]
    XCOEPB,  -- COEPB [CO_XCOEPB]
    XCOFP,   -- COFP [CO_XCOFP]
    XFMGM,   -- FM [FM_XFMGM]
    PRIMARY KEY (VRGNG)
);