| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | ANLN1 | Main Asset Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 4 | ANLN2 | Asset Subnumber | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | BDATU | Date validity ends | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | ADATU | Date for beginning of validity | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | KOSTL | Cost Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | LSTAR | Activity Type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | MSFAK | Multiple-shift factor for multiple shift operation | decimal | 3 | 2 | | | | |
| 12 | XSTIL | Asset shutdown | char | 1 | 0 | | | | Allow NULL? |
| 13 | STORT | Asset location | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | CAUFN | Internal order | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | PLAN1 | no longer used | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | PLAN2 | No longer used | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | RAUMN | Room | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | IAUFN | Maintenance order | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | IPROJ | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | | | | Allow NULL? |
| 20 | TPLKZ | Unused field length 3 | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | TPLNR | Functional Location | nvarchar | 30 | 0 | | | | Allow NULL? |
| 22 | ANUPD | Indicator: Type of change to table | char | 1 | 0 | | | | Allow NULL? |
| 23 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | | | | Allow NULL? |
| 24 | IPSNR | WBS element - maintenance project | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | KFZKZ | License plate no. of vehichle | nvarchar | 15 | 0 | | | | Allow NULL? |
| 26 | PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | KOSTLV | Cost center responsible for asset | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | FISTL | Funds Center | nvarchar | 16 | 0 | | | | Allow NULL? |
| 29 | GEBER | Fund | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | FKBER | Functional Area | nvarchar | 16 | 0 | | | | Allow NULL? |
| 31 | GRANT_NBR | Grant | nvarchar | 20 | 0 | | | | Allow NULL? |
| 32 | GEBER2 | Fund for APC Account Assignments | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | FKBER2 | Functional Area for APC Account Assignments | nvarchar | 16 | 0 | | | | Allow NULL? |
| 34 | GRANT_NBR2 | Grant for APC Account Assignments | nvarchar | 20 | 0 | | | | Allow NULL? |
| 35 | FISTL2 | Funds Center for APC Account Assignments | nvarchar | 16 | 0 | | | | Allow NULL? |
| 36 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | PS_PSP_PNR2 | WBS Element (Costs) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 38 | BUDGET_PD | FM: Budget Period | nvarchar | 10 | 0 | | | | Allow NULL? |
| 39 | BUDGET_PD2 | Budget Period for APC Account Assignments | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | SEGMENT | Segment for Segmental Reporting | nvarchar | 10 | 0 | | | | Allow NULL? |
| 41 | PRCTR | Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
