JHVGPZ02 SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from JHVGPZ02
Related tables to JHVGPZ02
Access table JHVGPZ02




Table View field list including key, data, relationships and ABAP select examples

JHVGPZ02 is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The JHVGPZ02 table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include AVM_NR (IS-M/AM: Sales Document Number), AVM_HRKNFT (IS-M/AM: Order Origin), POS_NR (IS-M: Order Item Number), GPROLLE (IS-M: Business Partner Role).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP JHVGPZ02 table view fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
AVM_NRIS-M/AM: Sales Document Number AVM_NRCHAR10JHAKALPHAAVM_NRJHAMJHA
AVM_HRKNFTIS-M/AM: Order Origin AVM_HRKNFTCHAR1AVM_HRKNFT
POS_NRIS-M: Order Item Number POS_NRNUMC3JHAPAVM_PNR
GPROLLEIS-M: Business Partner Role JPARVWCHAR2TJG39PARVWJPARVWJGR
GPNRIS-M: Business Partner Key GPNRCHAR10JGTGPNRALPHAGPNRJGPMJG0
PARZAIS-M: Partner Role Counter JPARZANUMC3JPARZA
GRUPPABRNRIS-M/AM: Billing Dataset GRUPPABRNRNUMC3JHAGAGRUPPABR
UPOS_NRIS-M: Order Sub-Item Number UPOS_NRNUMC4JHAUAVM_UPNR
EIN_NRIS-M: Schedule Line EIN_NRNUMC6JHAEAVMENR
MOTIVIS-M: Ad Spec Number (Ad) MOTIV_NRNUMC6JHAMOTPAM_MOTIV
ADRNRIS-M: Address Number JADRNRCHAR10JGTSADRALPHAJADRNR
LOGADRIS-M: Logical Address Number JLOGADRNUMC4JLOGADR
GPAGBusiness Partner: Sold-to Party GPAGCHAR10JGTGPNRALPHAGPNR
VKORGSales Organization VKORGCHAR4TJHVBERVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TJHVBERVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TJHVBERSPARTSPAC_SPART
VKGRPSales Group VKGRPCHAR3TVBVKVKGRPVKG
VKBURSales Office VKBURCHAR4TVKBZVKBURVKB
AUARTIS-M: Sales Document Type AUART_PAMCHAR4TJHAKAUART_PAMJHRMJHAUART_PAM
POS_ARTIS-M: Order-Publishing-Media - Item Type AVMPOS_ARTCHAR2TJH17AVMPOS_ART
XAGENAUFTRIS-M: Agency order indicator XAGENAUFTRCHAR1XFELD
WERBK_TYPIS-M: Combination Sale Type WKOMBI_TYPCHAR2TJH91WKOMBI_TYPMJHWKOMBI_TYP
BRAN_PAMIS-M/AM: Current Industry Sector Associated With Order Item BRAN_POSCHAR10TBRCBRACO
KAMPAGNEIS-M: Campaign (customer) KAMPAGNECHAR6TJJKAMPKAMPAGNE
VERMITT_KIS-M: Sales Agent with ID Code for Screen VERMKCHAR10VERMKJJMVERMJGPMJG0N
VERMITTLERIS-M: Sales Agent with ID Code for Screen VERMKCHAR10VERMKJJMVERMJGPMJG0N
STATUSKIS-M: Status STATUSKCHAR2PAM_STATUS
SELDAT_VONIS-M: Start Date for Item SELDAT_VONDATS8DATUM
SELDAT_BISIS-M: End Date for Items SELDAT_BISDATS8DATUM
PSTYVIS-M: Item Category for Sales Document PSTYV_PAMCHAR4TJHAPPSTYV_PAM
PRODHIS-M/AM: Product Hierarchy J_PRODHCHAR18JJT179J_PRODH
BELEG_ARTIS-M: Voucher Type (Proof) PAM_BELARTCHAR4TJJB1PAM_BELART
BELEG_ANZIS-M: Number of Voucher Copies PAM_BELANZNUMC5NUMC5
PACKAGE_IDPackage ISM_PACKAGE_IDCHAR10JJTPCALPHAISM_PACKAGE_ID
XDELETED_LOGICALIndicator: Order Object is Logically Deleted ISM_XDELETED_LOGICALCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table JHVGPZ02 using ABAP code

The following ABAP code Example will allow you to do a basic selection on JHVGPZ02 to SELECT all data from the table
DATA: WA_JHVGPZ02 TYPE JHVGPZ02.

SELECT SINGLE *
FROM JHVGPZ02
INTO CORRESPONDING FIELDS OF WA_JHVGPZ02
WHERE...

How to access SAP table JHVGPZ02

Within an ECC or HANA version of SAP you can also view further information about JHVGPZ02 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!