| 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 | EQUNR | Equipment Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | EQUI | EQUNR | Allow NULL? |
| 3 | DATBI | Valid To Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DATBI | Allow NULL? |
| 4 | EQLFN | Consecutive numbering of EquipUsagePeriods on same day | nvarchar | 3 | 0 | NUMC | (N'000') | No | | EQLFN | Allow NULL? |
| 5 | EQUZN | Number of next EquipUsagePeriod on same day | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | EQNNR | Allow NULL? |
| 6 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 7 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 8 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 9 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 10 | TIMBI | Equipment usage period time stamp | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TIMBI | Allow NULL? |
| 11 | ESTAI | SAP Development Reserve: Format CHAR, Length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | RESERVE_CHAR_001 | Allow NULL? |
| 12 | ESTAE | SAP Development reserve: Format CHAR, length 4 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | RESERVE_CHAR_004 | Allow NULL? |
| 13 | STNAM | SAP Development Reserve: Format CHAR, Length 12 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RESERVE_CHAR_012 | Allow NULL? |
| 14 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | RESERVE_CHAR_001 | Allow NULL? |
| 15 | DATAB | Valid-From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATAB | Allow NULL? |
| 16 | IWERK | Maintenance Planning Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T399I | IWERK | Allow NULL? |
| 17 | IWERKI | Data origin indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INHER | Allow NULL? |
| 18 | SUBMT | Construction type material of the object | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | SUBMT | Allow NULL? |
| 19 | MAPAR | Manufacturer part number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | MAPAR | Allow NULL? |
| 20 | HEQUI | Superordinate Equipment | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | EQUI | HEQUI | Allow NULL? |
| 21 | HEQNR | Equipment position at InstallLoc (Superior Equip./FunctLoc) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | HEQNR | Allow NULL? |
| 22 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T024I | INGRP | Allow NULL? |
| 23 | INGRPI | Data origin indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INHER | Allow NULL? |
| 24 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PM_OBJTY | Allow NULL? |
| 25 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | CRID | LGWID | Allow NULL? |
| 26 | GEWRKI | Data origin indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INHER | Allow NULL? |
| 27 | TIDNR | Technical identification number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | TIDNR | Allow NULL? |
| 28 | TIDNRI | Data origin indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INHER | Allow NULL? |
| 29 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ILOA | ILOAN | Allow NULL? |
| 30 | KUND1 | Customer number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUND1 | Allow NULL? |
| 31 | KUND2 | End customer number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUND2 | Allow NULL? |
| 32 | KUND3 | Operator | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUND3 | Allow NULL? |
| 33 | LIZNR | Equipment license number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | LIZNR | Allow NULL? |
| 34 | RBNR | Catalog Profile | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | T352B | RBNR | Allow NULL? |
| 35 | EZDAT | Date, intended for SAP internal use | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EQDAT | Allow NULL? |
| 36 | EZBER | Technical information, intended for SAP internal use | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | EQBER | Allow NULL? |
| 37 | EZNUM | Numerical field, intended for SAP internal use | nvarchar | 9 | 0 | NUMC | (N'000000000') | Yes | | EQNUM | Allow NULL? |
| 38 | RBNR_I | Data origin indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INHER | Allow NULL? |
| 39 | IBLNR | Physical Inventory Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | IBLNR | Allow NULL? |
| 40 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 41 | PVS_FOCUS | Internal Identification for PVS Objects | varbinary | 16 | 0 | RAW | | Yes | | PVS_GUID_CCC | |
| 42 | PPEGUID | Internal Identification for PVS Objects | varbinary | 16 | 0 | RAW | | Yes | | PVS_GUID_CCC | |
| 43 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TECHS | Allow NULL? |
| 44 | FUNCID | Function Identifier | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | CCC_FUNCID | Allow NULL? |
| 45 | FRCFIT | Indicator: Forced Installation/Dismantling | char | 1 | 0 | CHAR | (N' ') | Yes | | CCC_FRCFIT | Allow NULL? |
| 46 | FRCRMV | Force Dismantling Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | CCC_FRCRMV | Allow NULL? |
