| 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 | T000 | MANDT | Allow NULL? |
| 2 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | VBELN | Allow NULL? |
| 3 | POSNR | Item number of the SD document | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | POSNR | Allow NULL? |
| 4 | ETENR | Delivery Schedule Line Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | * | ETENR | Allow NULL? |
| 5 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 6 | VBTYP | SD document category | char | 1 | 0 | CHAR | (N' ') | Yes | | VBTYP | Allow NULL? |
| 7 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 8 | WAERK | SD Document Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERK | Allow NULL? |
| 9 | HWAER | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | HWAER | Allow NULL? |
| 10 | KUNAG | Sold-to party | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNAG | Allow NULL? |
| 11 | KUNRG | Payer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNRG | Allow NULL? |
| 12 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 13 | ZLSCH | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | * | DZLSCH | Allow NULL? |
| 14 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FKDAT | Allow NULL? |
| 15 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FBUDA | Allow NULL? |
| 16 | KURSK | Exchange Rate for Price Determination | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURSK | |
| 17 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 18 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VGBEL | Allow NULL? |
| 19 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | VGPOS | Allow NULL? |
| 20 | POSMENGE | Cumulative Order Quantity in Sales Units | decimal | 15 | 3 | QUAN | ((0)) | Yes | | KWMENG | |
| 21 | ERLMENGE_L | Completed quantity (delivery) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | ERLMENGE_L | |
| 22 | ERLMENGE_F | Invoiced quantity in basic unit of measure | decimal | 13 | 3 | QUAN | ((0)) | Yes | | ERLMENGE_F | |
| 23 | FAKLMENG | Invoiced delivery quantity in base unit of measure | decimal | 13 | 3 | QUAN | ((0)) | Yes | | FAKLMENG | |
| 24 | EDATU | Schedule line date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EDATU | Allow NULL? |
| 25 | BESTMENGE | Confirmed Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BMENG | |
| 26 | WADAT | Goods Issue Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WADAT | Allow NULL? |
| 27 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEINS | Allow NULL? |
| 28 | UNFMENG | Invoiced quantity on division level | decimal | 13 | 3 | QUAN | ((0)) | Yes | | EINZFAKT | |
| 29 | PREIS | Unit price in foreign currency per unit quantity | decimal | 15 | 2 | CURR | ((0)) | Yes | | EINZPREISF | |
| 30 | HPREI | Unit price in local currency per unit quantity | decimal | 15 | 2 | CURR | ((0)) | Yes | | EINZPREISH | |
| 31 | EBENE | Planning level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | FDLEV | Allow NULL? |
| 32 | FDGRV | Planning Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FDGRP | Allow NULL? |
| 33 | DATUM | Planning date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FDTAG | Allow NULL? |
| 34 | DMSHB | Amount in local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | DMSHW | |
| 35 | WRSHB | Amount in planned currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WRSHW | |
