| 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 | RUECK | Completion confirmation number for the operation | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | CO_RUECK | Allow NULL? |
| 3 | RMZHL | Confirmation counter | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | CO_RMZHL | Allow NULL? |
| 4 | ERSDA | Confirmation entry date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RU_ERSDA | Allow NULL? |
| 5 | ERNAM | Name of the person who entered the confirmation | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RU_ERNAM | Allow NULL? |
| 6 | LAEDA | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LAEDA | Allow NULL? |
| 7 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 8 | BUDAT | Posting date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUCHDATUM | Allow NULL? |
| 9 | ARBID | Object ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | OBJEKTID | Allow NULL? |
| 10 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 11 | LTXA1 | Confirmation text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | CO_RTEXT | Allow NULL? |
| 12 | TXTSP | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | T002 | SPRAS | Allow NULL? |
| 13 | ISERH | Confirmed break time | decimal | 9 | 3 | QUAN | ((0)) | Yes | | ISERH | |
| 14 | ZEIER | Unit for the break time | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | DZEIER | Allow NULL? |
| 15 | ILE01 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_ISMNGEH | Allow NULL? |
| 16 | ISM01 | Activity Currently to be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RU_ISMNG | |
| 17 | ILE02 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_ISMNGEH | Allow NULL? |
| 18 | ISM02 | Activity Currently to be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RU_ISMNG | |
| 19 | ILE03 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_ISMNGEH | Allow NULL? |
| 20 | ISM03 | Activity Currently to be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RU_ISMNG | |
| 21 | ILE04 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_ISMNGEH | Allow NULL? |
| 22 | ISM04 | Activity Currently to be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RU_ISMNG | |
| 23 | ILE05 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_ISMNGEH | Allow NULL? |
| 24 | ISM05 | Activity Currently to be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RU_ISMNG | |
| 25 | ILE06 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_ISMNGEH | Allow NULL? |
| 26 | ISM06 | Activity Currently to be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RU_ISMNG | |
| 27 | ABARB | Confirmation: Degree of processing | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CO_ABARB | Allow NULL? |
| 28 | ISMNW | Actual work | decimal | 7 | 1 | QUAN | ((0)) | Yes | | ISMNW | |
| 29 | ISMNE | Unit for work | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ARBEITE | Allow NULL? |
| 30 | LEARR | Activity Type for Confirmation | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | CSLA | LEARR | Allow NULL? |
| 31 | IDAUR | Actual Duration for Confirmation | decimal | 5 | 1 | QUAN | ((0)) | Yes | | IDAUR | |
| 32 | IDAUE | Unit for actual duration | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | IDAURE | Allow NULL? |
| 33 | ZCODE | Reference number for standard value code | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | DZCODE | Allow NULL? |
| 34 | LOART | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | LOHNART | Allow NULL? |
| 35 | QUALF | Suitability | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T423 | QUALF | Allow NULL? |
| 36 | ANZMA | Number of employees | decimal | 5 | 2 | DEC | ((0)) | Yes | | ANZMS | |
| 37 | LOGRP | Wage group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T421 | LOHNGRP | Allow NULL? |
| 38 | GMNGA | Previously confirmed yield in order unit of measure | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RU_GMNGA | |
| 39 | LMNGA | Yield to Be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RU_LMNGA | |
| 40 | XMNGA | Scrap to Be Confirmed | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RU_XMNGA | |
| 41 | GMEIN | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 42 | MEINH | Confirmation unit of measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RU_VORME | Allow NULL? |
| 43 | GRUND | Reason for Variance | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TRUG | CO_AGRND | Allow NULL? |
| 44 | PERNR | Personnel number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | CO_PERNR | Allow NULL? |
| 45 | ISDD | Confirmed date for start of execution | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RU_ISDD | Allow NULL? |
| 46 | ISDZ | Confirmed time for 'Execution start' | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RU_ISDZ | Allow NULL? |
| 47 | IERD | Confirmed date for 'Setup finish' | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RU_IERD | Allow NULL? |
| 48 | IERZ | Confirmed time for 'Setup finish' | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RU_IERZ | Allow NULL? |
| 49 | ISBD | Confirmed date for 'Processing start' | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RU_ISBD | Allow NULL? |
| 50 | ISBZ | Confirmed time for 'Processing start' | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RU_ISBZ | Allow NULL? |
| 51 | IEBD | Confirmed date for 'processing finish' | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RU_IEBD | Allow NULL? |
| 52 | IEBZ | Confirmed time for 'processing finish' | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RU_IEBZ | Allow NULL? |
| 53 | ISAD | Confirmed date for 'teardown start' | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RU_ISAD | Allow NULL? |
| 54 | ISAZ | Confirmed time for 'teardown start' | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RU_ISAZ | Allow NULL? |
| 55 | IEDD | Confirmed date for execution finish | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RU_IEDD | Allow NULL? |
| 56 | IEDZ | Confirmed time for 'Execution finish' | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RU_IEDZ | Allow NULL? |
| 57 | PEDD | Forecast finish date of operation from confirmation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CO_PEDD | Allow NULL? |
| 58 | PEDZ | Forecast finish time of operation from confirmation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CO_PEDZ | Allow NULL? |
| 59 | WABLNR | Number of Material Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | MBLNR | Allow NULL? |
| 60 | WEBLNR | Number of a document from a goods movement with errors | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | WEBLNR | Allow NULL? |
| 61 | AUERU | Partial/Final Confirmation | char | 1 | 0 | CHAR | (N' ') | Yes | | AUERU_VS | Allow NULL? |
| 62 | AUSOR | Clear Open Reservations | char | 1 | 0 | CHAR | (N' ') | Yes | | AUSBU | Allow NULL? |
| 63 | STNDR | Indicator: Standard confirmation | char | 1 | 0 | CHAR | (N' ') | Yes | | STNDR | Allow NULL? |
| 64 | MANUR | Indicator for type of confirmation | char | 1 | 0 | CHAR | (N' ') | Yes | | MANUR | Allow NULL? |
| 65 | MEILR | Indicator: Milestone confirmation carried out | char | 1 | 0 | CHAR | (N' ') | Yes | | MEILR | Allow NULL? |
| 66 | AUFPL | Routing number of operations in the order | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | CO_AUFPL | Allow NULL? |
| 67 | APLZL | General counter for order | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | AFVC | CO_APLZL | Allow NULL? |
| 68 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AUFK | AUFNR | Allow NULL? |
| 69 | APLFL | Sequence | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | PLNFOLGE | Allow NULL? |
| 70 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | VORNR | Allow NULL? |
| 71 | SUMNR | Node number of the superior operation | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | SUMKNTNR | Allow NULL? |
| 72 | OFM01 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CO_SCHAETZ | |
| 73 | OFE01 | Unit of measurement for the forecast standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RU_PROGVGE | Allow NULL? |
| 74 | LEK01 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_LEIKZ | Allow NULL? |
| 75 | OFM02 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CO_SCHAETZ | |
| 76 | OFE02 | Unit of measurement for the forecast standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RU_PROGVGE | Allow NULL? |
| 77 | LEK02 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_LEIKZ | Allow NULL? |
| 78 | OFM03 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CO_SCHAETZ | |
| 79 | OFE03 | Unit of measurement for the forecast standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RU_PROGVGE | Allow NULL? |
| 80 | LEK03 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_LEIKZ | Allow NULL? |
| 81 | OFM04 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CO_SCHAETZ | |
| 82 | OFE04 | Unit of measurement for the forecast standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RU_PROGVGE | Allow NULL? |
| 83 | LEK04 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_LEIKZ | Allow NULL? |
| 84 | OFM05 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CO_SCHAETZ | |
| 85 | OFE05 | Unit of measurement for the forecast standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RU_PROGVGE | Allow NULL? |
| 86 | LEK05 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_LEIKZ | Allow NULL? |
| 87 | OFM06 | Forecast value used to update the standard value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CO_SCHAETZ | |
| 88 | OFE06 | Unit of measurement for the forecast standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RU_PROGVGE | Allow NULL? |
| 89 | LEK06 | Indicator: No remaining activity expected | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_LEIKZ | Allow NULL? |
| 90 | OFMNW | Remaining work | decimal | 7 | 1 | QUAN | ((0)) | Yes | | REMNW | |
| 91 | OFMNE | Unit of measure for remaining work | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OFMNE | Allow NULL? |
| 92 | LEKNW | Indicator: No Remaining Work Expected | char | 1 | 0 | CHAR | (N' ') | Yes | | LEKNW | Allow NULL? |
| 93 | ODAUR | Remaining duration of activity | decimal | 5 | 1 | QUAN | ((0)) | Yes | | ODAUR | |
| 94 | ODAUE | Unit for remaining duration | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ODAUE | Allow NULL? |
| 95 | STOKZ | Indicator: Document Has Been Reversed | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_STOKZ | Allow NULL? |
| 96 | STZHL | Confirmation counter of cancelled confirmation | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | CO_STZHL | Allow NULL? |
| 97 | SMENG | Operation Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MGVRG | |
| 98 | RUECK_MST | Completion confirmation number for the operation | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | CO_RUECK | Allow NULL? |
| 99 | RMZHL_MST | Confirmation counter | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | CO_RMZHL | Allow NULL? |
| 100 | PDSNR | Sequential number for PDC messages | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | PDSNR_D | Allow NULL? |
| 101 | KAPID | Capacity ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | KAKO | KAPID | Allow NULL? |
| 102 | SPLIT | Split number | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | CY_SPLIT | |
| 103 | ZAUSW | Time Recording ID Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | DZAUSW | Allow NULL? |
| 104 | ORIND | Origin Indicator of PDC Message (Application) | char | 1 | 0 | CHAR | (N' ') | Yes | | ORIND | Allow NULL? |
| 105 | ORIGF | Origin Indicator of PDC Message | char | 1 | 0 | CHAR | (N' ') | Yes | | ORIGF | Allow NULL? |
| 106 | CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | KBED | CY_COUNT | Allow NULL? |
| 107 | BELNR_IST | Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CO_BELNR | Allow NULL? |
| 108 | BELNR_UMB | Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CO_BELNR | Allow NULL? |
| 109 | RMNGA | Current rework quantity to be confirmed | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RU_RMNGA | |
| 110 | CATSBELNR | Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CATSBELNR | Allow NULL? |
| 111 | SATZA | Record type for confirmation | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CO_SATZA | Allow NULL? |
| 112 | ERZET | Confirmation entry time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RU_ERZET | Allow NULL? |
| 113 | CATSPRICE | Price in Transaction Currency | decimal | 11 | 2 | CURR | ((0)) | Yes | | CATSPRICE | |
| 114 | CATSTCURR | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TWAER | Allow NULL? |
| 115 | CATSPEINH | Price Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | PEINH | |
| 116 | BEMOT | Accounting Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TBMOT | BEMOT | Allow NULL? |
| 117 | IPRZ1 | Current quantity to be confirmed for the business process | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RU_IPRZS | |
| 118 | IPRE1 | Unit of measurement for conf. quantity for business process | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RU_IPRZE | Allow NULL? |
| 119 | IPRK1 | No remaining quantity expected for business process | char | 1 | 0 | CHAR | (N' ') | Yes | | RU_IPRZK | Allow NULL? |
| 120 | EXNAM | External creator of confirmation | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RU_EXNAM | Allow NULL? |
| 121 | EXERD | External date of entry for confirmation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RU_EXERD | Allow NULL? |
| 122 | EXERZ | External time of entry for confirmation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RU_EXERZ | Allow NULL? |
| 123 | PRZ01 | Business Process | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | CO_PRZNR | Allow NULL? |
| 124 | OPRZ1 | Remaining quantity for business process | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OPRZ1 | |
| 125 | OPRE1 | Unit for remaining quantity of business process | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OPRE1 | Allow NULL? |
| 126 | SKOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KOKRS | Allow NULL? |
| 127 | SKOSTL | Sender Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SKOSTL | Allow NULL? |
| 128 | NODAT | Do not update actual date in the operation | char | 1 | 0 | CHAR | (N' ') | Yes | | NODAT | Allow NULL? |
| 129 | ISMNU | Unit for work | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ARBEITE | Allow NULL? |
| 130 | OFMNU | Unit for work | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ARBEITE | Allow NULL? |
| 131 | PACKNO | Package number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | PACKNO | Allow NULL? |
| 132 | EXTID | External Key for Confirmation (for example, from PDC System) | varbinary | 16 | 0 | RAW | | Yes | | RU_EXTID | |
| 133 | SCHGRUP | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SCHGRUP | Allow NULL? |
| 134 | KAPTPROG | Shift definition | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KAPTPROG | Allow NULL? |
| 135 | OBMAT | Material from Original Batch | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | UCMAT | Allow NULL? |
| 136 | OBCHA | Original Batch | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | UCCHA | Allow NULL? |
| 137 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | LICHN | Allow NULL? |
| 138 | MYEAR | Material Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | MJAHR | Allow NULL? |
| 139 | ME_SFCID | SFC Number from the ME System | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | CO_MES_INT_SFCID | Allow NULL? |
| 140 | ME_2ND_CONF_QTY | Rework Quantity Confirmed from SAP ME | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CO_MES_SECOND_CONF_QTY | |
| 141 | ROLE_ID | Role ID for Confirmation in Portal | char | 1 | 0 | CHAR | (N' ') | Yes | | RMAN_PRSP_ROLEID | Allow NULL? |
| 142 | UCMAT | Mill: Material in Process Batch | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MILL_PCMAT | Allow NULL? |
| 143 | UCCHA | Mill: Process batch | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | MILL_PCCHA | Allow NULL? |
| 144 | WTY_IND | Warranty indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | WTYSC_WTY_INDICATOR | Allow NULL? |
