SAP ABAP Table JKWERBVB (Mix Structure for XJKWERB)

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	INTTAB	Structure
Structure	JKWERBVB	Table Relationship Diagram
Short Description	Mix Structure for XJKWERB

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in