SAP ABAP Table JWBASI (IS-M/SD: Campaign Framework)

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	JWBASI	Table Relationship Diagram
Short Description	IS-M/SD: Campaign Framework

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	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
3	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
4	SPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
5	WERBEART	☑	WERBEART	WERBEART	CHAR	4	0	Sales Source	TJWAR
6	WERBEAKT	☑	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	TJWAK
7	GUELTIGVON	☑	WERBVONDT	DATUM	DATS	8	0	Start of Validity of Campaign Framework
8	GUELTIGBIS	☐	WERBBISDT	DATUM	DATS	8	0	End of Validity of Campaign Framework
9	MINDBEZUG	☐	MINDBEZUG	ISPMNG2	QUAN	2	0	Minimum Length of Subscription
10	MINDBEZEIN	☐	MINDBEZEIN	MEINS	UNIT	3	0	Time Unit for Minimum Length of Subscription	T006
11	LIEFUNTMAX	☐	LIEFUNTMAX	ISPMNG2	QUAN	2	0	Maximum Delivery Suspension
12	LIEFUMXEIN	☐	LIEFUMXEIN	MEINS	UNIT	3	0	Time unit for maximum delivery suspension	T006
13	HAFTDAUER	☐	HAFTDAUER	ISPMNG2	QUAN	2	0	Liability Period for Commission Clawback in Months
14	HAFTDEINH	☐	HAFTDEINH	MEINS	UNIT	3	0	Time Unit for Liability Period	T006
15	VPFLZEITRV	☐	VPFLZEITRV	ISPMNG2	QUAN	2	0	Commitment period for sales agent (subscriber)
16	VPFLZEINHV	☐	VPFLZEINHV	MEINS	UNIT	3	0	Time unit for commitment period	T006
17	XWERBTRAEG	☐	XWERBTRAEG	XFELD	CHAR	1	0	Indicator: Advertising medium required for order
18	WERBAUFW	☐	WERBAUFW	ISPWV112	CURR	13	2	Advertising costs (amount) per subscription obtained
19	WERBWAERS	☐	WERBWAERS	WAERS	CUKY	5	0	Currency of Advertising Expenses per Subscription	TCURC
20	XFREIABO	☐	XFREIABO	XFELD	CHAR	1	0	Indicator: Free subscription allowed
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	JWBASI	HAFTDEINH	T006	MSEHI	REF	C	CN
2	JWBASI	LIEFUMXEIN	T006	MSEHI	REF	C	CN
3	JWBASI	MANDT	T000	MANDT	KEY	1	N
4	JWBASI	MINDBEZEIN	T006	MSEHI	REF	C	CN
5	JWBASI	SPART	TSPA	SPART	KEY	1	N
6	JWBASI	VKORG	TVKO	VKORG	KEY	1	N
7	JWBASI	VPFLZEINHV	T006	MSEHI	REF	C	CN
8	JWBASI	VTWEG	TVTW	VTWEG	KEY	1	N
9	JWBASI	WERBEAKT	TJWAK	WERBEAKT	KEY	1	CN
10	JWBASI	WERBEART	TJWAR	WERBEART	KEY	1	N
11	JWBASI	WERBWAERS	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in