SAP table reference
TVTA
Organizational Unit: Sales Area(s)Explore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table TVTA.
SAP table TVTA has 4 primary key fields: MANDT,VKORG,VTWEG,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
TVTA fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | 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 | |||||||||||||||||
| VTWKU | Reference distrib.channel for cust.and material masters | CHAR | 2 | 0 | TVTW | VTWKU | |||||||||||||||||
| SPAKU | Reference division for customers | CHAR | 2 | 0 | TSPA | SPAKU | |||||||||||||||||
| VTWKO | Reference distribution channel for conditions | CHAR | 2 | 0 | TVTW | VTWKO | |||||||||||||||||
| SPAKO | Reference division for conditions | CHAR | 2 | 0 | TSPA | SPAKO | |||||||||||||||||
| MABER | Dunning Area | CHAR | 2 | 0 | T047M | MABER | |||||||||||||||||
| VKOAU | Reference sales org.for sales doc.types (by sales area) | CHAR | 4 | 0 | TVKO | VKOAU | |||||||||||||||||
| VTWAU | Distribution channel for sales doc types | CHAR | 2 | 0 | TVTW | VTWAU | |||||||||||||||||
| SPAAU | Reference division for document types (by sales area) | CHAR | 2 | 0 | TSPA | SPAAU | |||||||||||||||||
| GSBER | Business Area | CHAR | 4 | 0 | TGSB | GSBER | |||||||||||||||||
| REGGB | Rule for determining the business area | NUMC | 3 | 0 | REGGB | ||||||||||||||||||
| |||||||||||||||||||||||
| REVFP | Rule for transferring the results of the availability check | CHAR | 1 | 0 | REVFP | ||||||||||||||||||
| |||||||||||||||||||||||
| FIXMG | Delivery Date and Quantity Fixed | CHAR | 1 | 0 | FIXMG | ||||||||||||||||||
| AFIND | Promo determination | CHAR | 1 | 0 | AFIND | ||||||||||||||||||
| KKBER | Credit control area | CHAR | 4 | 0 | T014 | KKBER | |||||||||||||||||
| J_1ASNR | Branch for domestic operations | CHAR | 4 | 0 | J_1BBRANCH | J_1ADBRNCH | |||||||||||||||||
| J_1AESNR | Branch for export operations | CHAR | 4 | 0 | J_1BBRANCH | J_1AEBRNCH | |||||||||||||||||
| HIDE | Customization of SD Input Help Entries | CHAR | 1 | 0 | SD_OBSOLETE | ||||||||||||||||||
| J_3GKBAUL | ETM-Relevant Indicator | CHAR | 1 | 0 | J_3GKBAUL | ||||||||||||||||||
| |||||||||||||||||||||||
| OID_CHECKC | Check customer ship-to/sold-to warning/error/information | CHAR | 1 | 0 | OID_CHECKC | ||||||||||||||||||
/ Relationships
TVTA relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| TVTA | GSBER | TGSB | Business Areas | MANDT |
| TVTA | GSBER | TGSB | Business Areas | GSBER |
| TVTA | J_1AESNR | J_1BBRANCH | Business Place | BUKRS |
| TVTA | J_1AESNR | J_1BBRANCH | Business Place | BRANCH |
| TVTA | J_1AESNR | J_1BBRANCH | Business Place | BUPLA_TYPE |
| TVTA | J_1ASNR | J_1BBRANCH | Business Place | BUKRS |
| TVTA | J_1ASNR | J_1BBRANCH | Business Place | BRANCH |
| TVTA | J_1ASNR | J_1BBRANCH | Business Place | BUPLA_TYPE |
| TVTA | KKBER | T014 | Credit control areas | KKBER |
| TVTA | MABER | T047M | Dunning areas | MANDT |
| TVTA | MABER | T047M | Dunning areas | BUKRS |
| TVTA | SPAAU | TSPA | Organizational Unit: Sales Divisions | MANDT |
| TVTA | SPAAU | TSPA | Organizational Unit: Sales Divisions | SPART |
| TVTA | SPAKO | TSPA | Organizational Unit: Sales Divisions | MANDT |
| TVTA | SPAKO | TSPA | Organizational Unit: Sales Divisions | SPART |
| TVTA | SPAKU | TSPA | Organizational Unit: Sales Divisions | MANDT |
| TVTA | SPAKU | TSPA | Organizational Unit: Sales Divisions | SPART |
| TVTA | SPART | TVKOS | Organizational Unit: Divisions per Sales Organization | MANDT |
| TVTA | SPART | TVKOS | Organizational Unit: Divisions per Sales Organization | VKORG |
| TVTA | SPART | TVKOS | Organizational Unit: Divisions per Sales Organization | SPART |
| TVTA | VKOAU | TVKO | Organizational Unit: Sales Organizations | MANDT |
| TVTA | VKOAU | TVKO | Organizational Unit: Sales Organizations | VKORG |
| TVTA | VKORG | TVKO | Organizational Unit: Sales Organizations | MANDT |
| TVTA | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| TVTA | VTWAU | TVTW | Organizational Unit: Distribution Channels | MANDT |
| TVTA | VTWAU | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| TVTA | VTWEG | TVKOV | Org. Unit: Distribution Channels per Sales Organization | MANDT |
| TVTA | VTWEG | TVKOV | Org. Unit: Distribution Channels per Sales Organization | VKORG |
| TVTA | VTWEG | TVKOV | Org. Unit: Distribution Channels per Sales Organization | VTWEG |
| TVTA | VTWKO | TVTW | Organizational Unit: Distribution Channels | MANDT |
| TVTA | VTWKO | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| TVTA | VTWKU | TVTW | Organizational Unit: Distribution Channels | MANDT |
| TVTA | VTWKU | TVTW | Organizational Unit: Distribution Channels | VTWEG |