SAP ABAP Table CRMT_MKTSC_FS_QUERY (Scenario Planning: Fast search query structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTSC (Package) CRM Marketing Planner - Scenario Planning

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_MKTSC_FS_QUERY	Table Relationship Diagram
Short Description	Scenario Planning: Fast search query structure

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	WKS_EXTERNAL_ID	☐	CRMT_MKTSC_WKS_EXTID	CHAR18	CHAR	18	0	External ID of Scenario Set
2	WKS_VALID_FROM	☐	CRMT_MKTSC_VALID_FROM_FS	BCOS_TSTMP	DEC	15	0	Valid From (Fast Search)
3	WKS_VALID_TO	☐	CRMT_MKTSC_VALID_TO_FS	BCOS_TSTMP	DEC	15	0	Valid To (Fast Search)
4	WKS_CREATED_BY	☐	CRMT_MKTSC_CREATED_BY	UNAME	CHAR	12	0	Created By
5	WKS_CREATED_ON_MIN	☐	CRMT_MKTSC_CREATED_ON_MIN	BCOS_TSTMP	DEC	15	0	Lower Limit for Date and Time of Creation
6	WKS_CREATED_ON_MAX	☐	CRMT_MKTSC_CREATED_ON_MAX	BCOS_TSTMP	DEC	15	0	Upper Limit for Date and Time of Creation
7	WKS_CHANGED_BY	☐	CRMT_MKTSC_CHANGED_BY	UNAME	CHAR	12	0	Last Changed By
8	WKS_CHANGED_ON_MIN	☐	CRMT_MKTSC_CHANGED_ON_MIN	BCOS_TSTMP	DEC	15	0	Lower Limit for Date and Time of Last Change
9	WKS_CHANGED_ON_MAX	☐	CRMT_MKTSC_CHANGED_ON_MAX	BCOS_TSTMP	DEC	15	0	Upper Limit for Date and Time of Last Change
10	WKS_DESCR	☐	CRMT_MKTSC_DESCR	TEXT60	CHAR	60	0	Language-Dependent Description
11	WKS_MKTELEM_EXTID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
12	SCN_EXTERNAL_ID	☐	CRMT_MKTSC_SCN_EXTID	CHAR10	CHAR	10	0	External ID of Scenario
13	SCN_IS_OPERATIVE	☐	CRMT_MKTSC_IS_OPERATIVE_FS		STRG	0	0	Operative Scenario (Fast Search)
14	SCN_CREATED_ON_MIN	☐	CRMT_MKTSC_CREATED_ON_MIN	BCOS_TSTMP	DEC	15	0	Lower Limit for Date and Time of Creation
15	SCN_CREATED_ON_MAX	☐	CRMT_MKTSC_CREATED_ON_MAX	BCOS_TSTMP	DEC	15	0	Upper Limit for Date and Time of Creation
16	SCN_CREATED_BY	☐	CRMT_MKTSC_CREATED_BY	UNAME	CHAR	12	0	Created By
17	SCN_CHANGED_ON_MIN	☐	CRMT_MKTSC_CHANGED_ON_MIN	BCOS_TSTMP	DEC	15	0	Lower Limit for Date and Time of Last Change
18	SCN_CHANGED_ON_MAX	☐	CRMT_MKTSC_CHANGED_ON_MAX	BCOS_TSTMP	DEC	15	0	Upper Limit for Date and Time of Last Change
19	SCN_CHANGED_BY	☐	CRMT_MKTSC_CHANGED_BY	UNAME	CHAR	12	0	Last Changed By
20	SCN_DESCR	☐	CRMT_MKTSC_DESCR	TEXT60	CHAR	60	0	Language-Dependent Description
21	SCN_MKTELEM_EXTID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element

History

Last changed by/on	SAP	20060208
SAP Release Created in	500