SAP ABAP Table CRMT_MKTLIST_IL_SEARCH_IN (CRM Marketing : IL List Search Parameters)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-EAL (Application Component) External List Management
     ⤷ CRM_MKTLIST_INTERFACES (Package) CRM Marketing: External List Management - Interfaces 4.0

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_MKTLIST_IL_SEARCH_IN	Table Relationship Diagram
Short Description	CRM Marketing : IL List Search Parameters

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	DESCRIPTION	☐	CRMT_MKTLIST_DESCRIPTION	CRM_MKTLIST_DESCRIPTION	CHAR	60	0	CRM Marketing: External List - Description
2	.INCLUDE	☐				0	0	External List - Header
3	.INCLUDE	☐				0	0	CRM Marketing: External List - Key
4	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	LIST_GUID	☐	CRMT_MKTLIST_LIST_GUID	CRM_MKTLIST_LIST_GUID	RAW	16	0	CRM Marketing: GUID for an External List
6	.INCLUDE	☐				0	0	CRM Marketing: External List - Header with External Fields
7	LIST_ID	☐	CRMT_MKTLIST_LIST_ID	CRM_MKTLIST_LIST_ID	CHAR	28	0	CRM Marketing: ID for External List
8	LIST_ID_LOGSYS	☐	CRMT_MKTLIST_LIST_ID_LOGSYS	LOGSYS	CHAR	10	0	CRM Marketing: External List - Logical System for ID	*
9	ORIGIN	☐	CRMT_MKTLIST_ORIGIN	CRM_MKTLIST_ORIGIN	CHAR	6	0	CRM Marketing: External List - Origin	CRMC_MKTLIST_O
10	TYPE	☐	CRMT_MKTLIST_TYPE	CRM_MKTLIST_TYPE	CHAR	2	0	CRM Marketing: External List - Type	*
11	VALID_DATE_TO	☐	CRMT_MKTLIST_VALID_DATE_TO	CRM_MKTLIST_VALID_DATE_TO	DATS	8	0	CRM Marketing: Recommended End-of-Use Date
12	MAX_USAGE_NO	☐	CRMT_MKTLIST_MAX_USAGE	CRM_MKTLIST_MAX_USAGE	NUMC	4	0	CRM Marketing: Permitted Number of Uses
13	MAX_USAGE_DATE	☐	CRMT_MKTLIST_USAGE_DATE	CRM_MKTLIST_USAGE_DATE	DATS	8	0	CRM Marketing: Permitted End-of-Use Date
14	NO_GROSS	☐	CRMT_MKTLIST_NO_GROSS	CRM_MKTLIST_NO_GROSS	NUMC	8	0	CRM Marketing: External List - Gross Number
15	COSTS	☐	CRMT_MKTLIST_COST	WERTV8	CURR	15	2	CRM Marketing: External List - Costs
16	COSTS_CURRENCY	☐	CRMT_MKTLIST_CURRENCY	WAERS	CUKY	5	0	CRM Marketing: External List - Currency	*
17	.INCLUDE	☐				0	0	CRM Marketing: External List - Change Information
18	CREATED_AT	☐	CRMT_MKT_CREATED_AT	BCOS_TSTMP	DEC	15	0	Marketing Object: Creation Date
19	CREATED_BY	☐	CRMT_MKT_CREATED_BY	UNAME	CHAR	12	0	Marketing Object: Created By User
20	CHANGED_AT	☐	CRMT_MKT_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Marketing Object: Date of Last Change
21	CHANGED_BY	☐	CRMT_MKT_CHANGED_BY	UNAME	CHAR	12	0	Marketing Object: Last Changed By
22	DELETED	☐	CRMT_MKTLIST_DELETED	CRM_MKTLIST_DELETED	CHAR	1	0	CRM Marketing: External List - Deleted Flag
23	.INCLUDE	☐				0	0	CRM Marketing: External List - Application Log ID
24	APPL_LOG_ID	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
25	VALID_DATE_RANGE	☐	RSDATRANGE		STRU	0	0
26	SIGN	☐	TVARV_SIGN	SYCHAR01	CHAR	1	0	ABAP: ID: I/E (include/exclude values)
27	OPTION	☐	TVARV_OPTI	SYCHAR02	CHAR	2	0	ABAP: Selection option (EQ/BT/CP/...)
28	LOW	☐	SYDATUM	SYDATS	DATS	8	0	System Date
29	HIGH	☐	SYDATUM	SYDATS	DATS	8	0	System Date
30	USAGE_DATE_RANGE	☐	RSDATRANGE		STRU	0	0
31	SIGN	☐	TVARV_SIGN	SYCHAR01	CHAR	1	0	ABAP: ID: I/E (include/exclude values)
32	OPTION	☐	TVARV_OPTI	SYCHAR02	CHAR	2	0	ABAP: Selection option (EQ/BT/CP/...)
33	LOW	☐	SYDATUM	SYDATS	DATS	8	0	System Date
34	HIGH	☐	SYDATUM	SYDATS	DATS	8	0	System Date
35	PARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
36	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
37	CREATED_DATE_RANGE	☐	RSDATRANGE		STRU	0	0
38	SIGN	☐	TVARV_SIGN	SYCHAR01	CHAR	1	0	ABAP: ID: I/E (include/exclude values)
39	OPTION	☐	TVARV_OPTI	SYCHAR02	CHAR	2	0	ABAP: Selection option (EQ/BT/CP/...)
40	LOW	☐	SYDATUM	SYDATS	DATS	8	0	System Date
41	HIGH	☐	SYDATUM	SYDATS	DATS	8	0	System Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_MKTLIST_IL_SEARCH_IN	CLIENT	T000	MANDT
2	CRMT_MKTLIST_IL_SEARCH_IN	ORIGIN	CRMC_MKTLIST_O	ORIGIN

History

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