| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | HANDLE_ITEM | Worldwide unique key for LIPS-VBELN & LIPS_POSNR | nvarchar | 22 | 0 | | | | Allow NULL? |
| 3 | HANDLE_OBJ | Worldwide unique key for LIKP-VBELN | nvarchar | 22 | 0 | | | | Allow NULL? |
| 4 | PONUM | Purchasing Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | ITMNO | Item Number of Purchasing Document | nvarchar | 5 | 0 | | | | Allow NULL? |
| 6 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | BSTYP | Purchasing Document Category | char | 1 | 0 | | | | Allow NULL? |
| 9 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | BSAKZ | Control indicator for purchasing document type | char | 1 | 0 | | | | Allow NULL? |
| 11 | LOEKZ | Asset class marked for deletion | char | 1 | 0 | | | | Allow NULL? |
| 12 | STATU | Status field string | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | ELIKZ | "Delivery Completed" Indicator | char | 1 | 0 | | | | Allow NULL? |
| 15 | PSTYP | Item Category in Purchasing Document | char | 1 | 0 | | | | Allow NULL? |
| 16 | WEPOS | Goods Receipt Indicator | char | 1 | 0 | | | | Allow NULL? |
| 17 | WEUNB | Goods Receipt, Non-Valuated | char | 1 | 0 | | | | Allow NULL? |
| 18 | WEBRE | Indicator: GR-Based Invoice Verification | char | 1 | 0 | | | | Allow NULL? |
| 19 | EILDT | Start Date for GR-Based Settlement | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | USR01 | Additional data field 1 for delivery schedules | nvarchar | 35 | 0 | | | | Allow NULL? |
| 21 | USR02 | Additional data field 2 for delivery schedules | nvarchar | 35 | 0 | | | | Allow NULL? |
| 22 | USR03 | Additional data field 3 for delivery schedules | nvarchar | 35 | 0 | | | | Allow NULL? |
| 23 | USR04 | Additional data field 4 for delivery schedules | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | USR05 | Additional data field 5 for delivery schedules | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | PARGB | Trading partner's business area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | AUART | Sales Document Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | ANZ_POS_GRKOR | Number of Items in Delivery Group | int | 10 | 0 | | | | Allow NULL? |
| 29 | CHARG | Batch Number | nvarchar | 10 | 0 | | | | Allow NULL? |
