| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TRKORR | Request/Task | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | KAPPL | Application | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | KSCHL | Condition type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | KOTABNR | Condition table | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | QMANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | QSYSID | Name of SAP System | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | KNUMH | Condition record number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | VAKEY | Variable key 100 bytes | nvarchar | 100 | 0 | | | | Allow NULL? |
| 10 | DATAB | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | DATBI | Valid To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | KOPOS | Sequential number of the condition | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | KVEWE | Usage of the condition table | char | 1 | 0 | | | | Allow NULL? |
| 14 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | STFKZ | Scale Type | char | 1 | 0 | | | | Allow NULL? |
| 17 | KRECH | Calculation type for condition | char | 1 | 0 | | | | Allow NULL? |
| 18 | KBETR | Rate (condition amount or percentage) where no scale exists | decimal | 11 | 2 | | | | |
| 19 | KONWA | Rate unit (currency or percentage) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | KPEIN | Condition pricing unit | decimal | 5 | 0 | | | | |
| 21 | KMEIN | Condition unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | KUMZA | Numerator for converting condition units to base units | decimal | 5 | 0 | | | | |
| 23 | KUMNE | Denominator for converting condition units to base units | decimal | 5 | 0 | | | | |
| 24 | LOEVM_KO | Deletion Indicator for Condition Item | char | 1 | 0 | | | | Allow NULL? |
| 25 | ZAEHK_IND | Condition item index | nvarchar | 2 | 0 | | | | Allow NULL? |