SAP ABAP Table CRMV_IT_ASSIGN (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	CRMV_IT_ASSIGN	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PROCESS_TYPE	☑	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
3	ITEM_CAT_GROUP	☑	CRMT_ITEM_CAT_GROUP	CRM_ITEM_CAT_GROUP	CHAR	4	0	Item Category Group	CRMC_ITEM_CAT_GR
4	IT_TYPE_USAGE	☑	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	CRMC_IT_TYPE_US
5	ITEM_TYPE_MAIN	☑	CRMT_ITEM_TYPE_MAIN	CRM_ITEM_TYPE	CHAR	4	0	Item Category of Main Item	CRMC_ITEM_TYPE
6	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	CRMC_ITEM_TYPE
7	ITM_TYPE_ALT1	☐	CRMT_ITEM_TYPE_ALTERNATIVE	CRM_ITEM_TYPE	CHAR	4	0	Alternative Item Category	CRMC_ITEM_TYPE
8	ITM_TYPE_ALT2	☐	CRMT_ITEM_TYPE_ALTERNATIVE	CRM_ITEM_TYPE	CHAR	4	0	Alternative Item Category	CRMC_ITEM_TYPE
9	ITM_TYPE_ALT3	☐	CRMT_ITEM_TYPE_ALTERNATIVE	CRM_ITEM_TYPE	CHAR	4	0	Alternative Item Category	CRMC_ITEM_TYPE
10	ITM_TYPE_ALT4	☐	CRMT_ITEM_TYPE_ALTERNATIVE	CRM_ITEM_TYPE	CHAR	4	0	Alternative Item Category	CRMC_ITEM_TYPE
11	ITM_TYPE_ALT5	☐	CRMT_ITEM_TYPE_ALTERNATIVE	CRM_ITEM_TYPE	CHAR	4	0	Alternative Item Category	CRMC_ITEM_TYPE
12	ITM_TYPE_ALT6	☐	CRMT_ITEM_TYPE_ALTERNATIVE	CRM_ITEM_TYPE	CHAR	4	0	Alternative Item Category
13	ITM_TYPE_ALT7	☐	CRMT_ITEM_TYPE_ALTERNATIVE	CRM_ITEM_TYPE	CHAR	4	0	Alternative Item Category
14	ITM_TYPE_ALT8	☐	CRMT_ITEM_TYPE_ALTERNATIVE	CRM_ITEM_TYPE	CHAR	4	0	Alternative Item Category
15	ITM_TYPE_ALT9	☐	CRMT_ITEM_TYPE_ALTERNATIVE	CRM_ITEM_TYPE	CHAR	4	0	Alternative Item Category
16	ITM_TYPE_ALT10	☐	CRMT_ITEM_TYPE_ALTERNATIVE	CRM_ITEM_TYPE	CHAR	4	0	Alternative Item Category
17	ITM_TYPE_ALT11	☐	CRMT_ITEM_TYPE_ALTERNATIVE	CRM_ITEM_TYPE	CHAR	4	0	Alternative Item Category
18	P_DESCRIPTION_20	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
19	I_DESCRIPTION_20	☐	CRMT_ITM_TYPE_DESC_20	TEXT20	CHAR	20	0	Item Category Text(20 character)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMV_IT_ASSIGN	CLIENT	T000	MANDT	KEY	1	CN
2	CRMV_IT_ASSIGN	ITEM_CAT_GROUP	CRMC_ITEM_CAT_GR	ITEM_CAT_GROUP	KEY	1	CN
3	CRMV_IT_ASSIGN	ITEM_TYPE_MAIN	CRMC_ITEM_TYPE	ITM_TYPE	KEY	1	CN
4	CRMV_IT_ASSIGN	ITM_TYPE	CRMC_ITEM_TYPE	ITM_TYPE	REF	1	CN
5	CRMV_IT_ASSIGN	ITM_TYPE_ALT1	CRMC_ITEM_TYPE	ITM_TYPE	REF	1	CN
6	CRMV_IT_ASSIGN	ITM_TYPE_ALT2	CRMC_ITEM_TYPE	ITM_TYPE	REF	1	CN
7	CRMV_IT_ASSIGN	ITM_TYPE_ALT3	CRMC_ITEM_TYPE	ITM_TYPE	REF	1	CN
8	CRMV_IT_ASSIGN	ITM_TYPE_ALT4	CRMC_ITEM_TYPE	ITM_TYPE	REF	1	CN
9	CRMV_IT_ASSIGN	ITM_TYPE_ALT5	CRMC_ITEM_TYPE	ITM_TYPE	REF	1	CN
10	CRMV_IT_ASSIGN	IT_TYPE_USAGE	CRMC_IT_TYPE_US	IT_TYPE_USAGE	KEY	1	CN
11	CRMV_IT_ASSIGN	PROCESS_TYPE	CRMC_PROC_TYPE	PROCESS_TYPE	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in