| 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 | VKALS | Sales Pricing: Sales Price Calculation Schema | nvarchar | 6 | 0 | CHAR | (N' ') | No | T683 | VKALS | Allow NULL? |
| 3 | LIFEL | Sales Pricing: List Field for Determining Sales Price | nvarchar | 5 | 0 | CHAR | (N' ') | No | TWLF | LIFELD | Allow NULL? |
| 4 | KOFEL | Subtotal in sales price calculation schema | nvarchar | 5 | 0 | CHAR | (N' ') | No | | KOFEL | Allow NULL? |
| 5 | KVEWE | Usage of the condition table | char | 1 | 0 | CHAR | (N' ') | No | T681V | KVEWE | Allow NULL? |
| 6 | KAPPL | Application | nvarchar | 2 | 0 | CHAR | (N' ') | No | T681A | KAPPL | Allow NULL? |
| 7 | KSCHL | Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T685 | KSCHL | Allow NULL? |
| 8 | AKSCH | Promotion condition type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T685 | AKSCH | Allow NULL? |
| 9 | KKSCH | Condition type in the sales price calculation schema | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | KKSCH | Allow NULL? |
| 10 | WRSKZ | Sales Price Calculation: Default currency for conditions | char | 1 | 0 | CHAR | (N' ') | Yes | | WRSKZ | Allow NULL? |
| 11 | KOAER | Pricing: Type of condition type determination | char | 1 | 0 | CHAR | (N' ') | Yes | | KOAER | Allow NULL? |
| 12 | KOSER | Pricing: Condition record determination type | char | 1 | 0 | CHAR | (N' ') | Yes | | KOSER | Allow NULL? |
| 13 | UEBNA | Pricing: method of adoption from calc. schema --> list field | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBNA | Allow NULL? |
