SAP ABAP Table JHVPRDFI (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure JHVPRDFI   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 AVM_NR AVM_NR AVM_NR CHAR 10   0   IS-M/AM: Sales Document Number JHAK
3 POS_NR POS_NR AVM_PNR NUMC 3   0   IS-M: Order Item Number JHAP
4 UPOS_NR UPOS_NR AVM_UPNR NUMC 4   0   IS-M: Order Sub-Item Number JHAUA
5 EIN_NR EIN_NR AVMENR NUMC 6   0   IS-M: Schedule Line JHAE
6 MOTIV MOTIV_NR PAM_MOTIV NUMC 6   0   IS-M: Ad Spec Number (Ad)  
7 UR_BELEINH UR_BELEINH BELEINH CHAR 10   0   IS-M: Initial Booking Unit for the OPM Item JJTBE
8 BELEGEINH BE_BASIS BELEINH CHAR 10   0   IS-M: Basic Booking Unit JJTBE
9 E_BELEINH E_BE_BASIS BELEINH CHAR 10   0   IS-M: Publication Basic Booking Unit JJTBE
10 INHK_PLAZ INHK_PLAZ INHALTSKOM CHAR 8   0   IS-M: Positioning content component JJTIKO
11 INHK_SOVER INHK_SOVER INHALTSKOM CHAR 8   0   IS-M: Special Publication Content Component JJTIKO
12 E_TERMIN E_TERMIN DATUM DATS 8   0   IS-M: Publication Date  
13 E_HEFT E_HEFT PAM_PERIOD CHAR 14   0   IS-M: Publication Copy Number  
14 AENVERS_NR AENVERS_NR AENVERS_NR NUMC 4   0   IS-M: Last Change Version for Technical System  
15 XANNSCHLAB XANNSCHLAB XFELD CHAR 1   0   IS-M: Order Deadline is Past  
16 XSTPLAZ XSTPLAZ XFELD CHAR 1   0   IS-M: Positioned indicator  
17 XBELICHTET XBELICHTET XFELD CHAR 1   0   IS-M: "Exposed" Indicator  
18 XERSCH XERSCH XFELD CHAR 1   0   IS-M: Schedule Line Published Indicator  
19 SEITE_FSPEA SEITE_FSP SEITE_FSP CHAR 4   0   IS-M: Page/column format TJJ47
20 XSTORNIERT XSTORNIERT XFELD CHAR 1   0   IS-M: Canceled Order Object Indicator  
21 STATUSK STATUSK PAM_STATUS CHAR 2   0   IS-M: Status  
22 MOTIVSTAT MOTIVSTAT PAM_STATUS CHAR 2   0   IS-M: Ad spec status  
23 MOTAENVNR AENVERS_NR AENVERS_NR NUMC 4   0   IS-M: Last Change Version for Technical System  
24 MOTIVID MOTIVID MOTIVID CHAR 12   0   IS-M: Assigned ad spec/ad spec file in technical system  
25 AZART_GEST AZART_GEST AZART_GEST CHAR 4   0   IS-M: Design Ad Type TJJ19
26 HOEHE_I HOEHE_I GROESSE QUAN 7   3   IS-M: Actual height of the ad spec  
27 HOEHE_I_EH ISPEINH_H ISPEINH_H UNIT 3   0   IS-M: Unit of Measure for Height TJH61
28 BREITE_I BREITE_I GROESSE QUAN 7   3   IS-M: Actual Ad Spec Width  
29 BREITE_IEH BREITE_SEH ISPEINHEIT UNIT 3   0   IS-M/AM: Unit of Measure for Width TJH57
30 HOEHE_T HOEHE_T GROESSE QUAN 7   3   IS-M: Technical height  
31 HOEHE_T_EH ISPEINH_H ISPEINH_H UNIT 3   0   IS-M: Unit of Measure for Height TJH61
32 BREITE_T BREITE_T GROESSE QUAN 7   3   IS-M: Technical Width Specification  
33 BREITE_TEH BREITE_SEH ISPEINHEIT UNIT 3   0   IS-M/AM: Unit of Measure for Width TJH57
34 HOEHE_S HOEHE_S GROESSE QUAN 7   3   IS-M: Planned Height of the Ad Spec  
35 HOEHE_S_EH ISPEINH_H ISPEINH_H UNIT 3   0   IS-M: Unit of Measure for Height TJH61
36 BREITE_S BREITE_S GROESSE QUAN 7   3   IS-M: Planned Ad Spec Width  
37 BREITE_SEH BREITE_SEH ISPEINHEIT UNIT 3   0   IS-M/AM: Unit of Measure for Width TJH57
38 NUTZFL_ANT NUTZFL_ANT PROZENT100 NUMC 3   0   IS-M: Share of Technical Area used for Ad Spec  
39 ZUS_BERECH MEINH_ZUS ISPEINHEIT UNIT 3   0   IS-M: Additional Unit of Measure for Settlement TJH57
40 ZUS_MENGE BER_MENGE GROESSE QUAN 7   3   IS-M: Number of Additional Ad Spec Calculation Units  
41 SEITE_FSP SEITE_FSP SEITE_FSP CHAR 4   0   IS-M: Page/column format TJJ47
42 AZART_FARB AZART_FARB AZART_FARB CHAR 4   0   IS-M: Color Scheme Ad Type TJJ11
43 AZFARB_IST AZFARB_IST AZART_FARB CHAR 4   0   IS-M: Actual Color Scheme Ad Type TJJ11
44 GRUNFARBEN FARBNAME FARBNAME CHAR 8   0   IS-M: Color Name TJH33
45 ZUSATZFA1 FARBNAME FARBNAME CHAR 8   0   IS-M: Color Name TJH33
46 ZUSATZFA2 FARBNAME FARBNAME CHAR 8   0   IS-M: Color Name TJH33
47 ZUSATZFA3 FARBNAME FARBNAME CHAR 8   0   IS-M: Color Name TJH33
48 TYPO_NR TYPO_NR TYPONR CHAR 8   0   IS-M: Typography Number  
49 RAHMENTYP RAHMENTYP RAHMENTYP CHAR 8   0   IS-M: Border Type TJH35
50 RAHMENSTAE RAHMENSTAE NUM2 NUMC 2   0   IS-M: Border Width  
51 RAHMENEINH RAHMENEINH MEINS UNIT 3   0   IS-M: Unit of measurement for border width T006
52 INVERSKNZ INVERSKNZ XFELD CHAR 1   0   IS-M: Reversed Indicator  
53 RASTER RASTERUNG RASTERUNG CHAR 2   0   IS-M: Grid Spacing TJH37
54 STICHW STICHW TEXT40 CHAR 40   0   IS-M: Keyword  
55 TEXTSPITZE TEXTSPITZE TEXT25 CHAR 25   0   IS-M: Ad Text Header  
56 BILOZ_ANZ BILOZ_ANZ NUMC2 NUMC 2   0   IS-M: Amount of Artwork Assigned to the Ad Spec  
57 AZART_AREA AZART_AREA AZART_AREA CHAR 4   0   IS-M/AM: Fixed Format Proposal /Ad Dimensions TJJ13
58 VKORG VKORG VKORG CHAR 4   0   Sales Organization TJHVBER
59 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TJHVBER
60 SPART SPART SPART CHAR 2   0   Division TJHVBER
61 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
62 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVKBZ
63 AUART AUART_PAM AUART_PAM CHAR 4   0   IS-M: Sales Document Type TJHAK
64 PSTYV PSTYV_PAM PSTYV_PAM CHAR 4   0   IS-M: Item Category for Sales Document TJHAP
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JHVPRDFI AUART TJHAK AUART KEY 1 CN
2 JHVPRDFI AVM_NR JHAK AVM_NR KEY 1 CN
3 JHVPRDFI AZART_AREA TJJ13 AZART_AREA REF 1 CN
4 JHVPRDFI AZART_FARB TJJ11 AZART_FARB    
5 JHVPRDFI AZART_GEST TJJ19 AZART_GEST REF 1 CN
6 JHVPRDFI AZFARB_IST TJJ11 AZART_FARB REF 1 CN
7 JHVPRDFI BELEGEINH JJTBE BELEINH REF 1 CN
8 JHVPRDFI BREITE_IEH TJH57 ISPEINHEIT REF 1 CN
9 JHVPRDFI BREITE_SEH TJH57 ISPEINHEIT REF 1 CN
10 JHVPRDFI BREITE_TEH TJH57 ISPEINHEIT REF 1 CN
11 JHVPRDFI EIN_NR JHAE EIN_NR KEY 1 CN
12 JHVPRDFI E_BELEINH JJTBE BELEINH REF 1 CN
13 JHVPRDFI GRUNFARBEN TJH33 FARBNAME 1 CN
14 JHVPRDFI HOEHE_I_EH TJH61 ISPEINH_H REF 1 CN
15 JHVPRDFI HOEHE_S_EH TJH61 ISPEINH_H REF 1 CN
16 JHVPRDFI HOEHE_T_EH TJH61 ISPEINH_H REF 1 CN
17 JHVPRDFI INHK_PLAZ JJTIKO INHALTSKOM REF 1 CN
18 JHVPRDFI INHK_SOVER JJTIKO INHALTSKOM REF 1 CN
19 JHVPRDFI MANDT T000 MANDT KEY 1 CN
20 JHVPRDFI POS_NR JHAP POS_NR KEY 1 CN
21 JHVPRDFI PSTYV TJHAP PSTYV REF 1 CN
22 JHVPRDFI RAHMENEINH T006 MSEHI REF 1 CN
23 JHVPRDFI RAHMENTYP TJH35 RAHMENTYP 1 CN
24 JHVPRDFI RASTER TJH37 RASTER 1 CN
25 JHVPRDFI SEITE_FSP TJJ47 SEITE_FSP REF 1 CN
26 JHVPRDFI SEITE_FSPEA TJJ47 SEITE_FSP REF 1 CN
27 JHVPRDFI SPART TJHVBER SPART 1 CN
28 JHVPRDFI UPOS_NR JHAUA UPOS_NR KEY 1 CN
29 JHVPRDFI UR_BELEINH JJTBE BELEINH REF 1 CN
30 JHVPRDFI VKBUR TVKBZ VKBUR C CN
31 JHVPRDFI VKGRP TVBVK VKGRP C CN
32 JHVPRDFI VKORG TJHVBER VKORG 1 CN
33 JHVPRDFI VTWEG TJHVBER VTWEG 1 CN
34 JHVPRDFI ZUSATZFA1 TJH33 FARBNAME 1 CN
35 JHVPRDFI ZUSATZFA2 TJH33 FARBNAME 1 CN
36 JHVPRDFI ZUSATZFA3 TJH33 FARBNAME 1 CN
37 JHVPRDFI ZUS_BERECH TJH57 ISPEINHEIT REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in