| 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 | OBJTY | Object types of the CIM resource | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CR_OBJTY | Allow NULL? |
| 3 | OBJID | Object ID of the resource | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | CRID | CR_OBJID | Allow NULL? |
| 4 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDATUM | Allow NULL? |
| 5 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDATUM | Allow NULL? |
| 6 | AEDAT_GRND | Changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDTM | Allow NULL? |
| 7 | AENAM_GRND | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | USRNAME | Allow NULL? |
| 8 | AEDAT_VORA | Changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDTM | Allow NULL? |
| 9 | AENAM_VORA | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | USRNAME | Allow NULL? |
| 10 | AEDAT_TERM | Changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDTM | Allow NULL? |
| 11 | AENAM_TERM | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | USRNAME | Allow NULL? |
| 12 | AEDAT_TECH | Changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDTM | Allow NULL? |
| 13 | AENAM_TECH | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | USRNAME | Allow NULL? |
| 14 | ARBPL | Work center | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ARBPL | Allow NULL? |
| 15 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 16 | VERWE | Work Center Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TC30 | AP_VERWE | Allow NULL? |
| 17 | LVORM | Deletion flag for work center | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_LOEVORM | Allow NULL? |
| 18 | PAR01 | First work center parameter (for formulas) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TC20 | AP_PAR01 | Allow NULL? |
| 19 | PAR02 | Second work center parameter (for formulas) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TC20 | AP_PAR02 | Allow NULL? |
| 20 | PAR03 | Third work center parameter (for formulas) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TC20 | AP_PAR03 | Allow NULL? |
| 21 | PAR04 | Fourth work center parameter (for formulas) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TC20 | AP_PAR04 | Allow NULL? |
| 22 | PAR05 | Fifth work center parameter (for formulas) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TC20 | AP_PAR05 | Allow NULL? |
| 23 | PAR06 | Sixth work center parameter (for formulas) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TC20 | AP_PAR06 | Allow NULL? |
| 24 | PARU1 | Parameter unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | AP_PARUNIT | Allow NULL? |
| 25 | PARU2 | Parameter unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | AP_PARUNIT | Allow NULL? |
| 26 | PARU3 | Parameter unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | AP_PARUNIT | Allow NULL? |
| 27 | PARU4 | Parameter unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | AP_PARUNIT | Allow NULL? |
| 28 | PARU5 | Parameter unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | AP_PARUNIT | Allow NULL? |
| 29 | PARU6 | Parameter unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | AP_PARUNIT | Allow NULL? |
| 30 | PARV1 | Parameter value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | AP_PARVAL | |
| 31 | PARV2 | Parameter value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | AP_PARVAL | |
| 32 | PARV3 | Parameter value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | AP_PARVAL | |
| 33 | PARV4 | Parameter value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | AP_PARVAL | |
| 34 | PARV5 | Parameter value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | AP_PARVAL | |
| 35 | PARV6 | Parameter value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | AP_PARVAL | |
| 36 | PLANV | Key for task list usage | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TC23 | AP_PLANV | Allow NULL? |
| 37 | STAND | Work center location | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T499S | AP_STAND | Allow NULL? |
| 38 | VERAN | Person responsible for the work center | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TC24 | AP_VERAN | Allow NULL? |
| 39 | VGWTS | Standard value key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TC21 | VORGSCHL | Allow NULL? |
| 40 | VGM01 | Rule for standard value maintenance | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_VGW_MES | Allow NULL? |
| 41 | VGM02 | Rule for standard value maintenance | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_VGW_MES | Allow NULL? |
| 42 | VGM03 | Rule for standard value maintenance | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_VGW_MES | Allow NULL? |
| 43 | VGM04 | Rule for standard value maintenance | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_VGW_MES | Allow NULL? |
| 44 | VGM05 | Rule for standard value maintenance | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_VGW_MES | Allow NULL? |
| 45 | VGM06 | Rule for standard value maintenance | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_VGW_MES | Allow NULL? |
| 46 | XDEFA | Indicator: Work center for default values | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_DEFAULT | Allow NULL? |
| 47 | XKOST | Indicator: Work center is maintained for costing | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_XKOST | Allow NULL? |
| 48 | XSPRR | Indicator: Work center is locked | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_XSPRR | Allow NULL? |
| 49 | XTERM | Indicator: Work center is maintained for scheduling | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_XTERM | Allow NULL? |
| 50 | ZGR01 | Key for performance efficiency rate | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TC31 | IDZEITGRAD | Allow NULL? |
| 51 | ZGR02 | Key for performance efficiency rate | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TC31 | IDZEITGRAD | Allow NULL? |
| 52 | ZGR03 | Key for performance efficiency rate | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TC31 | IDZEITGRAD | Allow NULL? |
| 53 | ZGR04 | Key for performance efficiency rate | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TC31 | IDZEITGRAD | Allow NULL? |
| 54 | ZGR05 | Key for performance efficiency rate | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TC31 | IDZEITGRAD | Allow NULL? |
| 55 | ZGR06 | Key for performance efficiency rate | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TC31 | IDZEITGRAD | Allow NULL? |
| 56 | KTSCH | Standard text key | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | T435 | KTSCH | Allow NULL? |
| 57 | LOANZ | Number of Time Tickets | decimal | 3 | 0 | DEC | ((0)) | Yes | | LOHNANZ | |
| 58 | LOART | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | LOHNART | Allow NULL? |
| 59 | LOGRP | Wage group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T421 | LOHNGRP | Allow NULL? |
| 60 | QUALF | Suitability | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T423 | QUALF | Allow NULL? |
| 61 | RASCH | Setup Type Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T428 | RUEARSCHLU | Allow NULL? |
| 62 | STEUS | Control key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T430 | STEUS | Allow NULL? |
| 63 | VGE01 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VGWRTEH | Allow NULL? |
| 64 | VGE02 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VGWRTEH | Allow NULL? |
| 65 | VGE03 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VGWRTEH | Allow NULL? |
| 66 | VGE04 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VGWRTEH | Allow NULL? |
| 67 | VGE05 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VGWRTEH | Allow NULL? |
| 68 | VGE06 | Unit of measure for the standard value | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VGWRTEH | Allow NULL? |
| 69 | KTSCH_REF | Indicator: Standard text key is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | KTSCH_REF | Allow NULL? |
| 70 | LOART_REF | Indicator: Wage type is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | LOART_REF | Allow NULL? |
| 71 | LOANZ_REF | Indicator: Number of time tickets is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | LOANZ_REF | Allow NULL? |
| 72 | LOGRP_REF | Indicator: Wage group is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | LOGRP_REF | Allow NULL? |
| 73 | QUALF_REF | Indicator: Suitability is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | QUALF_REF | Allow NULL? |
| 74 | RASCH_REF | Indicator: Setup type key is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | RASCH_REF | Allow NULL? |
| 75 | STEUS_REF | Indicator: Control key is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | STEUS_REF | Allow NULL? |
| 76 | FORT1 | Formula for setup time | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TC25 | AP_FORM_T1 | Allow NULL? |
| 77 | FORT2 | Formula for the duration of processing time | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TC25 | AP_FORM_T2 | Allow NULL? |
| 78 | FORT3 | Formula for teardown time | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TC25 | AP_FORM_T3 | Allow NULL? |
| 79 | KAPID | Capacity ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | KAKO | KAPID | Allow NULL? |
| 80 | ORTGR | Location group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ORTSGRUPPE | Allow NULL? |
| 81 | ZEIWN | Unit for the standard queue time | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | DZEIWN | Allow NULL? |
| 82 | ZWNOR | Standard queue time | decimal | 9 | 3 | QUAN | ((0)) | Yes | | DZWNOR | |
| 83 | ZEIWM | Unit for the minumum queue time | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | DZEIWM | Allow NULL? |
| 84 | ZWMIN | Minimum queue time | decimal | 9 | 3 | QUAN | ((0)) | Yes | | DZWMIN | |
| 85 | FORMR | Indicator: same formulas as in capacity | char | 1 | 0 | CHAR | (N' ') | Yes | | FLGFORMART | Allow NULL? |
| 86 | MATYP | Machine type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TMATY | MATYP | Allow NULL? |
| 87 | CPLGR | CAPP planner group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T024C | CPLGR | Allow NULL? |
| 88 | SORTB | Sort string | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | TSRTB | SORTB | Allow NULL? |
| 89 | MTRVP | Additional time percentage for setup | decimal | 3 | 1 | DEC | ((0)) | Yes | | MTRVP | |
| 90 | MTMVP | Additional time percentage for machines | decimal | 3 | 1 | DEC | ((0)) | Yes | | MTMVP | |
| 91 | MTPVP | Aditional time percentage for labor | decimal | 3 | 1 | DEC | ((0)) | Yes | | MTPVP | |
| 92 | RSANZ | Number of confirmation slips | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CR_RS_ANZ | Allow NULL? |
| 93 | PDEST | Printer for shop papers | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSP03 | CR_PDEST | Allow NULL? |
| 94 | HROID | Object ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | PLOGI | HROBJID | Allow NULL? |
| 95 | FORTN | Formula for the duration of other types of int. processing | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TC25 | AP_FORM_TN | Allow NULL? |
| 96 | ZGR01_REF | Field is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_KZREF | Allow NULL? |
| 97 | ZGR02_REF | Field is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_KZREF | Allow NULL? |
| 98 | ZGR03_REF | Field is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_KZREF | Allow NULL? |
| 99 | ZGR04_REF | Field is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_KZREF | Allow NULL? |
| 100 | ZGR05_REF | Field is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_KZREF | Allow NULL? |
| 101 | ZGR06_REF | Field is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_KZREF | Allow NULL? |
| 102 | STEUS_C | Control key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T430 | STEUS | Allow NULL? |
| 103 | STEUS_I | Control key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T430 | STEUS | Allow NULL? |
| 104 | STEUS_N | Control key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T430 | STEUS | Allow NULL? |
| 105 | STEUS_Q | Control key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T430 | STEUS | Allow NULL? |
| 106 | RUZUS | Key: rounding and additional values | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCERS | RUZUS | Allow NULL? |
| 107 | RSANZ_REF | Indicator: Number of confirmation slips is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | RSANZ_REF | Allow NULL? |
| 108 | HR | Work center only resides in HR | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_KZHR | Allow NULL? |
| 109 | PRVBE | Production Supply Area | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | PVBE | PRVBE | Allow NULL? |
| 110 | SUBSYS | Subsystem Identifier for QM Subsystem Interface | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | QISUB | QEIFSUBSYS | Allow NULL? |
| 111 | BDEGR | Grouping for Connection to Subsystem | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BDEGR | Allow NULL? |
| 112 | RGEKZ | Indicator: Backflushing | char | 1 | 0 | CHAR | (N' ') | Yes | | RGEKZAP | Allow NULL? |
| 113 | HRTYP | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T778O | OTYPE | Allow NULL? |
| 114 | SLWID | Key word ID for user-defined fields | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | TCN00 | SLWID | Allow NULL? |
| 115 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LIFNR | Allow NULL? |
| 116 | SLWID_REF | Field is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_KZREF | Allow NULL? |
| 117 | LIFNR_REF | Field is referenced | char | 1 | 0 | CHAR | (N' ') | Yes | | AP_KZREF | Allow NULL? |
| 118 | VGARB | Unit of measure of work | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VGWRTAR | Allow NULL? |
| 119 | VGDIM | Dimension of work | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T006D | VGDIMAR | Allow NULL? |
| 120 | HRPLVAR | Plan Version | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T778P | PLVAR | Allow NULL? |
| 121 | VGDAU | Normal duration/unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | DAUNORE | Allow NULL? |
| 122 | STOBJ | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | J_OBJNR | Allow NULL? |
| 123 | RESGR | Matrix identification | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TCYMI | MATRIX_ID | Allow NULL? |
| 124 | LGORT_RES | Storage location storage resource | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001L | LGORT_RES | Allow NULL? |
| 125 | MIXMAT | Indicator: mixing of material allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | MIXMAT | Allow NULL? |
| 126 | ISTBED_KZ | Calculation of actual capacity requirements | char | 1 | 0 | CHAR | (N' ') | Yes | | CY_ISTBEDKZ | Allow NULL? |
