| 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 | WKART | Market-basket pricing type | nvarchar | 4 | 0 | CHAR | (N' ') | No | | W_WKART | Allow NULL? |
| 3 | EKERV | Purchase price determination sequence | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TWEV | EKERV_M | Allow NULL? |
| 4 | VKERV | Sales price determination sequence | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TWEV | EKERV_V | Allow NULL? |
| 5 | WWAER | Display Currency for Market-Basket Price Calculation | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | W_WWAER | Allow NULL? |
| 6 | WAUFR | Allocation rule for market-basket price calculation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | W_WAUFR | Allow NULL? |
| 7 | KURST | Exchange Rate Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | KURST | Allow NULL? |
| 8 | VKLIG | List group | char | 1 | 0 | CHAR | (N' ') | Yes | | LIGRU | Allow NULL? |
| 9 | VKLIV | List variant for sales price calculation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TWST | LIVAR | Allow NULL? |
| 10 | NUMKI | Number range in the case of internal number assignment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUMKI | Allow NULL? |
| 11 | NUMKE | Number range in the case of external number assignment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUMKE | Allow NULL? |
| 12 | SVARI | Name of a selection variant for dyn. reading of info struct. | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | SVARI | Allow NULL? |
| 13 | PERNU | Market-basket pr. calc.: no. periods for reading sales data | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | WKK_PERNUM | Allow NULL? |
| 14 | AFNAM | MB Price Calc.: Name of Function Module for Sales Qty Detrmn | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | W_AFNAM | Allow NULL? |
