SAP ABAP Table JVVTPVTL (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure JVVTPVTL   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  
3 KURZTEXT BEZEICHN15 TEXT15 CHAR 15   0   IS-M: Short Text  
4 LANGTEXT BEZEICHN50 TEXT50 CHAR 50   0   IS-M: Long Text  
5 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
6 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
7 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
8 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
9 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
10 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
11 XLOEVM LOEVM_ISP XFELD CHAR 1   0   Deletion Flag for Master Data in Media Sales & Distribution  
12 XLOEKZ LOEKZ_ISP XFELD CHAR 1   0   Deletion Indicator for Master Data in Media Sales & Dist.  
13 XSPERRE XSPERRE XFELD CHAR 1   0   General Block for Order Management  
14 FAHRKM FAHRKM ISPMNG9 QUAN 9   3   Distance (for Home Delivery Settlement)  
15 EINHFAHRKM EINHFAHRKM MEINS UNIT 3   0   Unit (km/m) T006
16 ZAHLSHLSSL ISPSHLSSL ISPMNG3 QUAN 3   0   IS-M: Number of Keys in Carrier Route (for Home Del. Sett.)  
17 EINHSHLSSL EINHSHLSSL MEINS UNIT 3   0   IS-M: Unit for Number of Keys T006
18 TRAGEZEITK TRAGEZEITK TRAGEZEITK CHAR 2   0   Distribution time category (for home delivery settlement) TJV15
19 FAHRKMKAT FAHRKMKAT FAHRKMKAT CHAR 2   0   Distance Traveled: Category (for Home Delivery Settlement) TJV13
20 WEGLANGKAT WEGLANGKAT WEGLANGKAT CHAR 2   0   IS-M: Path length category TJV35
21 TOPOLOGIEK TOPOLOGIEK TOPOLOGIEK CHAR 2   0   Topography category (for home delivery settlement) TJV11
22 SCHLGLDKAT SCHLGLDKAT SCHLGLDKAT CHAR 2   0   IS-M: Key compensation category TJV33
23 BEZKATE1 BEZKATE1 BEZKATE1 CHAR 2   0   Carrier Route Flat Rate Category TJV23
24 BEZKATE2 BEZKATE2 BEZKATE2 CHAR 2   0   IS-M: Carrier Route Category 2 TJV25
25 BEZKATE3 BEZKATE3 BEZKATE3 CHAR 2   0   IS-M: Carrier Route Category 3 TJV27
26 BEZKATE4 BEZKATE4 BEZKATE4 CHAR 2   0   IS-M: Carrier Route Category 4 TJV29
27 BEZKATE5 BEZKATE5 BEZKATE5 CHAR 2   0   IS-M: Carrier Route Category 5 TJV31
28 PROSPOTNTL PROSPOTNTL DEC11 DEC 11   0   IS-M: Planned circulation quantity for ad pre-prints  
29 XAKTUELL CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
30 WEGLANG WEGLANG ISPMNG9 QUAN 9   3   Path length for home delivery or distribution  
31 MEIWLANG MEINWLAENG MEINS UNIT 3   0   Unit of measurement for path length T006
32 TRAGEZEIT TRAGEZEIT DAUERSTD4 TIMS 6   0   IS-M: Distribution time  
33 BEABSTELLE BEABLSTH BEABLST CHAR 10   0   Main Unloading Point for Carrier Route (Default) JRTBEABST
34 XSCRIPT XSCRIPT XFELD CHAR 1   0   SAPscript comment recorded  
35 ZUSTELLER JZUSTELLER GPNR CHAR 10   0   IS-M: Carrier JGTGPNR
36 ZSGLSSCHFT VSGZUSTLR GPNR CHAR 10   0   IS-M/SD: Service Company to Which Carrier Belongs JGTGPNR
37 GPINKASSO GPINKASSO GPNR CHAR 10   0   IS-M: Field Collector JGTGPNR
38 VSGINKASSO VSGINKB GPNR CHAR 10   0   Service company for field collector (optional) JGTGPNR
39 GPRECH GPRECH GPNR CHAR 10   0   IS-M: Researcher JGTGPNR
40 VSGRCHEUR VSGRCHEUR GPNR CHAR 10   0   Researcher's Service Company JGTGPNR
41 BEWERTUNG JZBEWERT NUMC5 NUMC 5   0   IS-M: Valuation of carrier route for home del.settlement  
42 ZAHL_STOPP JZAHLSTOP DEC11 DEC 11   0   IS-M: Number of Households with "No Circulars" Notice  
43 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 JVVTPVTL BEABSTELLE JRTBEABST BEABLST KEY 1 CN
2 JVVTPVTL BEZKATE1 TJV23 BEZKATE1 REF C CN
3 JVVTPVTL BEZKATE2 TJV25 BEZKATE2 REF C CN
4 JVVTPVTL BEZKATE3 TJV27 BEZKATE3 REF C CN
5 JVVTPVTL BEZKATE4 TJV29 BEZKATE4 REF C CN
6 JVVTPVTL BEZKATE5 TJV31 BEZKATE5 REF C CN
7 JVVTPVTL EINHFAHRKM T006 MSEHI REF C CN
8 JVVTPVTL EINHSHLSSL T006 MSEHI REF C CN
9 JVVTPVTL FAHRKMKAT TJV13 FAHRKMKAT REF C CN
10 JVVTPVTL GPINKASSO JGTGPNR GPNR REF C CN
11 JVVTPVTL GPRECH JGTGPNR GPNR REF C CN
12 JVVTPVTL MANDT T000 MANDT KEY 1 CN
13 JVVTPVTL MEIWLANG T006 MSEHI REF C CN
14 JVVTPVTL SCHLGLDKAT TJV33 SCHLGLDKAT REF C CN
15 JVVTPVTL TOPOLOGIEK TJV11 TOPOLOGIEK REF C CN
16 JVVTPVTL TRAGEZEITK TJV15 TRAGEZEITK REF C CN
17 JVVTPVTL VSGINKASSO JGTGPNR GPNR REF C CN
18 JVVTPVTL VSGRCHEUR JGTGPNR GPNR REF C CN
19 JVVTPVTL WEGLANGKAT TJV35 WEGLANGKAT REF C CN
20 JVVTPVTL ZSGLSSCHFT JGTGPNR GPNR REF C CN
21 JVVTPVTL ZUSTELLER JGTGPNR GPNR REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in