TVTA is a standard Account Determination Transparent Table in SAP SD application, which stores Organizational Unit: Sales Area(s) data. On this page, you can view the Table Structure, Columns(Fields), links to SAP Documentation, Wiki & Help Pages, Q&A, similar/related TCodes, Tables, FMs, ABAP Reports, BW Datasources, and Authorization Objects for TVTA. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

TVTA — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Data Element Primary Key Data Type Length Check Table
    1 MANDT Client MANDT X CLNT 3
    2 VKORG Sales Org. VKORG X CHAR 4 TVKO
    3 VTWEG Distr. Channel VTWEG X CHAR 2 TVKOV
    4 SPART Division SPART X CHAR 2 TVKOS
    5 .INCLUDE 0
    6 VTWKU Reference distrib.channel for cust.and material masters VTWKU CHAR 2 TVTW
    7 SPAKU Reference division for customers SPAKU CHAR 2 TSPA
    8 VTWKO Reference distribution channel for conditions VTWKO CHAR 2 TVTW
    9 SPAKO Reference division for conditions SPAKO CHAR 2 TSPA
    10 MABER Dunning Area MABER CHAR 2 T047M
    11 VKOAU Reference sales org.for sales doc.types (by sales area) VKOAU CHAR 4 TVKO
    12 VTWAU Distribution channel for sales doc types VTWAU CHAR 2 TVTW
    13 SPAAU Reference division for document types (by sales area) SPAAU CHAR 2 TSPA
    14 GSBER Business Area GSBER CHAR 4 TGSB
    15 REGGB Rule for determining the business area REGGB NUMC 3
    16 REVFP Rule for transferring the results of the availability check REVFP CHAR 1
    17 FIXMG Delivery date and quantity fixed FIXMG CHAR 1
    18 AFIND Code for disabled from the Armed Forces AFIND CHAR 1
    19 KKBER Cred.contr.area KKBER CHAR 4 T014
    20 J_1ASNR Branch number J_1ADBRNCH CHAR 4 J_1BBRANCH
    21 J_1AESNR Branch for export operations J_1AEBRNCH CHAR 4 J_1BBRANCH
    22 .INCLU--AP 0
    23 .INCLUDE 0
    24 J_3GKBAUL ETM-Relevant Indicator J_3GKBAUL CHAR 1
    25 .INCLU--AP 0
    26 OID_CHECKC Check customer ship-to/sold-to warning/error/information OID_CHECKC CHAR 1

SAP Help, Wiki, Q&A and other resources for TVTA

