JHADRV SAP (IS-M/AM: OPM Ad Spec Master) Table details

Dictionary Type: Table
Description: IS-M/AM: OPM Ad Spec Master




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




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

JHADRV is a standard SAP Table which is used to store IS-M/AM: OPM Ad Spec Master data and is available within R/3 SAP systems depending on the version and release level.

The JHADRV table consists of various fields, each holding specific information or linking keys about IS-M/AM: OPM Ad Spec Master data available in SAP. These include AVM_NR (IS-M/AM: Sales Document Number), DRVORL_NR (IS-M: Ad Spec Master), DRVORLART (IS-M: Ad Spec Master Type), DRV_NOTIZ (IS-M: Note for Ad Spec Master).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP JHADRV table 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
DRVORL_NRIS-M: Ad Spec Master DRVORL_NRNUMC6DRVORL_NR
DRVORLARTIS-M: Ad Spec Master Type VORLARTCHAR4TJJ21ALPHAAZART_VORL
DRV_NOTIZIS-M: Note for Ad Spec Master DRV_NOTIZCHAR50TEXT50
DRVORL_INIS-M: Ad Spec Masters Holder DRVORL_INCHAR10Assigned to domainALPHAGPNR
DRV_IN_APIS-M: Contact Person for the Ad Spec Masters Holder ISM_CP_ASM_HOLDERCHAR10Assigned to domainALPHABU_PARTNERMJJ6
DRVORL_EMIS-M: Ad Spec Master Recipient in the Event of Return DRVORL_EMCHAR10Assigned to domainALPHAGPNR
DRV_EM_APIS-M: Contact Person for the Ad Spec Masters Recipient ISM_CP_ASM_RECIPIENTCHAR10Assigned to domainALPHABU_PARTNERMJJ6
DRVORL_SEIS-M: Ad Spec Master Sender (Deliverer) DRVORL_SECHAR10Assigned to domainALPHAGPNR
DRV_SE_APIS-M: Contact Person for Ad Spec Masters Sender ISM_CP_ASM_SENDERCHAR10Assigned to domainALPHABU_PARTNERMJJ6
DRVORL_TAIS-M: Business Partner for Tech.Management of Ad Spec Mstrs DRVORL_TACHAR10Assigned to domainALPHAGPNR
DRV_TA_APIS-M: Contact Person for Tech.Management of Ad Spec Masters ISM_CP_ASM_TECH_PROCCHAR10Assigned to domainALPHABU_PARTNERMJJ6
WEITERBEARIS-M: Subsequent Processor for Ad Spec Masters ISM_AD_SPEC_MST_SUB_PROCESSORCHAR12SOUCUSERNAME
XRUECKSENDIS-M: Return Ad Spec Masters Indicator XRUECKSENDCHAR1XFELD
DRV_RFTERMIS-M/AM: Reminder Date DRV_RFTERMDATS8DATUM
XDRVRFTMANIS-M: Reminder date changed manually indicator XDRVRFTMANCHAR1XFELD
DRV_RSTERMIS-M/AM: Return Date for Ad Spec Masters DRV_RSTERMDATS8DATUM
LOEKZDeletion Indicator for Master Data in Media Sales & Dist. LOEKZ_ISPCHAR1XFELD
XDRVORLKOMIS-M: Note for Ad Spec Master Exists Indicator XDRVORLKOMCHAR1XFELD
ACT_DRV_LTIS-M: Current Routing Bag Number DRV_LTNRNUMC6NUMC6
PRE_DRV_LTIS-M: Preceding Ad Spec Master Number (Last Routing Bag) PRE_DRV_LTNUMC6Assigned to domainDRVORL_NR
VORL_AVMNRIS-M: Order Number of the Preceding Document VORL_AVMNRCHAR10JHAKALPHAAVM_NR
VORL_DRVLNRIS-M: Template Ad Spec Master VORL_DRVLNRNUMC6JHADRVDRVORL_NR
XDRV_UNVIS-M: Ad Spec Master Incomplete Status XDRV_UNVCHAR1XFELD
XDRV_VOLLIS-M: Ad Spec Master Complete Status XDRV_VOLLCHAR1XFELD
XDRV_WEITIS-M: Ad Spec Master Forwarded Status XDRV_WEITCHAR1XFELD
XDRV_ERLIS-M: Ad Spec Master Completed Status XDRV_ERLCHAR1XFELD
XDRV_RUECKIS-M: Ad Spec Master Status Returned XDRV_RUECKCHAR1XFELD
XDRV_LTPRIS-M: Routing Bag Printed Indicator XDRV_LTPRCHAR1XFELD
ERFUSERCreated By ERFUSERCHAR12USNAM
ERFDATECreated On ERFDATEDATS8DATUM
ERFTIMETime Created ERFTIMETIMS6UZEIT
AENUSERLast Changed By AENUSERCHAR12USNAM
AENDATEDate of Last Change AENDATEDATS8DATUM
AENTIMETime of Last Change AENTIMETIMS6UZEIT
IN_NAMEIS-M: Name for Ad Spec Master DRV_NAMECHAR50TEXT50
IN_TELFIS-M: Telephone Number for Ad Spec Master DRV_TELCHAR30TEXT30
IN_TELXIS-M: Telefax Number for Ad Spec Master DRV_FAXCHAR30TEXT30
EM_NAMEIS-M: Name for Ad Spec Master DRV_NAMECHAR50TEXT50
EM_TELFIS-M: Telephone Number for Ad Spec Master DRV_TELCHAR30TEXT30
EM_TELXIS-M: Telefax Number for Ad Spec Master DRV_FAXCHAR30TEXT30
SE_NAMEIS-M: Name for Ad Spec Master DRV_NAMECHAR50TEXT50
SE_TELFIS-M: Telephone Number for Ad Spec Master DRV_TELCHAR30TEXT30
SE_TELXIS-M: Telefax Number for Ad Spec Master DRV_FAXCHAR30TEXT30
TA_NAMEIS-M: Name for Ad Spec Master DRV_NAMECHAR50TEXT50
TA_TELFIS-M: Telephone Number for Ad Spec Master DRV_TELCHAR30TEXT30
TA_TELXIS-M: Telefax Number for Ad Spec Master DRV_FAXCHAR30TEXT30
USED_POSARTIS-M: Order-Publishing-Media - Item Type AVMPOS_ARTCHAR2TJH17AVMPOS_ART

Key field Non-key field



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

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

SELECT SINGLE *
FROM JHADRV
INTO CORRESPONDING FIELDS OF WA_JHADRV
WHERE...

How to access SAP table JHADRV

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