SAP Table THIOZ
Customer Hierarchies: Allowed Organizational Assignments
THIOZ (Customer Hierarchies: Allowed Organizational Assignments) 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 THIOZ to other SAP tables.
THIOZ table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| HITYP | Customer hierarchy type | HITYP_KH | THIT | CHAR | 1 | 0 | ||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||
| HVKORG | Higher-level sales organization | HVKORG | TVKO | CHAR | 4 | 0 | ||
| HVTWEG | Higher-level distribution channel | HVTWEG | TVTW | CHAR | 2 | 0 | ||
| HSPART | Higher-level division | HSPART | TSPA | CHAR | 2 | 0 | ||
THIOZ foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| THIOZ | HITYP | THIOZ | MANDT | THIT | Customer Hierarchy Types | MANDT |
| THIOZ | HITYP | THIOZ | HITYP | THIT | Customer Hierarchy Types | HITYP |
| THIOZ | HSPART | THIOZ | HSPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| THIOZ | HSPART | THIOZ | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| THIOZ | HVKORG | THIOZ | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| THIOZ | HVKORG | THIOZ | HVKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| THIOZ | HVTWEG | THIOZ | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| THIOZ | HVTWEG | THIOZ | HVTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| THIOZ | MANDT | THIOZ | MANDT | T000 | Clients | MANDT |
| THIOZ | SPART | THIOZ | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| THIOZ | SPART | THIOZ | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| THIOZ | VKORG | THIOZ | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| THIOZ | VKORG | THIOZ | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| THIOZ | VTWEG | THIOZ | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| THIOZ | VTWEG | THIOZ | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
