SAP Table TVKO

Organizational Unit: Sales Organizations

TVKO (Organizational Unit: Sales Organizations) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TVKO to other SAP tables.

TVKO table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
VKORG Sales Organization VKORG CHAR 4 0
WAERS Statistics currency WAERS_V TCURC CUKY 5 0
BUKRS Company code of the sales organization VKBUK T001 CHAR 4 0
ADRNR Address ADRNR CHAR 10 0
TXNAM_ADR Text name for form text module short address TXNAM_ADR CHAR 16 0
TXNAM_KOP Text name for form text module letter header TXNAM_KOP CHAR 16 0
TXNAM_FUS Text name for formula text module footer lines TXNAM_FUS CHAR 16 0
TXNAM_GRU Text name for form text module: Greeting TXNAM_GRU CHAR 16 0
VKOAU Reference sales org.for sales doc.types (by sales area) VKOAU TVKO CHAR 4 0
KUNNR Customer number for intercompany billing KUNIV KNA1 CHAR 10 0
BOAVO Rebate processing active in the sales organization BOAVO CHAR 1 0
X Yes
NULL No
VKOKL Sales organization calendar VKOKL TFACD CHAR 2 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
EKGRP Purchasing Group EKGRP T024 CHAR 3 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
WERKS Plant WERKS_D T001W CHAR 4 0
BSART Order Type (Purchasing) BSART T161 CHAR 4 0
BSTYP Purchasing Document Category BSTYP CHAR 1 0
A Request for quotation
B Purchase requisition
F Purchase order
I Info record
K Contract
L Scheduling agreement
Q Service entry sheet
W Source list
BWART Movement Type (Inventory Management) BWARTWE T156 CHAR 3 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
TXNAM_SDB Text names for layout-set module SDS sender TXNAM_SDB CHAR 16 0
MWSKZ Tax code for SD documents J_1AMWSKZ T007A CHAR 2 0
XSTCEG Determining the VAT registration number XSTCEG CHAR 1 0
NULL according to priority rule
A generally from sold-to party
B generally from payer
C according to priority rule, dest. country from ship-to party
J_1ANUTIME Time of numbering for deliveries J_1ANUTIME CHAR 1 0
1 Creation of delivery document
3 Goods issue done
MAXBI Maximum Number of Items in Billing Document MAXBI NUMC 3 0
PLAUFZ Price protection period /SAPHT/SW_PLAUFZ NUMC 3 0
PLAUEZ Unit for price protection /SAPHT/SW_PLAUEZ CHAR 1 0
1 Day
2 Week
3 Month
4 Year

TVKO foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TVKO BSART TVKO BSART T161 Purchasing Document Types BSART
TVKO BSART TVKO MANDT T161 Purchasing Document Types MANDT
TVKO BSART TVKO BSTYP T161 Purchasing Document Types BSTYP
TVKO BUKRS TVKO MANDT T001 Company Codes MANDT
TVKO BUKRS TVKO BUKRS T001 Company Codes BUKRS
TVKO BWART TVKO MANDT T156 Movement Type MANDT
TVKO BWART TVKO BWART T156 Movement Type BWART
TVKO EKGRP TVKO MANDT T024 Purchasing Groups MANDT
TVKO EKGRP TVKO EKGRP T024 Purchasing Groups EKGRP
TVKO EKORG TVKO MANDT T024E Purchasing Organizations MANDT
TVKO EKORG TVKO EKORG T024E Purchasing Organizations EKORG
TVKO KUNNR TVKO MANDT KNA1 General Data in Customer Master MANDT
TVKO KUNNR TVKO KUNNR KNA1 General Data in Customer Master KUNNR
TVKO LGORT TVKO MANDT T001L Storage Locations MANDT
TVKO LGORT TVKO WERKS T001L Storage Locations WERKS
TVKO LGORT TVKO LGORT T001L Storage Locations LGORT
TVKO LIFNR TVKO MANDT LFA1 Vendor Master (General Section) MANDT
TVKO LIFNR TVKO LIFNR LFA1 Vendor Master (General Section) LIFNR
TVKO MWSKZ TVKO MANDT T007A Tax Keys MANDT
TVKO MWSKZ * T007A Tax Keys KALSM
TVKO MWSKZ TVKO MWSKZ T007A Tax Keys MWSKZ
TVKO VKOAU TVKO VKOAU TVKO Organizational Unit: Sales Organizations VKORG
TVKO VKOAU TVKO MANDT TVKO Organizational Unit: Sales Organizations MANDT
TVKO VKOKL TVKO VKOKL TFACD Factory calendar definition IDENT
TVKO WAERS TVKO MANDT TCURC Currency Codes MANDT
TVKO WAERS TVKO WAERS TCURC Currency Codes WAERS
TVKO WERKS TVKO MANDT T001W Plants/Branches MANDT
TVKO WERKS TVKO WERKS T001W Plants/Branches WERKS