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) |
