SAP ABAP Table CNMASS_ACTIVITY_ELEMENT (Mass change activity element)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-ST-OPR (Application Component) Operative Structures
     ⤷ CNMASS (Package) Mass processing in the Project System

Basic Data

Table Category	INTTAB	Structure
Structure	CNMASS_ACTIVITY_ELEMENT	Table Relationship Diagram
Short Description	Mass change activity element

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	NETWORK	☑	NW_AUFNR	AUFNR	CHAR	12	0	Network number	AUFK
2	ACTIVITY	☑	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
3	ELEMENT	☑	CN_ELEMENT	VORNR	CHAR	4	0	Activity element number (work/external/general costs)
4	CONTROL_KEY	☐	STEUS	STEUS	CHAR	4	0	Control key	T430
5	WORK_CNTR	☐	ARBPL	ARBPL	CHAR	8	0	Work center
6	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
7	DESCRIPTION	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
8	VENDOR_NO	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
9	PRICE	☐	PREIS	WERT11	CURR	11	2	Price
10	PRICE_UNIT	☐	PEINH	PACK3	DEC	5	0	Price unit
11	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
12	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
13	CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
14	INFO_REC	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
15	PURCH_ORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
16	PUR_GROUP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
17	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
18	NUMBER_OF_CAPACITIES	☐	ANZKAP	INT1	INT1	3	0	Number of capacities required
19	PERCENT_OF_WORK	☐	APROZENT	INT1	INT1	3	0	Work percentage
20	ACTTYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
21	ACTIVITY_COSTS	☐	PRKST	PRKST	CURR	11	2	Costs in the activity
22	PROJECT_DEFINITION	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
23	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
24	DISTRIBUTING_KEY	☐	CR_VERTN	CR_VERTL	CHAR	8	0	Distr.cap.reqmts (plant maint.,process order, network)	TC29
25	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
26	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
27	NOT_MRP_APPLICABLE	☐	NODISP	XFELD	CHAR	1	0	Ind: Reserv. not applicable to MRP;Purc. req. not created
28	PROJECT_SUMMARIZATION	☐	CLASF	XFELD	CHAR	1	0	Ind.: Take Activity Into Account for Project Summarization
29	OPERATION_MEASURE_UNIT	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
30	OPERATION_MEASURE_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
31	PLND_DELRY	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
32	WORK_ACTIVITY	☐	ARBEIT	ARBEIT	QUAN	7	1	Work involved in the activity
33	UN_WORK	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
34	UN_WORK_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
35	EARLY_START_DATE	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
36	EARLY_START_TIME	☐	FSAVZ	ATIME	TIMS	6	0	Earliest scheduled start: Execution (time)
37	EARLY_FINISH_DATE	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
38	EARLY_FINISH_TIME	☐	FSEDZ	ATIME	TIMS	6	0	Earliest scheduled finish: Execution (time)
39	LATEST_START_DATE	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
40	LATEST_START_TIME	☐	SSAVZ	ATIME	TIMS	6	0	Latest scheduled start: Execution (time)
41	LATEST_FINISH_DATE	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
42	LATEST_FINISH_TIME	☐	SSEDZ	ATIME	TIMS	6	0	Latest scheduled finish: Execution (time)
43	USER_FIELD_KEY	☐	SLWID	SLWID	CHAR	7	0	Key word ID for user-defined fields	TCN00
44	USER_FIELD_CHAR20_1	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
45	USER_FIELD_CHAR20_2	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
46	USER_FIELD_CHAR10_1	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
47	USER_FIELD_CHAR10_2	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
48	USER_FIELD_QUAN1	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
49	USER_FIELD_UNIT1	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
50	USER_FIELD_UNIT1_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
51	USER_FIELD_QUAN2	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
52	USER_FIELD_UNIT2	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
53	USER_FIELD_UNIT2_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
54	USER_FIELD_CURR1	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
55	USER_FIELD_CUKY1	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
56	USER_FIELD_CUKY1_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
57	USER_FIELD_CURR2	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
58	USER_FIELD_CUKY2	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
59	USER_FIELD_CUKY2_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
60	USER_FIELD_DATE1	☐	USRDATE	USRDATE	DATS	8	0	User field for date
61	USER_FIELD_DATE2	☐	USRDATE	USRDATE	DATS	8	0	User field for date
62	USER_FIELD_FLAG1	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
63	USER_FIELD_FLAG2	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
64	EARLY_START_DATE_FC	☐	FPAVD	DATUM	DATS	8	0	Earliest scheduled start date (forecast)
65	EARLY_START_TIME_FC	☐	FPAVZ	ATIME	TIMS	6	0	Earliest scheduled start time (forecast)
66	EARLY_FINISH_DATE_FC	☐	FPEDD	DATUM	DATS	8	0	Earliest scheduled finish date (forecast)
67	EARLY_FINISH_TIME_FC	☐	FPEDZ	ATIME	TIMS	6	0	Earliest scheduled finish time (forecast)
68	LATEST_START_DATE_FC	☐	SPAVD	DATUM	DATS	8	0	Latest scheduled start date (forecast)
69	LATEST_START_TIME_FC	☐	SPAVZ	ATIME	TIMS	6	0	Latest scheduled start time (forecast)
70	LATEST_FINISH_DATE_FC	☐	SPEDD	DATUM	DATS	8	0	Latest scheduled finish date (forecast)
71	LATEST_FINISH_TIME_FC	☐	SPEDZ	ATIME	TIMS	6	0	Latest scheduled finish time (forecast)
72	OBJECTCLASS_EXT	☐	SCOPE_LD	CHAR5	CHAR	5	0	Object class, language-dependent
73	OFFSET_START	☐	OFFSTB	VNZTV	QUAN	5	0	Offset to start of production resource/tool usage
74	OFFSET_START_UNIT	☐	CP_OEHOFFB	MEINS	UNIT	3	0	Unit for offset to start	*
75	OFFSET_START_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
76	OFFSET_END	☐	CP_OOFFSTE	VNZTV	QUAN	5	0	Offset to sub-operation finish
77	OFFSET_END_UNIT	☐	CP_OEHOFFE	MEINS	UNIT	3	0	Unit for offset to finish	*
78	OFFSET_END_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
79	FUNC_AREA	☐	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area
80	FUNC_AREA_LONG	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
81	PERS_NO	☐	CO_PERNR	PERNR	NUMC	8	0	Personnel number
82	RELEASE	☐	PS_RELEASE	XFELD	CHAR	1	0	Indicator: Object is being or has been released
83	TECH_COMPLETE	☐	PS_TECH_COMPLETE	XFELD	CHAR	1	0	Indicator: Object is being or has been technically completed
84	DELETE	☐	PS_DELETE	XFELD	CHAR	1	0	Indicator: Deletion flag has been set

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CNMASS_ACTIVITY_ELEMENT	ACTTYPE	CSLA	LSTAR
2	CNMASS_ACTIVITY_ELEMENT	CONTROL_KEY	T430	STEUS
3	CNMASS_ACTIVITY_ELEMENT	COST_ELEM	CSKA	KSTAR
4	CNMASS_ACTIVITY_ELEMENT	CURRENCY	TCURC	WAERS
5	CNMASS_ACTIVITY_ELEMENT	DISTRIBUTING_KEY	TC29	VERTL
6	CNMASS_ACTIVITY_ELEMENT	INFO_REC	EINA	INFNR
7	CNMASS_ACTIVITY_ELEMENT	MATL_GROUP	T023	MATKL
8	CNMASS_ACTIVITY_ELEMENT	NETWORK	AUFK	AUFNR	KEY
9	CNMASS_ACTIVITY_ELEMENT	OPERATION_MEASURE_UNIT	T006	MSEHI
10	CNMASS_ACTIVITY_ELEMENT	OPERATION_MEASURE_UNIT_ISO	T006I	ISOCODE
11	CNMASS_ACTIVITY_ELEMENT	PLANT	T001W	WERKS
12	CNMASS_ACTIVITY_ELEMENT	PROFIT_CTR	CEPC	PRCTR
13	CNMASS_ACTIVITY_ELEMENT	PURCH_ORG	T024E	EKORG
14	CNMASS_ACTIVITY_ELEMENT	PUR_GROUP	T024	EKGRP
15	CNMASS_ACTIVITY_ELEMENT	TAXJURCODE	TTXJ	TXJCD
16	CNMASS_ACTIVITY_ELEMENT	UN_WORK	T006	MSEHI
17	CNMASS_ACTIVITY_ELEMENT	UN_WORK_ISO	T006I	ISOCODE
18	CNMASS_ACTIVITY_ELEMENT	USER_FIELD_CUKY1	TCURC	WAERS
19	CNMASS_ACTIVITY_ELEMENT	USER_FIELD_CUKY2	TCURC	WAERS
20	CNMASS_ACTIVITY_ELEMENT	USER_FIELD_KEY	TCN00	SLWID
21	CNMASS_ACTIVITY_ELEMENT	USER_FIELD_UNIT1	T006	MSEHI
22	CNMASS_ACTIVITY_ELEMENT	USER_FIELD_UNIT1_ISO	T006I	ISOCODE
23	CNMASS_ACTIVITY_ELEMENT	USER_FIELD_UNIT2	T006	MSEHI
24	CNMASS_ACTIVITY_ELEMENT	USER_FIELD_UNIT2_ISO	T006I	ISOCODE
25	CNMASS_ACTIVITY_ELEMENT	VENDOR_NO	LFA1	LIFNR

History

Last changed by/on	SAP	20130529
SAP Release Created in