SAP table KONH (Conditions (Header))
SAP table KONH has 2 primary key fields being MANDT,KNUMH.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KNUMH | Number of the Condition Record | CHAR | 10 | 0 | KNUMH | ||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| KVEWE | Usage of the condition table | CHAR | 1 | 0 | T681V | KVEWE | |
| KOTABNR | Number of the Condition Table | CHAR | 3 | 0 | T681 | KOTABNR | |
| KAPPL | Application | CHAR | 2 | 0 | T681A | KAPPL | |
| KSCHL | Condition Type | CHAR | 4 | 0 | T685 | KSCHA | |
| DATAB | Valid-From Date | DATS | 8 | 0 | DATAB | ||
| DATBI | Valid To Date | DATS | 8 | 0 | DATBI | ||
| KOSRT | Search term for conditions | CHAR | 10 | 0 | KOSRT | ||
| KZUST | Responsibility in SD for condition/material | CHAR | 3 | 0 | T686C | KZUST | |
| KNUMA_PI | Sales Promotion | CHAR | 10 | 0 | KONA | KNUMA_PI | |
| KNUMA_AG | Sales Deal | CHAR | 10 | 0 | KONA | KNUMA_AG | |
| KNUMA_SQ | Sales quote | CHAR | 10 | 0 | KONA | KNUMA_SQ | |
| KNUMA_SD | Standard agreement | CHAR | 10 | 0 | KONA | KNUMA_SD | |
| AKTNR | Promotion | CHAR | 10 | 0 | WAKTION | ||
| KNUMA_BO | Agreement (subsequent settlement) | CHAR | 10 | 0 | KONA | KNUMA_BO | |
| LICNO | Tax exemption license number | CHAR | 24 | 0 | LICNO | ||
| LICDT | Date license granted | DATS | 8 | 0 | LICDT | ||
| TKONN | Trading Contract | CHAR | 10 | 0 | WBHK | TKONN | |
| CCNUM | Condition Contract | CHAR | 10 | 0 | WCOCOH | WCB_COCO_NUM | |
| EXTERNAL_GUID | External Guid | CHAR | 32 | 0 | EXT_COND_GUID | ||
| REFERENCE | Reference | NUMC | 18 | 0 | COND_REFERENCE | ||
| PRICEAPPROVALREQUEST | Approval Request for Price Conditions | CHAR | 10 | 0 | PRICEAPPROVALREQUEST |
KONH foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 KONH | CCNUM | WCOCOH | Condition Contract: Header | CLIENT |
| 0 KONH | CCNUM | WCOCOH | Condition Contract: Header | NUM |
| 1 KONH | KAPPL | T681A | Conditions: Applications | KAPPL |
| 0 KONH | KNUMA_AG | KONA | Agreements | MANDT |
| 0 KONH | KNUMA_AG | KONA | Agreements | KNUMA |
| 1 KONH | KNUMA_BO | KONA | Agreements | MANDT |
| 1 KONH | KNUMA_BO | KONA | Agreements | KNUMA |
| 0 KONH | KNUMA_PI | KONA | Agreements | MANDT |
| 0 KONH | KNUMA_PI | KONA | Agreements | KNUMA |
| 1 KONH | KNUMA_SD | KONA | Agreements | MANDT |
| 1 KONH | KNUMA_SD | KONA | Agreements | KNUMA |
| 0 KONH | KNUMA_SQ | KONA | Agreements | MANDT |
| 0 KONH | KNUMA_SQ | KONA | Agreements | KNUMA |
| 1 KONH | KOTABNR | T681 | Conditions: Structures | KOTABNR |
| 0 KONH | KSCHL | T685 | Conditions: Types | KAPPL |
| 0 KONH | KSCHL | T685 | Conditions: Types | KSCHL |
| 1 KONH | KVEWE | T681V | Conditions: Usages | KVEWE |
| 0 KONH | KZUST | T686C | Contact Person: Responsibilities in Sales and Distribution | MANDT |
| 1 KONH | MANDT | T000 | Clients | MANDT |
| 0 KONH | TKONN | WBHK | Trading Contract: Header Data | MANDT |
| 0 KONH | TKONN | WBHK | Trading Contract: Header Data | TKONN |