The TVTA table in SAP ERP or S/4HANA stores Organizational Unit: Sales Area(s) data. There are total 23 fields in TVTA table. The Organizational Unit: Sales Area(s) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database.Additionally we provide an overview of the structure and fields of TVTA table. It is in General Services SD Application Development (VZCORE) ABAP package and is part of the Account Determination (SD-BF-ACT) module.
SAP TVTA Table Fields
Following is the list of fields that are available in SAP TVTA table. The primary key fields of the table are MANDT (Client), VKORG (Sales Organization), VTWEG (Distribution Channel), SPART (Division).
Field | Description | Data Element | Check Table | Data Type |
---|---|---|---|---|
MANDT | Client | MANDT | CLNT (3) | |
VKORG | Sales Organization | VKORG | TVKO | CHAR (4) |
VTWEG | Distribution Channel | VTWEG | TVKOV | CHAR (2) |
SPART | Division | SPART | TVKOS | CHAR (2) |
VTWKU | Reference distrib.channel for cust.and material masters | VTWKU | TVTW | CHAR (2) |
SPAKU | Reference division for customers | SPAKU | TSPA | CHAR (2) |
VTWKO | Reference distribution channel for conditions | VTWKO | TVTW | CHAR (2) |
SPAKO | Reference division for conditions | SPAKO | TSPA | CHAR (2) |
MABER | Dunning Area | MABER | T047M | CHAR (2) |
VKOAU | Reference sales org.for sales doc.types (by sales area) | VKOAU | TVKO | CHAR (4) |
VTWAU | Distribution channel for sales doc types | VTWAU | TVTW | CHAR (2) |
SPAAU | Reference division for document types (by sales area) | SPAAU | TSPA | CHAR (2) |
GSBER | Business Area | GSBER | TGSB | CHAR (4) |
REGGB | Rule for determining the business area | REGGB | NUMC (3) | |
REVFP | Rule for transferring the results of the availability check | REVFP | CHAR (1) | |
FIXMG | Delivery Date and Quantity Fixed | FIXMG | CHAR (1) | |
AFIND | Promo determination | AFIND | CHAR (1) | |
KKBER | Credit control area | KKBER | T014 | CHAR (4) |
J_1ASNR | Branch for domestic operations | J_1ADBRNCH | J_1BBRANCH | CHAR (4) |
J_1AESNR | Branch for export operations | J_1AEBRNCH | J_1BBRANCH | CHAR (4) |
HIDE | Customization of SD Input Help Entries | SD_OBSOLETE | CHAR (1) | |
J_3GKBAUL | ETM-Relevant Indicator | J_3GKBAUL | CHAR (1) | |
OID_CHECKC | Check customer ship-to/sold-to warning/error/information | OID_CHECKC | CHAR (1) |