SAP Table
TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit
SAP table TVKBZ has 5 primary key fields being MANDT,VKORG,VTWEG,SPART,VKBUR.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TVKBZ columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyVKORG | Sales Organization | CHAR | 4 | 0 | TVKO | VKORG | |
| KeyVTWEG | Distribution Channel | CHAR | 2 | 0 | TVKOV | VTWEG | |
| KeySPART | Division | CHAR | 2 | 0 | TVKOS | SPART | |
| KeyVKBUR | Sales office | CHAR | 4 | 0 | TVBUR | VKBUR | |
| HIDE | Customization of SD Input Help Entries | CHAR | 1 | 0 | SD_OBSOLETE |
/ Relationships
TVKBZ foreign keys.
| 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 |