SAP Table CNMASS_PROJECT_DEFINITION
Mass changes for project definitions
CNMASS_PROJECT_DEFINITION (Mass changes for project definitions) 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_PROJECT_DEFINITION to other SAP tables.
Source: CNMASS_PROJECT_DEFINITION (Mass changes for project definitions)
CNMASS_PROJECT_DEFINITION table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PROJECT_DEFINITION | Project Definition | PS_PSPID | CHAR | 24 | 0 | |||||||||||
| DESCRIPTION | PS: Short description (1st text line) | PS_POST1 | CHAR | 40 | 0 | |||||||||||
| MASK_ID | Selection mask for WBS element short IDs | PS_KIMSK | CHAR | 24 | 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 | ||||||||||
| CONTROLLING_AREA | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||||||||||
| PROFIT_CTR | Profit Center | PRCTR | CEPC | CHAR | 10 | 0 | ||||||||||
| PROJECT_CURRENCY | WBS currency (project definition) | PS_PWHIE | TCURC | CUKY | 5 | 0 | ||||||||||
| PROJECT_CURRENCY_ISO | ISO currency code | ISOCD | CHAR | 3 | 0 | |||||||||||
| NETWORK_ASSIGNMENT | Network assignment | PS_ZUORD | NUMC | 1 | 0 |
Possible values
|
||||||||||
| START | Project planned start date | PS_PLFAZ | DATS | 8 | 0 | |||||||||||
| FINISH | Project planned finish date | PS_PLSEZ | DATS | 8 | 0 | |||||||||||
| PLANT | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||
| CALENDAR | Factory calendar key | FABKL | TFACD | CHAR | 2 | 0 | ||||||||||
| PLAN_BASIC | Planning method for project basic dates | PS_VGPLF | NUMC | 1 | 0 |
Possible values
|
||||||||||
| PLAN_FCST | Planning method for project forecast dates | PS_EWPLF | NUMC | 1 | 0 |
Possible values
|
||||||||||
| TIME_UNIT | Time unit in time scheduling | PS_ZTEHT | T006 | UNIT | 3 | 0 | ||||||||||
| TIME_UNIT_ISO | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | 0 | |||||||||||
| NETWORK_PROFILE | Network profile | PROFIDNZPL | TCN41 | CHAR | 7 | 0 | ||||||||||
| PROJECT_PROFILE | Project Profile | PROFIDPROJ | TCJ41 | CHAR | 7 | 0 | ||||||||||
| BUDGET_PROFILE | Budget Profile | BP_BPROFIL | TBP1C | CHAR | 6 | 0 | ||||||||||
| PROJECT_STOCK | Project stock | PS_BESTAND | CHAR | 1 | 0 |
Possible values
|
||||||||||
| OBJECTCLASS | Object Class | SCOPE_CV | CHAR | 2 | 0 |
Possible values
|
||||||||||
| STATISTICAL | Statistical WBS element | PS_XSTAT | CHAR | 1 | 0 |
Possible values
|
||||||||||
| TAXJURCODE | Tax Jurisdiction | TXJCD | CHAR | 15 | 0 | |||||||||||
| INT_PROFILE | Interest Profile for Project/Order Interest Calculation | PS_ZSCHM | TPI01 | CHAR | 7 | 0 | ||||||||||
| WBS_SCHED_PROFILE | Profile for WBS scheduling | PS_SCHDPRF | TCXPS | CHAR | 12 | 0 | ||||||||||
| CSH_BDGT_PROFILE | Payment plan profile | PSFM_PRF | TBP1C | CHAR | 6 | 0 | ||||||||||
| PLAN_PROFILE | Planning profile | BP_PPROFIL | TBP1C | CHAR | 6 | 0 | ||||||||||
| JOINT_VENTURE | Joint Venture | JV_NAME | CHAR | 6 | 0 | |||||||||||
| RECOVERY_IND | Recovery Indicator | JV_RECIND | CHAR | 2 | 0 | |||||||||||
| EQUITY_TYPE | Equity type | JV_ETYPE | CHAR | 3 | 0 | |||||||||||
| JV_OBJECT_TYPE | Joint Venture Object Type | JV_OTYPE | CHAR | 4 | 0 | |||||||||||
| JV_JIB_CLASS | JIB/JIBE Class | JV_JIBCL | CHAR | 3 | 0 | |||||||||||
| JV_JIB_SUB_CLASS_A | JIB/JIBE Subclass A | JV_JIBSA | CHAR | 5 | 0 | |||||||||||
| OBJECTCLASS_EXT | Object class, language-dependent | SCOPE_LD | CHAR | 5 | 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 |
Possible values
|
||||||||||
| LOCK | Indicator: Object is being or has been locked | PS_LOCK | CHAR | 1 | 0 |
Possible values
|
||||||||||
| TECH_COMPLETE | Indicator: Object is being or has been technically completed | PS_TECH_COMPLETE | CHAR | 1 | 0 |
Possible values
|
||||||||||
| DELETE | Indicator: Deletion flag has been set | PS_DELETE | CHAR | 1 | 0 |
Possible values
|
||||||||||
CNMASS_PROJECT_DEFINITION foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| CNMASS_PROJECT_DEFINITION | APPLICANT_NO | SY | MANDT | TCJ05 | Project applicant | MANDT |
| CNMASS_PROJECT_DEFINITION | APPLICANT_NO | CNMASS_PROJECT_DEFINITION | APPLICANT_NO | TCJ05 | Project applicant | ASTNR |
| CNMASS_PROJECT_DEFINITION | BUDGET_PROFILE | SY | MANDT | TBP1C | Budget/Plan Profile | MANDT |
| CNMASS_PROJECT_DEFINITION | BUDGET_PROFILE | CNMASS_PROJECT_DEFINITION | BUDGET_PROFILE | TBP1C | Budget/Plan Profile | PROFIL |
| CNMASS_PROJECT_DEFINITION | BUDGET_PROFILE | 'P' | TBP1C | Budget/Plan Profile | APPLIK | |
| CNMASS_PROJECT_DEFINITION | BUDGET_PROFILE | '41' | TBP1C | Budget/Plan Profile | WRTTP | |
| CNMASS_PROJECT_DEFINITION | BUS_AREA | CNMASS_PROJECT_DEFINITION | BUS_AREA | TGSB | Business Areas | GSBER |
| CNMASS_PROJECT_DEFINITION | BUS_AREA | SY | MANDT | TGSB | Business Areas | MANDT |
| CNMASS_PROJECT_DEFINITION | CALENDAR | CNMASS_PROJECT_DEFINITION | CALENDAR | TFACD | Factory calendar definition | IDENT |
| CNMASS_PROJECT_DEFINITION | COMP_CODE | SY | MANDT | T001 | Company Codes | MANDT |
| CNMASS_PROJECT_DEFINITION | COMP_CODE | CNMASS_PROJECT_DEFINITION | COMP_CODE | T001 | Company Codes | BUKRS |
| CNMASS_PROJECT_DEFINITION | CONTROLLING_AREA | SY | MANDT | TKA01 | Controlling Areas | MANDT |
| CNMASS_PROJECT_DEFINITION | CONTROLLING_AREA | CNMASS_PROJECT_DEFINITION | CONTROLLING_AREA | TKA01 | Controlling Areas | KOKRS |
| CNMASS_PROJECT_DEFINITION | CSH_BDGT_PROFILE | SY | MANDT | TBP1C | Budget/Plan Profile | MANDT |
| CNMASS_PROJECT_DEFINITION | CSH_BDGT_PROFILE | '62' | TBP1C | Budget/Plan Profile | WRTTP | |
| CNMASS_PROJECT_DEFINITION | CSH_BDGT_PROFILE | 'P' | TBP1C | Budget/Plan Profile | APPLIK | |
| CNMASS_PROJECT_DEFINITION | CSH_BDGT_PROFILE | CNMASS_PROJECT_DEFINITION | CSH_BDGT_PROFILE | TBP1C | Budget/Plan Profile | PROFIL |
| CNMASS_PROJECT_DEFINITION | INT_PROFILE | CNMASS_PROJECT_DEFINITION | INT_PROFILE | TPI01 | Interest Profile | ZSCHM |
| CNMASS_PROJECT_DEFINITION | INT_PROFILE | SY | MANDT | TPI01 | Interest Profile | MANDT |
| CNMASS_PROJECT_DEFINITION | NETWORK_PROFILE | 'N' | TCN41 | Network Defaults | PLNAW | |
| CNMASS_PROJECT_DEFINITION | NETWORK_PROFILE | CNMASS_PROJECT_DEFINITION | NETWORK_PROFILE | TCN41 | Network Defaults | PROFIDNETZ |
| CNMASS_PROJECT_DEFINITION | NETWORK_PROFILE | SYST | MANDT | TCN41 | Network Defaults | MANDT |
| CNMASS_PROJECT_DEFINITION | PLANT | CNMASS_PROJECT_DEFINITION | PLANT | T001W | Plants/Branches | WERKS |
| CNMASS_PROJECT_DEFINITION | PLANT | SY | MANDT | T001W | Plants/Branches | MANDT |
| CNMASS_PROJECT_DEFINITION | PLAN_PROFILE | 'P' | TBP1C | Budget/Plan Profile | APPLIK | |
| CNMASS_PROJECT_DEFINITION | PLAN_PROFILE | '01' | TBP1C | Budget/Plan Profile | WRTTP | |
| CNMASS_PROJECT_DEFINITION | PLAN_PROFILE | CNMASS_PROJECT_DEFINITION | PLAN_PROFILE | TBP1C | Budget/Plan Profile | PROFIL |
| CNMASS_PROJECT_DEFINITION | PLAN_PROFILE | SY | MANDT | TBP1C | Budget/Plan Profile | MANDT |
| CNMASS_PROJECT_DEFINITION | PROFIT_CTR | SY | MANDT | CEPC | Profit Center Master Data Table | MANDT |
| CNMASS_PROJECT_DEFINITION | PROFIT_CTR | CNMASS_PROJECT_DEFINITION | PROFIT_CTR | CEPC | Profit Center Master Data Table | PRCTR |
| CNMASS_PROJECT_DEFINITION | PROFIT_CTR | * | CEPC | Profit Center Master Data Table | DATBI | |
| CNMASS_PROJECT_DEFINITION | PROFIT_CTR | * | CEPC | Profit Center Master Data Table | KOKRS | |
| CNMASS_PROJECT_DEFINITION | PROJECT_CURRENCY | CNMASS_PROJECT_DEFINITION | PROJECT_CURRENCY | TCURC | Currency Codes | WAERS |
| CNMASS_PROJECT_DEFINITION | PROJECT_CURRENCY | SY | MANDT | TCURC | Currency Codes | MANDT |
| CNMASS_PROJECT_DEFINITION | PROJECT_PROFILE | CNMASS_PROJECT_DEFINITION | PROJECT_PROFILE | TCJ41 | Default Values for Work Breakdown Structure | PROFIDPROJ |
| CNMASS_PROJECT_DEFINITION | PROJECT_PROFILE | SY | MANDT | TCJ41 | Default Values for Work Breakdown Structure | MANDT |
| CNMASS_PROJECT_DEFINITION | RESPONSIBLE_NO | CNMASS_PROJECT_DEFINITION | RESPONSIBLE_NO | TCJ04 | Person in Responsible for Project | VERNR |
| CNMASS_PROJECT_DEFINITION | RESPONSIBLE_NO | SY | MANDT | TCJ04 | Person in Responsible for Project | MANDT |
| CNMASS_PROJECT_DEFINITION | TIME_UNIT | SY | MANDT | T006 | Units of Measurement | MANDT |
| CNMASS_PROJECT_DEFINITION | TIME_UNIT | CNMASS_PROJECT_DEFINITION | TIME_UNIT | T006 | Units of Measurement | MSEHI |
| CNMASS_PROJECT_DEFINITION | WBS_SCHED_PROFILE | CNMASS_PROJECT_DEFINITION | WBS_SCHED_PROFILE | TCXPS | Control parameters for WBS scheduling | PROFIL |
| CNMASS_PROJECT_DEFINITION | WBS_SCHED_PROFILE | SY | MANDT | TCXPS | Control parameters for WBS scheduling | MANDT |
