| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PROFIL_ID | Number of iPPE User Profile | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | TREE_ID | Identification of the ALV Tree on the iPPE User Interface | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | URL | Internet/Intranet Address | nvarchar | 255 | 0 | | | | Allow NULL? |
| 5 | NAVTREE_EXT | Width of the Navigation Area | smallint | 5 | 0 | | | | |
| 6 | HEADER_WIDTH | Width of Hierarchy Column | int | 10 | 0 | | | | Allow NULL? |
| 7 | VAR_ASSEMBLY | Use of Variant Assembly | char | 1 | 0 | | | | Allow NULL? |
| 8 | TAPART | iPPE Partner for Time Analysis | nvarchar | 20 | 0 | | | | Allow NULL? |
| 9 | PROFIL_AT1 | Profile ID of the Assignment Tree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | PROFIL_AT2 | Profile ID of the Assignment Tree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | PROFIL_AT3 | Profile ID of the Assignment Tree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | CAX | CAD and DMU Authorization | char | 1 | 0 | | | | Allow NULL? |
| 13 | DOKAR | Document Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | DOKVR | Document Version | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | DOKST | Document Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | DAPPL | Workstation Application | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | FLG_SINGLEFILE | Selection of Exactly One Document Info Record | char | 1 | 0 | | | | Allow NULL? |
| 18 | DISVARIANT | Display Variant for Navigation / Assignment Tree | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | THUMBNAIL | Thumbnail Active | char | 1 | 0 | | | | Allow NULL? |
| 20 | TBN_DOKAR | Document Type for Thumbnail | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | TBN_DAPPL | Workstation Application for Thumbnail | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | REP_TREE | Report Tree Active | char | 1 | 0 | | | | Allow NULL? |
| 23 | APPLICATION | Application in the iPPE Workbench | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | GUI_ID | Identification for GUI Status and Title of an Application | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | STD_PROFIL | Standard Profile for Unassigned Users | char | 1 | 0 | | | | Allow NULL? |
