| 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 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | ILOAN | Allow NULL? |
| 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | IFLOT | TPLNR | Allow NULL? |
| 4 | ABCKZ | ABC indicator for technical object | char | 1 | 0 | CHAR | (N' ') | Yes | T370C | ABCKZ | Allow NULL? |
| 5 | ABCKZI | Data origin for ABC indicator field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_ABCKZI | Allow NULL? |
| 6 | EQFNR | Sort field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | EQFNR | Allow NULL? |
| 7 | EQFNRI | Data origin for sort field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_EQFNRI | Allow NULL? |
| 8 | SWERK | Maintenance plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | SWERK | Allow NULL? |
| 9 | SWERKI | Data origin for maintenance plant field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_SWERKI | Allow NULL? |
| 10 | STORT | Location of maintenance object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T499S | PMLOC | Allow NULL? |
| 11 | STORTI | Data origin for location field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_STORTI | Allow NULL? |
| 12 | MSGRP | Room | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | RAUMNR | Allow NULL? |
| 13 | MSGRPI | Data origin for room number field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_MSGRPI | Allow NULL? |
| 14 | BEBER | Plant section | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T357 | BEBER | Allow NULL? |
| 15 | BEBERI | Data origin for plant section field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_BEBERI | Allow NULL? |
| 16 | CR_OBJTY | Object types of the CIM resource | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CR_OBJTY | Allow NULL? |
| 17 | PPSID | Object ID of PP work center | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | CRID | PPSID | Allow NULL? |
| 18 | PPSIDI | Data origin for PP work center field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_PPSIDI | Allow NULL? |
| 19 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 20 | GSBERI | Data origin for business area field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_GSBERI | Allow NULL? |
| 21 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TKA01 | KOKRS | Allow NULL? |
| 22 | KOKRSI | Data origin for controlling area field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_KOKRSI | Allow NULL? |
| 23 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CSKS | KOSTL | Allow NULL? |
| 24 | KOSTLI | Data origin for cost center field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_KOSTLI | Allow NULL? |
| 25 | PROID | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | PRPS | PS_PSP_PNR | Allow NULL? |
| 26 | PROIDI | Data origin for WBS element field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_PROIDI | Allow NULL? |
| 27 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 28 | BUKRSI | Data origin for company code field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_BUKRSI | Allow NULL? |
| 29 | ANLNR | Main Asset Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ANLH | ANLN1 | Allow NULL? |
| 30 | ANLNRI | Data origin for asset main no./sub-no. fields | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_ANLNRI | Allow NULL? |
| 31 | ANLUN | Asset Subnumber | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | ANLA | ANLN2 | Allow NULL? |
| 32 | ANLUNI | Data origin indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INHER | Allow NULL? |
| 33 | DAUFN | Standing order number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AUFK | DAUFN | Allow NULL? |
| 34 | DAUFNI | Data origin of standing order number field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_DAUFNI | Allow NULL? |
| 35 | AUFNR | Settlement order | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AUFK | ILOM_ORDST | Allow NULL? |
| 36 | AUFNRI | Data origin for settlement order field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_AUFNRI | Allow NULL? |
| 37 | TPLNRI | Data origin for functional location field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_TPLNRI | Allow NULL? |
| 38 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | VKORG | Allow NULL? |
| 39 | VKORGI | Data origin for sales organization field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_VKORGI | Allow NULL? |
| 40 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVKOV | VTWEG | Allow NULL? |
| 41 | VTWEGI | Data origin of distribution channel field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_VTWEGI | Allow NULL? |
| 42 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTA | SPART | Allow NULL? |
| 43 | SPARTI | Data origin for division field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_SPARTI | Allow NULL? |
| 44 | ADRNR | Address number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | ADRC | AD_ADDRNUM | Allow NULL? |
| 45 | ADRNRI | Data origin for address field | char | 1 | 0 | CHAR | (N' ') | Yes | | INH_ADRNRI | Allow NULL? |
| 46 | OWNER | Object reference indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ILOM_OWNER | Allow NULL? |
| 47 | VKBUR | Sales Office | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKBZ | VKBUR | Allow NULL? |
| 48 | VKGRP | Sales Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TVBVK | VKGRP | Allow NULL? |
