SAP ABAP Table JKVWERB (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JKVWERB	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☑	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order
3	POSNR	☑	APNR	APNR	NUMC	6	0	Sales Order Item
4	ETENR	☑	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line
5	JPARVW	☑	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
6	PARZA	☑	JPARZA	JPARZA	NUMC	3	0	IS-M: Partner Role Counter
7	JKPAVON	☑	JKPAVON	DATUM	DATS	8	0	Date from Which Partner Data in Sales Order is Valid
8	DLART	☑	JDLART	JDLART	CHAR	4	0	IS-M: Service type	TJL03
9	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
10	AUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
11	AUARTGRP	☐	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
12	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
13	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
14	SPART	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TVTA
15	VKBUR	☐	JVKBUR	VKBUR	CHAR	4	0	IS-M/SD: Receiving Sales Office	TVKBZ
16	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
17	XIMMATRIK	☐	XIMMATRIK	XFELD	CHAR	1	0	Indicator: Proof of matriculation provided
18	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
19	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
20	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
21	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
22	POART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
23	LAND1	☐	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	T005
24	XPATE	☐	XPATE	XFELD	CHAR	1	0	IS-M: Sponsored subscription
25	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
26	RECHBEGINN	☐	RECHBEGINN	DATUM	DATS	8	0	Billing From
27	RECHENDE	☐	RECHENDE	DATUM	DATS	8	0	Billing To
28	XNEGOPTION	☐	XNEGOPTION	XFELD	CHAR	1	0	IS-M: Item with Automatic Transformation to Chargeable
29	GUELTIGVON	☐	JKEPVON	DATUM	DATS	8	0	Date from Which Schedule Line in Sales Order is Valid
30	GUELTIGBIS	☐	JKEPBIS	DATUM	DATS	8	0	Date to Which Schedule Line in Sales Order is Valid
31	BEZPER	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	TJD09
32	ETMENGE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
33	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	T006
34	ETVORZEI	☐	ETVORZEI	VORZEI	CHAR	1	0	Plus/Minus Sign for Schedule Line Quantity in Sales Order
35	BZPERF	☐	BEZPERFAKT	BEZPER	CHAR	5	0	IS-M: Service Type for Billing	TJD09
36	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
37	VERSERVGES	☐	VERSERVGES	GPNR	CHAR	10	0	IS-M: Service Company	JGTVSG
38	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
39	FKPER	☐	FKPER	FKPER	CHAR	2	0	Billing Frequency	TJK01
40	WERBEART	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	TJWAR
41	PROVFDAT	☐	PROVFDAT	DATUM	DATS	8	0	Commission due date
42	VPFLZEINHV	☐	VPFLZEINHV	MEINS	UNIT	3	0	Time unit for commitment period	T006
43	VPFLZEITRV	☐	VPFLZEITRV	ISPMNG2	QUAN	2	0	Commitment period for sales agent (subscriber)
44	KONTAKTNR	☐	KONTAKTNR	ERSATZNR	CHAR	10	0	IS-M: Business Partner Sales Activity	JWTWEKO
45	XRECHERZ	☐	XRECHERZ	XFELD	CHAR	1	0	IS-M: Research generated
46	VSGRCHEUR	☐	VSGRCHEUR	GPNR	CHAR	10	0	Researcher's Service Company	JGTVSG
47	GPRECH	☐	GPRECH	GPNR	CHAR	10	0	IS-M: Researcher	JGTGPNR
48	APNRWERB	☐	APNRWERB	POSEX_ISP	NUMC	6	0	Order Item Number for Gift 'Free Subscription'
49	AVNRWERB	☐	AVNRWERB	AVNR	CHAR	10	0	Order Number for Gift 'Free Subscription'
50	WERBTRAEG	☐	WERBTRAEG	WERBTRAEG	CHAR	10	0	Advertising Medium	TJW09
51	ZUZAHLWAER	☐	JZUZAHLWAE	WAERS	CUKY	5	0	Currency for Additional Payment	TCURC
52	ZUZAHLBETR	☐	JZUZAHLBET	ISPWV112	CURR	13	2	Additional payment
53	ERLDATWERB	☐	ERLDATWERB	DATUM	DATS	8	0	Date Advertising Bonus Sent
54	MATNRWERB	☐	MATNR_SAPR	MATNR_ISP	CHAR	18	0	IS-M: Material number for gift
55	XRENDITE	☐	XRENDITE	XFELD	CHAR	1	0	Renewal commission
56	XWKZ	☐	XWKZ	XFELD	CHAR	1	0	Indicator: Promotion rebate
57	XEINMALPRV	☐	XEINMALPRV	XFELD	CHAR	1	0	Indicator: One-time commission
58	HAFTDEINH	☐	HAFTDEINH	MEINS	UNIT	3	0	Time Unit for Liability Period	T006
59	HAFTDAUER	☐	HAFTDAUER	ISPMNG2	QUAN	2	0	Liability Period for Commission Clawback in Months
60	PROVRART	☐	PROVRART	PROVRART	CHAR	1	0	Commission clawback type
61	PRVSP	☐	PROVSPERRE	PROVSPERRE	CHAR	2	0	Commission settlement block
62	XVTPRO	☐	XVTPRO	XFELD	CHAR	1	0	Relevant for commission
63	LIEFUMXEIN	☐	LIEFUMXEIN	MEINS	UNIT	3	0	Time unit for maximum delivery suspension	T006
64	LIEFUNTMAX	☐	LIEFUNTMAX	ISPMNG2	QUAN	2	0	Maximum Delivery Suspension
65	MINDBEZEIN	☐	MINDBEZEIN	MEINS	UNIT	3	0	Time Unit for Minimum Length of Subscription	T006
66	MINDBEZUG	☐	MINDBEZUG	ISPMNG2	QUAN	2	0	Minimum Length of Subscription
67	WERBEAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	TJWAK
68	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
69	JKWERBVON	☐	WERBVONDT	DATUM	DATS	8	0	Start of Validity of Campaign Framework
70	XSAPRSPERR	☐	XSAPRSPERR	XFELD	CHAR	1	0	Block indicator for gift shipping
71	WERBKZSCHL	☐	JWBZWKZSCH	JWBZWKZSCH	CHAR	1	0	IS-M: WBZ, Promotion Rebate Key	TJKW9
72	XURPOS	☐	XURPOS	XFELD	CHAR	1	0	Original item in publishing sales order

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKVWERB	AUART	TJAK	AUART	REF	1	CN
2	JKVWERB	BEZPER	TJD09	BEZPER	REF	1	CN
3	JKVWERB	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
4	JKVWERB	BZPERF	TJD09	BEZPER	REF	C	CN
5	JKVWERB	DLART	TJL03	DLART	KEY	1	CN
6	JKVWERB	DRERZ	JDTDRER	DRERZ	REF	C	CN
7	JKVWERB	EKORG	T024E	EKORG	KEY	1	CN
8	JKVWERB	ETMEINS	T006	MSEHI	REF	C	CN
9	JKVWERB	FKPER	TJK01	FKPER	REF	C	CN
10	JKVWERB	GPAG	JGTGPNR	GPNR	KEY	1	CN
11	JKVWERB	GPNR	JGTGPNR	GPNR	KEY	1	CN
12	JKVWERB	GPRECH	JGTGPNR	GPNR	REF	C	CN
13	JKVWERB	GSBER	TGSB	GSBER	REF	C	CN
14	JKVWERB	HAFTDEINH	T006	MSEHI	REF	C	CN
15	JKVWERB	JPARVW	TJG39	JPARVW	KEY	1	CN
16	JKVWERB	KONDA	T188	KONDA	REF	C	CN
17	JKVWERB	KONTAKTNR	JWTWEKO	KONTAKTNR	REF	C	CN
18	JKVWERB	LAND1	T005	LAND1	REF	C	CN
19	JKVWERB	LIEFUMXEIN	T006	MSEHI	REF	C	CN
20	JKVWERB	MANDT	T000	MANDT	KEY	1	CN
21	JKVWERB	MINDBEZEIN	T006	MSEHI	REF	C	CN
22	JKVWERB	POART	TJAP	POART	REF	1	CN
23	JKVWERB	PVA	JDTPVA	PVA	REF	C	CN
24	JKVWERB	SPART	TVTA	SPART	KEY	1	CN
25	JKVWERB	VERSERVGES	JGTVSG	VERSERVGES	REF	C	CN
26	JKVWERB	VKBUR	TVKBZ	VKBUR	REF	C	CN
27	JKVWERB	VKORG	TVKO	VKORG	KEY	1	CN
28	JKVWERB	VPFLZEINHV	T006	MSEHI	REF	C	CN
29	JKVWERB	VSGRCHEUR	JGTVSG	VERSERVGES	REF	C	CN
30	JKVWERB	VTWEG	TVKOV	VTWEG	KEY	1	CN
31	JKVWERB	WERBEAKT	TJWAK	WERBEAKT	REF	C	CN
32	JKVWERB	WERBEART	TJWAR	WERBEART	REF	C	CN
33	JKVWERB	WERBKZSCHL	TJKW9	WERBKZSCHL		1	CN
34	JKVWERB	WERBTRAEG	TJW09	WERBTRAEG	REF	C	CN
35	JKVWERB	ZUZAHLWAER	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in