1. Home
  2. Resources
  3. SAP Tables
  4. JHADRV - IS-M/AM: OPM Ad Spec Master

SAP Table JHADRV

IS-M/AM: OPM Ad Spec Master

JHADRV (IS-M/AM: OPM Ad Spec Master) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link JHADRV to other SAP tables.

JHADRV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AVM_NR IS-M/AM: Sales Document Number AVM_NR JHAK CHAR 10 0
DRVORL_NR IS-M: Ad Spec Master DRVORL_NR NUMC 6 0
DRVORLART IS-M: Ad Spec Master Type VORLART TJJ21 CHAR 4 0
DRV_NOTIZ IS-M: Note for Ad Spec Master DRV_NOTIZ CHAR 50 0
DRVORL_IN IS-M: Ad Spec Masters Holder DRVORL_IN CHAR 10 0
DRV_IN_AP IS-M: Contact Person for the Ad Spec Masters Holder ISM_CP_ASM_HOLDER CHAR 10 0
DRVORL_EM IS-M: Ad Spec Master Recipient in the Event of Return DRVORL_EM CHAR 10 0
DRV_EM_AP IS-M: Contact Person for the Ad Spec Masters Recipient ISM_CP_ASM_RECIPIENT CHAR 10 0
DRVORL_SE IS-M: Ad Spec Master Sender (Deliverer) DRVORL_SE CHAR 10 0
DRV_SE_AP IS-M: Contact Person for Ad Spec Masters Sender ISM_CP_ASM_SENDER CHAR 10 0
DRVORL_TA IS-M: Business Partner for Tech.Management of Ad Spec Mstrs DRVORL_TA CHAR 10 0
DRV_TA_AP IS-M: Contact Person for Tech.Management of Ad Spec Masters ISM_CP_ASM_TECH_PROC CHAR 10 0
WEITERBEAR IS-M: Subsequent Processor for Ad Spec Masters ISM_AD_SPEC_MST_SUB_PROCESSOR SOUC CHAR 12 0
XRUECKSEND IS-M: Return Ad Spec Masters Indicator XRUECKSEND CHAR 1 0
X Yes
NULL No
DRV_RFTERM IS-M/AM: Reminder Date DRV_RFTERM DATS 8 0
XDRVRFTMAN IS-M: Reminder date changed manually indicator XDRVRFTMAN CHAR 1 0
X Yes
NULL No
DRV_RSTERM IS-M/AM: Return Date for Ad Spec Masters DRV_RSTERM DATS 8 0
LOEKZ Deletion Indicator for Master Data in Media Sales & Dist. LOEKZ_ISP CHAR 1 0
X Yes
NULL No
XDRVORLKOM IS-M: Note for Ad Spec Master Exists Indicator XDRVORLKOM CHAR 1 0
X Yes
NULL No
ACT_DRV_LT IS-M: Current Routing Bag Number DRV_LTNR NUMC 6 0
PRE_DRV_LT IS-M: Preceding Ad Spec Master Number (Last Routing Bag) PRE_DRV_LT NUMC 6 0
VORL_AVMNR IS-M: Order Number of the Preceding Document VORL_AVMNR JHAK CHAR 10 0
VORL_DRVLNR IS-M: Template Ad Spec Master VORL_DRVLNR JHADRV NUMC 6 0
XDRV_UNV IS-M: Ad Spec Master Incomplete Status XDRV_UNV CHAR 1 0
X Yes
NULL No
XDRV_VOLL IS-M: Ad Spec Master Complete Status XDRV_VOLL CHAR 1 0
X Yes
NULL No
XDRV_WEIT IS-M: Ad Spec Master Forwarded Status XDRV_WEIT CHAR 1 0
X Yes
NULL No
XDRV_ERL IS-M: Ad Spec Master Completed Status XDRV_ERL CHAR 1 0
X Yes
NULL No
XDRV_RUECK IS-M: Ad Spec Master Status Returned XDRV_RUECK CHAR 1 0
X Yes
NULL No
XDRV_LTPR IS-M: Routing Bag Printed Indicator XDRV_LTPR CHAR 1 0
X Yes
NULL No
ERFUSER Created By ERFUSER CHAR 12 0
ERFDATE Created On ERFDATE DATS 8 0
ERFTIME Time Created ERFTIME TIMS 6 0
AENUSER Last Changed By AENUSER CHAR 12 0
AENDATE Date of Last Change AENDATE DATS 8 0
AENTIME Time of Last Change AENTIME TIMS 6 0
IN_NAME IS-M: Name for Ad Spec Master DRV_NAME CHAR 50 0
IN_TELF IS-M: Telephone Number for Ad Spec Master DRV_TEL CHAR 30 0
IN_TELX IS-M: Telefax Number for Ad Spec Master DRV_FAX CHAR 30 0
EM_NAME IS-M: Name for Ad Spec Master DRV_NAME CHAR 50 0
EM_TELF IS-M: Telephone Number for Ad Spec Master DRV_TEL CHAR 30 0
EM_TELX IS-M: Telefax Number for Ad Spec Master DRV_FAX CHAR 30 0
SE_NAME IS-M: Name for Ad Spec Master DRV_NAME CHAR 50 0
SE_TELF IS-M: Telephone Number for Ad Spec Master DRV_TEL CHAR 30 0
SE_TELX IS-M: Telefax Number for Ad Spec Master DRV_FAX CHAR 30 0
TA_NAME IS-M: Name for Ad Spec Master DRV_NAME CHAR 50 0
TA_TELF IS-M: Telephone Number for Ad Spec Master DRV_TEL CHAR 30 0
TA_TELX IS-M: Telefax Number for Ad Spec Master DRV_FAX CHAR 30 0
USED_POSART IS-M: Order-Publishing-Media - Item Type AVMPOS_ART TJH17 CHAR 2 0

