SAP ABAP Table JHVAVMACTGVZ (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure JHVAVMACTGVZ   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  
3 POS_NR POS_NR AVM_PNR NUMC 3   0   IS-M: Order Item Number  
4 GRUPPABRNR GRUPPABRNR GRUPPABR NUMC 3   0   IS-M/AM: Billing Dataset  
5 VNR JVMVVNR JVMVVNR CHAR 10   0   IS-M: Media Sales Agent Contract Number JJTVV
6 BEDNR VM_BEDNR VM_BEDNR NUMC 6   0   IS-M: Number of Media Sales Agent Contract Requirement JJTVB
7 PROVTYP PROVTYP PROVTYP CHAR 1   0   IS-M/AM: Commission Category  
8 VZUONR JH_VZUONR JH_VZUONR NUMC 2   0   IS-M/AM: Sales Agent Assignment Number (Corrections)  
9 GPAG GPAG GPNR CHAR 10   0   Business Partner: Sold-to Party JGTGPNR
10 VKORG VKORG VKORG CHAR 4   0   Sales Organization TJHVBER
11 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TJHVBER
12 SPART SPART SPART CHAR 2   0   Division TJHVBER
13 AUART AUART_PAM AUART_PAM CHAR 4   0   IS-M: Sales Document Type TJHAK
14 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
15 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVKBZ
16 AVM_HRKNFT AVM_HRKNFT AVM_HRKNFT CHAR 1   0   IS-M/AM: Order Origin  
17 POS_ART AVMPOS_ART AVMPOS_ART CHAR 2   0   IS-M: Order-Publishing-Media - Item Type TJH17
18 PSTYV PSTYV_PAM PSTYV_PAM CHAR 4   0   IS-M: Item Category for Sales Document TJHAP
19 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
20 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
21 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
22 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
23 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
24 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
25 BELEGEINH BE_BASIS BELEINH CHAR 10   0   IS-M: Basic Booking Unit JJTBE
26 UR_BELEINH UR_BELEINH BELEINH CHAR 10   0   IS-M: Initial Booking Unit for the OPM Item JJTBE
27 IHKOMP INHK_PRICE INHALTSKOM CHAR 8   0   IS-M: Content component from price hierarchy JJTIKO
28 INSERENT INSERENT GPNR CHAR 10   0   IS-M: Advertiser JHAISZ
29 BER_TERMIN BER_TERMIN DATUM DATS 8   0   IS-M: Date Services were Created for Settlement Purposes  
30 REGULIERER GPNR_RG GPNR CHAR 10   0   IS-M: Payer Business Partner JGTGPNR
31 GF_STATUS GF_STATUS PAM_STATUS CHAR 2   0   IS-M: Billing Dataset Status  
32 KALKS KALKS KALKS CHAR 1   0   Pricing procedure assigned to this customer TVKD
33 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
34 PLTYP PLTYP PLTYP CHAR 2   0   Price list type T189
35 PRSDT PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
36 SEITE_FSP SEITE_FSP SEITE_FSP CHAR 4   0   IS-M: Page/column format TJJ47
37 SEITE_FORM SEITE_FORM SEITE_FORM CHAR 2   0   IS-M: Page Format TJJ01
38 SFSP_ABR SFSP_ABR SEITE_FSP CHAR 4   0   IS-M: Column Format for Settlement TJJ47
39 AZART_AREA AZART_AREA AZART_AREA CHAR 4   0   IS-M/AM: Fixed Format Proposal /Ad Dimensions TJJ13
40 AZART_GEST AZART_GEST AZART_GEST CHAR 4   0   IS-M: Design Ad Type TJJ19
41 AZART_FORM AZART_FORM AZART_FORM CHAR 4   0   IS-M: Shape Ad Type TJJ17
42 AZART_FARB AZART_FARB AZART_FARB CHAR 4   0   IS-M: Color Scheme Ad Type TJJ11
43 AZART_SOND AZART_SOND AZART_SOND CHAR 2   0   IS-M: Ad Type - Special Handling Type TJJ49
44 KALSM KALSMASD KALSM CHAR 6   0   Sales and Distribution: Pricing Procedure in Pricing  
45 DRERZ DRERZ DRERZ CHAR 8   0   Publication JDTDRER
46 PVA PVA PVA CHAR 8   0   Edition JDTPVA
47 SI_TYP SITYP SI_TYP CHAR 2   0   IS-M: Ad Insert Type TJH29
48 SI_GEWKL ISM_SI_GEWKL SI_GEWKL CHAR 4   0   IS-M: Ad inserts weight price group TJHGEWKL
49 SI_SEKL ISM_SI_SEKL SI_SEKL CHAR 4   0   IS-M: Price Group for Ad Insert Pages TJHSEKL
50 WS_TIMESLC WS_TIMESLC WS_TIMESLC CHAR 2   0   IS-M: Commercial Time Slice TJJW1
51 WS_BLOCK WS_BLOCK WS_BLOCK CHAR 2   0   IS-M: Commercial Cluster TJJW3
52 WS_STELLE WS_STELLE NUMC3 NUMC 3   0   IS-M: Position (Sequence) Within a Commercial Cluster  
53 FORMAT_ONL FORMAT_ONL FORMAT_ONL CHAR 4   0   IS-M/AM: Format Proposal (Online)  
54 RRREL ISMRR_RELTYP ISMRR_RELTYP CHAR 1   0   IS-M/AM: Revenue Recognition Category  
55 XUVVZ XUVVZ XFELD CHAR 1   0   IS-M: Sales Agent Assignment Incomplete  
56 XSTORNIERT XSTORNIERT XFELD CHAR 1   0   IS-M: Canceled Order Object Indicator  
57 XFAKT_EE XFAKT_EE XFELD CHAR 1   0   IS-M: Billed Indicator  
58 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
59 VGRUP JVGRUP JVGRUP CHAR 6   0   IS-M: Media Sales Agent Contract Grouping TJJV1
60 VERM VERMK JJMVERM CHAR 10   0   IS-M: Sales Agent with ID Code for Screen  
61 PROSL JPROVSCHL PRSCHL CHAR 5   0   IS-M/AM: Commission Key for Media Sales Agent TJH23
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JHVAVMACTGVZ AUART TJHAK AUART KEY 1 CN
2 JHVAVMACTGVZ AZART_AREA TJJ13 AZART_AREA 1 CN
3 JHVAVMACTGVZ AZART_FARB TJJ11 AZART_FARB KEY 1 CN
4 JHVAVMACTGVZ AZART_FORM TJJ17 AZART_FORM KEY 1 CN
5 JHVAVMACTGVZ AZART_GEST TJJ19 AZART_GEST KEY 1 CN
6 JHVAVMACTGVZ AZART_SOND TJJ49 AZART_SOND REF 1 CN
7 JHVAVMACTGVZ BEDNR JJTVB BEDNR KEY 1 CN
8 JHVAVMACTGVZ BELEGEINH JJTBE BELEINH KEY 1 CN
9 JHVAVMACTGVZ DRERZ JDTDRER DRERZ REF 1 CN
10 JHVAVMACTGVZ EKORG T024E EKORG REF 1 CN
11 JHVAVMACTGVZ GPAG JGTGPNR GPNR KEY 1 CN
12 JHVAVMACTGVZ IHKOMP JJTIKO INHALTSKOM REF 1 CN
13 JHVAVMACTGVZ INSERENT JHAISZ INSERENT KEY 1 CN
14 JHVAVMACTGVZ KALKS TVKD KALKS    
15 JHVAVMACTGVZ KDGRP T151 KDGRP REF 1 CN
16 JHVAVMACTGVZ MANDT T000 MANDT KEY 1 CN
17 JHVAVMACTGVZ PLTYP T189 PLTYP REF 1 CN
18 JHVAVMACTGVZ POS_ART TJH17 AVMPOS_ART REF 1 CN
19 JHVAVMACTGVZ PROSL TJH23 PRSCHL REF 1 CN
20 JHVAVMACTGVZ PSTYV TJHAP PSTYV REF 1 CN
21 JHVAVMACTGVZ PVA JDTPVA PVA REF 1 CN
22 JHVAVMACTGVZ REGULIERER JGTGPNR GPNR REF 1 CN
23 JHVAVMACTGVZ SEITE_FORM TJJ01 SEITE_FORM KEY 1 CN
24 JHVAVMACTGVZ SEITE_FSP TJJ47 SEITE_FSP KEY 1 CN
25 JHVAVMACTGVZ SFSP_ABR TJJ47 SEITE_FSP REF 1 CN
26 JHVAVMACTGVZ SI_GEWKL TJHGEWKL SI_GEWKL REF 1 CN
27 JHVAVMACTGVZ SI_SEKL TJHSEKL SI_SEKL REF 1 CN
28 JHVAVMACTGVZ SI_TYP TJH29 SI_TYP REF 1 CN
29 JHVAVMACTGVZ SPART TJHVBER SPART 1 CN
30 JHVAVMACTGVZ UR_BELEINH JJTBE BELEINH REF 1 CN
31 JHVAVMACTGVZ VGRUP TJJV1 VGRUP REF 1 CN
32 JHVAVMACTGVZ VKBUR TVKBZ VKBUR C CN
33 JHVAVMACTGVZ VKGRP TVBVK VKGRP C CN
34 JHVAVMACTGVZ VKORG TJHVBER VKORG 1 CN
35 JHVAVMACTGVZ VNR JJTVV VNR KEY 1 CN
36 JHVAVMACTGVZ VTWEG TJHVBER VTWEG 1 CN
37 JHVAVMACTGVZ WS_BLOCK TJJW3 WS_BLOCK REF 1 CN
38 JHVAVMACTGVZ WS_TIMESLC TJJW1 WS_TIMESLC REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in