SAP table TCJ41 (Default Values for Work Breakdown Structure)

SAP table TCJ41 has 2 primary key fields being MANDT,PROFIDPROJ.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PROFIDPROJ Project Profile CHAR 7 0 PROFIDPROJ
WERKS Plant CHAR 4 0 T001W WERKS_D
KALID Factory calendar key CHAR 2 0 TFACD FABKL
VGPLF Planning method for project basic dates NUMC 1 0 PS_VGPLF
EWPLF Planning method for project forecast dates NUMC 1 0 PS_EWPLF
PLNAW Application of the task list CHAR 1 0 TCA09 PLNAW
VPROF Network Profile CHAR 7 0 TCN41 PROFIDNZPL
NZANZ Indicator: Network header visible to end user CHAR 1 0 NETZOBERFL
IDENT Display options for WBS elements CHAR 1 0 PS_IDENTKZ
1 Identification using project number
2 Identification using short description
3 Identification using text
ABGSL Results Analysis Key CHAR 6 0 TKKAA ABGR_SCHL
LEVELS Hierarchy structure: Level of detail INT1 3 0 PS_LEVEL
ZUORD Network assignment NUMC 1 0 PS_ZUORD
1 For project definition
2 For WBS element
TRMEQ Indicator: WBS dates detailed by activity dates CHAR 1 0 PS_TRMEQ
STSPD Status profile for project definition CHAR 8 0 TJ20 PS_STSPD
STSPR Status profile for WBS element CHAR 8 0 TJ20 PS_STSPR
KVEWE Usage of the condition table CHAR 1 0 T681V KVEWE
KAPPL Application CHAR 2 0 T681A KAPPL
KALSM Costing Sheet CHAR 6 0 T683 AUFKALSM
ZSCHL Overhead key CHAR 6 0 AUFZSCHL
APROF Settlement profile CHAR 6 0 TKB1A PS_APROF
APRFE Revenue settlement profile CHAR 6 0 TKB1A PS_APRFE
GRPGS Master data: Profile group hierarchy graphic CHAR 4 0 PS_GRGRUPS
GRPFS Master data: Hierarchy graphic profile name CHAR 12 0 PS_GRPROFS
GRPGT Time scheduling: Profile group hierarchy graphic CHAR 4 0 PS_GRGRUPT
GRPFT Time scheduling: Hierarchy graphic profile name CHAR 12 0 PS_GRPROFT
GRPGB Budget/cost planning: Profile group hierarchy graphic CHAR 4 0 PS_GRGRUPB
GRPFB Budget/cost planning: Profile name hierarchy graphic CHAR 12 0 PS_GRPROFB
BERST Authorization key for project master data CHAR 16 0 PS_BERST
BERTR Authorization key for project dates (WBS) CHAR 16 0 PS_BERTR
BERKO Authorization key for costs and revenues CHAR 16 0 PS_BERKO
BERBU Authorization key for project budget CHAR 16 0 PS_BERBU
SLWID Key word ID for user-defined fields CHAR 7 0 TCN00 SLWID
AUTOD Automatic value transfer from WBS element to project def. CHAR 1 0 PS_AUTOD
BPROF Budget Profile CHAR 6 0 TBP1C BP_BPROFIL
ZTEHT Time unit in time scheduling UNIT 3 0 T006 PS_ZTEHT
ALL_ACC Indicator: All WBS elements are account assignment elements CHAR 1 0 PS_ALLACC
ALL_ACT Indicator: Read project with activities CHAR 1 0 PS_ALL_ACT
BUKRS Company code for the project CHAR 4 0 T001 PS_VBUKR
GSBER Business area for the project CHAR 4 0 TGSB PS_VGSBR
KOKRS Controlling area for the project CHAR 4 0 TKA01 PS_VKOKR
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
WAERS WBS currency (project definition) CUKY 5 0 TCURC PS_PWHIE
CHGKZ Indicator: Status change documents CHAR 1 0 PROJCHGKZ
BESTA Project stock CHAR 1 0 PS_BESTAND
SCOPE Object Class CHAR 2 0 SCOPE_CV
IV Investment
OC Overhead costs
PA Profit analysis
PR Production
XSTAT Statistical WBS element CHAR 1 0 PS_XSTAT
AEBLG Change document creation allowed CHAR 1 0 PS_AEBLG
PRART Project Type CHAR 2 0 TCJ1 PS_PRART
BPPROFL Profile for project planning board CHAR 12 0 TCBP BPPROFILE
ZSCHM Interest Profile for Project/Order Interest Calculation CHAR 7 0 TPI01 PS_ZSCHM
EINGR Capacity load profile in graphical planning table CHAR 10 0 TCY30 PS_EINGR
EINTB Capacity load profile for tabular planning table CHAR 10 0 TCY30 PS_EINTB
IMPRF Investment Measure Profile CHAR 6 0 TAPRF IM_PROFIL
THPROFILE Profile for the hierarchy graphic in time scheduling CHAR 12 0 TCTH THPROFILE
SCPRF Profile for WBS scheduling CHAR 12 0 TCXPS PS_SCHDPRF
CLALL Classify all WBS elements CHAR 1 0 PS_CLPRALL
CLFAK Classify billing elements CHAR 1 0 PS_CLPRFAK
CLKNT Classify account assignment elements CHAR 1 0 PS_CLPRKNT
VSPRF Version profile CHAR 7 0 TCN51 VER_PROFIL
FMPRF Payment plan profile CHAR 6 0 TBP1C PSFM_PRF
LSTKP List profile for capacity evaluations in proj. planning brd. CHAR 10 0 TCY30 PS_LSTKP
EINGE Individual capacities: Overall profile for planning table CHAR 10 0 TCY30 PS_EINGE
EINTE Indiv. capacities: Overall profile for tab. planning table CHAR 10 0 TCY30 PS_EINTE
PPROF Planning Profile CHAR 6 0 TBP1C BP_PPROFIL
PLINT Indicator for Integrated Planning CHAR 1 0 PLINT
RESZ1 Residence Time 1 (Calendar Months) NUMC 3 0 RESZ1
RESZ2 Residence Time 2 (Calendar Months) NUMC 3 0 RESZ2
GRVST WBS hierarchy graphic, vertical arrangement from level NUMC 3 0 PS_GRSTV
XROOT Indicator: WBS can only have one WBS element with level 1 CHAR 1 0 PS_1ROOT
VALID Validation CHAR 7 0 GB93 VALID
VALID_PSP Validation CHAR 7 0 GB93 VALID
AUTOVAL 'Automatic validation' indicator CHAR 1 0 AUTOVAL
SUBST Substitution Name CHAR 7 0 GB92 SUBST_ID
SUBST_PSP Substitution Name CHAR 7 0 GB92 SUBST_ID
AUTOSUB 'Automatic substitution' indicator CHAR 1 0 AUTOSUB
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
SMPRF Simulation profile CHAR 7 0 TCN54 SIM_PROFIL
HY_SEARCH1 Number of the first text used for the search. CHAR 2 0 CN_SEARCH1
HY_SEARCH2 Number of the second text used for the search. CHAR 2 0 CN_SEARCH2
HY_SEARCH3 Number of the third text used for the search. CHAR 2 0 CN_SEARCH3
FLGVRG Indicator: Bottom-up calculation with activity dates CHAR 1 0 PS_FLGVRG
without taking activity dates into consideration
1 taking activity dates into consideration
2 Consideration of activity dates by user decision
GRTOP Indicator: Automatic requirements grouping CHAR 1 0 GRONTOP
PGPRF Distribution profile CHAR 6 0 TPGPRF PGPROFID
KZERB Indicator: Project summarization via master data charact. CHAR 1 0 PS_KZERB
STRAT Strategy for determining settlement rule in WBS element CHAR 2 0 TSR0E PS_STRAT
PARGR Partner Determination Procedure CHAR 4 0 V_TVPG_S PARGR
SCHTYP Scheduling scenario CHAR 1 0 PS_SCHED_TYPE
Free scheduling
1 Bottom-up scenario (pre-defined)
2 Top-down scenario (pre-defined)
FUNC_AREA Functional Area CHAR 16 0 TFKB FKBER
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVKOV VTWEG
SPART Division CHAR 2 0 TVTA SPART
DPPPROF Dynamic Item Processor Profile CHAR 8 0 AD01C_PROF AD01PROFNR
VPKSTU Node level NUMC 2 0 SEU_LEVEL
EXEC_PROFILE Execution Services Profile CHAR 4 0 TEE000 CK_EXPROFILE
IPPS iPPE Relationship with a Project CHAR 1 0 PS_IPPS
PSACL ACL tab activated for project and network profile CHAR 1 0 PS_ACL_DELE
PSACLH ACL tab activated for project and network profile CHAR 1 0 PS_ACLH_DELE
TEMPLATE_KEY Standard Text Key CHAR 7 0 KTSCH
SLWID_PROJ Key word ID for user-defined fields CHAR 7 0 TCN00 SLWID

