SAP table reference
TVKOS
Organizational Unit: Divisions per Sales OrganizationExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table TVKOS.
SAP table TVKOS has 3 primary key fields: MANDT,VKORG,SPART.
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
TVKOS 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 SPART | 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 relationships.
| 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 |