back to top

SAP TVTA Table – Organizational Unit: Sales Area(s)

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)