SAP ABAP Table CRMT_ELM_L_ATTR_IL (ELM: Attributes of ELMList - GenIL)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-EAL (Application Component) External List Management
     ⤷ CRM_MKTLIST_IL (Package) ELM Model BOL / GenIL

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_ELM_L_ATTR_IL	Table Relationship Diagram
Short Description	ELM: Attributes of ELMList - GenIL

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	LIST_GUID	☐	CRMT_MKTLIST_LIST_GUID	CRM_MKTLIST_LIST_GUID	RAW	16	0	CRM Marketing: GUID for an External List
2	.INCLUDE	☐				0	0	CRM Marketing: External List - Text with External Fields
3	LANGUAGE	☐	CRMT_MKTLIST_LANGUAGE	SPRAS	LANG	1	0	CRM Marketing: External List - Language Key	*
4	DESCRIPTION	☐	CRMT_MKTLIST_DESCRIPTION	CRM_MKTLIST_DESCRIPTION	CHAR	60	0	CRM Marketing: External List - Description
5	.INCLUDE	☐				0	0	CRM Marketing: External List - Header with External Fields
6	LIST_ID	☐	CRMT_MKTLIST_LIST_ID	CRM_MKTLIST_LIST_ID	CHAR	28	0	CRM Marketing: ID for External List
7	LIST_ID_LOGSYS	☐	CRMT_MKTLIST_LIST_ID_LOGSYS	LOGSYS	CHAR	10	0	CRM Marketing: External List - Logical System for ID	*
8	ORIGIN	☐	CRMT_MKTLIST_ORIGIN	CRM_MKTLIST_ORIGIN	CHAR	6	0	CRM Marketing: External List - Origin	CRMC_MKTLIST_O
9	TYPE	☐	CRMT_MKTLIST_TYPE	CRM_MKTLIST_TYPE	CHAR	2	0	CRM Marketing: External List - Type	CRMC_MKTLIST_T
10	VALID_DATE_TO	☐	CRMT_MKTLIST_VALID_DATE_TO	CRM_MKTLIST_VALID_DATE_TO	DATS	8	0	CRM Marketing: Recommended End-of-Use Date
11	MAX_USAGE_NO	☐	CRMT_MKTLIST_MAX_USAGE	CRM_MKTLIST_MAX_USAGE	NUMC	4	0	CRM Marketing: Permitted Number of Uses
12	MAX_USAGE_DATE	☐	CRMT_MKTLIST_USAGE_DATE	CRM_MKTLIST_USAGE_DATE	DATS	8	0	CRM Marketing: Permitted End-of-Use Date
13	NO_GROSS	☐	CRMT_MKTLIST_NO_GROSS	CRM_MKTLIST_NO_GROSS	NUMC	8	0	CRM Marketing: External List - Gross Number
14	COSTS	☐	CRMT_MKTLIST_COST	WERTV8	CURR	15	2	CRM Marketing: External List - Costs
15	COSTS_CURRENCY	☐	CRMT_MKTLIST_CURRENCY	WAERS	CUKY	5	0	CRM Marketing: External List - Currency	*
16	.INCLUDE	☐				0	0	CRM Marketing: External List - Change Information
17	CREATED_AT	☐	CRMT_MKT_CREATED_AT	BCOS_TSTMP	DEC	15	0	Marketing Object: Creation Date
18	CREATED_BY	☐	CRMT_MKT_CREATED_BY	UNAME	CHAR	12	0	Marketing Object: Created By User
19	CHANGED_AT	☐	CRMT_MKT_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Marketing Object: Date of Last Change
20	CHANGED_BY	☐	CRMT_MKT_CHANGED_BY	UNAME	CHAR	12	0	Marketing Object: Last Changed By
21	DELETED	☐	CRMT_MKTLIST_DELETED	CRM_MKTLIST_DELETED	CHAR	1	0	CRM Marketing: External List - Deleted Flag
22	APPL_LOG_ID	☐	CRMT_MKTLIST_LIST_LOG_IL	SYSUUID_22	CHAR	22	0	ELM: List Handle - BOL / GenIL
23	PACKAGE_GUID	☐	CRMT_MKTLIST_LIST_GUID	CRM_MKTLIST_LIST_GUID	RAW	16	0	CRM Marketing: GUID for an External List
24	CLEAR_OR_ALLOW	☐	CRMT_MKTLIST_CLEAR_ALLOW	CRM_MKTLIST_CLEAR_ALLOW	CHAR	1	0	CRM Marketing: External List - Clear or Allow Duplicates
25	START_TYPE	☐	CRMT_MKT_WF_START_TYPE	CRM_MKT_WF_START_TYPE	CHAR	1	0	CRM Marketing: Workflow - Start Type
26	START_DATE	☐	SWR_DATEIN	SYDATS	DATS	8	0	WAPI: Date in internal format (YYYYMMDD)
27	START_TIME	☐	SWR_TIMEIN	SYTIME	TIMS	6	0	WAPI: Time in internal format (hhmmss)
28	.INCLUDE	☐				0	0	ELM: Upload Attributes of ELMList - GenIL
29	FLAG_UPLOAD	☐	CRMT_MKTLIST_FLAG_UPLOAD_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Marked Step for Upload - GenIL
30	STATUS_UPLOAD	☐	CRMT_MKTLIST_STATUS_UPLOAD_IL	CRM_MKTLIST_PACKAGE_STATUS	CHAR	1	0	ELM: Step Status for Upload - GenIL
31	ATTR_ERROR_UPLOAD	☐	CRMT_MKTLIST_ERRORS_UPLOAD_IL	CRM_MKTLIST_PACKAGE_ATTR_ERR	CHAR	1	0	ELM: Error Attribute for Upload - GenIL
32	APPL_LOG_ID_UPLOAD	☐	CRMT_MKTLIST_UPLOAD_LOG_IL	SYSUUID_22	CHAR	22	0	ELM: Upload Handle - BOL / GenIL
33	FILE	☐	CRMT_MKTLIST_FILE_LOCATION	CRM_MKTLIST_FILE_LOCATION	CHAR	255	0	CRM Marketing: ELM - Location of the File to be Uploaded
34	FILE_STORAGE	☐	CRMT_MKTLIST_FILE_STORAGE	CRM_MKTLIST_FILE_STORAGE	CHAR	1	0	CRM Marketing: External List - File Storage Location
35	ESCAPE_CHAR	☐	CRMT_MKTLIST_ESCAPE_CHAR		CHAR	1	0	CRM Marketing: External List - Escape Character
36	SEPARATOR_TYPE	☐	CRMT_MKTLIST_SEPARATOR_TYPE	CRM_MKTLIST_SEPARATOR_TYPE	CHAR	1	0	CRM Marketing: External List - Type of Field Separator
37	SEPARATOR_CHAR	☐	CRMT_MKTLIST_SEPARATOR_CHAR		CHAR	1	0	CRM Marketing: External List - Separator Character
38	.INCLUDE	☐				0	0	ELM: Mapping Attributes of ELMList - GenIL
39	FLAG_MAP	☐	CRMT_MKTLIST_FLAG_MAP_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Marked Step for Mapping - GenIL
40	STATUS_MAP	☐	CRMT_MKTLIST_STATUS_MAP_IL	CRM_MKTLIST_PACKAGE_STATUS	CHAR	1	0	ELM: Step Status for Mapping - GenIL
41	ATTR_ERROR_MAP	☐	CRMT_MKTLIST_ERRORS_MAP_IL	CRM_MKTLIST_PACKAGE_ATTR_ERR	CHAR	1	0	ELM: Error Attribute for Mapping - GenIL
42	REPEAT_ALL_MAP	☐	CRMT_MKTLIST_REPALL_MAP_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Repeat All Data Records for Mapping - GenIL
43	APPL_LOG_ID_MAP	☐	CRMT_MKTLIST_MAP_LOG_IL	SYSUUID_22	CHAR	22	0	ELM: Map Handle - BOL / GenIL
44	MAPPING_FORMAT	☐	CRMT_MKTLIST_FORMAT_IL	CRM_MKTLIST_MH_ID	CHAR	6	0	Mapping Format
45	MAPPING_FORMAT_DESCRIPTION	☐	CRMT_MKTLIST_FORMAT_DESCR_IL	CRM_MKTLIST_M_DESCRIPTION	CHAR	60	0	ELM: Description of Mapping Format
46	FORMAT_TYPE	☐	CRMT_MKTLIST_FORMATTYPE_IL		CHAR	1	0	ELM Mapping: Category
47	FORMAT_TYPE_DESCRIPTION	☐	CRMT_MKTLIST_FT_DESCRIPTION_IL	CRM_MKTLIST_M_DESCRIPTION	CHAR	60	0	ELM Format Type: Description
48	.INCLUDE	☐				0	0	ELM: Attributes of ELM List for Check. Postal Addr. - GenIL
49	FLAG_CHECK_POSTAL	☐	CRMT_MKTLIST_FLAG_CHECK_P_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Marked Step for Checking of Postal Address - GenIL
50	STATUS_CHECK_POSTAL	☐	CRMT_MKTLIST_STATUS_CHECK_P_IL	CRM_MKTLIST_PACKAGE_STATUS	CHAR	1	0	ELM: Step Status for Checking the Postal Address - GenIL
51	ATTR_ERROR_CHECK_POSTAL	☐	CRMT_MKTLIST_ERRORS_CHECK_P_IL	CRM_MKTLIST_PACKAGE_ATTR_ERR	CHAR	1	0	ELM: Error Attribute for Checking Postal Address - GenIL
52	REPEAT_ALL_CHECK_POSTAL	☐	CRMT_MKTLIST_REPALL_CHECK_P_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Repeat All Data Records for Postal Address Check-GenIL
53	APPL_LOG_ID_CHECK_POSTAL	☐	CRMT_MKTLIST_CHECK_P_LOG_IL	SYSUUID_22	CHAR	22	0	ELM: Postal Check Handle - BOL / GenIL
54	CLEANSING_CASE_CHECK_POSTAL	☐	CRMT_MKTLIST_CL_C_CHECK_P_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Create Cleansing Case for Postal Address Check - GenIL
55	.INCLUDE	☐				0	0	ELM: Attributes of ELM List for Check. Postal Addr. - GenIL
56	FLAG_CHECK_DUP	☐	CRMT_MKTLIST_FLAG_CHECK_DUP_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Marked Step for Checking of Duplicate Records - GenIL
57	STATUS_CHECK_DUP	☐	CRMT_MKTLIST_STATUS_CHECK_D_IL	CRM_MKTLIST_PACKAGE_STATUS	CHAR	1	0	ELM: Step Status for Checking Duplicates - GenIL
58	ATTR_ERROR_CHECK_DUP	☐	CRMT_MKTLIST_ERRORS_CHECK_D_IL	CRM_MKTLIST_PACKAGE_ATTR_ERR	CHAR	1	0	ELM: Error Attribute for Checking Duplicates - GenIL
59	REPEAT_ALL_CHECK_DUP	☐	CRMT_MKTLIST_REPALL_CHECK_D_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Repeat All Data Records for Duplicates Check - GenIL
60	APPL_LOG_ID_CHECK_DUP	☐	CRMT_MKTLIST_CHECK_D_LOG_IL	SYSUUID_22	CHAR	22	0	ELM: Check Duplicate Handle - BOL / GenIL
61	CLEANSING_CASE_CHECK_DUP	☐	CRMT_MKTLIST_CL_C_CHECK_D_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Create Cleansing Case for Postal Address Check - GenIL
62	.INCLUDE	☐				0	0	ELM: Attributes of ELM List for BP Maintenance - GenIL
63	FLAG_MAINT_BP	☐	CRMT_MKTLIST_FLAG_MAINT_BP_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Marked Step for Maintaining Business Partners - GenIL
64	STATUS_MAINT_BP	☐	CRMT_MKTLIST_STATUS_MAIN_BP_IL	CRM_MKTLIST_PACKAGE_STATUS	CHAR	1	0	ELM: Step Status for Maintaining Business Partners - GenIL
65	ATTR_ERROR_MAINT_BP	☐	CRMT_MKTLIST_ERRORS_MAIN_BP_IL	CRM_MKTLIST_PACKAGE_ATTR_ERR	CHAR	1	0	ELM: Error Attribute for Maintaining Business Partners-GenIL
66	APPL_LOG_ID_MAINT_BP	☐	CRMT_MKTLIST_MAINT_BP_LOG_IL	SYSUUID_22	CHAR	22	0	ELM: BP Maintenance Handle - BOL / GenIL
67	.INCLUDE	☐				0	0	ELM: Attributes of ELM List for Trans. Maintenance - GenIL
68	FLAG_MAINT_TR	☐	CRMT_MKTLIST_FLAG_MAINT_TR_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Marked Step for Maintaining Transactions - GenIL
69	STATUS_MAINT_TR	☐	CRMT_MKTLIST_STATUS_MAIN_TR_IL	CRM_MKTLIST_PACKAGE_STATUS	CHAR	1	0	ELM: Step Status for Maintaining Transactions - GenIL
70	ATTR_ERROR_MAINT_TR	☐	CRMT_MKTLIST_ERRORS_MAIN_TR_IL	CRM_MKTLIST_PACKAGE_ATTR_ERR	CHAR	1	0	ELM: Error Attribute for Maintaining Transactions - GenIL
71	APPL_LOG_ID_MAINT_TR	☐	CRMT_MKTLIST_MAINT_TR_LOG_IL	SYSUUID_22	CHAR	22	0	ELM: Transaction Maintenance Handle - BOL / GenIL
72	.INCLUDE	☐				0	0	ELM: Attr. of ELM List for Target group Maintenance - GenIL
73	FLAG_MAINT_TG	☐	CRMT_MKTLIST_FLAG_MAINT_TG_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Marked Step for Maintaining Target Groups - GenIL
74	STATUS_MAINT_TG	☐	CRMT_MKTLIST_STATUS_MAIN_TG_IL	CRM_MKTLIST_PACKAGE_STATUS	CHAR	1	0	ELM: Step Status for Maintaining Target Groups - GenIL
75	ATTR_ERROR_MAINT_TG	☐	CRMT_MKTLIST_ERRORS_MAIN_TG_IL	CRM_MKTLIST_PACKAGE_ATTR_ERR	CHAR	1	0	ELM: Error Attribute for Maintaining Target Groups - GenIL
76	APPL_LOG_ID_MAINT_TG	☐	CRMT_MKTLIST_MAINT_TG_LOG_IL	SYSUUID_22	CHAR	22	0	ELM: Target Group Maintenance Handle - BOL / GenIL
77	SET_GUID	☐	CRMT_MKTTG_SET_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID Profile Set
78	SET_DESCRIPTION	☐	CRMT_MKTTG_SET_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Description of Profile Set
79	EXISTING_SET	☐	CRMT_MKTLIST_EXISTING_SET	CRM_MKTLIST_EXISTING_SET	CHAR	1	0	CRM Marketing: External List - New/Existing Profile Set
80	PF_GUID	☐	CRMT_MKTTG_PF_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of a Profile
81	TG_GUID	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group
82	TG_DESCRIPTION	☐	CRMT_MKTTG_TG_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Description of a Target Group
83	EXISTING_TG	☐	CRMT_MKTLIST_EXISTING_TG	CRM_MKTLIST_EXISTING_TG	CHAR	1	0	CRM Marketing: External List - New/Existing Target Group
84	.INCLUDE	☐				0	0	ELM: Attr. of ELM List for Deleting Temporary Obj. - GenIL
85	FLAG_DEL_TEMP	☐	CRMT_MKTLIST_FLAG_DEL_TEMP_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Marked Step for Deleting Temporary Objects - GenIL
86	STATUS_DEL_TEMP	☐	CRMT_MKTLIST_STATUS_DEL_TEM_IL	CRM_MKTLIST_PACKAGE_STATUS	CHAR	1	0	ELM: Step Status for Deleting Temporary Objects - GenIL
87	ATTR_ERROR_DEL_TEMP	☐	CRMT_MKTLIST_ERRORS_DEL_TEM_IL	CRM_MKTLIST_PACKAGE_ATTR_ERR	CHAR	1	0	ELM: Error Attribute for Deleting Temporary Objects - GenIL
88	APPL_LOG_DEL_TEMP	☐	CRMT_MKTLIST_DEL_TEMP_LOG_IL	SYSUUID_22	CHAR	22	0	ELM: Temporary Deletion Handle - BOL / GenIL
89	.INCLUDE	☐				0	0	ELM: Attr. of ELM List for Deleting List - GenIL
90	FLAG_DEL_LIST	☐	CRMT_MKTLIST_FLAG_DEL_LIST_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Marked Step for Deleting the List - GenIL
91	STATUS_DEL_LIST	☐	CRMT_MKTLIST_STATUS_DELLIST_IL	CRM_MKTLIST_PACKAGE_STATUS	CHAR	1	0	ELM: Step Status for Deleting the List - GenIL
92	ATTR_ERROR_DEL_LIST	☐	CRMT_MKTLIST_ERRORS_DELLIST_IL	CRM_MKTLIST_PACKAGE_ATTR_ERR	CHAR	1	0	ELM: Error Attribute for Deleting List - GenIL
93	APPL_LOG_DEL_LIST	☐	CRMT_MKTLIST_DEL_LIST_LOG_IL	SYSUUID_22	CHAR	22	0	ELM: List Deletion Handle - BOL / GenIL
94	ORIGIN_DESCR	☐	CRMT_MKTLIST_ORIGIN_DESCR_IL	CRM_MKTLIST_ORIGIN_DESCR	CHAR	40	0	CRM Marketing: Description of Origin
95	TYPE_DESCR	☐	CRMT_MKTLIST_TYPE_DESCR_IL	CRM_MKTLIST_TYPE_DESCR	CHAR	40	0	CRM Marketing: Type Description
96	.INCLUDE	☐				0	0	ELM: created / changed information with split date / time
97	DATE_CREATED_ON	☐	CRMT_MKTLIST_DATE_CREATED_ON		DATS	8	0	ELM: List Creation Date
98	TIME_CREATED_ON	☐	CRMT_MKTLIST_TIME_CREATED_ON		TIMS	6	0	ELM: List Creation Time
99	DATE_CHANGED_ON	☐	CRMT_MKTLIST_DATE_CHANGED_ON		DATS	8	0	ELM: List Change Date
100	TIME_CHANGED_ON	☐	CRMT_MKTLIST_TIME_CHANGED_ON		TIMS	6	0	ELM: List Change Time
101	CREATED_BY_TEXT	☐			STRG	0	0
102	CHANGED_BY_TEXT	☐			STRG	0	0
103	.INCLUDE	☐				0	0	CRM Marketing: External List - Customer Enhancements
104	CUSTOMER_EXT	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
105	.INCLUDE	☐				0	0	CRM 7.0 Extension Include for ELM
106	ELM_H_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
107	.INCLUDE	☐				0	0	ELM: Attributes of ELM List for MC Maintenance - GenIL
108	FLAG_MAINT_MC	☐	CRMT_MKTLIST_FLAG_MAINT_MC_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Marked Step for Maintaining Mkt. Prospects - GenIL
109	STATUS_MAINT_MC	☐	CRMT_MKTLIST_STATUS_MAIN_MC_IL	CRM_MKTLIST_PACKAGE_STATUS	CHAR	1	0	ELM: Step Status for Maintaining Marketing Prospect - GenIL
110	ATTR_ERROR_MAINT_MC	☐	CRMT_MKTLIST_ERRORS_MAIN_MC_IL	CRM_MKTLIST_PACKAGE_ATTR_ERR	CHAR	1	0	ELM: Error Attribute for Maintaining Mkt. Prospects - GenIL
111	APPL_LOG_ID_MAINT_MC	☐	CRMT_MKTLIST_MAINT_MC_LOG_IL	SYSUUID_22	CHAR	22	0	ELM: Marketing Prospect Creation Handle - BOL / GenIL
112	.INCLUDE	☐				0	0	ELM: TREX Upload Attributes for Marketing prospects
113	FLAG_UPLD_MC_TREX	☐	CRMT_MKTLIST_FLAG_UPLD_MTRX_IL	CRM_BOOLEAN	CHAR	1	0	ELM: Marked Step for Upload of Marketing Prospects to TREX
114	STATUS_UPLD_MC_TREX	☐	CRMT_MKTLIST_STS_UPLD_MTRX_IL	CRM_MKTLIST_PACKAGE_STATUS	CHAR	1	0	ELM: Step Status for Upload of Marketing Prospects to TREX
115	ATTR_ERROR_UPLD_MC_TREX	☐	CRMT_MKTLIST_ERR_UPLD_MTRX_IL	CRM_MKTLIST_PACKAGE_ATTR_ERR	CHAR	1	0	ELM: Error Attribute for Upload Marketing Prospects to TREX
116	APPL_LOG_ID_UPLD_TREX	☐	CRMT_MKTLIST_UPLD_MTRX_LOG_IL	SYSUUID_22	CHAR	22	0	ELM: Upload of Marketing Prospects to TREX Handle - GenIL

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_ELM_L_ATTR_IL	ORIGIN	CRMC_MKTLIST_O	ORIGIN
2	CRMT_ELM_L_ATTR_IL	TYPE	CRMC_MKTLIST_T	TYPE

History

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