Monday, March 4, 2024

TVKO: Organizational Unit: Sales Organizations

TVKO is a standard SAP HANA table in SAP ERP (or) S/4HANA system which stores Organizational Unit: Sales Organizations data. There are total 27 fields in the table. The TVKO table can be found in the Customizing R/3 RV central functions (VZ0CCORE) package and is part of the Account Determination (SD-BF-ACT) module.

SAP HANA Table Type Column Store
Buffering Permission Buffering switched on
Buffering Type Full buffering as specified by generic key

TVKO Table Fields

The following is the list of fields that are available in SAP TVKO table. The key fields of the table are highlighted in color.

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

Availability

The SAP HANA table TVKO is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Released
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for TVKO table

We’re updating the content all the time, so check back regularly.