SAP ABAP Table CRM_LRP_RES_ASSIGNMENT (Assignment List for Service Representatives)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-RPL-SRV (Application Component) Service Resource Planning
     ⤷ CRM_LRP_LAYER (Package) CRM - WFM Core - Interface

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_LRP_RES_ASSIGNMENT	Table Relationship Diagram
Short Description	Assignment List for Service Representatives

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	ASSIGNMENT_ID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
2	BUSINESS_PARTNER_ID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
3	BEG_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
4	END_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
5	STATUS_NUMBER	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
6	STATUS_TEXT04	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
7	STATUS_TEXT30	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
8	ITEM_INFO	☐	CRM_LRP_DEMAND		STRU	0	0
9	BT_BUS_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category
10	BT_GUID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
11	BT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
12	BT_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type
13	BT_DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
14	ITEM_BUS_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type
15	ITEM_GUID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
16	ITEM_NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
17	ITEM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category
18	ORDERED_PROD	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
19	ORDERED_PROD_GUID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
20	DESCRIPTION	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
21	PROD_AMOUNT	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
22	PROD_UNIT	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
23	ITEM_START_DATE_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
24	ITEM_END_DATE_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
25	DURATION_C	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
26	DURATION_UNIT_C	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
27	DURATION	☐	CRMT_SRV_DURATION	MENG13	QUAN	13	3	Duration
28	DURATION_UNIT	☐	CRMT_SRV_DURATION_UOM	MEINS	UNIT	3	0	Unit for Duration of Work
29	CUSTOMER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
30	CUSTOMER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
31	CUSTOMER_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
32	CUSTOMER_POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
33	CUSTOMER_CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
34	CUSTOMER_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
35	CUSTOMER_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
36	CUSTOMER_TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
37	CUSTOMER_TIME_ZONE	☐	SYSTZONLO	SYCHAR06	CHAR	6	0	Time Zone
38	CUSTOMER_ADDR_NR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
39	CUSTOMER_FCT	☐	CMST_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
40	CUSTOMER_FCT_T	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
41	CUSTOMER_HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
42	CUSTOMER_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
43	SRV_RECIPIENT_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
44	SRV_RECIPIENT_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
45	SRV_RECIPIENT_FCT	☐	CMST_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
46	SRV_RECIPIENT_FCT_T	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
47	DISPATCHED	☐	INT4	INT4	INT4	10	0	Natural number
48	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority
49	PRIORITY_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
50	SUBJECT	☐	CHAR80	CHAR80	CHAR	80	0	Char 80
51	SERVICE_TYPE	☐	CRMT_SERVICE_TYPE	CRMT_SERVICE_TYPE	CHAR	4	0	Service Type
52	SRVT_DESCRIPTION	☐	COMT_BSP_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
53	VALUATION_TYPE	☐	CRMT_VALUATION_TYPE	CRMT_VALUATION_TYPE	CHAR	6	0	Valuation Type
54	VALT_DESCRIPTION	☐	COMT_BSP_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
55	CONFIRM_RELEVANT	☐	CRMT_CONFIRM_RELEVANT	CRM_BOOLEAN	CHAR	1	0	Relevant for Confirmation
56	CONF_PROC_TYPE	☐	CRMT_PROCESS_TYPE_TO	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type: Target Document
57	CONF_ITEM_TYPE	☐	CRMT_ITEM_TYPE_TO	CRM_ITEM_TYPE	CHAR	4	0	Item Category: Target Document
58	SLA_FIRST_REACT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
59	SLA_FINISH	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
60	REF_PRODUCT	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
61	REF_PRODUCT_TXT	☐	CRMT_TEXT_OBJECT	SM_CHAR40	CHAR	40	0	Reference Object Text
62	SRV_APPT_BEG	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
63	SRV_APPT_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
64	ITEM_STATUS_T04	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
65	ITEM_STATUS_T30	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
66	CANCELED	☐	CRM_DWP_CANCELED	CHAR1	CHAR	1	0	Order Item Has Been Cancelled
67	TL_TIME_CONST	☐	CRMT_DWP_TL_TIME_CONSTRAINTS	CRM_DWP_TRAFFIC_LIGHT	CHAR	4	0	Traffic Light Display Relating to Time Constraints
68	AC_INDICATOR	☐	CRMT_AC_INDICATOR	CRMT_AC_INDICATOR	CHAR	2	0	Accounting Indicator
69	BT_AC_INDICATOR	☐	CRMT_AC_INDICATOR	CRMT_AC_INDICATOR	CHAR	2	0	Accounting Indicator

History

Last changed by/on	SAP	20130604
SAP Release Created in	20C