SAP ABAP Table CRMT_BSP_MKTLIST_SEARCH (Structure for IL search in External List Management (BSP UI))

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_MKTLIST_SEARCH	Table Relationship Diagram
Short Description	Structure for IL search in External List Management (BSP UI)

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

Foreign Keys

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

History

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