SAP ABAP Table JWTWEKO (IS-M/SD: Sales Activity for Business Partner)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JWTWEKO	Table Relationship Diagram
Short Description	IS-M/SD: Sales Activity for Business Partner

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KONTAKTNR	☑	KONTAKTNR	ERSATZNR	CHAR	10	0	IS-M: Business Partner Sales Activity
3	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
4	GPROLLE	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
5	KONTAKTDAT	☐	KONTAKTDAT	DATUM	DATS	8	0	Date of sales activity
6	KONTAKTUHR	☐	KONTAKTUHR	UZEIT	TIMS	6	0	IS-M: Time of sales activity
7	WKONTKTART	☐	WKONTKTART	KTAAR	CHAR	4	0	IS-M: Sales activity type	TVKK
8	WKONTKTGRU	☐	WKONTKTGRU	KTAGR	CHAR	3	0	IS-M: Reason for sales activity	TVC2
9	WKONTKTST	☐	WKONTKTST	KTAST	CHAR	1	0	IS-M: Status of sales activity	TVC3
10	WKONTKTERG	☐	WKONTKTERG	KTAER	CHAR	3	0	IS-M: Outcome of sales activity	TVC1
11	WKERGGRUND	☐	WKERGGRUND	KTAEB	CHAR	3	0	IS-M: Analysis of sales activity outcome	TVC4
12	WERBEAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	TJWAK
13	WERBEART	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	TJWAR
14	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
15	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
16	SPARTE	☐	SPART	SPART	CHAR	2	0	Division	TSPA
17	VERKBUERO	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
18	VERKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
19	XSCRIPTE	☐	XSCRIPTE	XFELD	CHAR	1	0	SAPscript text for external comment
20	UNAME	☐	JUSER	UNAME	CHAR	12	0	IS-M: User Name
21	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
22	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
23	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
24	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
25	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
26	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
27	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JWTWEKO	GPNR	JGTGPNR	GPNR	KEY	1	CN
2	JWTWEKO	GPROLLE	TJG39	JPARVW	REF	1	CN
3	JWTWEKO	MANDT	T000	MANDT	KEY	1	CN
4	JWTWEKO	SPARTE	TSPA	SPART	REF	1	CN
5	JWTWEKO	VERKBUERO	TVBUR	VKBUR	REF	C	CN
6	JWTWEKO	VERKGRP	TVKGR	VKGRP	REF	C	CN
7	JWTWEKO	VKORG	TVKO	VKORG	REF	1	CN
8	JWTWEKO	VTWEG	TVTW	VTWEG	REF	1	CN
9	JWTWEKO	WERBEAKT	TJWAK	WERBEAKT	REF	C	CN
10	JWTWEKO	WERBEART	TJWAR	WERBEART	REF	1	CN
11	JWTWEKO	WKERGGRUND	TVC4	KTAEB	REF	C	CN
12	JWTWEKO	WKONTKTART	TVKK	KTAAR	REF	1	CN
13	JWTWEKO	WKONTKTERG	TVC1	KTAER	REF	C	CN
14	JWTWEKO	WKONTKTGRU	TVC2	KTAGR	REF	C	CN
15	JWTWEKO	WKONTKTST	TVC3	KTAST	REF	C	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in