SAP ABAP Table JKVWMAT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JKVWMAT	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	JKAK
3	POSNR	☑	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	JKAP
4	ETENR	☑	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line
5	PROMNR	☑	JPROMNR	JPROMNR	NUMC	3	0	Sales order introduction	JKPROM
6	MATNRWERB	☑	MATNR_SAPR	MATNR_ISP	CHAR	18	0	IS-M: Material number for gift
7	GPNR	☑	GPVERM	GPNR	CHAR	10	0	Business Partner Sales Agent	JGTGPNR
8	XMAINAGENT	☐	XMAINAGENT	XFELD	CHAR	1	0	IS-M/SD: Indicator for Main Sales Agent
9	ZUZAHLBETR	☐	JZUZAHLBET	ISPWV112	CURR	13	2	Additional payment
10	ZUZAHLWAER	☐	JZUZAHLWAE	WAERS	CUKY	5	0	Currency for Additional Payment
11	VERSANDDAT	☐	JPRMVRSDAT	DATUM	DATS	8	0	IS-M/SD: Gift Shipping Date
12	VPFLZEITRV	☐	VPFLZEITRV	ISPMNG2	QUAN	2	0	Commitment period for sales agent (subscriber)
13	VPFLZEINHV	☐	VPFLZEINHV	MEINS	UNIT	3	0	Time unit for commitment period	T006
14	VPFLBEGINN	☐	VPFLBEGINN	DATUM	DATS	8	0	IS-M/SD: Date on which commitment period begins
15	ERLDATWERB	☐	ERLDATWERB	DATUM	DATS	8	0	Date Advertising Bonus Sent
16	XSAPRSPERR	☐	XSAPRSPERR	XFELD	CHAR	1	0	Block indicator for gift shipping
17	AVNRWERB	☐	AVNRWERB	AVNR	CHAR	10	0	Order Number for Gift 'Free Subscription'
18	APNRWERB	☐	APNRWERB	POSEX_ISP	NUMC	6	0	Order Item Number for Gift 'Free Subscription'
19	WERBEART	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	TJWAR
20	WERBEAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	TJWAK
21	XAQUISITION	☐	XAQUISITION	XFELD	CHAR	1	0	IS-M/SD: Indicator - first introduction record
22	JKPROMVON	☐	WERBVONDT	DATUM	DATS	8	0	Start of Validity of Campaign Framework
23	MINDBEZUG	☐	MINDBEZUG	ISPMNG2	QUAN	2	0	Minimum Length of Subscription
24	MINDBEZEIN	☐	MINDBEZEIN	MEINS	UNIT	3	0	Time Unit for Minimum Length of Subscription	T006
25	POSNR_BASE	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
26	CYCLENR_BASE	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number	JKACCOUNT
27	POART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
28	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
29	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
30	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
31	JKEPVON	☐	JKEPVON	DATUM	DATS	8	0	Date from Which Schedule Line in Sales Order is Valid
32	JKEPBIS	☐	JKEPBIS	DATUM	DATS	8	0	Date to Which Schedule Line in Sales Order is Valid
33	BEZPER	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	TJD09
34	ETMENGE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
35	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	T006
36	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
37	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
38	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
39	SPART	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TVTA
40	XFKVDICHT	☐	XFKVDICHT	XFELD	CHAR	1	0	IS-M: Summarize deliveries according to billing item
41	AUARTGRP	☐	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
42	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKVWMAT	BEZPER	TJD09	BEZPER	REF	1	CN
2	JKVWMAT	CYCLENR_BASE	JKACCOUNT	CYCLENR	REF	C	CN
3	JKVWMAT	DRERZ	JDTDRER	DRERZ	REF	C	CN
4	JKVWMAT	ETMEINS	T006	MSEHI	REF	C	CN
5	JKVWMAT	GPAG	JGTGPNR	GPNR	KEY	1	CN
6	JKVWMAT	GPNR	JGTGPNR	GPNR	KEY	1	CN
7	JKVWMAT	MANDT	T000	MANDT	KEY	1	CN
8	JKVWMAT	MINDBEZEIN	T006	MSEHI	REF	C	CN
9	JKVWMAT	POART	TJAP	POART	REF	1	CN
10	JKVWMAT	POSNR	JKAP	POSNR	KEY	1	CN
11	JKVWMAT	POSNR_BASE	JKAP	POSNR	KEY	1	CN
12	JKVWMAT	PROMNR	JKPROM	PROMNR	KEY	1	CN
13	JKVWMAT	PVA	JDTPVA	PVA	REF	C	CN
14	JKVWMAT	SPART	TVTA	SPART	KEY	1	CN
15	JKVWMAT	VBELN	JKAK	VBELN	KEY	1	CN
16	JKVWMAT	VKORG	TVKO	VKORG	KEY	1	CN
17	JKVWMAT	VPFLZEINHV	T006	MSEHI	REF	C	CN
18	JKVWMAT	VTWEG	TVKOV	VTWEG	KEY	1	CN
19	JKVWMAT	WERBEAKT	TJWAK	WERBEAKT	REF	C	CN
20	JKVWMAT	WERBEART	TJWAR	WERBEART	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in