| 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 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | LIFNR | Vendor Account Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | HWAER | Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 14 | NETWR | Effective order value | decimal | 15 | 2 | | | | |
| 15 | REWRT | Invoice Amount | decimal | 15 | 2 | | | | |
| 16 | ABEST | No. of purchase orders | decimal | 9 | 0 | | | | |
| 17 | ABSTP | Number of purchase order items | decimal | 9 | 0 | | | | |
| 18 | ABSTE | Number of purchase order item schedule lines | decimal | 9 | 0 | | | | |
| 19 | AANFR | Number of requests for quotations | decimal | 9 | 0 | | | | |
| 20 | AANFP | Number of requests for quotation items | decimal | 9 | 0 | | | | |
| 21 | AANGP | Number of Quotation Items | decimal | 9 | 0 | | | | |
| 22 | AKONT | Number of contracts | decimal | 9 | 0 | | | | |
| 23 | AKONP | Number of contract items | decimal | 9 | 0 | | | | |
| 24 | ALFPL | Number of scheduling agreements | decimal | 9 | 0 | | | | |
| 25 | ALFPP | Number of scheduling agreement items | decimal | 9 | 0 | | | | |
| 26 | ALFPE | Number of delivery schedules | decimal | 9 | 0 | | | | |
| 27 | ALIEF | Number of deliveries | decimal | 9 | 0 | | | | |