JHADRV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JHADRV AVM_NR JHADRV MANDT JHAK IS-M/AM: Order-Publishing-Media (Header Data) MANDT
JHADRV AVM_NR JHADRV AVM_NR JHAK IS-M/AM: Order-Publishing-Media (Header Data) AVM_NR
JHADRV DRVORLART JHADRV DRVORLART TJJ21 IS-M/AM: Template Type for Ad Spec Masters AZART_VORL
JHADRV DRVORLART JHADRV MANDT TJJ21 IS-M/AM: Template Type for Ad Spec Masters MANDT
JHADRV MANDT JHADRV MANDT T000 Clients MANDT
JHADRV USED_POSART JHADRV MANDT TJH17 IS-M/AM: OPM Item Type MANDT
JHADRV USED_POSART JHADRV USED_POSART TJH17 IS-M/AM: OPM Item Type AVMPOS_ART
JHADRV VORL_AVMNR JHADRV MANDT JHAK IS-M/AM: Order-Publishing-Media (Header Data) MANDT
JHADRV VORL_AVMNR JHADRV VORL_AVMNR JHAK IS-M/AM: Order-Publishing-Media (Header Data) AVM_NR
JHADRV VORL_DRVLNR JHADRV VORL_DRVLNR JHADRV IS-M/AM: OPM Ad Spec Master DRVORL_NR
JHADRV VORL_DRVLNR JHADRV MANDT JHADRV IS-M/AM: OPM Ad Spec Master MANDT
JHADRV VORL_DRVLNR JHADRV AVM_NR JHADRV IS-M/AM: OPM Ad Spec Master AVM_NR
JHADRV WEITERBEAR JHADRV WEITERBEAR SOUC SAPoffice: Inverse user (SAP user) SAPNAM
JHADRV WEITERBEAR JHADRV MANDT SOUC SAPoffice: Inverse user (SAP user) MANDT