SAP Table
TVKOS Organizational Unit: Divisions per Sales Organization
SAP table TVKOS has 3 primary key fields being MANDT,VKORG,SPART.
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
TVKOS 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 | |
| KeySPART | Division | CHAR | 2 | 0 | TSPA | SPART | |
| SPAKU | Reference division for customers | CHAR | 2 | 0 | TSPA | SPAKU | |
| SPAKO | Reference division for conditions | CHAR | 2 | 0 | TSPA | SPAKO | |
| SPAAU | Reference division for document types (by sales area) | CHAR | 2 | 0 | TSPA | SPAAU | |
| HIDE | Customization of SD Input Help Entries | CHAR | 1 | 0 | SD_OBSOLETE |
/ Relationships
TVKOS foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TVKOS | SPAAU | TSPA | Organizational Unit: Sales Divisions | MANDT |
| TVKOS | SPAAU | TSPA | Organizational Unit: Sales Divisions | SPART |
| TVKOS | SPAKO | TSPA | Organizational Unit: Sales Divisions | MANDT |
| TVKOS | SPAKO | TSPA | Organizational Unit: Sales Divisions | SPART |
| TVKOS | SPAKU | TSPA | Organizational Unit: Sales Divisions | MANDT |
| TVKOS | SPAKU | TSPA | Organizational Unit: Sales Divisions | SPART |
| TVKOS | SPART | TSPA | Organizational Unit: Sales Divisions | MANDT |
| TVKOS | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| TVKOS | VKORG | TVKO | Organizational Unit: Sales Organizations | MANDT |
| TVKOS | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |