| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MTPROF_ID | Material tracking profile ID | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | OBJTY_INIT | Object type for document flow | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | DFPROF_ID | Document flow profile ID | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | DFPINV_01 | Flag: invert document flow profile | char | 1 | 0 | | | | Allow NULL? |
| 6 | DFPROF_02 | Document flow profile ID | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | DFPINV_02 | Flag: invert document flow profile | char | 1 | 0 | | | | Allow NULL? |
| 8 | DFPMRG_02 | Flag: merge document flow | char | 1 | 0 | | | | Allow NULL? |
| 9 | TRGRP_01 | Tracking group id | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | TRGRP_02 | Tracking group id | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | TRGRP_03 | Tracking group id | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | TRGRP_04 | Tracking group id | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | TRGRP_05 | Tracking group id | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | OUTPUT_TYPE | Material tracking output type | char | 1 | 0 | | | | Allow NULL? |
| 15 | SFORM | Smart form for tracking output (not used at present) | nvarchar | 30 | 0 | | | | Allow NULL? |
| 16 | XEXTR | Flag: Profile may be used to prepare extract | char | 1 | 0 | | | | Allow NULL? |
| 17 | X_SEL_STATUS_LO | Flag: select by low bound status | char | 1 | 0 | | | | Allow NULL? |
| 18 | X_SEL_STATUS_HI | Flag: Selection by high bound status | char | 1 | 0 | | | | Allow NULL? |
| 19 | X_DEL_PARENT | Flag: parent is deleted when all children deleted | char | 1 | 0 | | | | Allow NULL? |
| 20 | OBJCT_W | Tracking object count - warning | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | OBJCT_E | Tracking object count - error | nvarchar | 10 | 0 | | | | Allow NULL? |