TCJ41 foreign key relationships

Table Field Check Table Check Field
0 TCJ41 ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
0 TCJ41 ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
1 TCJ41 APRFE TKB1A Settlement Profile MANDT
1 TCJ41 APRFE TKB1A Settlement Profile APROF
0 TCJ41 APROF TKB1A Settlement Profile MANDT
0 TCJ41 APROF TKB1A Settlement Profile APROF
1 TCJ41 BPPROFL TCBP Gantt chart settings MANDT
1 TCJ41 BPPROFL TCBP Gantt chart settings PROFILE
0 TCJ41 BPROF TBP1C Budget/Plan Profile MANDT
0 TCJ41 BPROF TBP1C Budget/Plan Profile PROFIL
0 TCJ41 BPROF TBP1C Budget/Plan Profile APPLIK
0 TCJ41 BPROF TBP1C Budget/Plan Profile WRTTP
1 TCJ41 BUKRS T001 Company Codes BUKRS
0 TCJ41 DPPPROF AD01C_PROF DIP profile: Usage MANDT
0 TCJ41 DPPPROF AD01C_PROF DIP profile: Usage PROFNR
1 TCJ41 EINGE TCY30 Overall profile for capacity leveling MANDT
1 TCJ41 EINGE TCY30 Overall profile for capacity leveling PROFILE_ID
0 TCJ41 EINGR TCY30 Overall profile for capacity leveling MANDT
0 TCJ41 EINGR TCY30 Overall profile for capacity leveling PROFILE_ID
1 TCJ41 EINTB TCY30 Overall profile for capacity leveling MANDT
1 TCJ41 EINTB TCY30 Overall profile for capacity leveling PROFILE_ID
0 TCJ41 EINTE TCY30 Overall profile for capacity leveling MANDT
0 TCJ41 EINTE TCY30 Overall profile for capacity leveling PROFILE_ID
1 TCJ41 EXEC_PROFILE TEE000 Easy Execution Profile MANDT
1 TCJ41 EXEC_PROFILE TEE000 Easy Execution Profile CK_EXPROFILE
0 TCJ41 FMPRF TBP1C Budget/Plan Profile MANDT
0 TCJ41 FMPRF TBP1C Budget/Plan Profile PROFIL
0 TCJ41 FMPRF TBP1C Budget/Plan Profile APPLIK
0 TCJ41 FMPRF TBP1C Budget/Plan Profile WRTTP
1 TCJ41 FUNC_AREA TFKB Functional areas FKBER
0 TCJ41 GSBER TGSB Business Areas MANDT
0 TCJ41 GSBER TGSB Business Areas GSBER
1 TCJ41 IMPRF TAPRF Cap. inv. measure profile for AuC and dep. simulation MANDT
1 TCJ41 IMPRF TAPRF Cap. inv. measure profile for AuC and dep. simulation IVPRO
0 TCJ41 KALSM T683 Pricing procedures KAPPL
0 TCJ41 KALSM T683 Pricing procedures KALSM
1 TCJ41 KAPPL T681A Conditions: Applications KAPPL
0 TCJ41 KOKRS TKA01 Controlling Areas MANDT
1 TCJ41 KVEWE T681V Conditions: Usages KVEWE
0 TCJ41 LSTKP TCY30 Overall profile for capacity leveling MANDT
0 TCJ41 LSTKP TCY30 Overall profile for capacity leveling PROFILE_ID
1 TCJ41 PARGR V_TVPG_S Generated Table for View MANDT
1 TCJ41 PARGR V_TVPG_S Generated Table for View PAOBJ
1 TCJ41 PARGR V_TVPG_S Generated Table for View SPRAS
0 TCJ41 PGPRF TPGPRF Profile for static pegging and data distribution PROFID
1 TCJ41 PLNAW TCA09 Task list applications MANDT
1 TCJ41 PLNAW TCA09 Task list applications PLNAW
0 TCJ41 PPROF TBP1C Budget/Plan Profile MANDT
0 TCJ41 PPROF TBP1C Budget/Plan Profile PROFIL
0 TCJ41 PPROF TBP1C Budget/Plan Profile APPLIK
0 TCJ41 PPROF TBP1C Budget/Plan Profile WRTTP
1 TCJ41 PRART TCJ1 "Project Types" MANDT
1 TCJ41 PRART TCJ1 "Project Types" PRART
0 TCJ41 PRCTR CEPC Profit Center Master Data Table PRCTR
0 TCJ41 PRCTR CEPC Profit Center Master Data Table DATBI
0 TCJ41 PRCTR CEPC Profit Center Master Data Table KOKRS
1 TCJ41 SCPRF TCXPS Control parameters for WBS scheduling MANDT
1 TCJ41 SCPRF TCXPS Control parameters for WBS scheduling PROFIL
0 TCJ41 SLWID TCN00 Key Word ID for PS User Fields MANDT
1 TCJ41 SLWID_PROJ TCN00 Key Word ID for PS User Fields MANDT
0 TCJ41 SMPRF TCN54 Simualtion control MANDT
1 TCJ41 SPART TVTA Organizational Unit: Sales Area(s) MANDT
1 TCJ41 SPART TVTA Organizational Unit: Sales Area(s) VKORG
1 TCJ41 SPART TVTA Organizational Unit: Sales Area(s) VTWEG
1 TCJ41 SPART TVTA Organizational Unit: Sales Area(s) SPART
0 TCJ41 STSPD TJ20 Status profiles MANDT
0 TCJ41 STSPD TJ20 Status profiles STSMA
1 TCJ41 STSPR TJ20 Status profiles MANDT
1 TCJ41 STSPR TJ20 Status profiles STSMA
0 TCJ41 THPROFILE TCTH Settings for hierarchy graphic (schedule maint.) MANDT
0 TCJ41 THPROFILE TCTH Settings for hierarchy graphic (schedule maint.) PROFILE
1 TCJ41 VALID GB93 Validation VALID
0 TCJ41 VALID_PSP GB93 Validation VALID
1 TCJ41 VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 TCJ41 VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 TCJ41 VPROF TCN41 Network Defaults MANDT
0 TCJ41 VPROF TCN41 Network Defaults PLNAW
1 TCJ41 VSPRF TCN51 Version profile for PS versions MANDT
0 TCJ41 VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
0 TCJ41 VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
0 TCJ41 VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
1 TCJ41 WAERS TCURC Currency Codes MANDT
1 TCJ41 WAERS TCURC Currency Codes WAERS
0 TCJ41 WERKS T001W Plants/Branches WERKS
1 TCJ41 ZSCHM TPI01 Interest Profile MANDT
0 TCJ41 ZTEHT T006 Units of Measurement MANDT
0 TCJ41 ZTEHT T006 Units of Measurement MSEHI