| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | APPLCLASS | Application class for DD objects (not used) | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | APPLCLASS | Allow NULL? |
| 3 | SUBCLASS | Subgroup by application class | nvarchar | 2 | 0 | CHAR | (N' ') | No | | SUBCLASS | Allow NULL? |
| 4 | TABNAME | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TABNAME | Allow NULL? |
| 5 | REPID | Report | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | CFREPID2 | Allow NULL? |
| 6 | METHOD | Data mining method | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | DM_METHOD | Allow NULL? |
| 7 | RESULTNO | No. of data mining process | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | DM_RESNO | Allow NULL? |
| 8 | UNAME | User name | nvarchar | 12 | 0 | CHAR | (N' ') | No | | CFUNAME | Allow NULL? |
| 9 | SAVEDATE | Results saved on date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DM_SAVEDAT | Allow NULL? |
| 10 | SAVETIME | Saved at time | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | DM_SAVETIM | Allow NULL? |
| 11 | METH_TEXT | Description of data mining method | nvarchar | 20 | 0 | CHAR | (N' ') | No | | DM_METHTXT | Allow NULL? |
| 12 | MAX_AUFSP | Maximum Number of Drilldowns | nvarchar | 3 | 0 | NUMC | (N'000') | No | | DM_MAXAUF | Allow NULL? |
| 13 | DIST_OBJ | Max. interval between adjacent objects in data mining | nvarchar | 3 | 0 | NUMC | (N'000') | No | | DM_DIST_OB | Allow NULL? |
| 14 | DIST_DIM | Max. Dispersion to Next Drilldown Dimension | nvarchar | 3 | 0 | NUMC | (N'000') | No | | DM_DIST_DI | Allow NULL? |
| 15 | OUTPUT | Minimum homogeneousness | decimal | 6 | 4 | DEC | ((0)) | No | | DM_OUTPUT | |
| 16 | BREAKDOWN | Maximum homogeneousness | decimal | 6 | 4 | DEC | ((0)) | No | | DM_BREAKD | |
| 17 | VAR_VERF | Method of calculating variance | char | 1 | 0 | CHAR | (N' ') | No | | DM_VARVERF | Allow NULL? |
| 18 | CODE | Function name | nvarchar | 4 | 0 | CHAR | (N' ') | No | | DM_CODE | Allow NULL? |
| 19 | BOPE | Condition parameter | nvarchar | 2 | 0 | CHAR | (N' ') | No | | DM_BOPE | Allow NULL? |
| 20 | BWRT | Condition value | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | DM_BWRT | Allow NULL? |
| 21 | FILT_END | Summarize results? | char | 1 | 0 | CHAR | (N' ') | No | | DM_PRUNE | Allow NULL? |
| 22 | FILT_EXPL | Explicit filtering | char | 1 | 0 | CHAR | (N' ') | No | | DM_FILTER | Allow NULL? |
| 23 | FILT_PROC | Avoid redundancies in data mining | char | 1 | 0 | CHAR | (N' ') | No | | DM_PROC | Allow NULL? |
| 24 | TIME_OUT | Maximum runtime in data mining process | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | DM_TIMEOUT | Allow NULL? |
| 25 | VAL_WEIGHT | Values excluded for absolute basis | nvarchar | 100 | 0 | CHAR | (N' ') | No | | DMVALWEIGH | Allow NULL? |
| 26 | VAL_CONTRO | Values excluded for search ratio | nvarchar | 100 | 0 | CHAR | (N' ') | No | | DMVALCONTR | Allow NULL? |
| 27 | WEI_WEIGHT | Weighting of absolute basis | nvarchar | 2 | 0 | NUMC | (N'00') | No | | DMWEIWEIGH | Allow NULL? |
| 28 | WEI_CONTRO | Weighting of search ratio | nvarchar | 2 | 0 | NUMC | (N'00') | No | | DMWEICONTR | Allow NULL? |
| 29 | DUMMYPARA | Dummy data element | nvarchar | 10 | 0 | CHAR | (N' ') | No | | DM_DUMMY | Allow NULL? |
| 30 | FORM | Form | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | RKE_CFORM | Allow NULL? |
| 31 | STATUS01 | Status 1 of analysis results | char | 1 | 0 | CHAR | (N' ') | No | | DM_STAT01 | Allow NULL? |
| 32 | STATUS02 | Status 2 of analysis results | char | 1 | 0 | CHAR | (N' ') | No | | DM_STAT02 | Allow NULL? |
| 33 | POINTER01 | Pointer to display table with objects | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | DM_POINT01 | Allow NULL? |
| 34 | POINTER02 | Pointer to display table with key figures | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | DM_POINT02 | Allow NULL? |
| 35 | DATDATE | Date of defined COIX data | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | CFCOIXDDAT | Allow NULL? |
| 36 | DATTIME | Time of defined data in COIX | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | CFCOIXDTIM | Allow NULL? |
| 37 | SEL_FLAG | Checkbox | char | 1 | 0 | CHAR | (N' ') | No | | DM_SELFLAG | Allow NULL? |
