| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | KOTE959 | Sales org./Distr. Chl/Customer/Material | 9 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 2 | KOTE960 | Sales org./Distr. Chl/Customer/Material | 9 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 3 | ZEIM_VBAK | Sales Document: Header Data | 58 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| TOPAdvertising Management |
| 4 | KOTE201 | Sales Organization/Partner Object | 7 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| TOPAgency Business Global Trade |
| 5 | WBRK | Agency business: Header | 61 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| TOPBilling |
| 6 | SDFM_SF_AG_INDEX | MANDT MANDTIndex Table for Update of Statistics (Agreements) | 3 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 7 | VBRK | Billing Document: Header Data | 60 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| TOPConditions |
| 8 | CND_MEM_INITIAL | Conditions: Buffer for Initial Upload | 8 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 9 | E000 | Condition Table for Rebate $ | 6 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 10 | KONA | Agreements | 2 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 11 | KONAIND | Index: Groups of Conditions/Header Record Conditions | 2 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 12 | KOTE001 | Customer/Material | 10 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 13 | KOTE002 | Customer/Rebate Group | 10 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 14 | KOTE003 | Customer | 9 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 15 | KOTE004 | Customer Hierarchy | 9 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 16 | KOTE005 | Customer Hierarchy/Material | 10 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 17 | KOTE006 | Vendor/Material | 8 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 18 | KOTE007 | Vendor/Accounting Group | 8 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 19 | KOTE008 | Vendor | 7 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 20 | KOTE009 | Vendor/VSR | 8 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 21 | KOTE010 | Vendor Hierarchy: Rebate | 7 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 22 | KOTE011 | Vendor Hierarchy: Material Rebate | 8 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 23 | KOTE012 | Vendor Hierarchy: Vendor Sub-Range Rebate | 8 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 24 | KOTE013 | SOrg/Vendor/Customer | 8 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 25 | KOTE017 | Campaign ID/Customer/Material | 8 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 26 | KOTE522 | Camp. ID/Customer/Material | 8 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 27 | KOTE523 | Camp. ID/Customer/Matl grp 1 | 8 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 28 | KOTE524 | Camp. ID/Customer/Matl grp 1 | 8 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 29 | KOTE950 | Condition Table for Rebate KOTE950 | 9 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 30 | KOTE999 | Sales org./Distr. Chl/Customer/Prod.hier. | 9 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| TOPCross-Application Components |
| 31 | VVBAK | Sales Document: Header Data | 58 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| TOPData Collection |
| 32 | S015 | Subsequent Settlement: Evaluation | 9 | KNUMA | Agreement (subsequent settlement) | nvarchar | 10 | 0 | | |
| 33 | S015E | S015 - Structural Information | 4 | KNUMA | Agreement (subsequent settlement) | nvarchar | 10 | 0 | | |
| TOPRebate Agreements |
| 34 | AGR_MAP_KNUMA | Conversion Table AG_GUID CRM <> KNUMA | 3 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 35 | AGR_MEM_INITIAL | Agreements: Buffer for Intial Upload | 2 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 36 | AGR_REL_KNUMA_CM | Assignment: Agreement --> Campaign | 2 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| TOPRemaining Beverage - Obsolete Objects |
| 37 | /BEV1/BO_CONT | Contract Data for Rebate Agreements | 2 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 38 | /BEV1/BO_DATA | Proof Table for Rebate Processing | 2 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 39 | /BEV1/RBLA | Settlement Interval and Date Last Settlement for Agreement | 6 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 40 | /BEV1/RBVBAK | Sales Document: Header Data | 58 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| TOPSales |
| 41 | VBAK | Sales Document: Header Data | 58 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| TOPSimulation |
| 42 | VSVBAK_CN | Version: Sales document: Header data | 59 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| TOPSubsequent Settlement |
| 43 | EBAB | Settlement Runs Subsequent Settlement, Header Data | 3 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 44 | EBABG | Settlement Runs Subsequent Settlement, Interval Scales | 3 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 45 | EBABP | Settlement Runs Subsequent Settlement, Condition Record | 3 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 46 | KOPA | Rebate Arrangement/Partner Assignment | 2 | KNUMA | Agreement (various conditions grouped together) | nvarchar | 10 | 0 | | |
| 47 | S015BIW1 | S015BIW1 * Supplementary settlement - Evaluation | 9 | KNUMA | Agreement (subsequent settlement) | nvarchar | 10 | 0 | | |
| 48 | S015BIW2 | S015BIW2 * Supplementary settlement - Evaluation | 9 | KNUMA | Agreement (subsequent settlement) | nvarchar | 10 | 0 | | |
