SAP ABAP Table TJWAK (IS-M/SD: Sales Promotion)

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	TJWAK	Table Relationship Diagram
Short Description	IS-M/SD: Sales Promotion

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	WERBEAKT	☑	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion
3	GUELTIGVON	☐	WERBAVONDT	DATUM	DATS	8	0	Start of Validity of Sales Promotion
4	GUELTIGBIS	☐	WERBABISDT	DATUM	DATS	8	0	End of Validity of Sales Promotion
5	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
6	CO_AUFNR	☐	J_CO_AUFNR	AUFNR	CHAR	12	0	Order number of internal CO order for account assignment	AUFK
7	GEOEIN	☐	GEOEINWB	GEOEIN	CHAR	10	0	IS-M: Geographical Unit in Sales Promotion	JSTGEOEINH
8	ANZWERBPLN	☐	ANZWERBPLN	STMENGE	DEC	9	0	Number of Planned Sales Activities
9	ANZPROBPLN	☐	ANZPROBPLN	STMENGE	DEC	9	0	Number of Planned Trial Items
10	ANZABOPLN	☐	ANZABOPLN	STMENGE	DEC	9	0	Number of Planned Standard Subscription Items
11	ANZWERBIST	☐	ANZWERBIST	STMENGE	DEC	9	0	Actual Sales Activities
12	ANZPROBIST	☐	ANZPROBIST	STMENGE	DEC	9	0	Actual Number of Trial Items
13	ANZABOIST	☐	ANZABOIST	STMENGE	DEC	9	0	Actual Number of Standard Subscription Items
14	ANZETPROBE	☐	ANZETPROBE	STMENGE	DEC	9	0	Number of Publication Days for Trial or Free Item
15	RQUOTE_PLN	☐	J_RQUOTE	PRZNT	DEC	7	4	IS-M: Return rate
16	RQUOTE_IST	☐	J_RQUOTE	PRZNT	DEC	7	4	IS-M: Return rate
17	EQUOTE_PLN	☐	J_EQUOTE	PRZNT	DEC	7	4	IS-M: Success rate
18	EQUOTE_IST	☐	J_EQUOTE	PRZNT	DEC	7	4	IS-M: Success rate
19	WAERS_PLN	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	WAERS_IST	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
21	KOSTEN_PLN	☐	JKOSTEN	WERTV8	CURR	15	2	IS-M: Costs
22	KOSTEN_IST	☐	JKOSTEN	WERTV8	CURR	15	2	IS-M: Costs
23	CPO	☐	JCPO	WERT05	CURR	9	2	IS-M: Cost per order
24	ANZABOISTS	☐	ANZABOISTS	STMENGE	DEC	9	0	IS-M: Full Subscriptions Terminated from Sales Promotion
25	AKTDATUM	☐	JISTDATUM	DATUM	DATS	8	0	IS-M: Date of Last Actual Data Update
26	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
27	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
28	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
29	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
30	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
31	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
32	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
33	ANZABOISTX	☐	ANZABOISTX	STMENGE	DEC	9	0	IS-M: Terminated Subscriptions from Sales Promotion
34	ANZKSTLPLN	☐	ANZKSTLPLN	STMENGE	DEC	9	0	Planned Number of Free Items
35	ANZKSTLIST	☐	ANZKSTLIST	STMENGE	DEC	9	0	Actual Number of Free Items
36	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN_PROP	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Default for Marketing Campaign

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TJWAK	CO_AUFNR	AUFK	AUFNR
2	TJWAK	DRERZ	JDTDRER	DRERZ	REF	1	CN
3	TJWAK	GEOEIN	JSTGEOEINH	GEOEIN	REF	C	CN
4	TJWAK	MANDT	T000	MANDT	KEY	1	N
5	TJWAK	WAERS_IST	TCURC	WAERS
6	TJWAK	WAERS_PLN	TCURC	WAERS

History

Last changed by/on	SAP	20050224
SAP Release Created in