SAP table KONHM (Portfolio Determination - Data Part)
SAP table KONHM 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 | ||||||||||||||||
| EXPOFO | External Portfolio Number | CHAR | 30 | 0 | EXPOFO | ||||||||||||||||
| TEXT | Description | CHAR | 40 | 0 | BEZEI40 | ||||||||||||||||
| 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 | Portfolio Type | CHAR | 4 | 0 | T685 | KSCHM | |||||||||||||||
| DATAB | Valid-From Date | DATS | 8 | 0 | DATAB | ||||||||||||||||
| DATBI | Valid To Date | DATS | 8 | 0 | DATBI | ||||||||||||||||
| PZUSTP | Portfolio: Responsibility for Current Portfolio | CHAR | 4 | 0 | TPOFOA | PZUSTP | |||||||||||||||
| POSRT | Portfolio Search Term | CHAR | 10 | 0 | POSRT | ||||||||||||||||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||||||||||||||||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||||||||||||||||
| ASSOCUNIT | Source of Association Unit | CHAR | 1 | 0 | WB2_ASSOC_UNIT_SOURCE |
|
|||||||||||||||
| ASSOCROUND | Rounding for Association Quantity | CHAR | 1 | 0 | WB2_ASSOC_ROUNDING |
|
|||||||||||||||
| COMMODITY | Commodity Definition | CHAR | 16 | 0 | TCOM | WCOMMODITY | |||||||||||||||
| BOM_PROFILE | Profile for BOM Items | CHAR | 4 | 0 | WB2_C_BOMP | WB2_BOM_PROFILE | |||||||||||||||
| ALT_BOM | Alternative BOM | CHAR | 2 | 0 | STALT |
KONHM foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 KONHM | BOM_PROFILE | WB2_C_BOMP | Profile for BOM Items | MANDT |
| 1 KONHM | COMMODITY | TCOM | Definition of Commodities | MANDT |
| 1 KONHM | COMMODITY | TCOM | Definition of Commodities | COMMODITY |
| 0 KONHM | KAPPL | T681A | Conditions: Applications | KAPPL |
| 1 KONHM | KOTABNR | T681 | Conditions: Structures | KOTABNR |
| 0 KONHM | KSCHL | T685 | Conditions: Types | KAPPL |
| 0 KONHM | KSCHL | T685 | Conditions: Types | KSCHL |
| 1 KONHM | KVEWE | T681V | Conditions: Usages | KVEWE |
| 0 KONHM | MANDT | T000 | Clients | MANDT |
| 1 KONHM | PZUSTP | TPOFOA | Portfolio: Define Responsibility | MANDT |