| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PLNTY | Task List Type | char | 1 | 0 | | | | Allow NULL? |
| 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | PLNAL | Group Counter | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | ZAEHL | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | TECHV | Technical status from | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | AENNR | Change Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | LOEKZ | Deletion Indicator | char | 1 | 0 | | | | Allow NULL? |
| 10 | PARKZ | Indicator: inactive changes | char | 1 | 0 | | | | Allow NULL? |
| 11 | ANDAT | Date record created on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | ANNAM | User who created record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | VERWE | Task list usage | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | STATU | Status | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | PLNME | Task list unit of measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | LOSVN | From Lot Size | decimal | 13 | 3 | | | | |
| 20 | LOSBS | To lot size | decimal | 13 | 3 | | | | |
| 21 | VAGRP | Responsible planner group/department | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | AESZN | Document change number (without document management system) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 23 | KTEXT | Task list description | nvarchar | 40 | 0 | | | | Allow NULL? |
| 24 | TXTSP | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 25 | ABDAT | Date of the last call | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | ABANZ | Number of calls | decimal | 4 | 0 | | | | |
| 27 | PROFIDNETZ | Profile | nvarchar | 7 | 0 | | | | Allow NULL? |
| 28 | KOKRS | Controlling Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | QVEWERKS | Plant of Selected Set for Automatic Usage Decision | nvarchar | 4 | 0 | | | | Allow NULL? |
| 30 | QVEMENGE | Selected Set for Usage Decision | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | QVEVERSION | Code Version Used for an Automatic Usage Decision | nvarchar | 6 | 0 | | | | Allow NULL? |
| 32 | QVEDATUM | Date of Code Used for Usage Decision | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | QVEGRUPPE | Code Group for Automatic Usage Decision | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | QVECODE | Code for Automatic Usage Decision | nvarchar | 4 | 0 | | | | Allow NULL? |
| 35 | QDYNREGEL | Dynamic Modification Rule | nvarchar | 3 | 0 | | | | Allow NULL? |
| 36 | QDYNHEAD | Level at Which Dynamic Modification Parameters Are Defined | char | 1 | 0 | | | | Allow NULL? |
| 37 | QPRZIEHVER | Sample-Drawing Procedure | nvarchar | 8 | 0 | | | | Allow NULL? |
| 38 | QVERSNPRZV | Version No. of the Sample-Drawing Procedure | nvarchar | 6 | 0 | | | | Allow NULL? |
| 39 | QKZRASTER | Inspection Point | char | 1 | 0 | | | | Allow NULL? |
| 40 | QDYNSTRING | String for Dynamic Modification Criteria (Database Relevant) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 41 | STRAT | Maintenance strategy | nvarchar | 6 | 0 | | | | Allow NULL? |
| 42 | PPOOL | Maintenance package pool | nvarchar | 6 | 0 | | | | Allow NULL? |
| 43 | ISTRU | Assembly | nvarchar | 18 | 0 | | | | Allow NULL? |
| 44 | IWERK | Maintenance Planning Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 45 | ANLZU | Syst.Condition | char | 1 | 0 | | | | Allow NULL? |
| 46 | ARBID | Work center group with planning function | nvarchar | 8 | 0 | | | | Allow NULL? |
| 47 | EXTNUM | External Numbering of Units to be Inspected | char | 1 | 0 | | | | Allow NULL? |
| 48 | DELKZ | Indicator: Delete completely in reorganization run | char | 1 | 0 | | | | Allow NULL? |
| 49 | ARBTY | Object types of the CIM resource | nvarchar | 2 | 0 | | | | Allow NULL? |
| 50 | STUPR | Setup recipe | nvarchar | 8 | 0 | | | | Allow NULL? |
| 51 | CLNDR | Clean-out recipe | nvarchar | 8 | 0 | | | | Allow NULL? |
| 52 | PRTYP | Process type | char | 1 | 0 | | | | Allow NULL? |
| 53 | REODAT | Archive date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 54 | NETID | Object ID of the resource | nvarchar | 8 | 0 | | | | Allow NULL? |
| 55 | FLG_CHK | Ind: Task list was submitted for consistency check | char | 1 | 0 | | | | Allow NULL? |
| 56 | PSPNR | Standard WBS element | nvarchar | 8 | 0 | | | | Allow NULL? |
| 57 | TTRAS | Task lists: Internal representation of the period pattern | nvarchar | 6 | 0 | | | | Allow NULL? |
| 58 | KZKFG | Ind: Configurable object | char | 1 | 0 | | | | Allow NULL? |
| 59 | PLNNR_ALT | Old number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 60 | FLG_CAPO | Recalculate standard values at order creation using CAPP | char | 1 | 0 | | | | Allow NULL? |
| 61 | STLTY | BOM category | char | 1 | 0 | | | | Allow NULL? |
| 62 | STLNR | Bill of material | nvarchar | 8 | 0 | | | | Allow NULL? |
| 63 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | | | Allow NULL? |
| 64 | SLWBEZ | Identification for the Inspection Point Field Combination | nvarchar | 3 | 0 | | | | Allow NULL? |
| 65 | PPKZTLZU | Partial Lot Assignment in an Inspection During Production | char | 1 | 0 | | | | Allow NULL? |
| 66 | CHRULE | Change rule | char | 1 | 0 | | | | Allow NULL? |
| 67 | CCOAA | Change Type for Object | nvarchar | 3 | 0 | | | | Allow NULL? |
| 68 | ST_ARBID | Object ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 69 | MEINH | Unit of Measure for Activity/Operation | nvarchar | 3 | 0 | | | | Allow NULL? |
| 70 | UMREZ | Numerator for converting task list and oper. un. of measure | decimal | 5 | 0 | | | | |
| 71 | UMREN | Denominator for converting rtg and op units of measure | decimal | 5 | 0 | | | | |
| 72 | BMSCH | Base Quantity | decimal | 13 | 3 | | | | |
| 73 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | | | | Allow NULL? |
| 74 | MS_FLAG | Indicator: Multiple Specifications | char | 1 | 0 | | | | Allow NULL? |
| 75 | TSTMP_BW | Time Stamp for BI Delta Extraction | decimal | 16 | 0 | | | | |
| 76 | MES_ROUTINGID | Key of a Routing from an ME System | nvarchar | 64 | 0 | | | | Allow NULL? |
| 77 | XHIERTL | Sign: Task List Contains Hierarchical Operations | char | 1 | 0 | | | | Allow NULL? |
| 78 | TL_EXTID | A&D: External ID of Task List | nvarchar | 40 | 0 | | | | Allow NULL? |
