SAP ABAP Table JHVWWWTEMP (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure JHVWWWTEMP   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  
2 SESSIONNO SESSIONNO SESSIONNO CHAR 10   0   IS-M: Key for Temporary Storage of Internet Data  
3 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
4 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
5 SPART SPART SPART CHAR 2   0   Division TSPA
6 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVBUR
7 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVKGR
8 AUART AUART_PAM AUART_PAM CHAR 4   0   IS-M: Sales Document Type TJHAK
9 ERSCH_T ERSCH_T DATUM DATS 8   0   IS-M: Publication Date  
10 INHK_KFM INHK_KFM INHALTSKOM CHAR 8   0   IS-M: Business Content Component JJTIKO
11 VORL_POSNR VORL_POSNR AVM_PNR NUMC 3   0   IS-M: Item number of the Preceding Item  
12 JWWWKEY JWWWKEY_JHAW JWWWKEY_IAC CHAR 10   0   IS-M/AM: Key for Order Data  
13 AVM_NR AVM_NR_WITHOUT_SEARCHHELP AVM_NR CHAR 10   0   IS-M: Order  
14 MOTIV MOTIV_NR PAM_MOTIV NUMC 6   0   IS-M: Ad Spec Number (Ad)  
15 TEC_AVM_NR TEC_AVM_NR CHAR10 CHAR 10   0   IS-M: Order number in technical system  
16 MOTIVID MOTIVID MOTIVID CHAR 12   0   IS-M: Assigned ad spec/ad spec file in technical system  
17 BELEGEINH BELEGEINH BELEINH CHAR 10   0   IS-M/AM: Booking Unit JJTBE
18 INHK_KLEV1 INHK_PUBREL INHALTSKOM CHAR 8   0   IS-M: Publication-Relevant Content Component JJTIKO
19 AZART_GEST AZART_GEST AZART_GEST CHAR 4   0   IS-M: Design Ad Type TJJ19
20 AZFARB_IST AZFARB_IST AZART_FARB CHAR 4   0   IS-M: Actual Color Scheme Ad Type TJJ11
21 GRUNFARBEI FARBNAME FARBNAME CHAR 8   0   IS-M: Color Name TJH33
22 FARBNAME1I FARBNAME FARBNAME CHAR 8   0   IS-M: Color Name TJH33
23 FARBNAME2I FARBNAME FARBNAME CHAR 8   0   IS-M: Color Name TJH33
24 FARBNAME3I FARBNAME FARBNAME CHAR 8   0   IS-M: Color Name TJH33
25 SEITE_FSP SEITE_FSP SEITE_FSP CHAR 4   0   IS-M: Page/column format TJJ47
26 XANSCHNITT XANSCHNITT XFELD CHAR 1   0   IS-M: Bled Ad Spec Indicator  
27 XUEBERBUND XUEBERBUND XFELD CHAR 1   0   IS-M: Indicates That The Ad Spec Overlaps Gutter Margin  
28 HOEHE_I HOEHE_ITMM GROESSETMM NUMC 7   0   IS-M: Actual Ad Spec Height to a Thousandth of a Unit of M.  
29 HOEHE_I_EH ISPEINH_H ISPEINH_H UNIT 3   0   IS-M: Unit of Measure for Height TJH61
30 BREITE_I BREITEITMM GROESSETMM NUMC 7   0   IS-M: Actual Ad Spec Width to Thousandth of UM  
31 BREITE_IEH BREITE_SEH ISPEINHEIT UNIT 3   0   IS-M/AM: Unit of Measure for Width TJH57
32 ANZWORT1_I ANZWOERTER GROESSETMM NUMC 7   0   IS-M: Number of Words in a Text-Based Ad in Units of 1000  
33 ANZWORT2_I ANZWOERTER GROESSETMM NUMC 7   0   IS-M: Number of Words in a Text-Based Ad in Units of 1000  
34 ANZZEIL1_I ANZZEILEN GROESSETMM NUMC 7   0   IS-M: Number of Lines for a Line-Based Ad in Units of 1000  
35 ANZZEIL2_I ANZZEILEN GROESSETMM NUMC 7   0   IS-M: Number of Lines for a Line-Based Ad in Units of 1000  
36 ANZZEICH_I ANZZEICHEN GROESSETMM NUMC 7   0   IS-M: No.of Characters for a Char.-Based Ad (1000 Units)  
37 TYPO_NR_IS TYPO_NR TYPONR CHAR 8   0   IS-M: Typography Number  
38 RAHMENTYPI RAHMENTYP RAHMENTYP CHAR 8   0   IS-M: Border Type TJH35
39 RAHMENSTAI RAHMENSTAE NUM2 NUMC 2   0   IS-M: Border Width  
40 RAHMENEINH RAHMENEINH MEINS UNIT 3   0   IS-M: Unit of measurement for border width T006
41 TEXTSPITZE TEXTSPITZE TEXT25 CHAR 25   0   IS-M: Ad Text Header  
42 INVERSKNZI INVERSKNZ XFELD CHAR 1   0   IS-M: Reversed Indicator  
43 RASTER_IST RASTERUNG RASTERUNG CHAR 2   0   IS-M: Grid Spacing TJH37
44 MOTIV_URL MOTIV_URL TEXT255 CHAR 255   0   IS-M/AM: URL for Ad Spec  
45 CHIFFRE_NR CHIFFRE CHIFFRE_NR CHAR 10   0   IS-M/AM: Box Number  
46 CHIFFRE_KZ CHIFFRE_KZ CHIFFRE_KZ CHAR 1   0   IS-M: Box Number Indicator TJH59
47 CHIFFRE_OR CHIFFRE_OR VKBUR CHAR 4   0   IS-M: Box Number Location TVBUR
48 VORL_AVMNR VORL_AVMNR AVM_NR CHAR 10   0   IS-M: Order Number of the Preceding Document  
49 VORL_MOTNR VORL_MOTNR PAM_MOTIV NUMC 6   0   IS-M: Ad Spec Template (Ad)  
50 VORL_TECID VORL_TECID MOTIVID CHAR 12   0   IS-M: Ad spec template (description in technical system)  
51 INSERENT INSERENT GPNR CHAR 10   0   IS-M: Advertiser  
52 XAGENTUR XAGENTUR XFELD CHAR 1   0   IS-M: Agency Indicator  
53 ZLSCH JZLSCH ZLSCH CHAR 1   0   IS-M: Payment Method  
54 BANKS BANKS LAND1 CHAR 3   0   Bank country key  
55 BANKL BANKK BANKK CHAR 15   0   Bank Keys  
56 BANKN BANKN BANKN CHAR 18   0   Bank account number  
57 IBAN IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
58 MNDID SEPA_MNDID ID035 CHAR 35   0   Unique Referene to Mandate per Payment Recipient  
59 XSEPAACTIVE XSEPAACTIVE XFELD CHAR 1   0   IS-M: Create SEPA Mandate with the Active Status  
60 SIGN_CITY SEPA_SIGN_CITY TEXT40 CHAR 40   0   Location of Signature  
61 SIGN_DATE SEPA_SIGN_DATE DATUM DATS 8   0   Date of Signature  
62 BANKA BANKA TEXT60 CHAR 60   0   Name of bank  
63 BKONT BKONT BKONT CHAR 2   0   Bank Control Key  
64 XEZER XEZER XFELD CHAR 1   0   Indicator: Is there collection authorization ?  
65 CGUID CARD_GUID SYSUUID RAW 16   0   GUID of a Payment Card  
66 ENCTP CCSECA_ENCTYPE CCSECA_ENCTYPE CHAR 1   0   Type of Encryption  
67 CCINS CCINS CCINS CHAR 4   0   Payment cards: Card type  
68 CCNUM CCNUM CCNUM CHAR 25   0   Payment cards: Card number  
69 DATBI DATBI DATUM DATS 8   0   Valid To Date  
70 CCTYP CCTYP CCTYP CHAR 2   0   Payment cards: Card category  
71 BKVID BU_BKVID CHAR4 CHAR 4   0   Bank details ID  
72 CCNAME CCNAME TEXT40 CHAR 40   0   Payment Cards: Name of Cardholder  
73 AUDAT AUDAT_CC DATUM DATS 8   0   Payment cards: Authorization date  
74 AUTIM AUTIM UZEIT TIMS 6   0   Payment cards: Authorization time  
75 AUNUM AUNUM CHAR10 CHAR 10   0   Payment cards: Authorization number  
76 AUTRA AUTRA CHAR15 CHAR 15   0   Payment cards: Authoriz. reference code of clearing house  
77 ISM_CVVAL ISM_CVVAL ISM_CVVAL CHAR 6   0   Card Verification Value  
78 ISM_CVVCT ISM_CVVCT ISM_CVVCT CHAR 1   0   Control Field for Card Verification Value  
79 ISM_CVVST ISM_CVVST ISM_CVVST CHAR 1   0   Usage Status of Card Verification Value  
80 ISM_RCCVV ISM_RCCVV_CC CHAR4 CHAR 4   0   Results Check for Card Verification Value TCCRC
81 ADDPAY_TYPE_1 ISM_ADDPAYMENT_TYPE ISM_ADDPAYMENT_TYPE CHAR 2   0   IS-M/SD: Additional Payment Type TJK21
82 ADDPAY_VALUE_1 ISM_ADDPAYMENT_VALUE WERT5 CURR 9   2   IS-M/SD: Additional Payment Amount  
83 WAERK_1 WAERK WAERS CUKY 5   0   SD document currency  
84 XNONRECURRING_1 ISM_ADDPAYMENT_XNONRECURRING XFELD CHAR 1   0   IS-M/SD: One-Time Additional Payment  
85 XRECURRING_1 ISM_ADDPAYMENT_XRECURRING XFELD CHAR 1   0   IS-M/SD: Additional Payment is Repeated Periodically  
86 ADDPAY_TYPE_2 ISM_ADDPAYMENT_TYPE ISM_ADDPAYMENT_TYPE CHAR 2   0   IS-M/SD: Additional Payment Type TJK21
87 ADDPAY_VALUE_2 ISM_ADDPAYMENT_VALUE WERT5 CURR 9   2   IS-M/SD: Additional Payment Amount  
88 WAERK_2 WAERK WAERS CUKY 5   0   SD document currency  
89 XNONRECURRING_2 ISM_ADDPAYMENT_XNONRECURRING XFELD CHAR 1   0   IS-M/SD: One-Time Additional Payment  
90 XRECURRING_2 ISM_ADDPAYMENT_XRECURRING XFELD CHAR 1   0   IS-M/SD: Additional Payment is Repeated Periodically  
91 MSGID SYMSGID ARBGB CHAR 20   0   Message Class  
92 MSGNO SYMSGNO SYMSGNO NUMC 3   0   Message Number  
93 MSGTY SYMSGTY SYCHAR01 CHAR 1   0   Message Type  
94 MSGV1 SYMSGV SYCHAR50 CHAR 50   0   Message Variable  
95 MSGV2 SYMSGV SYCHAR50 CHAR 50   0   Message Variable  
96 MSGV3 SYMSGV SYCHAR50 CHAR 50   0   Message Variable  
97 MSGV4 SYMSGV SYCHAR50 CHAR 50   0   Message Variable  
98 XINET_USER XINET_USER XFELD CHAR 1   0   Create Internet User with Password for BP  
99 PASSWORD_BP XUNCODE XUBCODE CHAR 40   0   New password  
100 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
101 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
102 NATXTP JNATXTP CHAR100 CHAR 100   0   Message Text with Parameters Used  
103 ICON_STATUS ICON_L4 ICON CHAR 4   0   Icon with output length 4  
104 USERALIAS USALIAS USALIAS CHAR 40   0   Internet user alias  
105 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
106 PREIS_AVM1 PREIS_AVM1 WERTV8 CURR 15   2   IS-M: Price Field 1 in the Order  
107 PREIS_AVM2 PREIS_AVM2 WERTV8 CURR 15   2   IS-M: Price Field 2 in the Order  
108 WAEHRG WAERK WAERS CUKY 5   0   SD document currency TCURC
109 JPARVW JPARVW JPARVW CHAR 2   0   IS-M: Business Partner Role  
110 GPNR GPNR GPNR CHAR 10   0   IS-M: Business Partner Key  
111 ANRED JANRED JANRED CHAR 2   0   IS-M: Form-of-Address Key TJG43
112 NAME1 NAME1_ISP NAME CHAR 35   0   IS-M: Business Partner Name  
113 NAME2 NAME2_ISP NAME CHAR 35   0   IS-M: First Name of Business Partner  
114 NAME3 NAME3_ISP NAME CHAR 35   0   IS-M: Further Name Field for Business Partner  
115 TITEL TITEL_ISP TITEL CHAR 15   0   IS-M: Title T535N
116 PSTLZ PLZ_ISP PSTLZ CHAR 10   0   IS-M: Postal Code  
117 PSTLZ_ADDON PSTLZ_ADDON CHAR4 CHAR 4   0   IS-M: Extension to 5-Character ZIP Code  
118 PSTL2 PLZPF PSTLZ CHAR 10   0   IS-M: Postal Code for PO Box  
119 PSTL2_ADDON PSTL2_ADDON CHAR4 CHAR 4   0   IS-M: Extension to 5-Character ZIP Code (PO Box)  
120 ORTPF ORTPF TEXT35 CHAR 35   0   IS-M: City for PO Box  
121 PFACH PFACH_ISP PFACH_ISP CHAR 10   0   IS-M: Post Office Box  
122 ORT01 ORT01_ISP TEXT35 CHAR 35   0   IS-M: City  
123 STRASSEWWW STRASSEWWW TEXT55 CHAR 55   0   IS-M: Street in WWW (Contains Street Name and Directionals)  
124 STRAS STRAS_ISP TEXT35 CHAR 35   0   IS-M: Street Name  
125 PREDIRECTIONAL DIRECTIONAL DIRECTIONAL CHAR 10   0   IS-M: Direction for Street TJS41
126 POSTDIRECTIONAL DIRECTIONAL DIRECTIONAL CHAR 10   0   IS-M: Direction for Street TJS41
127 HAUSNWWW HSNMRWWW HAUSNUMMER CHAR 10   0   IS-M: House Number in WWW (Contains House Number and Affix)  
128 HAUSN HSNMR1 HAUSNUMMER CHAR 10   0   IS-M: House Number  
129 HSNMR2 HSNMR2 CHAR8 CHAR 8   0   IS-M: House Number Affix  
130 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
131 ERSTADR ERSTADR ERSTADR CHAR 1   0   IS-M: Address Proposal for Alternatives  
132 ADDRSECABBREV ADDRSECABBREV ADDRSECABBREV CHAR 4   0   IS-M: Secondary Address Text  
133 ADDRSECNUMBER ADDRSECNUMBER ADDRSECNUMBER CHAR 8   0   IS-M: Secondary Address Number  
134 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
135 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
136 ISPTELVWP ISPTELVWP ISPTELVW CHAR 10   0   IS-M: Area Code (Home)  
137 ISPTELP ISPTELP ISPTEL CHAR 20   0   IS-M: Telephone Number  
138 ISPTELVWD ISPTELVWD ISPTELVW CHAR 10   0   IS-M: Area Code - Work  
139 ISPTELD ISPTELD ISPTEL CHAR 20   0   IS-M: Telephone Number  
140 ISPHANDY ISPHANDY CHAR30 CHAR 30   0   IS-M: Mobile Phone Number  
141 TELFX TELFX TEXT31 CHAR 31   0   Fax Number  
142 ISPEMAIL ISPEMAIL CHAR50LOW CHAR 50   0   IS-M: E-Mail Address  
143 UVADR_ST UVADR_AD UVADR_AD CHAR 1   0   IS-M: Coding Status of Address  
144 UVADR_PF UVADR_AD UVADR_AD CHAR 1   0   IS-M: Coding Status of Address  
145 UVADR_GK UVADR_AD UVADR_AD CHAR 1   0   IS-M: Coding Status of Address  
146 POSTEINORT JALORT ALORT CHAR 8   0   IS-M: City Number (Unique)  
147 POSTEINSTR STRASSENNR STRASSENNR CHAR 10   0   IS-M: Street Number  
148 PEINORTPF ALORT2 ALORT CHAR 8   0   IS-M: Postal Unit of City for PO Box  
149 PRIVACY_STATUS ADDRESS_PRIVACY_STATUS ADDRESS_PRIVACY_STATUS CHAR 1   0   IS-M: Status of Address As Regards Data Protection  
150 NAMZU NAMZU_ISP TITEL CHAR 15   0   IS-M: Name Affix  
151 VORSW VORSW_ISP TITEL CHAR 15   0   IS-M: Name Prefix  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JHVWWWTEMP ADDPAY_TYPE_1 TJK21 ADDPAYMENT_TYPE    
2 JHVWWWTEMP ADDPAY_TYPE_2 TJK21 ADDPAYMENT_TYPE    
3 JHVWWWTEMP ANRED TJG43 JANRED REF 1 CN
4 JHVWWWTEMP AUART TJHAK AUART REF 1 CN
5 JHVWWWTEMP AZART_GEST TJJ19 AZART_GEST REF 1 CN
6 JHVWWWTEMP AZFARB_IST TJJ11 AZART_FARB REF 1 CN
7 JHVWWWTEMP BELEGEINH JJTBE BELEINH REF 1 CN
8 JHVWWWTEMP BREITE_IEH TJH57 ISPEINHEIT REF 1 CN
9 JHVWWWTEMP CHIFFRE_KZ TJH59 CHIFFRE_KZ REF 1 CN
10 JHVWWWTEMP CHIFFRE_OR TVBUR VKBUR REF 1 CN
11 JHVWWWTEMP FARBNAME1I TJH33 FARBNAME REF 1 CN
12 JHVWWWTEMP FARBNAME2I TJH33 FARBNAME REF 1 CN
13 JHVWWWTEMP FARBNAME3I TJH33 FARBNAME 1 CN
14 JHVWWWTEMP GRUNFARBEI TJH33 FARBNAME REF 1 CN
15 JHVWWWTEMP HOEHE_I_EH TJH61 ISPEINH_H REF 1 CN
16 JHVWWWTEMP INHK_KFM JJTIKO INHALTSKOM REF 1 CN
17 JHVWWWTEMP INHK_KLEV1 JJTIKO INHALTSKOM REF 1 CN
18 JHVWWWTEMP ISM_RCCVV TCCRC RCODE    
19 JHVWWWTEMP LAND1 T005 LAND1 KEY    
20 JHVWWWTEMP POSTDIRECTIONAL TJS41 DIRECTIONAL REF 1 CN
21 JHVWWWTEMP PREDIRECTIONAL TJS41 DIRECTIONAL REF 1 CN
22 JHVWWWTEMP RAHMENEINH T006 MSEHI REF 1 CN
23 JHVWWWTEMP RAHMENTYPI TJH35 RAHMENTYP REF 1 CN
24 JHVWWWTEMP RASTER_IST TJH37 RASTER REF 1 CN
25 JHVWWWTEMP REGIO T005S BLAND REF 1 CN
26 JHVWWWTEMP SEITE_FSP TJJ47 SEITE_FSP REF 1 CN
27 JHVWWWTEMP SPART TSPA SPART REF 1 CN
28 JHVWWWTEMP SPRAS T002 SPRAS REF 1 CN
29 JHVWWWTEMP TITEL T535N TITEL    
30 JHVWWWTEMP VKBUR TVBUR VKBUR REF 1 CN
31 JHVWWWTEMP VKGRP TVKGR VKGRP REF 1 CN
32 JHVWWWTEMP VKORG TVKO VKORG REF 1 CN
33 JHVWWWTEMP VTWEG TVTW VTWEG REF 1 CN
34 JHVWWWTEMP WAEHRG TCURC WAERS    
History
Last changed by/on SAP  20131127 
SAP Release Created in