SAP Table TVTA
Organizational Unit: Sales Area(s)
TVTA (Organizational Unit: Sales Area(s)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TVTA to other SAP tables.
TVTA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||||||||
|
VKORG
Sales Organization
|
VKORG | TVKO |
CHAR
|
4 | 0 | |||||||||||||||||
|
VTWEG
Distribution Channel
|
VTWEG | TVKOV |
CHAR
|
2 | 0 | |||||||||||||||||
|
SPART
Division
|
SPART | TVKOS |
CHAR
|
2 | 0 | |||||||||||||||||
|
VTWKU
Reference distrib.channel for cust.and material masters
|
VTWKU | TVTW |
CHAR
|
2 | 0 | |||||||||||||||||
|
SPAKU
Reference division for customers
|
SPAKU | TSPA |
CHAR
|
2 | 0 | |||||||||||||||||
|
VTWKO
Reference distribution channel for conditions
|
VTWKO | TVTW |
CHAR
|
2 | 0 | |||||||||||||||||
|
SPAKO
Reference division for conditions
|
SPAKO | TSPA |
CHAR
|
2 | 0 | |||||||||||||||||
|
MABER
Dunning Area
|
MABER | T047M |
CHAR
|
2 | 0 | |||||||||||||||||
|
VKOAU
Reference sales org.for sales doc.types (by sales area)
|
VKOAU | TVKO |
CHAR
|
4 | 0 | |||||||||||||||||
|
VTWAU
Distribution channel for sales doc types
|
VTWAU | TVTW |
CHAR
|
2 | 0 | |||||||||||||||||
|
SPAAU
Reference division for document types (by sales area)
|
SPAAU | TSPA |
CHAR
|
2 | 0 | |||||||||||||||||
|
GSBER
Business Area
|
GSBER | TGSB |
CHAR
|
4 | 0 | |||||||||||||||||
|
REGGB
Rule for determining the business area
|
REGGB |
NUMC
|
3 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
REVFP
Rule for transferring the results of the availability check
|
REVFP |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
FIXMG
Delivery date and quantity fixed
|
FIXMG |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
AFIND
Promo determination
|
AFIND |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
KKBER
Credit control area
|
KKBER | T014 |
CHAR
|
4 | 0 | |||||||||||||||||
|
J_1ASNR
Branch for domestic operations
|
J_1ADBRNCH | J_1BBRANCH |
CHAR
|
4 | 0 | |||||||||||||||||
|
J_1AESNR
Branch for export operations
|
J_1AEBRNCH | J_1BBRANCH |
CHAR
|
4 | 0 | |||||||||||||||||
|
ISP_VB
IS-M: Distribution Zone
|
VERBBEZ | JVTBEZIRK |
CHAR
|
10 | 0 | |||||||||||||||||
|
ISM_BP_VTB_GROUP
IS-M: Sales Area Group for Business Partner Selection
|
GROUP_SALESAREA | TJH_GR_SALESAREA |
CHAR
|
4 | 0 | |||||||||||||||||
|
J_3GKBAUL
ETM-Relevant Indicator
|
J_3GKBAUL |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
OID_CHECKC
Check customer ship-to/sold-to warning/error/information
|
OID_CHECKC |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
TVTA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TVTA | GSBER | TVTA | MANDT |
TGSB
Business Areas
|
MANDT |
| TVTA | GSBER | TVTA | GSBER |
TGSB
Business Areas
|
GSBER |
| TVTA | ISM_BP_VTB_GROUP | TVTA | ISM_BP_VTB_GROUP |
TJH_GR_SALESAREA
IS-M: Sales Area Group
|
GR_SA |
| TVTA | ISM_BP_VTB_GROUP | SYST | MANDT |
TJH_GR_SALESAREA
IS-M: Sales Area Group
|
MANDT |
| TVTA | ISP_VB | SYST | MANDT |
JVTBEZIRK
IS-M: Carrier Route (Generalization)
|
MANDT |
| TVTA | ISP_VB | TVTA | ISP_VB |
JVTBEZIRK
IS-M: Carrier Route (Generalization)
|
BEZIRK |
| TVTA | J_1AESNR | TVTA | MANDT |
J_1BBRANCH
Business Place
|
MANDT |
| TVTA | J_1AESNR | TVKO | BUKRS |
J_1BBRANCH
Business Place
|
BUKRS |
| TVTA | J_1AESNR | TVTA | J_1AESNR |
J_1BBRANCH
Business Place
|
BRANCH |
| TVTA | J_1ASNR | TVKO | BUKRS |
J_1BBRANCH
Business Place
|
BUKRS |
| TVTA | J_1ASNR | TVTA | J_1ASNR |
J_1BBRANCH
Business Place
|
BRANCH |
| TVTA | J_1ASNR | TVTA | MANDT |
J_1BBRANCH
Business Place
|
MANDT |
| TVTA | KKBER | TVTA | MANDT |
T014
Credit control areas
|
MANDT |
| TVTA | KKBER | TVTA | KKBER |
T014
Credit control areas
|
KKBER |
| TVTA | MABER | TVKO | BUKRS |
T047M
Dunning areas
|
BUKRS |
| TVTA | MABER | TVTA | MABER |
T047M
Dunning areas
|
MABER |
| TVTA | MABER | TVTA | MANDT |
T047M
Dunning areas
|
MANDT |
| TVTA | SPAAU | TVTA | MANDT |
TSPA
Organizational Unit: Sales Divisions
|
MANDT |
| TVTA | SPAAU | TVTA | SPAAU |
TSPA
Organizational Unit: Sales Divisions
|
SPART |
| TVTA | SPAKO | TVTA | MANDT |
TSPA
Organizational Unit: Sales Divisions
|
MANDT |
| TVTA | SPAKO | TVTA | SPAKO |
TSPA
Organizational Unit: Sales Divisions
|
SPART |
| TVTA | SPAKU | TVTA | SPAKU |
TSPA
Organizational Unit: Sales Divisions
|
SPART |
| TVTA | SPAKU | TVTA | MANDT |
TSPA
Organizational Unit: Sales Divisions
|
MANDT |
| TVTA | SPART | TVTA | MANDT |
TVKOS
Organizational Unit: Divisions per Sales Organization
|
MANDT |
| TVTA | SPART | TVTA | VKORG |
TVKOS
Organizational Unit: Divisions per Sales Organization
|
VKORG |
| TVTA | SPART | TVTA | SPART |
TVKOS
Organizational Unit: Divisions per Sales Organization
|
SPART |
| TVTA | VKOAU | TVTA | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| TVTA | VKOAU | TVTA | VKOAU |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| TVTA | VKORG | TVTA | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| TVTA | VKORG | TVTA | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| TVTA | VTWAU | TVTA | MANDT |
TVTW
Organizational Unit: Distribution Channels
|
MANDT |
| TVTA | VTWAU | TVTA | VTWAU |
TVTW
Organizational Unit: Distribution Channels
|
VTWEG |
| TVTA | VTWEG | TVTA | VTWEG |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
VTWEG |
| TVTA | VTWEG | TVTA | MANDT |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
MANDT |
| TVTA | VTWEG | TVTA | VKORG |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
VKORG |
| TVTA | VTWKO | TVTA | MANDT |
TVTW
Organizational Unit: Distribution Channels
|
MANDT |
| TVTA | VTWKO | TVTA | VTWKO |
TVTW
Organizational Unit: Distribution Channels
|
VTWEG |
| TVTA | VTWKU | TVTA | VTWKU |
TVTW
Organizational Unit: Distribution Channels
|
VTWEG |
| TVTA | VTWKU | TVTA | MANDT |
TVTW
Organizational Unit: Distribution Channels
|
MANDT |