| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | VSNMR | Number or description of a version | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | AUFPL_VOR | No. identifying the network to which the predecessor belongs | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | APLZL_VOR | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | AUFPL_NCH | No. identifying the network to which the successor belongs | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | APLZL_NCH | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | AOBAR | Type of relationship | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | MIMAX | Indicates whether maximum time interval will be considered | char | 1 | 0 | | | | Allow NULL? |
| 9 | OBJNR | Object number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 10 | ZEINH | Unit for the time interval between relationships | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | DAUER | Time interval between relationships | decimal | 5 | 1 | | | | |
| 12 | DAUKZ | Indicator for the duration of the relationship | char | 1 | 0 | | | | Allow NULL? |
| 13 | VORNC | Indicator: maintained after successor | char | 1 | 0 | | | | Allow NULL? |
| 14 | NCVOR | Indicates whether data after predecessor is maintained | char | 1 | 0 | | | | Allow NULL? |
| 15 | LOEKZ | Indicates whether an object is logically deleted. | char | 1 | 0 | | | | Allow NULL? |
| 16 | KALID | Factory Calendar | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | PRZNT | % used to calc. time interval between predecessor/successor | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | PROVG | Key for defining time intervals in a relationship | char | 1 | 0 | | | | Allow NULL? |
| 19 | ARBID | Object ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | FSABD | Earliest start date for the relationship | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | FSABZ | Earliest start time for the relationship | nvarchar | 6 | 0 | | | | Allow NULL? |
| 23 | SSABD | Latest start date of the relationship | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | SSABZ | Latest start time of the relationship | nvarchar | 6 | 0 | | | | Allow NULL? |
| 25 | FEABD | Earliest finish date for the relationship | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | FEABZ | Earliest finish time for the relationship | nvarchar | 6 | 0 | | | | Allow NULL? |
| 27 | SEABD | Latest finish date of the relationship | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | SEABZ | Latest finish time of the relationship | nvarchar | 6 | 0 | | | | Allow NULL? |
| 29 | DAUTM | Relationship duration (in seconds) as result of scheduling | int | 10 | 0 | | | | Allow NULL? |
| 30 | AUCRE | Ind.: Relationship automatically generated | char | 1 | 0 | | | | Allow NULL? |
| 31 | DAUERMAX | Maximum time interval for relationship | decimal | 5 | 1 | | | | |
| 32 | AENNR | Change Number | nvarchar | 12 | 0 | | | | Allow NULL? |
