| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 4 | EBELN | Purchase Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | BSTNR | Allow NULL? |
| 5 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | NUMC | (N'00000') | No | * | EBELP | Allow NULL? |
| 6 | EINDT | Item Delivery Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | EINDT | Allow NULL? |
| 7 | ETENR | Delivery Schedule Line Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | * | ETENR | Allow NULL? |
| 8 | BUPER | Posting period in the form YYYYMM | nvarchar | 6 | 0 | ACCP | (N' ') | Yes | | BUPER | Allow NULL? |
| 9 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | EKGRP | Allow NULL? |
| 10 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LIFNR | Allow NULL? |
| 11 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | * | MATKL | Allow NULL? |
| 12 | MULKZ | Multi-indicator: material | char | 1 | 0 | CHAR | (N' ') | Yes | | MULKZ | Allow NULL? |
| 13 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 14 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 15 | BSTYP | Purchasing Document Category | char | 1 | 0 | CHAR | (N' ') | Yes | | BSTYP | Allow NULL? |
| 16 | LOEKZ | Deletion Indicator in Purchasing Document | char | 1 | 0 | CHAR | (N' ') | Yes | | ELOEK | Allow NULL? |
| 17 | MENGE | Quantity Ordered Against this Purchase Requisition | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSMNG | |
| 18 | MEINS | Purchase Order Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | BSTME | Allow NULL? |
| 19 | UMREF | Conversion factor for quantity conversion | decimal | 9 | 5 | DEC | ((0)) | Yes | | MC_UMREF | |
| 20 | BRTWR | Gross order value in base unit of measure | decimal | 15 | 2 | CURR | ((0)) | Yes | | MC_BRTWR | |
| 21 | NETWR | Net purchase order value (base unit) | decimal | 15 | 2 | CURR | ((0)) | Yes | | MC_NETWR | |
| 22 | WAERS | Purchase order currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BSTWA | Allow NULL? |
| 23 | WKURS | Exchange Rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | WKURS | |
| 24 | FFACT | Factor for the "From" Currency Units | decimal | 9 | 0 | DEC | ((0)) | Yes | | FFACT | |
| 25 | REMNG | Quantity invoiced | decimal | 13 | 3 | QUAN | ((0)) | Yes | | REMNG | |
| 26 | REWRT | Invoice value in local currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | REWRT | |
| 27 | WEMNG | Quantity of Goods Received | decimal | 13 | 3 | QUAN | ((0)) | Yes | | WEMNG | |
| 28 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEDAT | Allow NULL? |
| 29 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BSART | Allow NULL? |
| 30 | DLIFZ | Mean average delivery time (R/2->R/3 link) | decimal | 5 | 1 | DEC | ((0)) | Yes | | MC_DLIFZ | |
| 31 | ALIEF | Number of deliveries | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_ALIEF | |
| 32 | WEABW | Quantity of Goods Received | decimal | 13 | 3 | QUAN | ((0)) | Yes | | WEMNG | |
| 33 | MAHNZ | Number of Reminders/Expediters | decimal | 3 | 0 | DEC | ((0)) | Yes | | MAHNZ | |
| 34 | SLFDT | Statistics-Relevant Delivery Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SLFDT | Allow NULL? |
| 35 | LMEIN | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | LAGME | Allow NULL? |
| 36 | LAND1 | Country key of vendor | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | MCLANDL | Allow NULL? |
| 37 | HWAER | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | HWAER | Allow NULL? |
| 38 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EKORG | Allow NULL? |
