SAP Table COLUMNS_ST
DB02: dba_tab_columns (Oracle)
COLUMNS_ST (DB02: dba_tab_columns (Oracle)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link COLUMNS_ST to other SAP tables.
COLUMNS_ST table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| COLUMN_N | Column name | COLUMN_N | CHAR | 30 | 0 | |||
| DATA_TYPE | datatype of the column | DATA_TYPE | CHAR | 10 | 0 | |||
| DATA_LENG | length of the column in bytes | DATA_LENG | INT4 | 10 | 0 | |||
| DATA_PREC | length: decimal digits (number) or binary | DATA_PREC | CHAR | 10 | 0 | |||
| DATA_SCALE | decimal places | DATA_SCALE | INT4 | 10 | 0 | |||
| NULLABLE | does column allow null values? | NULLABLE_C | CHAR | 4 | 0 | |||
| COLUMN_ID | sequence number of the column as created | COLUMN_ID | DEC | 14 | 0 | |||
| DEF_LENGTH | length of default value for the column | DEF_LENGTH | DEC | 14 | 0 | |||
| DATA_DEF | default value for the column | DATA_DEF | CHAR | 14 | 0 | |||
| NUM_DISTIN | number of distinct values in the column | NUM_DISTIN | DEC | 14 | 0 | |||
| LOW_VALUE | the low value in the column | LOW_VALUE | CHAR | 14 | 0 | |||
| HIGH_VALUE | the high value in the column | HIGH_VALUE | CHAR | 30 | 0 | |||
| DENSITY | density of the column | DENSITY | DEC | 14 | 0 | |||
| NUM_NULLS | number of nulls in the column | NUM_NULLS | DEC | 14 | 0 | |||
| NUM_BUCKET | Number of buckets in histogram | NUM_BUCKET | DEC | 14 | 0 | |||
| LAST_ANAL | date of the most recent analysis | LAST_ANAL | DATS | 8 | 0 | |||
| SAMP_SIZE | sample size used in analyzing this column | SAMP_SIZE | DEC | 14 | 0 | |||
