SAP Table CNMASS_WBS_ELEMENT

Mass changes for WBS elements

CNMASS_WBS_ELEMENT (Mass changes for WBS elements) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CNMASS_WBS_ELEMENT to other SAP tables.

CNMASS_WBS_ELEMENT table fields

Field Data element Checktable Datatype Length Decimals
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
PROJECT_DEFINITION Project Definition PS_PSPID CHAR 24 0
DESCRIPTION PS: Short description (1st text line) PS_POST1 CHAR 40 0
SHORT_ID WBS element short identification PS_POSKI CHAR 16 0
RESPONSIBLE_NO Number of the responsible person (project manager) PS_VERNR TCJ04 NUMC 8 0
APPLICANT_NO Applicant number PS_ASTNR TCJ05 NUMC 8 0
COMP_CODE Company Code BUKRS T001 CHAR 4 0
BUS_AREA Business Area GSBER TGSB CHAR 4 0
CO_AREA Controlling Area KOKRS TKA01 CHAR 4 0
PROFIT_CTR Profit Center PRCTR CEPC CHAR 10 0
PROJ_TYPE Project type PS_PRART TCJ1 CHAR 2 0
NETWORK_ASSIGNMENT Network assignment PS_ZUORD NUMC 1 0
1 For project definition
2 For WBS element
COSTING_SHEET Costing Sheet AUFKALSM T683 CHAR 6 0
OVERHEAD_KEY Overhead key AUFZSCHL TKZSL CHAR 6 0
CALENDAR Factory calendar key FABKL TFACD CHAR 2 0
PRIORITY Priority NW_PRIO TCN07 CHAR 1 0
EQUIPMENT Equipment Number EQUNR EQUI CHAR 18 0
FUNCTIONAL_LOCATION Functional Location TPLNR IFLOT CHAR 30 0
CURRENCY Currency Key CURRENCY TCURC CUKY 5 0
CURRENCY_ISO ISO currency code ISOCD CHAR 3 0
PLANT Plant WERKS_D T001W CHAR 4 0
USER_FIELD_KEY Key word ID for user-defined fields SLWID TCN00 CHAR 7 0
USER_FIELD_CHAR20_1 1st user field for 20 characters - WBS element- USR00PRPS CHAR 20 0
USER_FIELD_CHAR20_2 2nd user field 20 digits - WBS element USR01PRPS CHAR 20 0
USER_FIELD_CHAR10_1 3rd user-defined field 10 digits -WBS element USR02PRPS CHAR 10 0
USER_FIELD_CHAR10_2 4th user-defined field 10 digits -WBS element USR03PRPS CHAR 10 0
USER_FIELD_QUAN1 1st user-defined field for quantity(length 10,3) WBS element USR04PRPS QUAN 13 3
USER_FIELD_UNIT1 1st user defined field for quantity field unit - WBS element USE04PRPS UNIT 3 0
USER_FIELD_UNIT1_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
USER_FIELD_QUAN2 2nd use field for quantity (length 10,3) WBS element USR05PRPS QUAN 13 3
USER_FIELD_UNIT2 2nd user defined field for quantity field unit - WBS element USE05PRPS UNIT 3 0
USER_FIELD_UNIT2_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
USER_FIELD_CURR1 1st user field for values (length 10,3) WBS element USR06PRPS CURR 13 3
USER_FIELD_CUKY1 1st user defined field for value field unit - WBS element USE06PRPS CUKY 5 0
USER_FIELD_CUKY1_ISO ISO currency code ISOCD CHAR 3 0
USER_FIELD_CURR2 2nd user field for values (length 10,3) -WBS element USR07PRPS CURR 13 3
USER_FIELD_CUKY2 2nd user defined field for value field unit - WBS element USE07PRPS CUKY 5 0
USER_FIELD_CUKY2_ISO ISO currency code ISOCD CHAR 3 0
USER_FIELD_DATE1 1st user field for date -WBS element USR08PRPS DATS 8 0
USER_FIELD_DATE2 2nd user field for date -WBS element USR09PRPS DATS 8 0
USER_FIELD_FLAG1 1st user field for 'Ind. for evaluations' WBS elem. USR10PRPS CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
USER_FIELD_FLAG2 2nd user field for 'Indicator for eval.s' WBS elemnt USR11PRPS CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
OBJECTCLASS Object Class SCOPE_CV CHAR 2 0
OC Overhead costs
IV Investment
PR Production
PA Profit analysis
STATISTICAL Statistical WBS element PS_XSTAT CHAR 1 0
X Yes
NULL No
TAXJURCODE Tax Jurisdiction TXJCD TTXJ CHAR 15 0
INT_PROFILE Interest Profile for Project/Order Interest Calculation PS_ZSCHM TPI01 CHAR 7 0
JOINT_VENTURE Joint Venture JV_NAME T8JV CHAR 6 0
RECOVERY_IND Recovery Indicator JV_RECIND T8JJ CHAR 2 0
EQUITY_TYPE Equity type JV_ETYPE T8JE CHAR 3 0
JV_OBJECT_TYPE Joint Venture Object Type JV_OTYPE CHAR 4 0
JV_JIB_CLASS JIB/JIBE Class JV_JIBCL T8J6A CHAR 3 0
JV_JIB_SUB_CLASS_A JIB/JIBE Subclass A JV_JIBSA T8J6C CHAR 5 0
OBJECTCLASS_EXT Object class, language-dependent SCOPE_LD CHAR 5 0
WBS_PLANNING_ELEMENT Indicator: Planning element PS_PLAKZ CHAR 1 0
X Yes
NULL No
WBS_ACCOUNT_ASSIGNMENT_ELEMENT Indicator: Account assignment element PS_BELKZ CHAR 1 0
X Yes
NULL No
WBS_BILLING_ELEMENT Indicator: Billing element PS_FAKKZ CHAR 1 0
X Yes
NULL No
RESPSBL_CCTR Responsible cost center PS_FKSTL CSKS CHAR 10 0
RESPSBL_CCTR_CONTROLLING_AREA Controlling area of responsible cost center PS_FKOKR TKA01 CHAR 4 0
REQUEST_CCTR Requesting cost center PS_AKSTL CSKS CHAR 10 0
REQUEST_COMP_CODE Requesting company code IM_ABUKRS T001 CHAR 4 0
REQUEST_CCTR_CONTROLLING_AREA Controlling area of requesting cost center PS_AKOKR TKA01 CHAR 4 0
LOCATION Location PS_STORT T499S CHAR 10 0
CHANGE_NO Change Number AENNR AENR CHAR 12 0
INVEST_PROFILE Investment measure profile IM_PROFIL TAPRF CHAR 6 0
RES_ANAL_KEY Results Analysis Key ABGR_SCHL TKKAA CHAR 6 0
WBS_CCTR_POSTED_ACTUAL Cost center to which costs are actually posted PS_KOSTL CSKS CHAR 10 0
WBS_BASIC_START_DATE WBS element: Basic start date PS_PSTRT DATS 8 0
WBS_BASIC_FINISH_DATE WBS element: Basic finish date PS_PENDE DATS 8 0
WBS_FORECAST_START_DATE Forecasted start date of the WBS element PS_ESTRT DATS 8 0
WBS_FORECAST_FINISH_DATE Forecasted finish date of the WBS element PS_EENDE DATS 8 0
WBS_ACTUAL_START_DATE Actual start date for the WBS element PS_ISTRT DATS 8 0
WBS_ACTUAL_FINISH_DATE Actual finish date of the WBS element PS_IENDE DATS 8 0
WBS_BASIC_DURATION Length (duration) of the basic dates in the WBS element PS_PDAUR QUAN 5 1
WBS_BASIC_DUR_UNIT Unit for duration of basic WBS element dates PS_PEINH UNIT 3 0
WBS_BASIC_DUR_UNIT_ISO ISO code for unit of measurement ISOCD_UNIT T006I CHAR 3 0
WBS_FORECAST_DURATION Forecasted length (duration) of the WBS element PS_EDAUR QUAN 5 1
WBS_FORCAST_DUR_UNIT Unit for duration of WBS element planned dates PS_EEINH UNIT 3 0
WBS_FORECAST_DUR_UNIT_ISO ISO code for unit of measurement ISOCD_UNIT T006I CHAR 3 0
WBS_ACTUAL_DURATION Actual length (duration) of the WBS element PS_IDAUR QUAN 5 1
WBS_ACTUAL_DUR_UNIT Unit for duration of actual WBS element dates PS_IEINH UNIT 3 0
WBS_ACTUAL_DUR_UNIT_ISO ISO code for unit of measurement ISOCD_UNIT T006I CHAR 3 0
FUNC_AREA Functional Area FKBER_SHORT CHAR 4 0
FUNC_AREA_LONG Functional Area FKBER CHAR 16 0
RELEASE Indicator: Object is being or has been released PS_RELEASE CHAR 1 0
X Yes
NULL No
LOCK Indicator: Object is being or has been locked PS_LOCK CHAR 1 0
X Yes
NULL No
TECH_COMPLETE Indicator: Object is being or has been technically completed PS_TECH_COMPLETE CHAR 1 0
X Yes
NULL No
DELETE Indicator: Deletion flag has been set PS_DELETE CHAR 1 0
X Yes
NULL No

