| 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 | VSNMR | Number or description of a version | nvarchar | 12 | 0 | CHAR | (N' ') | No | | VSNMR | Allow NULL? |
| 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TPLNR | Allow NULL? |
| 4 | MLANG | Primary language for object texts | char | 1 | 0 | LANG | (N' ') | Yes | T002 | MLANG | Allow NULL? |
| 5 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T370S | TPLKZ | Allow NULL? |
| 6 | FLTYP | Functional location category | char | 1 | 0 | CHAR | (N' ') | Yes | T370F | FLTYP | Allow NULL? |
| 7 | TPLMA | Superior functional location | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | IFLOT | TPLMA | Allow NULL? |
| 8 | ERDAT | Date on which the object was created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ICRDT | Allow NULL? |
| 9 | ERNAM | Name of User Who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ICRNA | Allow NULL? |
| 10 | AEDAT | Date on which the object was last changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | IUPDT | Allow NULL? |
| 11 | AENAM | Name of the user who last changed the object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | IUPNA | Allow NULL? |
| 12 | DATAB | Start-up Date of the Technical Object | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ILOM_DATAB | Allow NULL? |
| 13 | BEGRU | Technical object authorization group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T370B | IAUTG | Allow NULL? |
| 14 | TRPNR | Reference functional location | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | IRLOT | TRPNR | Allow NULL? |
| 15 | PSTAE | SAP Development reserve: Format CHAR, length 4 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | RESERVE_CHAR_004 | Allow NULL? |
| 16 | STNAM | SAP Development Reserve: Format CHAR, Length 12 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RESERVE_CHAR_012 | Allow NULL? |
| 17 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | RESERVE_CHAR_001 | Allow NULL? |
| 18 | SUBMT | Construction type material of the object | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | SUBMT | Allow NULL? |
| 19 | SUBMTI | Data origin for construction type field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_SUBMTI | Allow NULL? |
| 20 | MAPAR | Manufacturer part number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | MAPAR | Allow NULL? |
| 21 | MAPARI | SAP Development Reserve: Format CHAR, Length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | RESERVE_CHAR_001 | Allow NULL? |
| 22 | IEQUI | Installation of equipment allowed at the functional location | char | 1 | 0 | CHAR | (N' ') | Yes | | IEQUI | Allow NULL? |
| 23 | IEQUII | Data origin for equip. inst. allowed field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_IEQUII | Allow NULL? |
| 24 | EINZL | Single equipment installation at functional location | char | 1 | 0 | CHAR | (N' ') | Yes | | EINZL | Allow NULL? |
| 25 | EINZLI | Data origin for authorization group field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_BEGRUI | Allow NULL? |
| 26 | IWERK | Maintenance Planning Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T399I | IWERK | Allow NULL? |
| 27 | IWERKI | Data origin for planning plant field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_IWERKI | Allow NULL? |
| 28 | INGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T024I | INGRP | Allow NULL? |
| 29 | INGRPI | Data origin for maintenance planner group field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_INGRPI | Allow NULL? |
| 30 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PM_OBJTY | Allow NULL? |
| 31 | LGWID | Object ID of the Work Center | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | CRID | LGWID | Allow NULL? |
| 32 | LGWIDI | Data Origin for the Field 'Work Center' | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_LGWIDI | Allow NULL? |
| 33 | RBNR | Catalog Profile | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | T352B | RBNR | Allow NULL? |
| 34 | RBNR_I | Data origin for maintenance catalog field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_RBNR_I | Allow NULL? |
| 35 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ILOA | ILOAN | Allow NULL? |
| 36 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | ONR00 | J_OBJNR | Allow NULL? |
| 37 | POSNR | Position in superior technical object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ILOM_POSNR | Allow NULL? |
| 38 | ISTYP | Object category for Industry Solutions (IS) | char | 1 | 0 | CHAR | (N' ') | Yes | | ILOM_ISTYP | Allow NULL? |
| 39 | PREMS | Premise | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ILOM_PREMS | Allow NULL? |
| 40 | EQART | Type of Technical Object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T370K | EQART | Allow NULL? |
| 41 | INVNR | Inventory number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | INVNR | Allow NULL? |
| 42 | GROES | Size/dimension | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | GROSS | Allow NULL? |
| 43 | BRGEW | Gross Weight | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BRGEW | |
| 44 | GEWEI | Weight Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | GEWEI | Allow NULL? |
| 45 | ANSWT | Acquisition Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | ANSWT | |
| 46 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 47 | ANSDT | Acquisition date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ANDTI | Allow NULL? |
| 48 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HERST | Allow NULL? |
| 49 | HERLD | Country of manufacture | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | HERLD | Allow NULL? |
| 50 | BAUJJ | Year of construction | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BAUJJ | Allow NULL? |
| 51 | BAUMM | Month of construction | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BAUMM | Allow NULL? |
| 52 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | TYPBZ | Allow NULL? |
| 53 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | EMATN | Allow NULL? |
| 54 | SERGE | Manufacturer serial number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SERGE | Allow NULL? |
| 55 | HANDLE | SAP Development Reserve: Integration of Date Segment (Key) | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | ITOBTMP_TSEGGUID | Allow NULL? |
| 56 | TSEGTP | SAP Development Reserve: Integration Date Segment (Tempate) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ITOBTMP_TSEGTEMPLA | Allow NULL? |
| 57 | FLLB_DUTY | Logbook Duty | char | 1 | 0 | CHAR | (N' ') | Yes | | DIACL_DUTY | Allow NULL? |
| 58 | FLLB_HIDE | Hide Logbook Display | char | 1 | 0 | CHAR | (N' ') | Yes | | DIACL_HIDE | Allow NULL? |
| 59 | IFLOT_SRTYPE | Shift Report Type for Object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ILOM_SR_SRTYPE | Allow NULL? |
| 60 | IFLOT_SNTYPE | Notification Type for Shift Note for Object | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TQ80 | ILOM_SN_SNTYPE | Allow NULL? |
