SAP ABAP Table MSSPLANGUIDESTRUC (Plan guide information)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSSPLANGUIDESTRUC	Table Relationship Diagram
Short Description	Plan guide information

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	PLANGUIDEID	☐	MSSPLANGUIDEID	INT4	INT4	10	0	Plan guide ID
2	PLANGUIDENAME	☐	MSSPLANGUIDE	MSSSYSNAME	CHAR	128	0	Planguide name
3	PLANCRDT	☐	MSSPLANCRDT		CHAR	24	0	Plan guide creation date
4	PLANMODDT	☐	MSSPLANMODDT		CHAR	24	0	Plan guide modification date
5	PLANDISABLED	☐	MSSPLANDISABLED	INT1	INT1	3	0	Plan is disabled
6	PLAN_QUERY	☐	MSSPLANQUERY		CHAR	1024	0	Plan guide query text
7	PLAN_SCOPETYPE	☐	MSSPLANSCOPETYPE	INT4	INT4	10	0	Scope type
8	PLAN_SCOPETYPEDESC	☐	MSSPLANSCOPETYPEDESC		CHAR	60	0	Plan guide scope type description
9	PLAN_PARAMS	☐	MSSPLANPARAMS		CHAR	1024	0	Plan guide parameters
10	PLAN_HINTS	☐	MSSPLANHINTS		CHAR	1024	0	Plan guide hints

History

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