| 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 | * | S_MANDT | Allow NULL? |
| 2 | USERNAME | User name for NWG customizing variant data | nvarchar | 30 | 0 | CHAR | (N' ') | No | | FCML_NWG_USER | Allow NULL? |
| 3 | PARENT_KEY | 30 Characters | nvarchar | 30 | 0 | CHAR | (N' ') | No | | CHAR30 | Allow NULL? |
| 4 | ROW_KEY | 30 Characters | nvarchar | 30 | 0 | CHAR | (N' ') | No | | CHAR30 | Allow NULL? |
| 5 | EXPANDED | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 6 | IS_LEAF | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 7 | TECH_NAME | 30 Characters | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CHAR30 | Allow NULL? |
| 8 | TEXT | FPM: Text for the Explanation Control | ntext | 1073741823 | 0 | | | Yes | | FPM_TEXT | |
| 9 | CHILDREN_LOADED | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 10 | IMAGE_SRC | Image Source | ntext | 1073741823 | 0 | | | Yes | | FPMGB_IMAGE_SRC | |
| 11 | BOX_DISPLAY | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 12 | TOOLTIP_DISPLAY | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 13 | CATEID | Category ID for NWG customizing master data item | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | FCML_NWG_CATEID | Allow NULL? |
| 14 | CATENAME | Category Name for NWG customizing master data item | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | FCML_NWG_CATENAME | Allow NULL? |
| 15 | SUBCATEID | Sub-category ID for NWG customizing master data item | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FCML_NWG_SUBID | Allow NULL? |
| 16 | SUBCATENAME | Sub-category Name for NWG customizing master data item | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | FCML_NWG_SUBNAME | Allow NULL? |
| 17 | FIELDID | Field ID in NWG customizing master data item | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | FCML_NWG_FID | Allow NULL? |
| 18 | FIELDNAME | Field Name for NWG customizing master data item | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | FCML_NWG_FNAME | Allow NULL? |
| 19 | FIELDSDESC | Medium Field Label | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SCRTEXT_M | Allow NULL? |
| 20 | FIELDDESC | Long Field Label | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SCRTEXT_L | Allow NULL? |
| 21 | CB_RO_REF | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 22 | DD_RO_REF | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 23 | PT_RO_REF | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 24 | CD_CC_REF | Web Dynpro: TableCellDesign | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | WDUI_TABLE_CELL_DESIGN | Allow NULL? |
| 25 | SAVEDATE | Date in CHAR format | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | DATE | Allow NULL? |
| 26 | SAVETIME | Time hhmmss (in the Basis) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | TIME06 | Allow NULL? |