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 | Possible values | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
J_1ANUTIME
Time of numbering for deliveries
|
J_1ANUTIME |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
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 |