| 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 | AUTYP | Order category | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AUFTYP | Allow NULL? |
| 3 | UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | No | | UNAME | Allow NULL? |
| 4 | RUECK | Completion confirmation number for the operation | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | CO_RUECK | Allow NULL? |
| 5 | BUDAT | Posting date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BUCHDATUM | Allow NULL? |
| 6 | ARBID | Object ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | OBJEKTID | Allow NULL? |
| 7 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 8 | LTXA1 | Confirmation text | nvarchar | 40 | 0 | CHAR | (N' ') | No | | CO_RTEXT | Allow NULL? |
| 9 | ISERH | Confirmed break time | decimal | 9 | 3 | QUAN | ((0)) | No | | ISERH | |
| 10 | ZEIER | Unit for the break time | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | DZEIER | Allow NULL? |
| 11 | ILE01 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | CO_ISMNGEH | Allow NULL? |
| 12 | ISM01 | Activity Currently to be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | No | | RU_ISMNG | |
| 13 | ILE02 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | CO_ISMNGEH | Allow NULL? |
| 14 | ISM02 | Activity Currently to be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | No | | RU_ISMNG | |
| 15 | ILE03 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | CO_ISMNGEH | Allow NULL? |
| 16 | ISM03 | Activity Currently to be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | No | | RU_ISMNG | |
| 17 | ILE04 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | CO_ISMNGEH | Allow NULL? |
| 18 | ISM04 | Activity Currently to be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | No | | RU_ISMNG | |
| 19 | ILE05 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | CO_ISMNGEH | Allow NULL? |
| 20 | ISM05 | Activity Currently to be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | No | | RU_ISMNG | |
| 21 | ILE06 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | CO_ISMNGEH | Allow NULL? |
| 22 | ISM06 | Activity Currently to be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | No | | RU_ISMNG | |
| 23 | ABARB | Confirmation: Degree of processing | nvarchar | 3 | 0 | NUMC | (N'000') | No | | CO_ABARB | Allow NULL? |
| 24 | ISMNW | Actual work | decimal | 7 | 1 | QUAN | ((0)) | No | | ISMNW | |
| 25 | ISMNE | Unit for work | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | ARBEITE | Allow NULL? |
| 26 | LEARR | Activity Type for Confirmation | nvarchar | 6 | 0 | CHAR | (N' ') | No | CSLA | LEARR | Allow NULL? |
| 27 | IDAUR | Actual Duration for Confirmation | decimal | 5 | 1 | QUAN | ((0)) | No | | IDAUR | |
| 28 | IDAUE | Unit for actual duration | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | IDAURE | Allow NULL? |
| 29 | ZCODE | Reference number for standard value code | nvarchar | 6 | 0 | CHAR | (N' ') | No | | DZCODE | Allow NULL? |
| 30 | LOART | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | | LOHNART | Allow NULL? |
| 31 | QUALF | Suitability | nvarchar | 2 | 0 | CHAR | (N' ') | No | T423 | QUALF | Allow NULL? |
| 32 | ANZMA | Number of employees | decimal | 5 | 2 | DEC | ((0)) | No | | ANZMS | |
| 33 | LOGRP | Wage group | nvarchar | 3 | 0 | CHAR | (N' ') | No | T421 | LOHNGRP | Allow NULL? |
| 34 | GMNGA | Previously confirmed yield in order unit of measure | decimal | 13 | 3 | QUAN | ((0)) | No | | RU_GMNGA | |
| 35 | LMNGA | Yield to Be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | No | | RU_LMNGA | |
| 36 | XMNGA | Scrap to Be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | No | | RU_XMNGA | |
| 37 | GMEIN | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | MEINS | Allow NULL? |
| 38 | MEINH | Confirmation unit of measure | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | RU_VORME | Allow NULL? |
| 39 | GRUND | Reason for Variance | nvarchar | 4 | 0 | CHAR | (N' ') | No | TRUG | CO_AGRND | Allow NULL? |
| 40 | PERNR | Personnel number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | CO_PERNR | Allow NULL? |
| 41 | ISDD | Confirmed date for start of execution | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RU_ISDD | Allow NULL? |
| 42 | ISDZ | Confirmed time for 'Execution start' | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | RU_ISDZ | Allow NULL? |
| 43 | IERD | Confirmed date for 'Setup finish' | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RU_IERD | Allow NULL? |
| 44 | IERZ | Confirmed time for 'Setup finish' | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | RU_IERZ | Allow NULL? |
| 45 | ISBD | Confirmed date for 'Processing start' | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RU_ISBD | Allow NULL? |
| 46 | ISBZ | Confirmed time for 'Processing start' | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | RU_ISBZ | Allow NULL? |
| 47 | IEBD | Confirmed date for 'processing finish' | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RU_IEBD | Allow NULL? |
| 48 | IEBZ | Confirmed time for 'processing finish' | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | RU_IEBZ | Allow NULL? |
| 49 | ISAD | Confirmed date for 'teardown start' | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RU_ISAD | Allow NULL? |
| 50 | ISAZ | Confirmed time for 'teardown start' | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | RU_ISAZ | Allow NULL? |
| 51 | IEDD | Confirmed date for execution finish | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RU_IEDD | Allow NULL? |
| 52 | IEDZ | Confirmed time for 'Execution finish' | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | RU_IEDZ | Allow NULL? |
| 53 | PEDD | Forecast finish date of operation from confirmation | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | CO_PEDD | Allow NULL? |
| 54 | PEDZ | Forecast finish time of operation from confirmation | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | CO_PEDZ | Allow NULL? |
| 55 | AUERU | Activation of Final Confirmation | char | 1 | 0 | CHAR | (N' ') | No | | AUERU | Allow NULL? |
| 56 | AUSOR | Clear Open Reservations | char | 1 | 0 | CHAR | (N' ') | No | | AUSBU | Allow NULL? |
| 57 | STNDR | Indicator: Standard confirmation | char | 1 | 0 | CHAR | (N' ') | No | | STNDR | Allow NULL? |
| 58 | MANUR | Indicator for type of confirmation | char | 1 | 0 | CHAR | (N' ') | No | | MANUR | Allow NULL? |
| 59 | MEILR | Indicator: Milestone confirmation carried out | char | 1 | 0 | CHAR | (N' ') | No | | MEILR | Allow NULL? |
| 60 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | AUFK | AUFNR | Allow NULL? |
| 61 | APLFL | Sequence | nvarchar | 6 | 0 | CHAR | (N' ') | No | | PLNFOLGE | Allow NULL? |
| 62 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | CHAR | (N' ') | No | | VORNR | Allow NULL? |
| 63 | OFM01 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | No | | CO_SCHAETZ | |
| 64 | OFE01 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | VGWRTEH | Allow NULL? |
| 65 | LEK01 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | No | | CO_LEIKZ | Allow NULL? |
| 66 | OFM02 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | No | | CO_SCHAETZ | |
| 67 | OFE02 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | VGWRTEH | Allow NULL? |
| 68 | LEK02 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | No | | CO_LEIKZ | Allow NULL? |
| 69 | OFM03 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | No | | CO_SCHAETZ | |
| 70 | OFE03 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | VGWRTEH | Allow NULL? |
| 71 | LEK03 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | No | | CO_LEIKZ | Allow NULL? |
| 72 | OFM04 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | No | | CO_SCHAETZ | |
| 73 | OFE04 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | VGWRTEH | Allow NULL? |
| 74 | LEK04 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | No | | CO_LEIKZ | Allow NULL? |
| 75 | OFM05 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | No | | CO_SCHAETZ | |
| 76 | OFE05 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | VGWRTEH | Allow NULL? |
| 77 | LEK05 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | No | | CO_LEIKZ | Allow NULL? |
| 78 | OFM06 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | No | | CO_SCHAETZ | |
| 79 | OFE06 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | VGWRTEH | Allow NULL? |
| 80 | LEK06 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | No | | CO_LEIKZ | Allow NULL? |
| 81 | OFMNW | Remaining work | decimal | 7 | 1 | QUAN | ((0)) | No | | REMNW | |
| 82 | OFMNE | Unit of measure for remaining work | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | OFMNE | Allow NULL? |
| 83 | LEKNW | Indicator: No Remaining Work Expected | char | 1 | 0 | CHAR | (N' ') | No | | LEKNW | Allow NULL? |
| 84 | ODAUR | Remaining duration of activity | decimal | 5 | 1 | QUAN | ((0)) | No | | ODAUR | |
| 85 | ODAUE | Unit for remaining duration | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | ODAUE | Allow NULL? |
| 86 | SMENG | Operation Quantity | decimal | 13 | 3 | QUAN | ((0)) | No | | MGVRG | |
| 87 | SPLIT | Split number | tinyint | 3 | 0 | INT1 | ((0)) | No | | CY_SPLIT | |
| 88 | ZAUSW | Time Recording ID Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | DZAUSW | Allow NULL? |
| 89 | KAPAR | Capacity category | nvarchar | 3 | 0 | CHAR | (N' ') | No | TC26 | KAPART | Allow NULL? |
| 90 | UVORN | Suboperation | nvarchar | 4 | 0 | CHAR | (N' ') | No | | UVORN | Allow NULL? |
| 91 | CATSBELNR | Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CATSBELNR | Allow NULL? |
| 92 | CATSPRICE | Price in Transaction Currency | decimal | 11 | 2 | CURR | ((0)) | Yes | | CATSPRICE | |
| 93 | CATSTCURR | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TWAER | Allow NULL? |
| 94 | CATSPEINH | Price Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | PEINH | |
| 95 | RMNGA | Current rework quantity to be confirmed | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RU_RMNGA | |
| 96 | BEMOT | Accounting Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TBMOT | BEMOT | Allow NULL? |
| 97 | PRZ01 | Business Process | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | CO_PRZNR | Allow NULL? |
| 98 | IPRZ1 | Current quantity to be confirmed for the business process | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RU_IPRZS | |
| 99 | IPRE1 | Unit of measurement for conf. quantity for business process | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | RU_IPRZE | Allow NULL? |
| 100 | IPRK1 | No remaining quantity expected for business process | char | 1 | 0 | CHAR | (N' ') | Yes | | RU_IPRZK | Allow NULL? |
| 101 | OPRZ1 | Remaining quantity for business process | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OPRZ1 | |
| 102 | OPRE1 | Unit for remaining quantity of business process | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | OPRE1 | Allow NULL? |
| 103 | SCRID | ID for collective entry input list | char | 1 | 0 | CHAR | (N' ') | Yes | | RU_SCRID | Allow NULL? |
| 104 | NODAT | Do not update actual date in the operation | char | 1 | 0 | CHAR | (N' ') | Yes | | NODAT | Allow NULL? |
| 105 | ISMNW_2 | Actual Work | decimal | 8 | 2 | QUAN | ((0)) | Yes | | ISMNW_2 | |
| 106 | OFMNW_2 | Remaining Work | decimal | 8 | 2 | QUAN | ((0)) | Yes | | REMNW_2 | |
| 107 | ISMNU | Unit for work | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ARBEITE | Allow NULL? |
| 108 | OFMNU | Unit for work | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ARBEITE | Allow NULL? |
| 109 | PACKNO | Package number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | PACKNO | Allow NULL? |
