SAP ABAP Data Element MSSTABOPTS (Table options on locking and memory)

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

Data Element	MSSTABOPTS
Short Description	Table options on locking and memory

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	CHAR10
Data Type	CHAR	Character String
Length	10
Decimal Places	0
Output Length	10
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	10	Options
Medium	15	Table options
Long	20	Table lock option
Heading	17	Table lock option

Documentation

Definition

Table and clustered index options for the table. Value T means true and F means false. There are 10 digits, the first 5 indicate 5 options and the other 5 digits are unused:

1: Clustered index option 'auto update stats'

2: Pintable

3: Table lock on bulk load

4: Allow page locks on the clustered index

5: Allow row locks on the clustered index

If all the above values are set to be true, the column should have the following output:

TTTTT-----

A value of '-' for 1, 4, 5 means the table has no clustered index.

Use

Dependencies

Example

History

Last changed by/on	SAP	20110908
SAP Release Created in	620