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
X Yes
NULL No
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