TJ01

Transparent Table System Table (transport)

Betriebswirtschaftliche Vorgänge

TJ01 is an SAP database table in S/4HANA. Betriebswirtschaftliche Vorgänge. 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.

-- Betriebswirtschaftliche Vorgänge
-- 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)
);