| 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 | * | MANDT | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | GJAHR | Posting year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR_KK | Allow NULL? |
| 4 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SH_OPBEL_KK | Allow NULL? |
| 5 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | FKK_VBRK_SHORT | VBELN | Allow NULL? |
| 6 | KNUMV | Number of the document condition | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KNUMV | Allow NULL? |
| 7 | KPOSN | Condition item number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | KPOSN | Allow NULL? |
| 8 | STUNR | Step number | nvarchar | 3 | 0 | NUMC | (N'000') | No | * | STUNR | Allow NULL? |
| 9 | ZAEHK | Condition counter | nvarchar | 2 | 0 | NUMC | (N'00') | No | | DZAEHK | Allow NULL? |
| 10 | KAPPL | Application | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | KAPPL | Allow NULL? |
| 11 | KSCHL | Condition type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KSCHA | Allow NULL? |
| 12 | KDATU | Condition pricing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KDATU | Allow NULL? |
| 13 | KRECH | Calculation type for condition | char | 1 | 0 | CHAR | (N' ') | Yes | | KRECH | Allow NULL? |
| 14 | KAWRT | Condition base value | decimal | 15 | 2 | CURR | ((0)) | Yes | | KAWRT | |
| 15 | KBETR | Rate (condition amount or percentage) | decimal | 11 | 2 | CURR | ((0)) | Yes | | KBETR | |
| 16 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 17 | KKURS | Condition exchange rate for conversion to local currency | decimal | 9 | 5 | DEC | ((0)) | Yes | | KKURS | |
| 18 | KPEIN | Condition pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | KPEIN | |
| 19 | KMEIN | Condition unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | KMEIN | Allow NULL? |
| 20 | KNTYP | Condition category (examples: tax, freight, price, cost) | char | 1 | 0 | CHAR | (N' ') | Yes | | KNTYP | Allow NULL? |
| 21 | KSTAT | Condition is used for statistics | char | 1 | 0 | CHAR | (N' ') | Yes | | KSTAT | Allow NULL? |
| 22 | KNUMH | Condition record number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KNUMH | Allow NULL? |
| 23 | KOPOS | Sequential number of the condition | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | KOPOS | Allow NULL? |
| 24 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAKNR | Allow NULL? |
| 25 | MWSK1 | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 26 | SAKN2 | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAKNR | Allow NULL? |
| 27 | MWSK2 | Withholding tax code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WT_WITHCD | Allow NULL? |
| 28 | KWERT | Condition value | decimal | 13 | 2 | CURR | ((0)) | Yes | | KWERT | |
| 29 | KINAK | Condition is inactive | char | 1 | 0 | CHAR | (N' ') | Yes | | KINAK | Allow NULL? |
| 30 | KOAID | Condition class | char | 1 | 0 | CHAR | (N' ') | Yes | | KOAID | Allow NULL? |
