SAP Table KONH
Conditions (Header)
KONH (Conditions (Header)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link KONH to other SAP tables.
KONH table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |
|
KNUMH
Condition record number
|
KNUMH |
CHAR
|
10 | 0 | ||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||
|
ERDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||
|
KVEWE
Usage of the condition table
|
KVEWE | T681V |
CHAR
|
1 | 0 | |
|
KOTABNR
Condition table
|
KOTABNR | T681 |
NUMC
|
3 | 0 | |
|
KAPPL
Application
|
KAPPL | T681A |
CHAR
|
2 | 0 | |
|
KSCHL
Condition type
|
KSCHA | T685 |
CHAR
|
4 | 0 | |
|
VAKEY
Variable key 100 bytes
|
VAKEY |
CHAR
|
100 | 0 | ||
|
DATAB
Valid-From Date
|
DATAB |
DATS
|
8 | 0 | ||
|
DATBI
Valid To Date
|
DATBI |
DATS
|
8 | 0 | ||
|
KOSRT
Search term for conditions
|
KOSRT |
CHAR
|
10 | 0 | ||
|
KZUST
Responsibility in SD for condition/material
|
KZUST | T686C |
CHAR
|
3 | 0 | |
|
KNUMA_PI
Promotion
|
KNUMA_PI | KONA |
CHAR
|
10 | 0 | |
|
KNUMA_AG
Sales deal
|
KNUMA_AG | KONA |
CHAR
|
10 | 0 | |
|
KNUMA_SQ
Sales quote
|
KNUMA_SQ | KONA |
CHAR
|
10 | 0 | |
|
KNUMA_SD
Standard agreement
|
KNUMA_SD | KONA |
CHAR
|
10 | 0 | |
|
AKTNR
Promotion
|
WAKTION |
CHAR
|
10 | 0 | ||
|
KNUMA_BO
Agreement (subsequent settlement)
|
KNUMA_BO | KONA |
CHAR
|
10 | 0 | |
|
LICNO
Tax exemption license number
|
LICNO |
CHAR
|
20 | 0 | ||
|
LICDT
Date license granted
|
LICDT |
DATS
|
8 | 0 | ||
|
VADAT
Variable Data Part
|
VADAT_KO |
CHAR
|
100 | 0 |
KONH foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| KONH | KAPPL | KONH | KAPPL |
T681A
Conditions: Applications
|
KAPPL |
| KONH | KNUMA_AG | KONH | MANDT |
KONA
Agreements
|
MANDT |
| KONH | KNUMA_AG | KONH | KNUMA_AG |
KONA
Agreements
|
KNUMA |
| KONH | KNUMA_BO | KONH | MANDT |
KONA
Agreements
|
MANDT |
| KONH | KNUMA_BO | KONH | KNUMA_BO |
KONA
Agreements
|
KNUMA |
| KONH | KNUMA_PI | KONH | MANDT |
KONA
Agreements
|
MANDT |
| KONH | KNUMA_PI | KONH | KNUMA_PI |
KONA
Agreements
|
KNUMA |
| KONH | KNUMA_SD | KONH | MANDT |
KONA
Agreements
|
MANDT |
| KONH | KNUMA_SD | KONH | KNUMA_SD |
KONA
Agreements
|
KNUMA |
| KONH | KNUMA_SQ | KONH | MANDT |
KONA
Agreements
|
MANDT |
| KONH | KNUMA_SQ | KONH | KNUMA_SQ |
KONA
Agreements
|
KNUMA |
| KONH | KOTABNR | KONH | KVEWE |
T681
Conditions: Structures
|
KVEWE |
| KONH | KOTABNR | KONH | KOTABNR |
T681
Conditions: Structures
|
KOTABNR |
| KONH | KSCHL | KONH | KVEWE |
T685
Conditions: Types
|
KVEWE |
| KONH | KSCHL | KONH | KAPPL |
T685
Conditions: Types
|
KAPPL |
| KONH | KSCHL | KONH | KSCHL |
T685
Conditions: Types
|
KSCHL |
| KONH | KSCHL | KONH | MANDT |
T685
Conditions: Types
|
MANDT |
| KONH | KVEWE | KONH | KVEWE |
T681V
Conditions: Usages
|
KVEWE |
| KONH | KZUST | KONH | MANDT |
T686C
Contact Person: Responsibilities in Sales and Distribution
|
MANDT |
| KONH | KZUST | KONH | KZUST |
T686C
Contact Person: Responsibilities in Sales and Distribution
|
KZUST |
| KONH | MANDT | KONH | MANDT |
T000
Clients
|
MANDT |