SAP table reference
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational UnitExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table TVKBZ.
SAP table TVKBZ has 5 primary key fields: MANDT,VKORG,VTWEG,SPART,VKBUR.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
TVKBZ fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key VKORG | Sales Organization | CHAR | 4 | 0 | TVKO | VKORG | |
| Key VTWEG | Distribution Channel | CHAR | 2 | 0 | TVKOV | VTWEG | |
| Key SPART | Division | CHAR | 2 | 0 | TVKOS | SPART | |
| Key VKBUR | Sales office | CHAR | 4 | 0 | TVBUR | VKBUR | |
| HIDE | Customization of SD Input Help Entries | CHAR | 1 | 0 | SD_OBSOLETE |
/ Relationships
TVKBZ relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| TVKBZ | SPART | TVKOS | Organizational Unit: Divisions per Sales Organization | MANDT |
| TVKBZ | SPART | TVKOS | Organizational Unit: Divisions per Sales Organization | VKORG |
| TVKBZ | SPART | TVKOS | Organizational Unit: Divisions per Sales Organization | SPART |
| TVKBZ | VKBUR | TVBUR | Organizational Unit: Sales Offices | MANDT |
| TVKBZ | VKORG | TVKO | Organizational Unit: Sales Organizations | MANDT |
| TVKBZ | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| TVKBZ | VTWEG | TVKOV | Org. Unit: Distribution Channels per Sales Organization | MANDT |
| TVKBZ | VTWEG | TVKOV | Org. Unit: Distribution Channels per Sales Organization | VKORG |
| TVKBZ | VTWEG | TVKOV | Org. Unit: Distribution Channels per Sales Organization | VTWEG |