TJ01
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA