SAP ABAP Table JHADRV (IS-M/AM: OPM Ad Spec Master)
Hierarchy
☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
Table Category TRANSP    Transparent table 
Transparent table JHADRV   Table Relationship Diagram
Short Description IS-M/AM: OPM Ad Spec Master    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
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 JHAK
3 DRVORL_NR DRVORL_NR DRVORL_NR NUMC 6   0   IS-M: Ad Spec Master  
4 DRVORLART VORLART AZART_VORL CHAR 4   0   IS-M: Ad Spec Master Type TJJ21
5 DRV_NOTIZ DRV_NOTIZ TEXT50 CHAR 50   0   IS-M: Note for Ad Spec Master  
6 DRVORL_IN DRVORL_IN GPNR CHAR 10   0   IS-M: Ad Spec Masters Holder *
7 DRV_IN_AP ISM_CP_ASM_HOLDER BU_PARTNER CHAR 10   0   IS-M: Contact Person for the Ad Spec Masters Holder *
8 DRVORL_EM DRVORL_EM GPNR CHAR 10   0   IS-M: Ad Spec Master Recipient in the Event of Return *
9 DRV_EM_AP ISM_CP_ASM_RECIPIENT BU_PARTNER CHAR 10   0   IS-M: Contact Person for the Ad Spec Masters Recipient *
10 DRVORL_SE DRVORL_SE GPNR CHAR 10   0   IS-M: Ad Spec Master Sender (Deliverer) *
11 DRV_SE_AP ISM_CP_ASM_SENDER BU_PARTNER CHAR 10   0   IS-M: Contact Person for Ad Spec Masters Sender *
12 DRVORL_TA DRVORL_TA GPNR CHAR 10   0   IS-M: Business Partner for Tech.Management of Ad Spec Mstrs *
13 DRV_TA_AP ISM_CP_ASM_TECH_PROC BU_PARTNER CHAR 10   0   IS-M: Contact Person for Tech.Management of Ad Spec Masters *
14 WEITERBEAR ISM_AD_SPEC_MST_SUB_PROCESSOR USERNAME CHAR 12   0   IS-M: Subsequent Processor for Ad Spec Masters SOUC
15 XRUECKSEND XRUECKSEND XFELD CHAR 1   0   IS-M: Return Ad Spec Masters Indicator  
16 DRV_RFTERM DRV_RFTERM DATUM DATS 8   0   IS-M/AM: Reminder Date  
17 XDRVRFTMAN XDRVRFTMAN XFELD CHAR 1   0   IS-M: Reminder date changed manually indicator  
18 DRV_RSTERM DRV_RSTERM DATUM DATS 8   0   IS-M/AM: Return Date for Ad Spec Masters  
19 LOEKZ LOEKZ_ISP XFELD CHAR 1   0   Deletion Indicator for Master Data in Media Sales & Dist.  
20 XDRVORLKOM XDRVORLKOM XFELD CHAR 1   0   IS-M: Note for Ad Spec Master Exists Indicator  
21 ACT_DRV_LT DRV_LTNR NUMC6 NUMC 6   0   IS-M: Current Routing Bag Number  
22 PRE_DRV_LT PRE_DRV_LT DRVORL_NR NUMC 6   0   IS-M: Preceding Ad Spec Master Number (Last Routing Bag) *
23 VORL_AVMNR VORL_AVMNR AVM_NR CHAR 10   0   IS-M: Order Number of the Preceding Document JHAK
24 VORL_DRVLNR VORL_DRVLNR DRVORL_NR NUMC 6   0   IS-M: Template Ad Spec Master JHADRV
25 .INCLUDE       0   0   IS-M/AM: Include For Ad Spec Master Status  
26 XDRV_UNV XDRV_UNV XFELD CHAR 1   0   IS-M: Ad Spec Master Incomplete Status  
27 XDRV_VOLL XDRV_VOLL XFELD CHAR 1   0   IS-M: Ad Spec Master Complete Status  
28 XDRV_WEIT XDRV_WEIT XFELD CHAR 1   0   IS-M: Ad Spec Master Forwarded Status  
29 XDRV_ERL XDRV_ERL XFELD CHAR 1   0   IS-M: Ad Spec Master Completed Status  
30 XDRV_RUECK XDRV_RUECK XFELD CHAR 1   0   IS-M: Ad Spec Master Status Returned  
31 XDRV_LTPR XDRV_LTPR XFELD CHAR 1   0   IS-M: Routing Bag Printed Indicator  
32 .INCLUDE       0   0   Created-By Data (Medium Scope)  
33 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
34 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
35 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
36 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
37 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
38 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
39 .INCLUDE       0   0   IS-M: include for further communication camera ready copies  
40 IN_NAME DRV_NAME TEXT50 CHAR 50   0   IS-M: Name for Ad Spec Master  
41 IN_TELF DRV_TEL TEXT30 CHAR 30   0   IS-M: Telephone Number for Ad Spec Master  
42 IN_TELX DRV_FAX TEXT30 CHAR 30   0   IS-M: Telefax Number for Ad Spec Master  
43 EM_NAME DRV_NAME TEXT50 CHAR 50   0   IS-M: Name for Ad Spec Master  
44 EM_TELF DRV_TEL TEXT30 CHAR 30   0   IS-M: Telephone Number for Ad Spec Master  
45 EM_TELX DRV_FAX TEXT30 CHAR 30   0   IS-M: Telefax Number for Ad Spec Master  
46 SE_NAME DRV_NAME TEXT50 CHAR 50   0   IS-M: Name for Ad Spec Master  
47 SE_TELF DRV_TEL TEXT30 CHAR 30   0   IS-M: Telephone Number for Ad Spec Master  
48 SE_TELX DRV_FAX TEXT30 CHAR 30   0   IS-M: Telefax Number for Ad Spec Master  
49 TA_NAME DRV_NAME TEXT50 CHAR 50   0   IS-M: Name for Ad Spec Master  
50 TA_TELF DRV_TEL TEXT30 CHAR 30   0   IS-M: Telephone Number for Ad Spec Master  
51 TA_TELX DRV_FAX TEXT30 CHAR 30   0   IS-M: Telefax Number for Ad Spec Master  
52 USED_POSART AVMPOS_ART AVMPOS_ART CHAR 2   0   IS-M: Order-Publishing-Media - Item Type TJH17
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JHADRV AVM_NR JHAK AVM_NR KEY 1 CN
2 JHADRV DRVORLART TJJ21 AZART_VORL REF 1 CN
3 JHADRV MANDT T000 MANDT KEY 1 CN
4 JHADRV USED_POSART TJH17 AVMPOS_ART    
5 JHADRV VORL_AVMNR JHAK AVM_NR REF 1 CN
6 JHADRV VORL_DRVLNR JHADRV DRVORL_NR REF 1 CN
7 JHADRV WEITERBEAR SOUC SAPNAM 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in