SAP ABAP Table CRMS_WFD_CPR_ROLE_API (CProject role attribute structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-RPL-SRV (Application Component) Service Resource Planning
     ⤷ CRM_WFD_API (Package) Interface to WFD Core for Resource Planning

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_WFD_CPR_ROLE_API	Table Relationship Diagram
Short Description	CProject role attribute structure

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	.INCLUDE	☐				0	0	Project Roles Unified
2	ROLE_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	.INCLUDE	☐				0	0	Project Roles Unified
4	PROJECT_NUMBER	☐	CRME_WFD_PROJ_NUMBER		CHAR	24	0	Project Number cProjects
5	PROJECT_TYPE	☐	CRME_WFD_PROJ_PRO_TYPE		CHAR	15	0	Project Type
6	PROJECT_TYPE_TEXT	☐	CRME_WFD_PROJ_PRO_TYPE_TEXT		CHAR	40	0	Project Type Desc.
7	PROJECT_NAME	☐	CRME_WFD_PROJ_NAME		CHAR	40	0	cProject Name
8	PROJECT_GUID	☐	CRME_WFD_PROJ_GUID	CHAR32	CHAR	32	0	cProject GUID
9	RESPONSIBLE_ROLE_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
10	RESPONSIBLE_ROLE_GUID	☐	BU_PARTNER_GUID_BAPI	SYSUUID_C	CHAR	32	0	GUID of a Business Partner in CHAR 32 Format for BAPIs
11	RESPONSIBLE_ROLE_NAME	☐	CRME_WFD_PROJ_RESP_RES_TEXT	TEXT80	CHAR	80	0	Name of Project Lead
12	SOLD_TO_PARTY_ID	☐	CRM_WFD_PROJ_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-To Party ID	*
13	SOLD_TO_PARTY_GUID	☐	BU_PARTNER_GUID_BAPI	SYSUUID_C	CHAR	32	0	GUID of a Business Partner in CHAR 32 Format for BAPIs
14	SOLD_TO_PARTY_NAME	☐	CRME_WFD_SOLD_TO_PARTY_NAME	TEXT80	CHAR	80	0	Sold-To Party
15	CUSTOMER_ID	☐	CRME_WFD_PROJ_CUSTOMER_ID	BU_PARTNER	CHAR	10	0	Customer Number	*
16	CUSTOMER_GUID	☐	CRME_WFD_PROJ_CUSTOMER_GUID		CHAR	32	0	Project Customer GUID
17	CUSTOMER_NAME	☐	CRME_WFD_PROJ_CUSTOMER_NAME		CHAR	80	0	Project Customer Name
18	RESPONSIBLE_ORG_UNIT	☐	CRME_WFD_PROJ_RESP_ORG	HROBJID	NUMC	8	0	Organization Responsible	*
19	RESPONSIBLE_ORG_UNIT_SHORT	☐	CRME_WFD_PROJ_RESP_ORG_SHORT	CHAR12	CHAR	12	0	Organization Responsible ID
20	RESPONSIBLE_ORG_UNIT_TEXT	☐	CRME_WFD_PROJ_RESP_ORG_STEXT	CHAR40	CHAR	40	0	Organization Responsible Description
21	ROLE_TYPE_TEXT	☐	CRME_WFD_PROJ_PART_ROLE_TEXT	CHAR40	CHAR	40	0	Name of Project Role Type
22	ROLE_DESCRIPTION	☐	CRME_WFD_ROLE_DESCRIPTION		CHAR	40	0	Language-Dependent Role Description
23	CALCULATED_BEGIN	☐	CRME_WFD_PROJ_SCHEDULED_START		DATS	8	0	Calculated Start Date
24	CALCULATED_END	☐	CRME_WFD_PROJ_SCHEDULED_FINISH		DATS	8	0	Calculated End Date
25	SORT_WORK_EFFORT	☐	CRME_WFD_PROJ_EFFORT		QUAN	9	2	Required Capacity
26	WORK_EFFORT	☐	CRME_WFD_PROJ_EFFORT		QUAN	9	2	Required Capacity
27	SORT_WORK_ASSIGNED	☐	CRME_WFD_PROJ_STAFFED_EFFORT		QUAN	9	2	Staffed Required Capacity
28	WORK_ASSIGNED	☐	CRME_WFD_PROJ_STAFFED_EFFORT		QUAN	9	2	Staffed Required Capacity
29	WORK_UNIT	☐	CRME_WFD_PROJ_EFFORT_UNIT	MEINS	UNIT	3	0	Unit for Required Capacity	*
30	RATE	☐	CRME_WFD_PROJ_RATE		CHAR	15	0	Cost/Revenue Rate for Project Roles and Business Partners
31	REVENUE_RATE	☐	CRME_WFD_PROJ_REVENUE_RATE		CURR	11	2	Manual Cost/Revenue Rate
32	CURRENCY	☐	CRME_WFD_PROJ_CURRENCY		CUKY	5	0	Currency Key
33	STAFFING_MANAGER	☐	CRME_WFD_PROJ_STAFF_MGR	SYCHAR12	CHAR	12	0	User Name of Staffing Manager
34	STAFFING_MANAGER_NAME	☐	CRME_WFD_PROJ_RESP_STAFF_MGR		CHAR	80	0	Staffing Manager Responsible
35	STAFFING_ORG_UNIT	☐	CRME_WFD_PROJ_STAFF_ORG	HROBJID	NUMC	8	0	Organization Responsible	*
36	STAFFING_ORG_UNIT_SHORT	☐	CRME_WFD_PROJ_STAFF_ORG_SHORT	CHAR12	CHAR	12	0	Organization Responsible ID
37	STAFFING_ORG_UNIT_TEXT	☐	CRME_WFD_PROJ_STAFF_ORG_STEXT	CHAR40	CHAR	40	0	Organization Responsible Description
38	CANDIDATE_MANAGER	☐	CRME_WFD_PROJ_CAND_MGR	SYCHAR12	CHAR	12	0	User Name of Candidate Manager
39	CANDIDATE_MANAGER_NAME	☐	CRME_WFD_PROJ_RESP_CAND_MGR		CHAR	80	0	Candidate Manager Responsible
40	CANDIDATE_ORG_UNIT	☐	CRME_WFD_PROJ_CAND_ORG	HROBJID	NUMC	8	0	Organization Responsible	*
41	CANDIDATE_ORG_UNIT_SHORT	☐	CRME_WFD_PROJ_CAND_ORG_SHORT	CHAR12	CHAR	12	0	Organization Responsible ID
42	CANDIDATE_ORG_UNIT_TEXT	☐	CRME_WFD_PROJ_CAND_ORG_STEXT	CHAR40	CHAR	40	0	Organization Responsible Description
43	CANDIDATE_MANAGEMENT_ACTIVE	☐	CRME_WFD_PROJ_CAND_IN_WORKLIST	CRM_WFD_BOOLEAN	CHAR	1	0	Role Is Displayed in Candidate Manager's Worklist
44	WORK_ASSIGNED_RATIO	☐	CRME_WFD_PROJ_WRK_ASSGND_RATIO	DEC6_2	DEC	8	2	Staffing Ratio
45	LOCATION	☐	CRME_WFD_PROJ_LOCATION		CHAR	4	0	Project Location
46	LOCATION_DESCRIPTION	☐	CRME_WFD_PROJ_LOCATION_DESC	TEXT30	CHAR	30	0	Location Description
47	ROLE_ID	☐	CRME_WFD_PROJ_ROLE_ID		CHAR	24	0	Project Role ID
48	STAFF_PERCENTAGE	☐	CRME_WFD_STAFFING_PERCENTAGE	NUMC3	NUMC	3	0	Staffing Percentage
49	STAFFING_STATE	☐	CRME_WFD_ASSIGNMENT_STATE	CHAR1	CHAR	1	0	Staffing Level
50	NO_CANDIDATES	☐	SYDBCNT	SYST_LONG	INT4	10	0	Processed Database Table Rows
51	SKILLS_ASSIGNED	☐	BOOLEAN_01	BOOLEAN_01	CHAR	1	0	Boolean Variable ('1'=true,'0'=false)
52	ENABLE_BREAKDOWN	☐	CRME_WFD_BOOLEAN	CRM_WFD_BOOLEAN	CHAR	1	0	CRM WFD Boolean Data Element
53	DEM_TYPE	☐	CRME_WFD_DEM_TYPE	CRM_WFD_DEM_TYPE	CHAR	1	0	Demand Type
54	.INCLUDE	☐				0	0	Include for Enhanced Attributes for Project Role Search
55	EA_DUMMY	☐	CRME_WFD_DUMMY		CHAR	1	0	Test Data Element for Enhanced Attributes
56	.INCLUDE	☐				0	0
57	.INCLUDE	☐				0	0
58	.INCLUDE	☐				0	0	Attribute Structure for Staffing Process
59	STATUS	☐	CRME_WFD_PROJ_STATUS		STRG	0	0	Project Status
60	STAFFING_COMMENTS	☐	CRME_WFD_PROJ_COMMENT		STRG	0	0	Staffing Comment
61	STAFFING_COMMENT_NEW	☐	CRME_WFD_PROJ_COMMENT		STRG	0	0	Staffing Comment
62	TRANSITION_STATUS_NAME	☐	CRME_WFD_PROJ_TR_STATUS_NAME		STRG	0	0	Transition Status Description
63	TRANSITION_STATUS_VALUE	☐	CRME_WFD_PROJ_TR_STATUS_VALUE		STRG	0	0	Transition Status Value
64	LOCKED	☐	CRME_WFD_BOOLEAN	CRM_WFD_BOOLEAN	CHAR	1	0	CRM WFD Boolean Data Element
65	DIRTY	☐	CRME_WFD_BOOLEAN	CRM_WFD_BOOLEAN	CHAR	1	0	CRM WFD Boolean Data Element

History

Last changed by/on	SAP	20130604
SAP Release Created in	600