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
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
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
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