SAP ABAP Table JKWERB (Publishing Sales Order: Promotion Data)

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	JKWERB	Table Relationship Diagram
Short Description	Publishing Sales Order: Promotion Data

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	VBELN	☑	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
3	POSNR	☑	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	JKAP
4	WERBEART	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	TJWAR
5	WERBEAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	TJWAK
6	GUELTIGVON	☐	WERBVONDT	DATUM	DATS	8	0	Start of Validity of Campaign Framework
7	MINDBEZUG	☐	MINDBEZUG	ISPMNG2	QUAN	2	0	Minimum Length of Subscription
8	MINDBEZEIN	☐	MINDBEZEIN	MEINS	UNIT	3	0	Time Unit for Minimum Length of Subscription	T006
9	LIEFUNTMAX	☐	LIEFUNTMAX	ISPMNG2	QUAN	2	0	Maximum Delivery Suspension
10	LIEFUMXEIN	☐	LIEFUMXEIN	MEINS	UNIT	3	0	Time unit for maximum delivery suspension	T006
11	XVTPRO	☐	XVTPRO	XFELD	CHAR	1	0	Relevant for commission
12	PRVSP	☐	PROVSPERRE	PROVSPERRE	CHAR	2	0	Commission settlement block	*
13	PROVRART	☐	PROVRART	PROVRART	CHAR	1	0	Commission clawback type
14	HAFTDAUER	☐	HAFTDAUER	ISPMNG2	QUAN	2	0	Liability Period for Commission Clawback in Months
15	HAFTDEINH	☐	HAFTDEINH	MEINS	UNIT	3	0	Time Unit for Liability Period	T006
16	XEINMALPRV	☐	XEINMALPRV	XFELD	CHAR	1	0	Indicator: One-time commission
17	XWKZ	☐	XWKZ	XFELD	CHAR	1	0	Indicator: Promotion rebate
18	XRENDITE	☐	XRENDITE	XFELD	CHAR	1	0	Renewal commission
19	MATNRWERB	☐	MATNR_SAPR	MATNR_ISP	CHAR	18	0	IS-M: Material number for gift	*
20	ERLDATWERB	☐	ERLDATWERB	DATUM	DATS	8	0	Date Advertising Bonus Sent
21	XSAPRSPERR	☐	XSAPRSPERR	XFELD	CHAR	1	0	Block indicator for gift shipping
22	ZUZAHLBETR	☐	JZUZAHLBET	ISPWV112	CURR	13	2	Additional payment
23	ZUZAHLWAER	☐	JZUZAHLWAE	WAERS	CUKY	5	0	Currency for Additional Payment	TCURC
24	WERBTRAEG	☐	WERBTRAEG	WERBTRAEG	CHAR	10	0	Advertising Medium	TJW09
25	AVNRWERB	☐	AVNRWERB	AVNR	CHAR	10	0	Order Number for Gift 'Free Subscription'	*
26	APNRWERB	☐	APNRWERB	POSEX_ISP	NUMC	6	0	Order Item Number for Gift 'Free Subscription'
27	GPRECH	☐	GPRECH	GPNR	CHAR	10	0	IS-M: Researcher	JGTGPNR
28	VSGRCHEUR	☐	VSGRCHEUR	GPNR	CHAR	10	0	Researcher's Service Company	JGTVSG
29	XRECHERZ	☐	XRECHERZ	XFELD	CHAR	1	0	IS-M: Research generated
30	KONTAKTNR	☐	KONTAKTNR	ERSATZNR	CHAR	10	0	IS-M: Business Partner Sales Activity	JWTWEKO
31	VPFLZEITRV	☐	VPFLZEITRV	ISPMNG2	QUAN	2	0	Commitment period for sales agent (subscriber)
32	VPFLZEINHV	☐	VPFLZEINHV	MEINS	UNIT	3	0	Time unit for commitment period	T006
33	PROVFDAT	☐	PROVFDAT	DATUM	DATS	8	0	Commission due date
34	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
35	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
36	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
37	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
38	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
39	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
40	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
41	XPROVVSYST	☐	XPROVVSYST	XFELD	CHAR	1	0	Commission settlement for subscription in legacy system

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKWERB	GPRECH	JGTGPNR	GPNR	REF	C	CN
2	JKWERB	HAFTDEINH	T006	MSEHI	REF	C	CN
3	JKWERB	KONTAKTNR	JWTWEKO	KONTAKTNR	REF	C	CN
4	JKWERB	LIEFUMXEIN	T006	MSEHI	REF	C	CN
5	JKWERB	MANDT	T000	MANDT	KEY	1	CN
6	JKWERB	MINDBEZEIN	T006	MSEHI	REF	C	CN
7	JKWERB	POSNR	JKAP	POSNR	KEY	1	CN
8	JKWERB	VBELN	JKAK	VBELN	KEY	1	CN
9	JKWERB	VPFLZEINHV	T006	MSEHI	REF	C	CN
10	JKWERB	VSGRCHEUR	JGTVSG	VERSERVGES	REF	C	CN
11	JKWERB	WERBEAKT	TJWAK	WERBEAKT	REF	C	CN
12	JKWERB	WERBEART	TJWAR	WERBEART	REF	C	CN
13	JKWERB	WERBTRAEG	TJW09	WERBTRAEG	REF	C	CN
14	JKWERB	ZUZAHLWAER	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in