| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | ID | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 2 | OBJECT_TYPE | BRFplus: Object Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | VERSION | FDT: Version | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | NAME | FDT: Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 5 | APPLICATION_ID | FDT: Universal Unique Identifier | nvarchar | 32 | 0 | | | | Allow NULL? |
| 6 | ACCESS_LEVEL | FDT: Access Level | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | CR_USER | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | CR_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 9 | CH_USER | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 10 | CH_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 11 | DELETED | FDT: Deleted Option | char | 1 | 0 | | | | Allow NULL? |
| 12 | TRANSPORTED | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 13 | DEPL_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 14 | WTT_TIMESTAMP | FDT: Write to Transport Timestamp | decimal | 15 | 0 | | | | |
| 15 | OSYSID | Name of SAP System | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | OSYSCLIENT | Client name as pure data without special meaning | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | OBSOLETE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 18 | LOCAL_OBJECT | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | | | | Allow NULL? |
| 19 | JOB_ID | FDT: Job ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 20 | TV_STATE | FDT: Truncate versioning state | char | 1 | 0 | | | | Allow NULL? |
| 21 | TV_TIMESTAMP | BRFplus: Date from which on old versions shall be dropped | decimal | 15 | 0 | | | | |
| 22 | TV_SET_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 23 | P_TV_TIMESTAMP | BRFplus: Date from which on versions are dropped physical | decimal | 15 | 0 | | | | |
| 24 | P_TV_SET_TMSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 25 | CR_RELEASE | SAP Release | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | CH_RELEASE | SAP Release | nvarchar | 10 | 0 | | | | Allow NULL? |