JHVTBED SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




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

JHVTBED 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 JHVTBED table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include VKORG (Sales Organization), VTWEG (Distribution Channel), SPART (Division), TBEDNR (IS-M: Rate Requirement Number).. 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 JHVTBED 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
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
TBEDNRIS-M: Rate Requirement Number TBEDNRCHAR5ALPHATBEDNR
GUELTIGABIS-M: 'Valid From' Date DATEVALFRMDATS8DATUM
GUELTIGBISIS-M: 'Valid To' Date DATEVALTODATS8DATUM
XLOESCHVMDeletion Flag for Master Data in Media Sales & Distribution LOEVM_ISPCHAR1XFELD
KURZTEXTIS-M: Short Text BEZEICHN15CHAR15TEXT15
ZUOFUNKTIS-M: Assignment Function (Inclusive, Exclusive) JZFKTCHAR1JZUORDFUNK
AVMPOS_ARTIS-M: Order-Publishing-Media - Item Type AVMPOS_ARTCHAR2TJH17AVMPOS_ART
POSTYPIS-M: Item Category for Sales Document PSTYV_PAMCHAR4TJHAPPSTYV_PAM
KUKARRIS-M: Customer Profile JKUKARRCHAR2TJJ95ALPHAJKUKARR
KONDAPrice group (customer) KONDACHAR2T188KONDAVKA
XORTSPREISIS-M/AM: Local Customer Indicator XORTSPREISCHAR1XFELD
GGSCHFTIS-M: Barter Deal GGSCHFTCHAR2GGSCHFT
BELEINHIS-M/AM: Booking Unit BELEGEINHCHAR10JJTBEALPHABELEINHJBEMJJ1
INHK_TECH2IS-M: Special Publication Content Component INHK_SOVERCHAR8JJTIKOALPHAINHALTSKOMJJ1
INHK_KFMIS-M: Business Content Component INHK_KFMCHAR8JJTIKOALPHAINHALTSKOMJJ1
AZART_AREAIS-M/AM: Fixed Format Proposal /Ad Dimensions AZART_AREACHAR4TJJ13ALPHAAZART_AREAMJHAZART_AREA
AZART_FARBIS-M: Color Scheme Ad Type AZART_FARBCHAR4TJJ11ALPHAAZART_FARBJHF
AZART_GESTIS-M: Design Ad Type AZART_GESTCHAR4TJJ19ALPHAAZART_GESTJH4
AZART_FORMIS-M: Shape Ad Type AZART_FORMCHAR4TJJ17ALPHAAZART_FORM
AZART_PLAZIS-M: Ad Type with Regard to General Positioning AZART_PLAZCHAR4TJJ15AZART_PLAZMJHAZART_PLAZ
SINSBEARBIS-M: Ad Insert Processing Type SINSBEARBCHAR2TJH03SIBEAR_ARTJJB
SI_TYPIS-M: Ad Insert Type SITYPCHAR2TJH29SI_TYPJJ7
MATNRIS-M: Service material number MATNR_DIENCHAR18JJTDIENALPHAMATNR_DIENJJD
DIENTYPIS-M: Service Type DIENTYPCHAR4TJH71DIENTYP
ERFUSERCreated By ERFUSERCHAR12USNAM
ERFDATECreated On ERFDATEDATS8DATUM
ERFTIMETime Created ERFTIMETIMS6UZEIT
AENUSERLast Changed By AENUSERCHAR12USNAM
AENDATEDate of Last Change AENDATEDATS8DATUM
AENTIMETime of Last Change AENTIMETIMS6UZEIT

Key field Non-key field



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

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

SELECT SINGLE *
FROM JHVTBED
INTO CORRESPONDING FIELDS OF WA_JHVTBED
WHERE...

How to access SAP table JHVTBED

Within an ECC or HANA version of SAP you can also view further information about JHVTBED 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!