TVTA SAP table for – Organizational Unit: Sales Area(s)

Here we would like to draw your attention to TVTA table in SAP. As we know it is being mainly used with the SAP SD-BF (Basic Functions in SD) component which is coming under SD module (Sales & Distribution). TVTA is a SAP standard transparent table used for storing Organizational Unit: Sales Area(s) related data in SAP. It comes under the package VZCORE.

SAP TVTA table

Table TVTA technical data

TableTVTA
Data storingOrganizational Unit: Sales Area(s)
ModuleSD
ComponentSD-BF
SAP PackageVZCORE
Delivery ClassC – Customer table, data is only maintained by the customer
Table CategoryTRANSPARENT

SAP TVTA Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in TVTA table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • MABER
    Its data type is C (Character String) with field length 2
  • VKOAU
    Its data type is C (Character String) with field length 4
  • VTWAU
    Its data type is C (Character String) with field length 2
  • SPAAU
    Its data type is C (Character String) with field length 2
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • REGGB
    Its data type is N (Character String with Digits Only) with field length 3
  • REVFP
    Its data type is C (Character String) with field length 1
  • FIXMG
    Its data type is C (Character String) with field length 1
  • AFIND
    Its data type is C (Character String) with field length 1
  • KKBER
    Its data type is C (Character String) with field length 4
  • VKORG : Sales Organization
    Its a key field. Its data type is C (Character String) with field length 4
  • J_1ASNR
    Its data type is C (Character String) with field length 4
  • J_1AESNR
    Its data type is C (Character String) with field length 4
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is JHATVTA
  • ISP_VB
    Its data type is C (Character String) with field length 10
  • ISM_BP_VTB_GROUP
    Its data type is C (Character String) with field length 4
  • J_3GKBAUL
    Its data type is C (Character String) with field length 1
  • OID_CHECKC
    Its data type is C (Character String) with field length 1
  • VTWEG : Distribution Channel
    Its a key field. Its data type is C (Character String) with field length 2
  • SPART : Division
    Its a key field. Its data type is C (Character String) with field length 2
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is SI_TVTA
  • VTWKU
    Its data type is C (Character String) with field length 2
  • SPAKU
    Its data type is C (Character String) with field length 2
  • VTWKO
    Its data type is C (Character String) with field length 2
  • SPAKO
    Its data type is C (Character String) with field length 2