SAP ABAP Table MSSPARTDIST (Partition distribution information for a partitioned table)

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	MSSPARTDIST	Table Relationship Diagram
Short Description	Partition distribution information for a partitioned table

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	COLNAME	☐	MSSCOLUMN	MSSSYSNAME	CHAR	128	0	Column name
2	FUNCNAME	☐	MSSPARTFUNC	MSSSYSNAME	CHAR	128	0	Partition function name
3	PARTNO	☐	MSSPARTORD	INT2	INT2	5	0	Partition ordinal (or ID)
4	LOW_BOUNDARY	☐	MSSPARTLOWBOUND	MSSPARTVAL	CHAR	128	0	Description of the low boundary of a partition
5	HIGH_BOUNDARY	☐	MSSPARTHIGHBOUND	MSSPARTVAL	CHAR	128	0	Description of the high boundary of a partition
6	NROWS	☐	MSSPARTNUMROWS		CHAR	16	0	Number of rows in a partition (possibly '-') therefore char
7	MIN_VAL	☐	MSSPARTVALMIN	MSSPARTVAL	CHAR	128	0	Minimum val stored in a partition for the partitioning field
8	MAX_VAL	☐	MSSPARTVALMAX	MSSPARTVAL	CHAR	128	0	Max value stored in a partition for the partitioning field

History

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