SAP ABAP Table JHVMOTIV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVMOTIV	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
5	DRVORLART	☐	VORLART	AZART_VORL	CHAR	4	0	IS-M: Ad Spec Master Type	TJJ21
6	DRV_NOTIZ	☐	DRV_NOTIZ	TEXT50	CHAR	50	0	IS-M: Note for Ad Spec Master
7	DRVORL_IN	☐	DRVORL_IN	GPNR	CHAR	10	0	IS-M: Ad Spec Masters Holder
8	DRV_IN_AP	☐	ISM_CP_ASM_HOLDER	BU_PARTNER	CHAR	10	0	IS-M: Contact Person for the Ad Spec Masters Holder
9	DRVORL_EM	☐	DRVORL_EM	GPNR	CHAR	10	0	IS-M: Ad Spec Master Recipient in the Event of Return
10	DRV_EM_AP	☐	ISM_CP_ASM_RECIPIENT	BU_PARTNER	CHAR	10	0	IS-M: Contact Person for the Ad Spec Masters Recipient
11	DRVORL_SE	☐	DRVORL_SE	GPNR	CHAR	10	0	IS-M: Ad Spec Master Sender (Deliverer)
12	DRV_SE_AP	☐	ISM_CP_ASM_SENDER	BU_PARTNER	CHAR	10	0	IS-M: Contact Person for Ad Spec Masters Sender
13	DRVORL_TA	☐	DRVORL_TA	GPNR	CHAR	10	0	IS-M: Business Partner for Tech.Management of Ad Spec Mstrs
14	DRV_TA_AP	☐	ISM_CP_ASM_TECH_PROC	BU_PARTNER	CHAR	10	0	IS-M: Contact Person for Tech.Management of Ad Spec Masters
15	WEITERBEAR	☐	ISM_AD_SPEC_MST_SUB_PROCESSOR	USERNAME	CHAR	12	0	IS-M: Subsequent Processor for Ad Spec Masters	SOUC
16	XRUECKSEND	☐	XRUECKSEND	XFELD	CHAR	1	0	IS-M: Return Ad Spec Masters Indicator
17	DRV_RFTERM	☐	DRV_RFTERM	DATUM	DATS	8	0	IS-M/AM: Reminder Date
18	XDRVRFTMAN	☐	XDRVRFTMAN	XFELD	CHAR	1	0	IS-M: Reminder date changed manually indicator
19	DRV_RSTERM	☐	DRV_RSTERM	DATUM	DATS	8	0	IS-M/AM: Return Date for Ad Spec Masters
20	LOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
21	XDRVORLKOM	☐	XDRVORLKOM	XFELD	CHAR	1	0	IS-M: Note for Ad Spec Master Exists Indicator
22	ACT_DRV_LT	☐	DRV_LTNR	NUMC6	NUMC	6	0	IS-M: Current Routing Bag Number
23	PRE_DRV_LT	☐	PRE_DRV_LT	DRVORL_NR	NUMC	6	0	IS-M: Preceding Ad Spec Master Number (Last Routing Bag)
24	VORL_AVMNR	☐	VORL_AVMNR	AVM_NR	CHAR	10	0	IS-M: Order Number of the Preceding Document	JHAK
25	VORL_DRVLNR	☐	VORL_DRVLNR	DRVORL_NR	NUMC	6	0	IS-M: Template Ad Spec Master	JHADRV
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	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
33	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
34	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
35	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
36	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
37	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
38	IN_NAME	☐	DRV_NAME	TEXT50	CHAR	50	0	IS-M: Name for Ad Spec Master
39	IN_TELF	☐	DRV_TEL	TEXT30	CHAR	30	0	IS-M: Telephone Number for Ad Spec Master
40	IN_TELX	☐	DRV_FAX	TEXT30	CHAR	30	0	IS-M: Telefax Number for Ad Spec Master
41	EM_NAME	☐	DRV_NAME	TEXT50	CHAR	50	0	IS-M: Name for Ad Spec Master
42	EM_TELF	☐	DRV_TEL	TEXT30	CHAR	30	0	IS-M: Telephone Number for Ad Spec Master
43	EM_TELX	☐	DRV_FAX	TEXT30	CHAR	30	0	IS-M: Telefax Number for Ad Spec Master
44	SE_NAME	☐	DRV_NAME	TEXT50	CHAR	50	0	IS-M: Name for Ad Spec Master
45	SE_TELF	☐	DRV_TEL	TEXT30	CHAR	30	0	IS-M: Telephone Number for Ad Spec Master
46	SE_TELX	☐	DRV_FAX	TEXT30	CHAR	30	0	IS-M: Telefax Number for Ad Spec Master
47	TA_NAME	☐	DRV_NAME	TEXT50	CHAR	50	0	IS-M: Name for Ad Spec Master
48	TA_TELF	☐	DRV_TEL	TEXT30	CHAR	30	0	IS-M: Telephone Number for Ad Spec Master
49	TA_TELX	☐	DRV_FAX	TEXT30	CHAR	30	0	IS-M: Telefax Number for Ad Spec Master
50	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	JHVMOTIV	AVM_NR	JHAK	AVM_NR	KEY	1	CN
2	JHVMOTIV	DRVORLART	TJJ21	AZART_VORL	REF	1	CN
3	JHVMOTIV	MANDT	T000	MANDT	KEY	1	CN
4	JHVMOTIV	USED_POSART	TJH17	AVMPOS_ART
5	JHVMOTIV	VORL_AVMNR	JHAK	AVM_NR	REF	1	CN
6	JHVMOTIV	VORL_DRVLNR	JHADRV	DRVORL_NR	REF	1	CN
7	JHVMOTIV	WEITERBEAR	SOUC	SAPNAM		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in