TVKO SAP (Organizational Unit: Sales Organizations) Table details
Dictionary Type: Table
Description: Organizational Unit: Sales Organizations
Description: Organizational Unit: Sales Organizations
Table field list including key, data, relationships and ABAP select examples
TVKO is a standard SAP Table which is used to store Organizational Unit: Sales Organizations data and is available within R/3 SAP systems depending on the version and release level.
The TVKO table consists of various fields, each holding specific information or linking keys about Organizational Unit: Sales Organizations data available in SAP. These include VKORG (Sales Organization), WAERS (Statistics currency), BUKRS (Company code of the sales organization), ADRNR (Address).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = TVKOT
SAP TVKO table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| VKORG | Sales Organization | VKORG | CHAR | 4 | VKORG | VKO | C_VKORG | ||
| WAERS | Statistics currency | WAERS_V | CUKY | 5 | TCURC | WAERS | |||
| BUKRS | Company code of the sales organization | VKBUK | CHAR | 4 | T001 | BUKRS | |||
| ADRNR | Address | ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
| TXNAM_ADR | Text name for form text module short address | TXNAM_ADR | CHAR | 16 | TXNAM16 | ||||
| TXNAM_KOP | Text name for form text module letter header | TXNAM_KOP | CHAR | 16 | TXNAM16 | ||||
| TXNAM_FUS | Text name for formula text module footer lines | TXNAM_FUS | CHAR | 16 | TXNAM16 | ||||
| TXNAM_GRU | Text name for form text module: Greeting | TXNAM_GRU | CHAR | 16 | TXNAM16 | ||||
| VKOAU | Reference sales org.for sales doc.types (by sales area) | VKOAU | CHAR | 4 | TVKO | VKORG | VKO | ||
| KUNNR | Customer number for intercompany billing | KUNIV | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
| BOAVO | Rebate processing active in the sales organization | BOAVO | CHAR | 1 | XFELD | ||||
| VKOKL | Sales organization calendar | VKOKL | CHAR | 2 | TFACD | WFCID | |||
| EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
| EKGRP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| BSART | Order Type (Purchasing) | BSART | CHAR | 4 | T161 | BSART | BSA | ||
| BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
| BWART | Movement Type (Inventory Management) | BWARTWE | CHAR | 3 | T156 | BWART | BWE | ||
| LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
| TXNAM_SDB | Text names for layout-set module SDS sender | TXNAM_SDB | CHAR | 16 | TXNAM16 | ||||
| MWSKZ | Tax code for SD documents | J_1AMWSKZ | CHAR | 2 | T007A | MWSKZ | |||
| XSTCEG | Determining the VAT registration number | XSTCEG | CHAR | 1 | XSTCEG | ||||
| J_1ANUTIME | Time of numbering for deliveries | J_1ANUTIME | CHAR | 1 | J_1ANUTIME | ||||
| MAXBI | Maximum Number of Items in Billing Document | MAXBI | NUMC | 3 | NUM03 | ||||
| .INCLU--AP | 0 | ||||||||
| PLAUFZ | Price protection period | /SAPHT/SW_PLAUFZ | NUMC | 3 | NUM3 | ||||
| PLAUEZ | Unit for price protection | /SAPHT/SW_PLAUEZ | CHAR | 1 | KDZEH |
| Key field | Non-key field |
How do I retrieve data from SAP table TVKO using ABAP code
The following ABAP code Example will allow you to do a basic selection on TVKO to SELECT all data from the tableDATA: WA_TVKO TYPE TVKO.
SELECT SINGLE *
FROM TVKO
INTO CORRESPONDING FIELDS OF WA_TVKO
WHERE...
How to access SAP table TVKO
Within an ECC or HANA version of SAP you can also view further information about TVKO and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects