| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | GUID | MWB: GUID of a Node in the Hierarchy | nvarchar | 22 | 0 | CHAR | (N' ') | No | | DMC_STREE_GUID | Allow NULL? |
| 2 | CONTAINER | MWB: GUID of a Container for Metadata | nvarchar | 22 | 0 | CHAR | (N' ') | No | DMC_CNTN | DMC_CONTAINER_GUID | Allow NULL? |
| 3 | STYPE | DMC: Flag if receiver or sender structure | char | 1 | 0 | CHAR | (N' ') | No | | DMC_SRTYPE | Allow NULL? |
| 4 | SEQNUM | DMC: Position in Tree Depth-First | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | DMC_SEQNO | Allow NULL? |
| 5 | IDENT | Tree Structure ID | nvarchar | 20 | 0 | CHAR | (N' ') | No | | DMC_STIDT | Allow NULL? |
| 6 | STRUCT | MWB: GUID of a Data Structure | nvarchar | 22 | 0 | CHAR | (N' ') | No | | DMC_STRUCT_GUID | Allow NULL? |
| 7 | FILEDESC | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | GUID_22 | Allow NULL? |
| 8 | PREC | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | GUID_22 | Allow NULL? |
| 9 | VERSIO | Version Number of Objects | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | DMC_VERSIO | Allow NULL? |
| 10 | CHNAM | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 11 | STRUCLEVEL | DMC: Structure Level of a Node | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DMC_SLEVEL | Allow NULL? |
| 12 | PARENTID | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | GUID_22 | Allow NULL? |
| 13 | CHANGEDATE | System Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATUM | Allow NULL? |
| 14 | AUTHOR | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 15 | CREATEDATE | System Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATUM | Allow NULL? |
| 16 | DESCR | Description | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | DMC_DESCR | Allow NULL? |
| 17 | REFNAME | Reference to Original Sender/Receiver Structure | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | DMC_REFNM | Allow NULL? |
| 18 | STREE_TYPE | Tree types, like table type, structure, etc. | char | 1 | 0 | CHAR | (N' ') | Yes | | DMC_STREE_TYPE | Allow NULL? |
