| 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 | VPKID | Sales pricing document number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | VPKHEAD | VPKID | Allow NULL? |
| 3 | DLINR | Number of the Dynamic Item | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | No | AD01DLI | AD01DLINR | Allow NULL? |
| 4 | LOCKED | Element locked or not | char | 1 | 0 | CHAR | (N' ') | Yes | | VPKITEMLOCK | Allow NULL? |
| 5 | BEMOT | Accounting Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TBMOT | BEMOT | Allow NULL? |
| 6 | AUMOT | Apportionment reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | AD01C_CT | AUMOT | Allow NULL? |
| 7 | VWAER | SD Document Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERK | Allow NULL? |
| 8 | POSNR | Sales Document Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | POSNR_VA | Allow NULL? |
| 9 | POSNRVPK | Item number of sales document (internal for SPc) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | VPKPOSNR | Allow NULL? |
| 10 | UEPOSVPK | Main internal item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | VBUP | VPKUEPOSNR | Allow NULL? |
| 11 | MATNR_SD | Material number for determining the sales price | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | VPK_MATNR_SD | Allow NULL? |
| 12 | SO_WTGBTR | Total Value in Transaction Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WTGXXX | |
| 13 | SO_WOGBTR | Total Value in Object Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WOGXXX | |
| 14 | SO_WKGBTR | Total Value in Controlling Area Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WKGXXX | |
| 15 | SO_MEGBTR | Total Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MEGXXX | |
| 16 | BI_WTGBTR | Total Value in Transaction Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WTGXXX | |
| 17 | BI_WOGBTR | Total Value in Object Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WOGXXX | |
| 18 | BI_WKGBTR | Total Value in Controlling Area Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WKGXXX | |
| 19 | BI_MEGBTR | Total Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MEGXXX | |
| 20 | OP_WTGBTR | Total Value in Transaction Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WTGXXX | |
| 21 | OP_WOGBTR | Total Value in Object Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WOGXXX | |
| 22 | OP_WKGBTR | Total Value in Controlling Area Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WKGXXX | |
| 23 | OP_MEGBTR | Total Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MEGXXX | |
| 24 | CA_WTGBTR | Total Value in Transaction Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WTGXXX | |
| 25 | CA_WOGBTR | Total Value in Object Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WOGXXX | |
| 26 | CA_WKGBTR | Total Value in Controlling Area Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WKGXXX | |
| 27 | CA_MEGBTR | Total Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MEGXXX | |
| 28 | IN_WTGBTR | Total Value in Transaction Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WTGXXX | |
| 29 | IN_WOGBTR | Total Value in Object Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WOGXXX | |
| 30 | IN_WKGBTR | Total Value in Controlling Area Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WKGXXX | |
| 31 | IN_MEGBTR | Total Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MEGXXX | |
| 32 | LA_WTGBTR | Total Value in Transaction Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WTGXXX | |
| 33 | LA_WOGBTR | Total Value in Object Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WOGXXX | |
| 34 | LA_WKGBTR | Total Value in Controlling Area Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WKGXXX | |
| 35 | LA_MEGBTR | Total Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MEGXXX | |
| 36 | NO_WTGBTR | Total Value in Transaction Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WTGXXX | |
| 37 | NO_WOGBTR | Total Value in Object Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WOGXXX | |
| 38 | NO_WKGBTR | Total Value in Controlling Area Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WKGXXX | |
| 39 | NO_MEGBTR | Total Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MEGXXX | |
| 40 | BA_WTGBTR | Total Value in Transaction Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WTGXXX | |
| 41 | BA_WOGBTR | Total Value in Object Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WOGXXX | |
| 42 | BA_WKGBTR | Total Value in Controlling Area Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WKGXXX | |
| 43 | BA_MEGBTR | Total Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MEGXXX | |
| 44 | NETVALUE | Net value (price) | decimal | 15 | 2 | CURR | ((0)) | Yes | | VPKNETVALUE | |
