| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PVNNO | Construction Progress Report Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | PS_PSP_PHIUP | Number of the superior WBS element | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | PSP_PROJ | Current number of the appropriate project | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | PKOKR | Controlling area for WBS element | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | PERIO | Period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | BUDAT | Posting Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | BLTXT | Document Header Text | nvarchar | 50 | 0 | | | | Allow NULL? |
| 11 | ERTIMESTMP | Time created (Greenwich Meantime) | decimal | 16 | 0 | | | | |
| 12 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | ERZET | Entry time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 14 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | AETIMESTMP | Change Time in Greenwich Meantime | decimal | 16 | 0 | | | | |
| 16 | AEDTM | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | AEZET | Time last change was made | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |