SAP Table TJKWV
IS-M/SD: External Connection - Sales Area Determination
TJKWV (IS-M/SD: External Connection - Sales Area Determination) 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 TJKWV to other SAP tables.
TJKWV table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |
|
DRERZ
Publication
|
DRERZ | JDTDRER |
CHAR
|
8 | 0 | |
|
VKORG
Sales Organization
|
VKORG | TVKO |
CHAR
|
4 | 0 | |
|
VTWEG
Distribution Channel
|
VTWEG | TVKOV |
CHAR
|
2 | 0 | |
|
SPART
Division for order header
|
SPART_AK | TVTA |
CHAR
|
2 | 0 | |
|
VKBUR
Sales Office
|
VKBUR | TVBUR |
CHAR
|
4 | 0 | |
|
VKGRP
Sales Group
|
VKGRP | TVKGR |
CHAR
|
3 | 0 |
TJKWV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TJKWV | DRERZ | TJKWV | MANDT |
JDTDRER
IS-M/SD: Publications
|
MANDT |
| TJKWV | DRERZ | TJKWV | DRERZ |
JDTDRER
IS-M/SD: Publications
|
DRERZ |
| TJKWV | MANDT | TJKWV | MANDT |
T000
Clients
|
MANDT |
| TJKWV | SPART | TJKWV | MANDT |
TVTA
Organizational Unit: Sales Area(s)
|
MANDT |
| TJKWV | SPART | TJKWV | VKORG |
TVTA
Organizational Unit: Sales Area(s)
|
VKORG |
| TJKWV | SPART | TJKWV | VTWEG |
TVTA
Organizational Unit: Sales Area(s)
|
VTWEG |
| TJKWV | SPART | TJKWV | SPART |
TVTA
Organizational Unit: Sales Area(s)
|
SPART |
| TJKWV | VKBUR | TJKWV | MANDT |
TVBUR
Organizational Unit: Sales Offices
|
MANDT |
| TJKWV | VKBUR | TJKWV | VKBUR |
TVBUR
Organizational Unit: Sales Offices
|
VKBUR |
| TJKWV | VKGRP | TJKWV | VKGRP |
TVKGR
Organizational Unit: Sales Groups
|
VKGRP |
| TJKWV | VKGRP | TJKWV | MANDT |
TVKGR
Organizational Unit: Sales Groups
|
MANDT |
| TJKWV | VKORG | TJKWV | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| TJKWV | VKORG | TJKWV | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| TJKWV | VTWEG | TJKWV | VTWEG |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
VTWEG |
| TJKWV | VTWEG | TJKWV | MANDT |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
MANDT |
| TJKWV | VTWEG | TJKWV | VKORG |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
VKORG |