| 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 | AUFPL | Routing number of operations in the order | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | CO_AUFPL | Allow NULL? |
| 3 | APLZL | General counter for order | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | AFVC | CO_APLZL | Allow NULL? |
| 4 | APHZL | Internal Sub-Calculation Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PLNPH | Allow NULL? |
| 5 | AFTZL | Internal process instruction number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PLNFT | Allow NULL? |
| 6 | AFVZL | Internal PI characteristic/characteristic value number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PLNFV | Allow NULL? |
| 7 | PLNTY | Task List Type | char | 1 | 0 | CHAR | (N' ') | No | TCA01 | PLNTY | Allow NULL? |
| 8 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | CHAR | (N' ') | No | | PLNNR | Allow NULL? |
| 9 | PLNKN | Number of the task list node | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PLNKN | Allow NULL? |
| 10 | PLNPH | Internal Sub-Calculation Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PLNPH | Allow NULL? |
| 11 | PLNFT | Internal process instruction number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PLNFT | Allow NULL? |
| 12 | PLNFV | Internal PI characteristic/characteristic value number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PLNFV | Allow NULL? |
| 13 | ZAEHL | Internal counter | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | CIM_COUNT | Allow NULL? |
| 14 | FVLNR | Line Number of Process Instruction Characteristic | nvarchar | 4 | 0 | CHAR | (N' ') | No | | R_FVNR | Allow NULL? |
| 15 | ATINN | Internal characteristic | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | * | ATINN | Allow NULL? |
| 16 | ATZHL | Int counter | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | ATZHL | Allow NULL? |
| 17 | ATWRT | Characteristic Value | nvarchar | 30 | 0 | CHAR | (N' ') | No | | ATWRT | Allow NULL? |
| 18 | ATFLV | Internal floating point from | float | 15 | 16 | FLTP | ((0)) | No | | ATFLV | |
| 19 | ATFLB | Internal floating point value to | float | 15 | 16 | FLTP | ((0)) | No | | ATFLB | |
| 20 | ATCOD | Code for value dependency | char | 1 | 0 | CHAR | (N' ') | No | | ATCOD | Allow NULL? |
| 21 | ATAWE | Alternative unit | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | ATAWE | Allow NULL? |
| 22 | ATAW1 | Alternative unit | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | ATAWE | Allow NULL? |
| 23 | ATFOR | Data type of characteristic | nvarchar | 4 | 0 | CHAR | (N' ') | No | | ATFOR | Allow NULL? |
| 24 | WRTKZ | Indicator: Characteristic value assigned | char | 1 | 0 | CHAR | (N' ') | No | | CO_WRTKZ | Allow NULL? |
| 25 | TXTSP | Language Key | char | 1 | 0 | LANG | (N' ') | No | T002 | LANGU | Allow NULL? |
| 26 | AENNR | Change Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AENNR | Allow NULL? |
