SAP ABAP Table JVVTTITEL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JVVTTITEL	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	BEZIRK	☑	BEZIRK	BEZIRK	CHAR	10	0	Carrier Route	JVTBEZIRK
3	XVRTBEZIRK	☑	XVRTBEZIRK	XFELD	CHAR	1	0	Ad pre-print zone
4	XTITBEZIRK	☑	XTITBEZIRK	XFELD	CHAR	1	0	Carrier route
5	XBLGBEZIRK	☑	XBLGBEZIRK	XFELD	CHAR	1	0	Insert zone
6	KURZTEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
7	LANGTEXT	☐	BEZEICHN50	TEXT50	CHAR	50	0	IS-M: Long Text
8	XFRDBEZIRK	☐	XFRDBEZIRK	XFELD	CHAR	1	0	Indicator: Carrier route with third party home delivery
9	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
10	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
11	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
12	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
13	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
14	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
15	XLOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
16	XLOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
17	XSPERRE	☐	XSPERRE	XFELD	CHAR	1	0	General Block for Order Management
18	XRECHERCH	☐	XRECHERCH	XFELD	CHAR	1	0	Sale only if research performed
19	XVORKAS	☐	XVORKAS	XFELD	CHAR	1	0	Sale only with advance payment
20	XEZBZG	☐	XEZBZG	XFELD	CHAR	1	0	No single purchases allowed in order processing
21	FAHRKM	☐	FAHRKM	ISPMNG9	QUAN	9	3	Distance (for Home Delivery Settlement)
22	EINHFAHRKM	☐	EINHFAHRKM	MEINS	UNIT	3	0	Unit (km/m)	T006
23	ZAHLSHLSSL	☐	ISPSHLSSL	ISPMNG3	QUAN	3	0	IS-M: Number of Keys in Carrier Route (for Home Del. Sett.)
24	EINHSHLSSL	☐	EINHSHLSSL	MEINS	UNIT	3	0	IS-M: Unit for Number of Keys	T006
25	SCHLGLDKAT	☐	SCHLGLDKAT	SCHLGLDKAT	CHAR	2	0	IS-M: Key compensation category	TJV33
26	TRAGEZEITK	☐	TRAGEZEITK	TRAGEZEITK	CHAR	2	0	Distribution time category (for home delivery settlement)	TJV15
27	FAHRKMKAT	☐	FAHRKMKAT	FAHRKMKAT	CHAR	2	0	Distance Traveled: Category (for Home Delivery Settlement)	TJV13
28	WEGLANGKAT	☐	WEGLANGKAT	WEGLANGKAT	CHAR	2	0	IS-M: Path length category	TJV35
29	TOPOLOGIEK	☐	TOPOLOGIEK	TOPOLOGIEK	CHAR	2	0	Topography category (for home delivery settlement)	TJV11
30	BEZKATE1	☐	BEZKATE1	BEZKATE1	CHAR	2	0	Carrier Route Flat Rate Category	TJV23
31	BEZKATE2	☐	BEZKATE2	BEZKATE2	CHAR	2	0	IS-M: Carrier Route Category 2	TJV25
32	BEZKATE3	☐	BEZKATE3	BEZKATE3	CHAR	2	0	IS-M: Carrier Route Category 3	TJV27
33	BEZKATE4	☐	BEZKATE4	BEZKATE4	CHAR	2	0	IS-M: Carrier Route Category 4	TJV29
34	BEZKATE5	☐	BEZKATE5	BEZKATE5	CHAR	2	0	IS-M: Carrier Route Category 5	TJV31
35	PROSPOTNTL	☐	PROSPOTNTL	DEC11	DEC	11	0	IS-M: Planned circulation quantity for ad pre-prints
36	TITLPOTNTL	☐	TITLPOTNTL	DEC11	DEC	11	0	IS-M: Planned customer circulation quantity for title
37	XLAUFLIST	☐	XLAUFLIST	XFELD	CHAR	1	0	IS-M: Generate carrier round sequence during release
38	XAKTUELL	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
39	WEGLANG	☐	WEGLANG	ISPMNG9	QUAN	9	3	Path length for home delivery or distribution
40	MEIWLANG	☐	MEINWLAENG	MEINS	UNIT	3	0	Unit of measurement for path length	T006
41	TRAGEZEIT	☐	TRAGEZEIT	DAUERSTD4	TIMS	6	0	IS-M: Distribution time
42	ZUSZSTLLZ	☐	JZUSZSTLLZ	DAUERSTD4	TIMS	6	0	Additional home delivery time
43	ZSTLLZNABO	☐	JZSTLZNABO	DAUERSTD4	TIMS	6	0	Delivery time including delivery to non-subscribers
44	WEGLANGABO	☐	WEGLANGABO	ISPMNG9	QUAN	9	3	Path length for parallel delivery to non-subscribers
45	MEIWLANGAB	☐	MEINWLAENG	MEINS	UNIT	3	0	Unit of measurement for path length	T006
46	BEABSTELLE	☐	BEABLSTH	BEABLST	CHAR	10	0	Main Unloading Point for Carrier Route (Default)	JRTBEABST
47	ZUSTELLER	☐	JZUSTELLER	GPNR	CHAR	10	0	IS-M: Carrier	JGTGPNR
48	ZSGLSSCHFT	☐	VSGZUSTLR	GPNR	CHAR	10	0	IS-M/SD: Service Company to Which Carrier Belongs	JGTGPNR
49	GPINKASSO	☐	GPINKASSO	GPNR	CHAR	10	0	IS-M: Field Collector	JGTGPNR
50	VSGINKASSO	☐	VSGINKB	GPNR	CHAR	10	0	Service company for field collector (optional)	JGTGPNR
51	GPRECH	☐	GPRECH	GPNR	CHAR	10	0	IS-M: Researcher	JGTGPNR
52	VSGRCHEUR	☐	VSGRCHEUR	GPNR	CHAR	10	0	Researcher's Service Company	JGTGPNR
53	BEWERTUNG	☐	JZBEWERT	NUMC5	NUMC	5	0	IS-M: Valuation of carrier route for home del.settlement
54	ZAHL_STOPP	☐	JZAHLSTOP	DEC11	DEC	11	0	IS-M: Number of Households with "No Circulars" Notice
55	ZAHL_STOPA	☐	JZAHLSTOPA	DEC11	DEC	11	0	IS-M: Number of refusals for free sheet

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JVVTTITEL	BEABSTELLE	JRTBEABST	BEABLST	KEY	1	CN
2	JVVTTITEL	BEZIRK	JVTBEZIRK	BEZIRK	KEY	1	N
3	JVVTTITEL	BEZKATE1	TJV23	BEZKATE1	REF	C	CN
4	JVVTTITEL	BEZKATE2	TJV25	BEZKATE2	REF	C	CN
5	JVVTTITEL	BEZKATE3	TJV27	BEZKATE3	REF	C	CN
6	JVVTTITEL	BEZKATE4	TJV29	BEZKATE4	REF	C	CN
7	JVVTTITEL	BEZKATE5	TJV31	BEZKATE5	REF	C	CN
8	JVVTTITEL	EINHFAHRKM	T006	MSEHI	REF	C	CN
9	JVVTTITEL	EINHSHLSSL	T006	MSEHI	REF	C	CN
10	JVVTTITEL	FAHRKMKAT	TJV13	FAHRKMKAT	REF	C	CN
11	JVVTTITEL	GPINKASSO	JGTGPNR	GPNR	REF	C	CN
12	JVVTTITEL	GPRECH	JGTGPNR	GPNR	REF	C	CN
13	JVVTTITEL	MANDT	T000	MANDT	KEY	1	CN
14	JVVTTITEL	MEIWLANG	T006	MSEHI	REF	C	CN
15	JVVTTITEL	MEIWLANGAB	T006	MSEHI	REF	C	CN
16	JVVTTITEL	SCHLGLDKAT	TJV33	SCHLGLDKAT	REF	C	CN
17	JVVTTITEL	TOPOLOGIEK	TJV11	TOPOLOGIEK	REF	C	CN
18	JVVTTITEL	TRAGEZEITK	TJV15	TRAGEZEITK	REF	C	CN
19	JVVTTITEL	VSGINKASSO	JGTGPNR	GPNR	REF	C	CN
20	JVVTTITEL	VSGRCHEUR	JGTGPNR	GPNR	REF	C	CN
21	JVVTTITEL	WEGLANGKAT	TJV35	WEGLANGKAT	REF	C	CN
22	JVVTTITEL	ZSGLSSCHFT	JGTGPNR	GPNR	REF	C	CN
23	JVVTTITEL	ZUSTELLER	JGTGPNR	GPNR	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in