SAP Table JWTWEKO
IS-M/SD: Sales Activity for Business Partner
JWTWEKO (IS-M/SD: Sales Activity for Business Partner) 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 JWTWEKO to other SAP tables.
JWTWEKO table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
KONTAKTNR | IS-M: Business Partner Sales Activity | KONTAKTNR | CHAR | 10 | 0 | |||||||
GPNR | IS-M: Business Partner Key | GPNR | JGTGPNR | CHAR | 10 | 0 | ||||||
GPROLLE | IS-M: Business Partner Role | JPARVW | TJG39 | CHAR | 2 | 0 | ||||||
KONTAKTDAT | Date of sales activity | KONTAKTDAT | DATS | 8 | 0 | |||||||
KONTAKTUHR | IS-M: Time of sales activity | KONTAKTUHR | TIMS | 6 | 0 | |||||||
WKONTKTART | IS-M: Sales activity type | WKONTKTART | TVKK | CHAR | 4 | 0 | ||||||
WKONTKTGRU | IS-M: Reason for sales activity | WKONTKTGRU | TVC2 | CHAR | 3 | 0 | ||||||
WKONTKTST | IS-M: Status of sales activity | WKONTKTST | TVC3 | CHAR | 1 | 0 | ||||||
WKONTKTERG | IS-M: Outcome of sales activity | WKONTKTERG | TVC1 | CHAR | 3 | 0 | ||||||
WKERGGRUND | IS-M: Analysis of sales activity outcome | WKERGGRUND | TVC4 | CHAR | 3 | 0 | ||||||
WERBEAKT | Sales Promotion | WERBEAKT | TJWAK | CHAR | 8 | 0 | ||||||
WERBEART | Sales Source | WERBEART | TJWAR | CHAR | 4 | 0 | ||||||
VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||
VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||
SPARTE | Division | SPART | TSPA | CHAR | 2 | 0 | ||||||
VERKBUERO | Sales Office | VKBUR | TVBUR | CHAR | 4 | 0 | ||||||
VERKGRP | Sales Group | VKGRP | TVKGR | CHAR | 3 | 0 | ||||||
XSCRIPTE | SAPscript text for external comment | XSCRIPTE | CHAR | 1 | 0 |
Possible values
|
||||||
UNAME | IS-M: User Name | JUSER | CHAR | 12 | 0 | |||||||
ERFUSER | Created By | ERFUSER | CHAR | 12 | 0 | |||||||
ERFDATE | Created On | ERFDATE | DATS | 8 | 0 | |||||||
ERFTIME | Time Created | ERFTIME | TIMS | 6 | 0 | |||||||
AENUSER | Last Changed By | AENUSER | CHAR | 12 | 0 | |||||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | 0 | |||||||
AENTIME | Time of Last Change | AENTIME | TIMS | 6 | 0 |
JWTWEKO foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
JWTWEKO | GPNR | JWTWEKO | MANDT | JGTGPNR | IS-M: Central Business Partner Table | MANDT |
JWTWEKO | GPNR | JWTWEKO | GPNR | JGTGPNR | IS-M: Central Business Partner Table | GPNR |
JWTWEKO | GPROLLE | JWTWEKO | MANDT | TJG39 | IS-M/SD: Business Partner Roles | MANDT |
JWTWEKO | GPROLLE | JWTWEKO | GPROLLE | TJG39 | IS-M/SD: Business Partner Roles | JPARVW |
JWTWEKO | MANDT | JWTWEKO | MANDT | T000 | Clients | MANDT |
JWTWEKO | SPARTE | JWTWEKO | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
JWTWEKO | SPARTE | JWTWEKO | SPARTE | TSPA | Organizational Unit: Sales Divisions | SPART |
JWTWEKO | VERKBUERO | JWTWEKO | MANDT | TVBUR | Organizational Unit: Sales Offices | MANDT |
JWTWEKO | VERKBUERO | JWTWEKO | VERKBUERO | TVBUR | Organizational Unit: Sales Offices | VKBUR |
JWTWEKO | VERKGRP | JWTWEKO | MANDT | TVKGR | Organizational Unit: Sales Groups | MANDT |
JWTWEKO | VERKGRP | JWTWEKO | VERKGRP | TVKGR | Organizational Unit: Sales Groups | VKGRP |
JWTWEKO | VKORG | JWTWEKO | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
JWTWEKO | VKORG | JWTWEKO | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
JWTWEKO | VTWEG | JWTWEKO | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
JWTWEKO | VTWEG | JWTWEKO | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
JWTWEKO | WERBEAKT | JWTWEKO | MANDT | TJWAK | IS-M/SD: Sales Promotion | MANDT |
JWTWEKO | WERBEAKT | JWTWEKO | WERBEAKT | TJWAK | IS-M/SD: Sales Promotion | WERBEAKT |
JWTWEKO | WERBEART | JWTWEKO | WERBEART | TJWAR | IS-M/SD: Sales Source | WERBEART |
JWTWEKO | WERBEART | JWTWEKO | MANDT | TJWAR | IS-M/SD: Sales Source | MANDT |
JWTWEKO | WKERGGRUND | JWTWEKO | MANDT | TVC4 | Sales Activity Outcome Analysis | MANDT |
JWTWEKO | WKERGGRUND | JWTWEKO | WKERGGRUND | TVC4 | Sales Activity Outcome Analysis | KTAEB |
JWTWEKO | WKONTKTART | JWTWEKO | WKONTKTART | TVKK | Sales Activity Types | KTAAR |
JWTWEKO | WKONTKTART | JWTWEKO | MANDT | TVKK | Sales Activity Types | MANDT |
JWTWEKO | WKONTKTERG | JWTWEKO | WKONTKTERG | TVC1 | Sales Activity Outcome | KTAER |
JWTWEKO | WKONTKTERG | JWTWEKO | MANDT | TVC1 | Sales Activity Outcome | MANDT |
JWTWEKO | WKONTKTGRU | JWTWEKO | MANDT | TVC2 | Reasons for Sales Activities | MANDT |
JWTWEKO | WKONTKTGRU | JWTWEKO | WKONTKTGRU | TVC2 | Reasons for Sales Activities | KTAGR |
JWTWEKO | WKONTKTST | JWTWEKO | MANDT | TVC3 | Sales Activity Status | MANDT |
JWTWEKO | WKONTKTST | JWTWEKO | WKONTKTST | TVC3 | Sales Activity Status | KTAST |