CNMASS_WBS_ELEMENT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CNMASS_WBS_ELEMENT APPLICANT_NO SY MANDT TCJ05 Project applicant MANDT
CNMASS_WBS_ELEMENT APPLICANT_NO CNMASS_WBS_ELEMENT APPLICANT_NO TCJ05 Project applicant ASTNR
CNMASS_WBS_ELEMENT BUS_AREA SY MANDT TGSB Business Areas MANDT
CNMASS_WBS_ELEMENT BUS_AREA CNMASS_WBS_ELEMENT BUS_AREA TGSB Business Areas GSBER
CNMASS_WBS_ELEMENT CALENDAR CNMASS_WBS_ELEMENT CALENDAR TFACD Factory calendar definition IDENT
CNMASS_WBS_ELEMENT CHANGE_NO SYST MANDT AENR Change Master MANDT
CNMASS_WBS_ELEMENT CHANGE_NO CNMASS_WBS_ELEMENT CHANGE_NO AENR Change Master AENNR
CNMASS_WBS_ELEMENT COMP_CODE SY MANDT T001 Company Codes MANDT
CNMASS_WBS_ELEMENT COMP_CODE CNMASS_WBS_ELEMENT COMP_CODE T001 Company Codes BUKRS
CNMASS_WBS_ELEMENT COSTING_SHEET * T683 Pricing procedures MANDT
CNMASS_WBS_ELEMENT COSTING_SHEET * T683 Pricing procedures KVEWE
CNMASS_WBS_ELEMENT COSTING_SHEET * T683 Pricing procedures KAPPL
CNMASS_WBS_ELEMENT COSTING_SHEET CNMASS_WBS_ELEMENT COSTING_SHEET T683 Pricing procedures KALSM
CNMASS_WBS_ELEMENT CO_AREA SY MANDT TKA01 Controlling Areas MANDT
CNMASS_WBS_ELEMENT CO_AREA CNMASS_WBS_ELEMENT CO_AREA TKA01 Controlling Areas KOKRS
CNMASS_WBS_ELEMENT CURRENCY SY MANDT TCURC Currency Codes MANDT
CNMASS_WBS_ELEMENT CURRENCY CNMASS_WBS_ELEMENT CURRENCY TCURC Currency Codes WAERS
CNMASS_WBS_ELEMENT EQUIPMENT SY MANDT EQUI Equipment master data MANDT
CNMASS_WBS_ELEMENT EQUIPMENT CNMASS_WBS_ELEMENT EQUIPMENT EQUI Equipment master data EQUNR
CNMASS_WBS_ELEMENT EQUITY_TYPE * T8JE Investment Type MANDT
CNMASS_WBS_ELEMENT EQUITY_TYPE CNMASS_WBS_ELEMENT COMP_CODE T8JE Investment Type BUKRS
CNMASS_WBS_ELEMENT EQUITY_TYPE CNMASS_WBS_ELEMENT EQUITY_TYPE T8JE Investment Type ETYPE
CNMASS_WBS_ELEMENT FUNCTIONAL_LOCATION SY MANDT IFLOT Functional Location (Table) MANDT
CNMASS_WBS_ELEMENT FUNCTIONAL_LOCATION CNMASS_WBS_ELEMENT FUNCTIONAL_LOCATION IFLOT Functional Location (Table) TPLNR
CNMASS_WBS_ELEMENT INT_PROFILE * TPI01 Interest Profile MANDT
CNMASS_WBS_ELEMENT INT_PROFILE CNMASS_WBS_ELEMENT INT_PROFILE TPI01 Interest Profile ZSCHM
CNMASS_WBS_ELEMENT INVEST_PROFILE CNMASS_WBS_ELEMENT INVEST_PROFILE TAPRF Cap. inv. measure profile for AuC and dep. simulation IVPRO
CNMASS_WBS_ELEMENT INVEST_PROFILE SYST MANDT TAPRF Cap. inv. measure profile for AuC and dep. simulation MANDT
CNMASS_WBS_ELEMENT JOINT_VENTURE * T8JV Joint Venture MANDT
CNMASS_WBS_ELEMENT JOINT_VENTURE CNMASS_WBS_ELEMENT COMP_CODE T8JV Joint Venture BUKRS
CNMASS_WBS_ELEMENT JOINT_VENTURE CNMASS_WBS_ELEMENT JOINT_VENTURE T8JV Joint Venture VNAME
CNMASS_WBS_ELEMENT JV_JIB_CLASS CNMASS_WBS_ELEMENT COMP_CODE T8J6A JIB/JIBE Class BUKRS
CNMASS_WBS_ELEMENT JV_JIB_CLASS CNMASS_WBS_ELEMENT JV_JIB_CLASS T8J6A JIB/JIBE Class CLASS
CNMASS_WBS_ELEMENT JV_JIB_CLASS * T8J6A JIB/JIBE Class MANDT
CNMASS_WBS_ELEMENT JV_JIB_SUB_CLASS_A CNMASS_WBS_ELEMENT JV_JIB_SUB_CLASS_A T8J6C JIB/JIBE Subclass SUBCLASS
CNMASS_WBS_ELEMENT JV_JIB_SUB_CLASS_A * T8J6C JIB/JIBE Subclass MANDT
CNMASS_WBS_ELEMENT JV_JIB_SUB_CLASS_A CNMASS_WBS_ELEMENT COMP_CODE T8J6C JIB/JIBE Subclass BUKRS
CNMASS_WBS_ELEMENT JV_JIB_SUB_CLASS_A CNMASS_WBS_ELEMENT JV_JIB_CLASS T8J6C JIB/JIBE Subclass CLASS
CNMASS_WBS_ELEMENT LOCATION CNMASS_WBS_ELEMENT LOCATION T499S Location STAND
CNMASS_WBS_ELEMENT LOCATION SYST MANDT T499S Location MANDT
CNMASS_WBS_ELEMENT LOCATION CNMASS_WBS_ELEMENT PLANT T499S Location WERKS
CNMASS_WBS_ELEMENT OVERHEAD_KEY SYST MANDT TKZSL Overhead Key MANDT
CNMASS_WBS_ELEMENT OVERHEAD_KEY CNMASS_WBS_ELEMENT OVERHEAD_KEY TKZSL Overhead Key ZSCHL
CNMASS_WBS_ELEMENT PLANT SY MANDT T001W Plants/Branches MANDT
CNMASS_WBS_ELEMENT PLANT CNMASS_WBS_ELEMENT PLANT T001W Plants/Branches WERKS
CNMASS_WBS_ELEMENT PRIORITY CNMASS_WBS_ELEMENT PRIORITY TCN07 Priority NPRIO
CNMASS_WBS_ELEMENT PRIORITY SY MANDT TCN07 Priority MANDT
CNMASS_WBS_ELEMENT PROFIT_CTR * CEPC Profit Center Master Data Table DATBI
CNMASS_WBS_ELEMENT PROFIT_CTR * CEPC Profit Center Master Data Table KOKRS
CNMASS_WBS_ELEMENT PROFIT_CTR SY MANDT CEPC Profit Center Master Data Table MANDT
CNMASS_WBS_ELEMENT PROFIT_CTR CNMASS_WBS_ELEMENT PROFIT_CTR CEPC Profit Center Master Data Table PRCTR
CNMASS_WBS_ELEMENT PROJ_TYPE SY MANDT TCJ1 "Project Types" MANDT
CNMASS_WBS_ELEMENT PROJ_TYPE CNMASS_WBS_ELEMENT PROJ_TYPE TCJ1 "Project Types" PRART
CNMASS_WBS_ELEMENT RECOVERY_IND CNMASS_WBS_ELEMENT COMP_CODE T8JJ Recovery Indicator BUKRS
CNMASS_WBS_ELEMENT RECOVERY_IND CNMASS_WBS_ELEMENT RECOVERY_IND T8JJ Recovery Indicator RECID
CNMASS_WBS_ELEMENT RECOVERY_IND * T8JJ Recovery Indicator MANDT
CNMASS_WBS_ELEMENT REQUEST_CCTR SYST MANDT CSKS Cost Center Master Data MANDT
CNMASS_WBS_ELEMENT REQUEST_CCTR CNMASS_WBS_ELEMENT CO_AREA CSKS Cost Center Master Data KOKRS
CNMASS_WBS_ELEMENT REQUEST_CCTR CNMASS_WBS_ELEMENT REQUEST_CCTR CSKS Cost Center Master Data KOSTL
CNMASS_WBS_ELEMENT REQUEST_CCTR * CSKS Cost Center Master Data DATBI
CNMASS_WBS_ELEMENT REQUEST_CCTR_CONTROLLING_AREA SYST MANDT TKA01 Controlling Areas MANDT
CNMASS_WBS_ELEMENT REQUEST_CCTR_CONTROLLING_AREA CNMASS_WBS_ELEMENT REQUEST_CCTR_CONTROLLING_AREA TKA01 Controlling Areas KOKRS
CNMASS_WBS_ELEMENT REQUEST_COMP_CODE SYST MANDT T001 Company Codes MANDT
CNMASS_WBS_ELEMENT REQUEST_COMP_CODE CNMASS_WBS_ELEMENT REQUEST_COMP_CODE T001 Company Codes BUKRS
CNMASS_WBS_ELEMENT RESPONSIBLE_NO SY MANDT TCJ04 Person in Responsible for Project MANDT
CNMASS_WBS_ELEMENT RESPONSIBLE_NO CNMASS_WBS_ELEMENT RESPONSIBLE_NO TCJ04 Person in Responsible for Project VERNR
CNMASS_WBS_ELEMENT RESPSBL_CCTR SYST MANDT CSKS Cost Center Master Data MANDT
CNMASS_WBS_ELEMENT RESPSBL_CCTR CNMASS_WBS_ELEMENT CO_AREA CSKS Cost Center Master Data KOKRS
CNMASS_WBS_ELEMENT RESPSBL_CCTR CNMASS_WBS_ELEMENT RESPSBL_CCTR CSKS Cost Center Master Data KOSTL
CNMASS_WBS_ELEMENT RESPSBL_CCTR * CSKS Cost Center Master Data DATBI
CNMASS_WBS_ELEMENT RESPSBL_CCTR_CONTROLLING_AREA CNMASS_WBS_ELEMENT RESPSBL_CCTR_CONTROLLING_AREA TKA01 Controlling Areas KOKRS
CNMASS_WBS_ELEMENT RESPSBL_CCTR_CONTROLLING_AREA SYST MANDT TKA01 Controlling Areas MANDT
CNMASS_WBS_ELEMENT RES_ANAL_KEY SYST MANDT TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
CNMASS_WBS_ELEMENT RES_ANAL_KEY CNMASS_WBS_ELEMENT RES_ANAL_KEY TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
CNMASS_WBS_ELEMENT TAXJURCODE * TTXJ Check Table for Tax Jurisdiction MANDT
CNMASS_WBS_ELEMENT TAXJURCODE CNMASS_WBS_ELEMENT COSTING_SHEET TTXJ Check Table for Tax Jurisdiction KALSM
CNMASS_WBS_ELEMENT TAXJURCODE CNMASS_WBS_ELEMENT TAXJURCODE TTXJ Check Table for Tax Jurisdiction TXJCD
CNMASS_WBS_ELEMENT USER_FIELD_KEY * TCN00 Key Word ID for PS User Fields MANDT
CNMASS_WBS_ELEMENT USER_FIELD_KEY CNMASS_WBS_ELEMENT USER_FIELD_KEY TCN00 Key Word ID for PS User Fields SLWID
CNMASS_WBS_ELEMENT WBS_ACTUAL_DUR_UNIT_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
CNMASS_WBS_ELEMENT WBS_ACTUAL_DUR_UNIT_ISO CNMASS_WBS_ELEMENT WBS_ACTUAL_DUR_UNIT_ISO T006I ISO codes for units of measurement ISOCODE
CNMASS_WBS_ELEMENT WBS_BASIC_DUR_UNIT_ISO CNMASS_WBS_ELEMENT WBS_BASIC_DUR_UNIT_ISO T006I ISO codes for units of measurement ISOCODE
CNMASS_WBS_ELEMENT WBS_BASIC_DUR_UNIT_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
CNMASS_WBS_ELEMENT WBS_CCTR_POSTED_ACTUAL CNMASS_WBS_ELEMENT CO_AREA CSKS Cost Center Master Data KOKRS
CNMASS_WBS_ELEMENT WBS_CCTR_POSTED_ACTUAL CNMASS_WBS_ELEMENT WBS_CCTR_POSTED_ACTUAL CSKS Cost Center Master Data KOSTL
CNMASS_WBS_ELEMENT WBS_CCTR_POSTED_ACTUAL * CSKS Cost Center Master Data DATBI
CNMASS_WBS_ELEMENT WBS_CCTR_POSTED_ACTUAL SYST MANDT CSKS Cost Center Master Data MANDT
CNMASS_WBS_ELEMENT WBS_FORECAST_DUR_UNIT_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
CNMASS_WBS_ELEMENT WBS_FORECAST_DUR_UNIT_ISO CNMASS_WBS_ELEMENT WBS_FORECAST_DUR_UNIT_ISO T006I ISO codes for units of measurement ISOCODE