SAP ABAP Table MSSPARTINFO (Partition 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	MSSPARTINFO	Table Relationship Diagram
Short Description	Partition 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	TYPEDESC	☐	MSSPARTTYPE	MSSPARTDOM	CHAR	5	0	Type of Partitioning (such as Range, Hash, ...)
4	DIRECTN	☐	MSSPARTDIR		CHAR	12	0	Partitioning direction
5	FANOUT	☐	MSSPARTFANOUT	INT4	INT4	10	0	Number of partitions created by a partitioning function
6	CRDT	☐	MSSPARTCRDT	DATS	DATS	8	0	Date of creation of a table partition
7	CRTM	☐	MSSPARTCRTM	TIME	TIMS	6	0	Time created
8	MODDT	☐	MSSPARTMODDT	DATS	DATS	8	0	Date of modification of a table partition
9	MODTM	☐	MSSPARTMODTM	TIME	TIMS	6	0	Time modified
10	SCHEME_NAME	☐	MSSPARTSCHEME	MSSSYSNAME	CHAR	128	0	Partitioning scheme name
11	DATATYP	☐	MSSPARTDATATYPE	MSSSYSNAME	CHAR	128	0	Partitioning data type name
12	PART_ORD	☐	MSSPARTORD	INT2	INT2	5	0	Partition ordinal (or ID)

History

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