Click the above link for the full list of resources and help pages, only the first few are posted below

  • How to check the values of BW related characteristics on ECC side | SAP Blogs

    1.Account Assignment Group    T-code: VKOA 2. Account Group    T-code: XD07 (Change Customer Account Group) 3. Bill-to-Party    T-code: VA03,XD02     Tables: KNVP, VBPA,TPAR 4.Billing document    T-code: VF02 (Change billing document),VF04 (Billnig due list),FBL5N (Display customer invoices by line),                  FBL1N(Display Vendor invoices by line)    Tables: VBRK,VBRP (Billing document Item data) 5.Company Code    Tables: T001 6.Controlling Area    Tables: TKA01 7. Customer Account Group    Tables: T077D 8.Customer    T-code: XD02,XD03,XD07    Tables: KNA1 (Gener...

    https://blogs.sap.com/2012/05/25/how-to-check-the-values-of-bw-related-characteristics-on-ecc-side

  • tables affected by MM01 - SAP Q&A

    *EINA

    *EINE

    *MAEX

    *MAKT

    *MALG

    *MAMT

    *MAPE

    *MARA

    *MARC

    *MARD

    *MARE

    *MARM

    *MAW1

    *MBEW

    *MFHM

    *MGEINE

    *MKAL

    *MLAN

    *MLGN

    *MLGT

    *MPGD

    *MPOP

    *MVER

    *MVKE

    *MWLI

    *MYMS

    *OBEW

    *SMEINH

    *T001

    *T001K

    *T001L

    *T001W

    *T130M

    *T137

    *T137T

    *T149A

    *T300

    *T300T

    *T301

    *T301T

    *TVKO

    *TVKOT

    *TVTW

    *TVTWT

    *USRM1

    ...

    https://answers.sap.com/questions/3049491/tables-affected-by-mm01.html

  • learn sd - SAP Q&A

    P.S. you can send me a mail at my mail id [email protected] for any specific details

    https://answers.sap.com/questions/2782822/free-goods.html

  • Sales area is not defined for customers | SAP Community

    I have done all the defining and assignment of the enterprise structure. I have also set up the sales area. But when I try to create a customer is gives me the messaage " Sales area IN01 12 12 is not defined for customers". It suggests that the entries are missing from the TVTA table but then when I checked the table the S.Org, Dist. Chnl and Div are there. could some one suggest whats happening here?

    https://answers.sap.com/questions/7424702/sales-area-is-not-defined-for-customers.html

  • In table TVTA, the entry SE44 02 is missing - SAP Q&A

    When am trying to create a customer master record with ref to another customer master record am getting the message "In table TVTA, the entry SE44 02 is missing" and cld not able to extend the same customer master reocord to another sales area with different company code.

    https://answers.sap.com/questions/6854642/defult-document-type.html

  • table TVTA - SAP Q&A

    After set up sales area with t-code OVXG, system will update the table TVTA.

    https://answers.sap.com/questions/6394087/table-tvta.html

  • ALL THE TABLES IN PM - SAP Q&A

    I need ALL the tables that are available in PLANT MAINTANENCE (PM) .

    https://answers.sap.com/answers/1243345/view.html

  • IW33 (Maintenance order) - SAP Q&A

    in the maintenance order (IW31), I want to know in which table the operations and components data is saved?

    https://answers.sap.com/answers/1268013/view.html

  • Sample code for BAPI_PRICES_CONDITIONS - SAP Q&A

    This BAPI looks like a work-in-progress. The description is in German, there is no documentation, it is not used anywhere and on top of all, it is not a RFC enabled FM. Are you sure this is the right BAPI?

    https://answers.sap.com/answers/1307583/view.html

  • aim asking what r the table names abap. - SAP Q&A

    this is srinivas, i want complete table names in abap.i mean standard tables of material,purchasing order,customer,vendar table names.

    https://answers.sap.com/answers/2474834/view.html

  • View the full list of resources, SAP Help/Wiki pages and Q&A for TVTA


Related Tables

TABLE Description Functional Area
TVKO Organizational Unit: Sales Organizations SD - Account Determination
VBAK Sales Document: Header Data SD - Sales
KNA1 General Data in Customer Master Logistics - Customer Master
TVKOV Org. Unit: Distribution Channels per Sales Organization SD - Account Determination
VBAP Sales Document: Item Data SD - Sales

Transaction Codes for SAP Table TVTA

TCODE Description Functional Area
VBKD Bonus Buy: Condition Types SD - Free Goods
VOR2 Joint Master Data: Division SD - Material Maintenance
VOR1 Joint Master Data: Distr. Channel SD - Material Maintenance
MCHB RIS: Till Receipt - Selection Logistics - Retail Information System (RIS)
MCHA RIS: Till Receipt/Matl - Selection Logistics - Retail Information System (RIS)
VTSP Ctr. Control: Fld Mod. Ext. Applic. FI - Contract Accounts Receivable and Payable

FMs for SAP Table TVTA

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer
SET_PF_STATUS Setzen Pf-Status Basis - ABAP Editor
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer

ABAP Reports for SAP Table TVTA

ABAP REPORT Description Functional Area
SAPMV45A Sales Order Processing SD - Sales
SAPLATPC ATP Controller / ATP Server
SAPMSSYD Screen Exits Basis - Syntax, Compiler, Runtime
SAPFGUICNTL Routines for Communication Between Kernel and Control Framework Basis - Graphical User Interface
SAPFSYSCALLS System Routines for Communication SAPMSSYD - Services DO NOT MODIFY Basis - Graphical User Interface
SAPLGRFC Queued sapgui RFC

BW Datasources for SAP Table TVTA

BW DATASOURCE Description Functional Area
0MATERIAL_ATTR Material Number Logistics - Logistics - General
0MAT_SALES_TEXT Material number with sales Logistics - Logistics - General
0CUST_SALES_TEXT Customer Number Logistics - Logistics - General
0MATERIAL_TEXT Material Number Logistics - Logistics - General

Authorization Objects for SAP Table TVTA

AUTHORIZATION OBJECT Description Functional Area
S_SPO_DEV Spool: Device authorizations
S_ADMI_FCD System Authorizations
S_BTCH_ADM Background Processing: Background Administrator
S_BDC_MONI Batch Input Authorizations
S_SPO_ACT Spool: Actions
S_EDITOR ABAP: Editor Checks

Most searched SAP Sales and Distribution Tables