| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | | | | Allow NULL? |
| 8 | SKLSOB | PMIS: Object class | nvarchar | 18 | 0 | | | | Allow NULL? |
| 9 | SUBMT | Material number for equipment | nvarchar | 18 | 0 | | | | Allow NULL? |
| 10 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | | | Allow NULL? |
| 11 | BAUJJ | Year of construction | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | STWAE | Statistics currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 15 | SUNIT | Unit for Breakdown Duration | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 17 | SNUMTP | PMIS: Total number of functional locations | decimal | 9 | 0 | | | | |
| 18 | STPEEN | PMIS: No.of functional locations w.individual installation | decimal | 9 | 0 | | | | |
| 19 | STPOEN | PMIS: No. of functional locations w/o equipment installed | decimal | 9 | 0 | | | | |
| 20 | STPSEN | PMIS: No.of functional locations w.collective installation | decimal | 9 | 0 | | | | |
| 21 | SNUMEQ | PMIS: Total number of pieces of equipment | decimal | 9 | 0 | | | | |
| 22 | ANSWT | Acquisition Value | decimal | 13 | 2 | | | | |
| 23 | SMOFN | No.of recorded notifications | decimal | 9 | 0 | | | | |
| 24 | SMMAB | No. of completed notifications | decimal | 9 | 0 | | | | |
| 25 | SABTG | No. processing days creation to completion | decimal | 9 | 0 | | | | |
| 26 | SGMSAUS | Number of machine breakdowns reported | decimal | 9 | 0 | | | | |
| 27 | SGAUSZT | Downtime entered | decimal | 13 | 3 | | | | |
| 28 | SSCODE | PMIS: No.of damages | decimal | 9 | 0 | | | | |
| 29 | SACODE | PMIS: number of activity codes | decimal | 9 | 0 | | | | |
| 30 | SUCODE | PMIS: No. of cause of damage codes | decimal | 9 | 0 | | | | |
| 31 | IAOFN | PMIS: number of maintenance orders created | decimal | 9 | 0 | | | | |
| 32 | IASOF | PMIS: no. of maintenance tasks to be performed immediately | decimal | 9 | 0 | | | | |
| 33 | IAPLANM | PMIS: number of planned maintenance orders | decimal | 9 | 0 | | | | |
| 34 | IAUNGPL | PMIS: number of unplanned maintenance orders | decimal | 9 | 0 | | | | |
| 35 | IAABG | PMIS: number of completed maintenance orders | decimal | 9 | 0 | | | | |
| 36 | IAKOSPLAN | Total plant maintenance costs (planned) | decimal | 15 | 2 | | | | |
| 37 | IAKOSIST | Total(actual) maintenance costs | decimal | 15 | 2 | | | | |
| 38 | IAPERKOSE | PMIS: PM costs for internal wages | decimal | 15 | 2 | | | | |
| 39 | IAPERKOSF | PMIS: PM costs for external wages | decimal | 15 | 2 | | | | |
| 40 | IAMATKOSE | PMIS: PM costs for internal material | decimal | 15 | 2 | | | | |
| 41 | IAMATKOSF | PMIS: PM costs for external material | decimal | 15 | 2 | | | | |
| 42 | IADIENKOS | PMIS: PM costs for services | decimal | 15 | 2 | | | | |
| 43 | IASONKOST | PMIS: Miscellaneous PM costs | decimal | 15 | 2 | | | | |
| 44 | IAERTRAG | Total plant maintenance revenues (actual) | decimal | 15 | 2 | | | | |
