| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | KNUMH | Condition record number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | KUNWE | Ship-to party | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 6 | BUTYP | Posting Type | char | 1 | 0 | | | | Allow NULL? |
| 7 | INDEX_B | | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | ENDDAT | Valid To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | BEGDAT | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | DATAB | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | DATBI | Valid To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | VKORG | Sales Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | SPART | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | FINAL | ID for Final Settlement | char | 1 | 0 | | | | Allow NULL? |
| 17 | STATUS | Processing status | char | 1 | 0 | | | | Allow NULL? |
| 18 | CORFLG | ID for Adjustment Settlements | char | 1 | 0 | | | | Allow NULL? |
| 19 | DOCFLG | ID for Created Documents | char | 1 | 0 | | | | Allow NULL? |
| 20 | COPFLG | ID for CO-PA Correction | char | 1 | 0 | | | | Allow NULL? |
| 21 | SOURCE | Origin of Settlement Data | char | 1 | 0 | | | | Allow NULL? |
| 22 | AUBEL | Sales Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | VBELN | Billing Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | KWERT | Condition base value | decimal | 15 | 2 | | | | |
| 25 | RRWRT | Rebate: Accruals reversed in condition currency | decimal | 19 | 2 | | | | |
| 26 | KBETR | Rate (condition amount or percentage) where no scale exists | decimal | 11 | 2 | | | | |
| 27 | KONWA | Rate unit (currency or percentage) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | KONWS | Scale currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 29 | KPEIN | Condition pricing unit | decimal | 5 | 0 | | | | |
| 30 | KMEIN | Condition unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | KMENG | Target quantity in sales units | decimal | 13 | 3 | | | | |
| 32 | KAWRT | Condition base value | decimal | 15 | 2 | | | | |
| 33 | KRECH | Calculation type for condition | char | 1 | 0 | | | | Allow NULL? |
| 34 | KZBZG | Scale basis indicator | char | 1 | 0 | | | | Allow NULL? |
| 35 | STORNO | Billing document is cancelled | char | 1 | 0 | | | | Allow NULL? |
| 36 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 37 | ERZET | Entry time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 38 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 40 | AEZET | Time last change was made | nvarchar | 6 | 0 | | | | Allow NULL? |
| 41 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
