TJ01
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)
| 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.
-- 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)
);
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