| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | PLNTY | Task List Type | char | 1 | 0 | CHAR | (N' ') | No | * | PLNTY | Allow NULL? |
| 3 | PLNNR | Number of the Standard Network | nvarchar | 8 | 0 | CHAR | (N' ') | No | | AOB_PLNNR | Allow NULL? |
| 4 | PLNAL | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | No | | PLNAL | Allow NULL? |
| 5 | PLNKN | Number of the task list node | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PLNKN | Allow NULL? |
| 6 | PLNRN | Number of the Standard Network | nvarchar | 8 | 0 | CHAR | (N' ') | No | | AOB_PLNNR | Allow NULL? |
| 7 | ALNRN | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | No | | PLNAL | Allow NULL? |
| 8 | KNNRN | Number of the task list node | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PLNKN | Allow NULL? |
| 9 | AOBAR | Type of relationship | nvarchar | 2 | 0 | CHAR | (N' ') | No | | AOBAR | Allow NULL? |
| 10 | MIMAX | Indicates whether maximum time interval will be considered | char | 1 | 0 | CHAR | (N' ') | No | | DAUMIMAX | Allow NULL? |
| 11 | ZAEHL | Internal counter | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | CIM_COUNT | Allow NULL? |
| 12 | DATUV | Valid-from date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CIM_DATE | Allow NULL? |
| 13 | TECHV | Technical status from | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TECHV | Allow NULL? |
| 14 | AENNR | Change Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AENR | AENNR | Allow NULL? |
| 15 | ZEINH | Unit for the time interval between relationships | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | AOBDAUEH | Allow NULL? |
| 16 | DAUER | Time interval between relationships | decimal | 5 | 1 | QUAN | ((0)) | Yes | | AOBDAUER | |
| 17 | DAUKZ | Indicator for the duration of the relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | AOBDAUKZ | Allow NULL? |
| 18 | VORNC | Indicator: maintained after successor | char | 1 | 0 | CHAR | (N' ') | Yes | | VORG_NACH | Allow NULL? |
| 19 | NCVOR | Indicates whether data after predecessor is maintained | char | 1 | 0 | CHAR | (N' ') | Yes | | NACH_VORG | Allow NULL? |
| 20 | LOEKZ | Asset class marked for deletion | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEKZ | Allow NULL? |
| 21 | KALID | Factory Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | WFCID | Allow NULL? |
| 22 | PRZNT | % used to calc. time interval between predecessor/successor | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | AOB_PRZNT | Allow NULL? |
| 23 | PROVG | Key for defining time intervals in a relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | AOB_PROVG | Allow NULL? |
| 24 | ARBID | Object ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | OBJEKTID | Allow NULL? |
| 25 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 26 | ANDAT | Date record created on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ANDAT | Allow NULL? |
| 27 | ANNAM | User who created record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ANNAM | Allow NULL? |
| 28 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 29 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 30 | DAUERMAX | Maximum time interval for relationship | decimal | 5 | 1 | QUAN | ((0)) | Yes | | AOBDAUERM | |
