| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BSTYP | Purchasing Document Category | char | 1 | 0 | | | | Allow NULL? |
| 3 | EDOKN | Object Number in Purchasing | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | EDOKP | Purchasing object: item | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | REVNO | Version number in Purchasing | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | ERUHR | Entry time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 9 | FGNAM | Name of person effecting release | nvarchar | 12 | 0 | | | | Allow NULL? |
| 10 | FGDAT | Date of release | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | FGUHR | Time of release | nvarchar | 6 | 0 | | | | Allow NULL? |
| 12 | OKNAM | Name of approving buyer | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | OKDAT | Date of buyer approval | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | OKUHR | Time of buyer approval | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | RSCOD | Reason for change | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | TXZ01 | Description of version | nvarchar | 60 | 0 | | | | Allow NULL? |
| 17 | EXTNR | External Change Number of Version | nvarchar | 20 | 0 | | | | Allow NULL? |
| 18 | CRNAM | Person requesting change | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | NETWR | Net Order Value in PO Currency | decimal | 13 | 2 | | | | |
| 20 | DIFWR | Value change due to version | decimal | 13 | 2 | | | | |
| 21 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | BUDAT | Posting date of version | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | REVOK | Status "version completed" | char | 1 | 0 | | | | Allow NULL? |
| 24 | STREV | Version status | char | 1 | 0 | | | | Allow NULL? |
| 25 | LOEKZ | Deletion Indicator in Purchasing Document | char | 1 | 0 | | | | Allow NULL? |
| 26 | BANPR | Old processing state in purchasing document before version | nvarchar | 2 | 0 | | | | Allow NULL? |