| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | AUFNR | Order number historical | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | UVORN | Suboperation | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | AUFPL | Routing number of operations in the order | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | APLZL | General counter for order | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | PLNTY | Task List Type | char | 1 | 0 | | | | Allow NULL? |
| 8 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | PLNKN | Number of the task list node | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | STEUS | Control key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | ARBPL | Work center | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | ARBID | Object ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | KTSCH | Standard text key | nvarchar | 7 | 0 | | | | Allow NULL? |
| 16 | LTXA1 | Operation short text | nvarchar | 40 | 0 | | | | Allow NULL? |
| 17 | TXTSP | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 18 | ANLZU | Syst.Condition | char | 1 | 0 | | | | Allow NULL? |
| 19 | ISTRU | Assembly | nvarchar | 18 | 0 | | | | Allow NULL? |
| 20 | OBJNR | Object number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 21 | ARBEI | Work involved in the activity | decimal | 7 | 1 | | | | |
| 22 | ARBEH | Unit for work | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | ANZZL | Number of capacities required | tinyint | 3 | 0 | | | | |
| 24 | ISMNW | Actual work | decimal | 13 | 3 | | | | |
| 25 | ISMNE | Unit for work | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | ISDD | Actual start: Execution (date) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | ISDZ | Actual start: Execution/setup (time) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 28 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | IEDZ | Actual finish: Execution (time) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 30 | LOGRP | Wage group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | LOART | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 32 | LOANZ | Number of Time Tickets | decimal | 3 | 0 | | | | |
| 33 | QUALF | Suitability | nvarchar | 2 | 0 | | | | Allow NULL? |
| 34 | RUECK | Completion confirmation number for the operation | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | RMZHL | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | MGVRG | Operation Quantity | decimal | 13 | 3 | | | | |
| 37 | MEINH | Unit of Measure for Activity/Operation | nvarchar | 3 | 0 | | | | Allow NULL? |
| 38 | PREIS | Price | decimal | 11 | 2 | | | | |
| 39 | PEINH | Price Unit | decimal | 5 | 0 | | | | |
| 40 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 41 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | | | |
| 42 | SAKTO | Cost Element | nvarchar | 10 | 0 | | | | Allow NULL? |
| 43 | MATKL | Material Group | nvarchar | 9 | 0 | | | | Allow NULL? |
| 44 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 45 | EKGRP | Purchasing group for external processing | nvarchar | 3 | 0 | | | | Allow NULL? |
| 46 | ESOKZ | Purchasing info record category | char | 1 | 0 | | | | Allow NULL? |
| 47 | INFNR | Number of Purchasing Info Record | nvarchar | 10 | 0 | | | | Allow NULL? |
| 48 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 49 | SORTL | Sort Term for Non-Stock Info Records | nvarchar | 10 | 0 | | | | Allow NULL? |
| 50 | PERNR | Personnel number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 51 | OTYPE | Object Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 52 | OBJEKTID | Object ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 53 | SLWID | Key word ID for user-defined fields | nvarchar | 7 | 0 | | | | Allow NULL? |
| 54 | USR00 | User field with 20 characters | nvarchar | 20 | 0 | | | | Allow NULL? |
| 55 | USR01 | User field with 20 characters | nvarchar | 20 | 0 | | | | Allow NULL? |
| 56 | USR02 | User field with 10 characters | nvarchar | 10 | 0 | | | | Allow NULL? |
| 57 | USR03 | User field with 10 characters | nvarchar | 10 | 0 | | | | Allow NULL? |
| 58 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | | | | |
| 59 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | | | Allow NULL? |
| 60 | USR05 | User field for quantity (length 10.3) | decimal | 13 | 3 | | | | |
| 61 | USE05 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | | | Allow NULL? |
| 62 | USR06 | User-defined field for values (length 10,3) | decimal | 13 | 3 | | | | |
| 63 | USE06 | User field: Unit for value fields | nvarchar | 5 | 0 | | | | Allow NULL? |
| 64 | USR07 | User-defined field for values (length 10,3) | decimal | 13 | 3 | | | | |
| 65 | USE07 | User field: Unit for value fields | nvarchar | 5 | 0 | | | | Allow NULL? |
| 66 | USR08 | User field for date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 67 | USR09 | User field for date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 68 | USR10 | User-defined field: Indicator for reports | char | 1 | 0 | | | | Allow NULL? |
| 69 | USR11 | User-defined field: Indicator for reports | char | 1 | 0 | | | | Allow NULL? |
| 70 | AUFKT | Execution Factor | decimal | 3 | 0 | | | | |
| 71 | TPLNR | Functional Location | nvarchar | 30 | 0 | | | | Allow NULL? |
| 72 | EQUNR | Equipment Number | nvarchar | 18 | 0 | | | | Allow NULL? |
