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