TCJ41 SAP (Default Values for Work Breakdown Structure) Table details
Dictionary Type: Table
Description: Default Values for Work Breakdown Structure
Description: Default Values for Work Breakdown Structure
Table field list including key, data, relationships and ABAP select examples
TCJ41 is a standard SAP Table which is used to store Default Values for Work Breakdown Structure data and is available within R/3 SAP systems depending on the version and release level.
The TCJ41 table consists of various fields, each holding specific information or linking keys about Default Values for Work Breakdown Structure data available in SAP. These include PROFIDPROJ (Project Profile), WERKS (Plant), KALID (Factory calendar key), VGPLF (Planning method for project basic dates).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = TCJ4T
SAP TCJ41 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PROFIDPROJ | Project Profile | PROFIDPROJ | CHAR | 7 | PROFIDPROJ | PWS | |||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
KALID | Factory calendar key | FABKL | CHAR | 2 | TFACD | WFCID | |||
VGPLF | Planning method for project basic dates | PS_VGPLF | NUMC | 1 | PSPLFRM | ||||
EWPLF | Planning method for project forecast dates | PS_EWPLF | NUMC | 1 | PSPLFRM | ||||
PLNAW | Application of the task list | PLNAW | CHAR | 1 | TCA09 | PLNAW | |||
VPROF | Network profile | PROFIDNZPL | CHAR | 7 | TCN41 | PROFILID | PNW | ||
NZANZ | Indicator: Network header visible to end user | NETZOBERFL | CHAR | 1 | X | ||||
IDENT | Display options for WBS elements | PS_IDENTKZ | CHAR | 1 | PS_IDENTKZ | ||||
ABGSL | Results Analysis Key | ABGR_SCHL | CHAR | 6 | TKKAA | ABGR_SCHL | ACS | ||
LEVELS | Hierarchy structure: Level of detail | PS_LEVEL | INT1 | 3 | INT1 | ||||
ZUORD | Network assignment | PS_ZUORD | NUMC | 1 | PS_ZUORD | ||||
TRMEQ | Indicator: WBS dates detailed by activity dates | PS_TRMEQ | CHAR | 1 | X | ||||
STSPD | Status profile for project definition | PS_STSPD | CHAR | 8 | TJ20 | J_STSMA | |||
STSPR | Status profile for WBS element | PS_STSPR | CHAR | 8 | TJ20 | J_STSMA | |||
KVEWE | Usage of the condition table | KVEWE | CHAR | 1 | T681V | KVEWE | KVW | ||
KAPPL | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
KALSM | Costing Sheet | AUFKALSM | CHAR | 6 | T683 | KALSM | |||
ZSCHL | Overhead key | AUFZSCHL | CHAR | 6 | CHAR6 | ||||
APROF | Settlement profile | PS_APROF | CHAR | 6 | TKB1A | ALPHA | APROF | ||
APRFE | Revenue settlement profile | PS_APRFE | CHAR | 6 | TKB1A | ALPHA | APROF | ||
GRPGS | Master data: Profile group hierarchy graphic | PS_GRGRUPS | CHAR | 4 | NETGRUPPE | ||||
GRPFS | Master data: Hierarchy graphic profile name | PS_GRPROFS | CHAR | 12 | NETPROF | ||||
GRPGT | Time scheduling: Profile group hierarchy graphic | PS_GRGRUPT | CHAR | 4 | NETGRUPPE | ||||
GRPFT | Time scheduling: Hierarchy graphic profile name | PS_GRPROFT | CHAR | 12 | NETPROF | ||||
GRPGB | Budget/cost planning: Profile group hierarchy graphic | PS_GRGRUPB | CHAR | 4 | NETGRUPPE | ||||
GRPFB | Budget/cost planning: Profile name hierarchy graphic | PS_GRPROFB | CHAR | 12 | NETPROF | ||||
BERST | Authorization key for project master data | PS_BERST | CHAR | 16 | CHAR16 | ||||
BERTR | Authorization key for project dates (WBS) | PS_BERTR | CHAR | 16 | CHAR16 | ||||
BERKO | Authorization key for costs and revenues | PS_BERKO | CHAR | 16 | CHAR16 | ||||
BERBU | Authorization key for project budget | PS_BERBU | CHAR | 16 | CHAR16 | ||||
SLWID | Key word ID for user-defined fields | SLWID | CHAR | 7 | TCN00 | SLWID | |||
AUTOD | Automatic value transfer from WBS element to project def. | PS_AUTOD | CHAR | 1 | XFELD | ||||
BPROF | Budget Profile | BP_BPROFIL | CHAR | 6 | TBP1C | BP_PROFIL | BP1 | ||
ZTEHT | Time unit in time scheduling | PS_ZTEHT | UNIT | 3 | T006 | CUNIT | MEINS | ||
ALL_ACC | Indicator: All WBS elements are account assignment elements | PS_ALLACC | CHAR | 1 | CHAR1 | ||||
ALL_ACT | Indicator: Read project with activities | PS_ALL_ACT | CHAR | 1 | X | ||||
BUKRS | Company code for the project | PS_VBUKR | CHAR | 4 | T001 | BUKRS | BUK | ||
GSBER | Business area for the project | PS_VGSBR | CHAR | 4 | TGSB | GSBER | GSB | ||
KOKRS | Controlling area for the project | PS_VKOKR | CHAR | 4 | TKA01 | CACCD | CAC | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
WAERS | WBS currency (project definition) | PS_PWHIE | CUKY | 5 | TCURC | WAERS | |||
CHGKZ | Indicator: Status change documents | PROJCHGKZ | CHAR | 1 | XFELD | ||||
BESTA | Project stock | PS_BESTAND | CHAR | 1 | XFELD | ||||
SCOPE | Object Class | SCOPE_CV | CHAR | 2 | SCOPE | SCOPE_CV | PCO | ||
XSTAT | Statistical WBS element | PS_XSTAT | CHAR | 1 | XFELD | ||||
AEBLG | Change document creation allowed | PS_AEBLG | CHAR | 1 | XFELD | ||||
PRART | Project type | PS_PRART | CHAR | 2 | TCJ1 | PS_PRART | |||
BPPROFL | Profile for project planning board | BPPROFILE | CHAR | 12 | TCBP | BPPROFILE | PPL | ||
ZSCHM | Interest Profile for Project/Order Interest Calculation | PS_ZSCHM | CHAR | 7 | TPI01 | PS_ZSCHM | |||
EINGR | Capacity load profile in graphical planning table | PS_EINGR | CHAR | 10 | TCY30 | CY_PROFIL | |||
EINTB | Capacity load profile for tabular planning table | PS_EINTB | CHAR | 10 | TCY30 | CY_PROFIL | |||
IMPRF | Investment measure profile | IM_PROFIL | CHAR | 6 | TAPRF | IM_PROFIL | |||
THPROFILE | Profile for the hierarchy graphic in time scheduling | THPROFILE | CHAR | 12 | TCTH | THPROFILE | |||
SCPRF | Profile for WBS scheduling | PS_SCHDPRF | CHAR | 12 | TCXPS | PS_SCHDPRF | |||
CLALL | Classify all WBS elements | PS_CLPRALL | CHAR | 1 | XFELD | ||||
CLFAK | Classify billing elements | PS_CLPRFAK | CHAR | 1 | XFELD | ||||
CLKNT | Classify account assignment elements | PS_CLPRKNT | CHAR | 1 | XFELD | ||||
VSPRF | Version profile | VER_PROFIL | CHAR | 7 | TCN51 | VER_PROFIL | |||
FMPRF | Payment plan profile | PSFM_PRF | CHAR | 6 | TBP1C | BP_PROFIL | BP1 | ||
LSTKP | List profile for capacity evaluations in proj. planning brd. | PS_LSTKP | CHAR | 10 | TCY30 | CY_PROFIL | |||
EINGE | Individual capacities: Overall profile for planning table | PS_EINGE | CHAR | 10 | TCY30 | CY_PROFIL | |||
EINTE | Indiv. capacities: Overall profile for tab. planning table | PS_EINTE | CHAR | 10 | TCY30 | CY_PROFIL | |||
PPROF | Planning profile | BP_PPROFIL | CHAR | 6 | TBP1C | BP_PROFIL | BP1 | ||
PLINT | Indicator for Integrated Planning | PLINT | CHAR | 1 | XFELD | ||||
RESZ1 | Residence Time 1 (Calendar Months) | RESZ1 | NUMC | 3 | NUMC3 | ||||
RESZ2 | Residence Time 2 (Calendar Months) | RESZ2 | NUMC | 3 | NUMC3 | ||||
GRVST | WBS hierarchy graphic, vertical arrangement from level | PS_GRSTV | NUMC | 3 | NUM3 | ||||
XROOT | Indicator: WBS can only have one WBS element with level 1 | PS_1ROOT | CHAR | 1 | XFELD | ||||
VALID | Validation | VALID | CHAR | 7 | GB93 | VALIDATION | |||
VALID_PSP | Validation | VALID | CHAR | 7 | GB93 | VALIDATION | |||
AUTOVAL | 'Automatic validation' indicator | AUTOVAL | CHAR | 1 | XFELD | ||||
SUBST | Substitution name | SUBST_ID | CHAR | 7 | GB92 | SUBSTID | GBU | ||
SUBST_PSP | Substitution name | SUBST_ID | CHAR | 7 | GB92 | SUBSTID | GBU | ||
AUTOSUB | 'Automatic substitution' indicator | AUTOSUB | CHAR | 1 | XFELD | ||||
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
SMPRF | Simulation profile | SIM_PROFIL | CHAR | 7 | TCN54 | SIM_PROFIL | |||
HY_SEARCH1 | Number of the first text used for the search. | CN_SEARCH1 | CHAR | 2 | VCTCENTRY | ||||
HY_SEARCH2 | Number of the second text used for the search. | CN_SEARCH2 | CHAR | 2 | VCTCENTRY | ||||
HY_SEARCH3 | Number of the third text used for the search. | CN_SEARCH3 | CHAR | 2 | VCTCENTRY | ||||
FLGVRG | Indicator: Bottom-up calculation with activity dates | PS_FLGVRG | CHAR | 1 | PS_FLGVRG | ||||
GRTOP | Indicator: Automatic requirements grouping | GRONTOP | CHAR | 1 | XFELD | ||||
PGPRF | Distribution profile | PGPROFID | CHAR | 6 | TPGPRF | PGPROFID | |||
KZERB | Indicator: Project summarization via master data charact. | PS_KZERB | CHAR | 1 | XFELD | ||||
STRAT | Strategy for determining settlement rule in WBS element | PS_STRAT | CHAR | 2 | TSR0E | PS_STRAT | |||
PARGR | Partner Determination Procedure | PARGR | CHAR | 4 | V_TVPG_S | PARGR | |||
SCHTYP | Scheduling scenario | PS_SCHED_TYPE | CHAR | 1 | PS_SCHED_TYPE | ||||
FUNC_AREA | Functional Area | FKBER | CHAR | 16 | TFKB | FKBER | FBE | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVKOV | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | TVTA | SPART | SPA | C_SPART | |
DPPPROF | Dynamic Item Processor Profile | AD01PROFNR | CHAR | 8 | AD01C_PROF | AD01PROFNR | AD0 | DIP_PROFILE | |
VPKSTU | Node level | SEU_LEVEL | NUMC | 2 | SEU_LEVEL | ||||
EXEC_PROFILE | Execution Services Profile | CK_EXPROFILE | CHAR | 4 | TEE000 | CK_EXPROFILE | |||
IPPS | iPPE Relationship with a Project | PS_IPPS | CHAR | 1 | XFELD | ||||
PSACL | ACL tab activated for project and network profile | PS_ACL_DELE | CHAR | 1 | XFELD | ||||
PSACLH | ACL tab activated for project and network profile | PS_ACLH_DELE | CHAR | 1 | XFELD | ||||
TEMPLATE_KEY | Standard text key | KTSCH | CHAR | 7 | Assigned to domain | KTSCH |
Key field | Non-key field |
How do I retrieve data from SAP table TCJ41 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TCJ41 to SELECT all data from the tableDATA: WA_TCJ41 TYPE TCJ41.
SELECT SINGLE *
FROM TCJ41
INTO CORRESPONDING FIELDS OF WA_TCJ41
WHERE...
How to access SAP table TCJ41
Within an ECC or HANA version of SAP you can also view further information about TCJ41 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects