SAP ABAP Table MSSTABCOL (Table column properties)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ SMSS_TOOLS (Package) Utilities for MS SQL Server

Basic Data

Table Category	INTTAB	Structure
Structure	MSSTABCOL	Table Relationship Diagram
Short Description	Table column properties

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	NAME	☐	MSSCOLUMN	MSSSYSNAME	CHAR	128	0	Column name
2	POSITION	☐	MSSCOLPOS		INT2	5	0	Position of the column in the table
3	TYPE	☐	MSSDATATYPE	MSSSYSNAME	CHAR	128	0	Data type name
4	LENGTH	☐	MSSCOLLENGTH		INT2	5	0	Storage length of the column
5	PRECISION	☐	MSSCOLPREC		INT2	5	0	Precison of the column
6	SCALE	☐	MSSCOLSCALE		INT1	3	0	Scale of the column (only if the data type is numeric)
7	ISNULLABLE	☐	MSSCOLISNULL		INT1	3	0	1/0: column is nullable / not-nullable
8	DEFAULT	☐	MSSDEFAULT	MSSSYSNAME	CHAR	128	0	Default name

History

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