back to top

SAP TVKO Table – Organizational Unit: Sales Organizations

TVKO table in SAP ERP or S/4HANA stores Organizational Unit: Sales Organizations data. There are total 27 fields in TVKO table. The Organizational Unit: Sales Organizations table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of TVKO table. It is in Customizing R/3 RV central functions (VZ0CCORE) ABAP package and is part of the Account Determination (SD-BF-ACT) module.

SAP TVKO Table Fields

Following is the list of fields that are available in SAP TVKO table. The primary key fields of Organizational Unit: Sales Organizations table in SAP are MANDT (Client), VKORG (Sales Organization).

Field Description Data Element Check Table Data Type
MANDT Client MANDT CLNT(3)
VKORG Sales Organization VKORG CHAR(4)
WAERS Statistics currency WAERS_V TCURC CUKY(5)
BUKRS Company code of the sales organization VKBUK T001 CHAR(4)
ADRNR Address ADRNR * CHAR(10)
TXNAM_ADR Text name for form text module short address TXNAM_ADR CHAR(16)
TXNAM_KOP Text name for form text module letter header TXNAM_KOP CHAR(16)
TXNAM_FUS Text name for formula text module footer lines TXNAM_FUS CHAR(16)
TXNAM_GRU Text name for form text module: Greeting TXNAM_GRU CHAR(16)
VKOAU Reference sales org.for sales doc.types (by sales area) VKOAU TVKO CHAR(4)
KUNNR Customer number for intercompany billing KUNIV KNA1 CHAR(10)
BOAVO Rebate processing active in the sales organization BOAVO CHAR(1)
VKOKL Sales organization calendar VKOKL TFACD CHAR(2)
EKORG Purchasing organization EKORG T024E CHAR(4)
EKGRP Purchasing Group EKGRP T024 CHAR(3)
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR(10)
WERKS Plant WERKS_D T001W CHAR(4)
BSART Order Type (Purchasing) BSART T161 CHAR(4)
BSTYP Purchasing Document Category BSTYP CHAR(1)
BWART Movement Type (Inventory Management) BWARTWE T156 CHAR(3)
LGORT Storage location LGORT_D T001L CHAR(4)
TXNAM_SDB Text names for layout-set module SDS sender TXNAM_SDB CHAR(16)
MWSKZ Tax code for SD documents J_1AMWSKZ T007A CHAR(2)
XSTCEG Rule that determines the VAT registration number (VAT ID) XSTCEG CHAR(1)
J_1ANUTIME Time of numbering for deliveries J_1ANUTIME CHAR(1)
MAXBI Maximum Number of Items in Billing Document MAXBI NUMC(3)
HIDE Customization of SD Input Help Entries SD_OBSOLETE CHAR(1)