SAP-tabelreferentie
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational UnitBekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel TVKBZ.
SAP-tabel TVKBZ heeft 5 primaire sleutelvelden: MANDT,VKORG,VTWEG,SPART,VKBUR.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
/ Velden
TVKBZ velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |
|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Sleutel VKORG | Sales Organization | CHAR | 4 | 0 | TVKO | VKORG | |
| Sleutel VTWEG | Distribution Channel | CHAR | 2 | 0 | TVKOV | VTWEG | |
| Sleutel SPART | Division | CHAR | 2 | 0 | TVKOS | SPART | |
| Sleutel VKBUR | Sales office | CHAR | 4 | 0 | TVBUR | VKBUR | |
| HIDE | Customization of SD Input Help Entries | CHAR | 1 | 0 | SD_OBSOLETE |
/ Relaties
TVKBZ relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| 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 |