SAP table TVTA (Organizational Unit: Sales Area(s))
SAP table TVTA has 4 primary key fields being MANDT,VKORG,VTWEG,SPART.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
MANDT
VKORG
Sales Organization
CHAR
4
0
TVKO
VKORG
VTWEG
Distribution Channel
CHAR
2
0
TVKOV
VTWEG
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
Possible values
001
Business area determination from plant/division (T134G)
002
Business area determination from sales area (TVTA)
003
Business area det. from sales org/dist. channel item div.
REVFP
Rule for transferring the results of the availability check
CHAR
1
0
REVFP
Possible values
Dialog Box for Shortages (Batch/BAPI Full Delivery)
1
Delivery Proposal for Product Selection
A
One-Time Delivery
B
Full Delivery
C
Delivery Proposal
D
Dialog Box for Shortages (Batch/BAPI One-Time Delivery)
E
Dialog Box (Batch/BAPI Delivery Proposal)
F
Dialog Box (Batch/BAPI Full Delivery) as Item Overrride
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
Possible values
SAP standard
1
Relevant to CEM with CEM posting rules
2
Relevant to CEM with SAP standard posting rules
3
Program-internal: CEM-relevant co. code to co. code (EDI)
OID_CHECKC
Check customer ship-to/sold-to warning/error/information
CHAR
1
0
OID_CHECKC
TVTA foreign key relationships
Table
Field
Check Table
Check Field
0 TVTA
GSBER
TGSB
Business Areas
MANDT
0 TVTA
GSBER
TGSB
Business Areas
GSBER
1 TVTA
J_1AESNR
J_1BBRANCH
Business Place
BUKRS
1 TVTA
J_1AESNR
J_1BBRANCH
Business Place
BRANCH
1 TVTA
J_1AESNR
J_1BBRANCH
Business Place
BUPLA_TYPE
0 TVTA
J_1ASNR
J_1BBRANCH
Business Place
BUKRS
0 TVTA
J_1ASNR
J_1BBRANCH
Business Place
BRANCH
0 TVTA
J_1ASNR
J_1BBRANCH
Business Place
BUPLA_TYPE
1 TVTA
KKBER
T014
Credit control areas
KKBER
0 TVTA
MABER
T047M
Dunning areas
MANDT
0 TVTA
MABER
T047M
Dunning areas
BUKRS
1 TVTA
SPAAU
TSPA
Organizational Unit: Sales Divisions
MANDT
1 TVTA
SPAAU
TSPA
Organizational Unit: Sales Divisions
SPART
0 TVTA
SPAKO
TSPA
Organizational Unit: Sales Divisions
MANDT
0 TVTA
SPAKO
TSPA
Organizational Unit: Sales Divisions
SPART
1 TVTA
SPAKU
TSPA
Organizational Unit: Sales Divisions
MANDT
1 TVTA
SPAKU
TSPA
Organizational Unit: Sales Divisions
SPART
0 TVTA
SPART
TVKOS
Organizational Unit: Divisions per Sales Organization
MANDT
0 TVTA
SPART
TVKOS
Organizational Unit: Divisions per Sales Organization
VKORG
0 TVTA
SPART
TVKOS
Organizational Unit: Divisions per Sales Organization
SPART
1 TVTA
VKOAU
TVKO
Organizational Unit: Sales Organizations
MANDT
1 TVTA
VKOAU
TVKO
Organizational Unit: Sales Organizations
VKORG
0 TVTA
VKORG
TVKO
Organizational Unit: Sales Organizations
MANDT
0 TVTA
VKORG
TVKO
Organizational Unit: Sales Organizations
VKORG
1 TVTA
VTWAU
TVTW
Organizational Unit: Distribution Channels
MANDT
1 TVTA
VTWAU
TVTW
Organizational Unit: Distribution Channels
VTWEG
0 TVTA
VTWEG
TVKOV
Org. Unit: Distribution Channels per Sales Organization
MANDT
0 TVTA
VTWEG
TVKOV
Org. Unit: Distribution Channels per Sales Organization
VKORG
0 TVTA
VTWEG
TVKOV
Org. Unit: Distribution Channels per Sales Organization
VTWEG
1 TVTA
VTWKO
TVTW
Organizational Unit: Distribution Channels
MANDT
1 TVTA
VTWKO
TVTW
Organizational Unit: Distribution Channels
VTWEG
0 TVTA
VTWKU
TVTW
Organizational Unit: Distribution Channels
MANDT
0 TVTA
VTWKU
TVTW
Organizational Unit: Distribution Channels
VTWEG