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