1. Home
  2. Resources
  3. SAP Tables
  4. TVTA - Organizational Unit: Sales Area(s)

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
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
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 REVFP CHAR 1 0
NULL Dialog box in the case of shortages (batch/BAPI full dlv.)
A One-time delivery
B Full delivery
C Delivery proposal
D Dialog box in the case of shrtages (batch/BAPI one-time dlv)
E Dialog box in the case of shortages (batch/BAPI dlv. prpsl)
1 Delivery proposal for product selection
FIXMG Delivery date and quantity fixed FIXMG CHAR 1 0
X Yes
NULL No
AFIND Promo determination AFIND CHAR 1 0
X Yes
NULL No
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
NULL 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 OID_CHECKC CHAR 1 0
NULL No message
W Warning
E Error
I Information

TVTA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TVTA GSBER TVTA GSBER TGSB Business Areas GSBER
TVTA GSBER TVTA MANDT TGSB Business Areas MANDT
TVTA ISM_BP_VTB_GROUP SYST MANDT TJH_GR_SALESAREA IS-M: Sales Area Group MANDT
TVTA ISM_BP_VTB_GROUP TVTA ISM_BP_VTB_GROUP TJH_GR_SALESAREA IS-M: Sales Area Group GR_SA
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 TVKO BUKRS J_1BBRANCH Business Place BUKRS
TVTA J_1AESNR TVTA J_1AESNR J_1BBRANCH Business Place BRANCH
TVTA J_1AESNR TVTA MANDT J_1BBRANCH Business Place MANDT
TVTA J_1ASNR TVTA MANDT J_1BBRANCH Business Place MANDT
TVTA J_1ASNR TVKO BUKRS J_1BBRANCH Business Place BUKRS
TVTA J_1ASNR TVTA J_1ASNR J_1BBRANCH Business Place BRANCH
TVTA KKBER TVTA MANDT T014 Credit control areas MANDT
TVTA KKBER TVTA KKBER T014 Credit control areas KKBER
TVTA MABER TVTA MANDT T047M Dunning areas MANDT
TVTA MABER TVKO BUKRS T047M Dunning areas BUKRS
TVTA MABER TVTA MABER T047M Dunning areas MABER
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 MANDT TSPA Organizational Unit: Sales Divisions MANDT
TVTA SPAKU TVTA SPAKU TSPA Organizational Unit: Sales Divisions SPART
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 VKOAU TVKO Organizational Unit: Sales Organizations VKORG
TVTA VKOAU TVTA MANDT TVKO Organizational Unit: Sales Organizations MANDT
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 MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
TVTA VTWEG TVTA VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
TVTA VTWEG TVTA VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
TVTA VTWKO TVTA MANDT TVTW Organizational Unit: Distribution Channels MANDT
TVTA VTWKO TVTA VTWKO TVTW Organizational Unit: Distribution Channels VTWEG
TVTA VTWKU TVTA MANDT TVTW Organizational Unit: Distribution Channels MANDT
TVTA VTWKU TVTA VTWKU TVTW Organizational Unit: Distribution Channels VTWEG