SAP ABAP Table MCJHAEADD (IS-M: Additional Fields for LIS Schedule Line/Ad Spec Data)

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	INTTAB	Structure
Structure	MCJHAEADD	Table Relationship Diagram
Short Description	IS-M: Additional Fields for LIS Schedule Line/Ad Spec Data

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	MOT_SIZE	☐	MOT_SIZE	MENGE	QUAN	13	3	IS-M: Ad spec size(actual) for update
2	MOT_SIZE_S	☐	MOT_SIZE_S	MENGE	QUAN	13	3	IS-M: Ad spec size (planned) for update
3	MOTSIZE_ME	☐	ISPEINHEIT	ISPEINHEIT	UNIT	3	0	IS-M: Unit of Measurement for Calculating Ad Spec Dimensions	TJH57
4	BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
5	DISPMENGE	☐	DSPMGE_PAM	STMENGE	DEC	9	0	IS-M: Planning Quantity for Ad Inserts
6	POSTMENGE	☐	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
7	BLGMENGE	☐	BLGMGE_PAM	STMENGE	DEC	9	0	IS-M: Delivery Quantity for Ad Insert
8	MOT_S_GS	☐	MOT_S_GS	MENGE	QUAN	13	3	IS-M: (Actual) ad spec size for updating credit memo
9	MOT_S_S_GS	☐	MOT_S_S_GS	MENGE	QUAN	13	3	IS-M: (Planned) ad spec size for updating credit memo
10	BEGRP_ST_E	☐	BEGRP_ST_E	BEGRP_STAT	CHAR	4	0	IS-M: BU Grouping: Schedule Line for Statistics	TJJ67
11	IKO_STAT_E	☐	IKO_STAT_E	INHALTSKOM	CHAR	8	0	IS-M: Statistical content component schedule line	JJTIKO
12	MOTIV	☐	MOTIV_NR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Number (Ad)	*
13	MOTIVSTAT	☐	MOTIVSTAT	PAM_STATUS	CHAR	2	0	IS-M: Ad spec status
14	NOTIZ	☐	MOTIVNOTIZ	TEXT50	CHAR	50	0	IS-M: Note for Ad Spec Design
15	MOTIVID	☐	MOTIVID	MOTIVID	CHAR	12	0	IS-M: Assigned ad spec/ad spec file in technical system
16	VORL_AVMNR	☐	VORL_AVMNR	AVM_NR	CHAR	10	0	IS-M: Order Number of the Preceding Document	*
17	VORL_MOTNR	☐	VORL_MOTNR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Template (Ad)	*
18	VORL_TECID	☐	VORL_TECID	MOTIVID	CHAR	12	0	IS-M: Ad spec template (description in technical system)
19	DRVORLART	☐	VORLART	AZART_VORL	CHAR	4	0	IS-M: Ad Spec Master Type	*
20	DRVORLKOM	☐	DRVORLKOM	TEXT35	CHAR	35	0	IS-M: Comment Field for Ad Spec Master
21	AZART_SOND	☐	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	*
22	ASOND_KOMM	☐	ASOND_KOMM	TEXT60	CHAR	60	0	IS-M: Comment for Special Ad Handling
23	AZART_GEST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	*
24	AZART_FORM	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	*
25	AZART_AREA	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	*
26	HOEHE_I	☐	HOEHE_I	GROESSE	QUAN	7	3	IS-M: Actual height of the ad spec
27	HOEHE_I_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	*
28	BREITE_I	☐	BREITE_I	GROESSE	QUAN	7	3	IS-M: Actual Ad Spec Width
29	BREITE_IEH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	*
30	HOEHE_T	☐	HOEHE_T	GROESSE	QUAN	7	3	IS-M: Technical height
31	HOEHE_T_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	*
32	BREITE_T	☐	BREITE_T	GROESSE	QUAN	7	3	IS-M: Technical Width Specification
33	BREITE_TEH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	*
34	HOEHE_S	☐	HOEHE_S	GROESSE	QUAN	7	3	IS-M: Planned Height of the Ad Spec
35	HOEHE_S_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	*
36	BREITE_S	☐	BREITE_S	GROESSE	QUAN	7	3	IS-M: Planned Ad Spec Width
37	BREITE_SEH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	*
38	ZUS_BERECH	☐	MEINH_ZUS	ISPEINHEIT	UNIT	3	0	IS-M: Additional Unit of Measure for Settlement	*
39	ZUS_MENGE	☐	BER_MENGE	GROESSE	QUAN	7	3	IS-M: Number of Additional Ad Spec Calculation Units
40	XHOEHE_ZWI	☐	XHOEHE_ZWI	XHOEHE_ZWI	CHAR	1	0	IS-M: Height Indicator	*
41	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
42	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
43	TEXTSPITZE	☐	TEXTSPITZE	TEXT25	CHAR	25	0	IS-M: Ad Text Header
44	ABW_TELLND	☐	ABW_TELLND	LAND1	CHAR	3	0	IS-M: Alternative International Dialing Code for Ad Spec	*
45	ABW_TELVW	☐	ABW_TELVW	ISPTELVW	CHAR	10	0	IS-M: Alternative Area Code for Ad Spec
46	ABW_TEL	☐	ABW_TEL	ISPTEL	CHAR	20	0	IS-M: Alternative Telephone Number for Ad Spec
47	TELEF_ART	☐	TELEF_ART	TELEF_ART	CHAR	2	0	IS-M: Type of telephone number	*
48	BILOZ_ANZ	☐	BILOZ_ANZ	NUMC2	NUMC	2	0	IS-M: Amount of Artwork Assigned to the Ad Spec
49	BILOZ_KOMM	☐	BILOKOMM	TEXT35	CHAR	35	0	IS-M: Comment on Artwork to be Used
50	XANSCHNITT	☐	XANSCHNITT	XFELD	CHAR	1	0	IS-M: Bled Ad Spec Indicator
51	XUEBERBUND	☐	XUEBERBUND	XFELD	CHAR	1	0	IS-M: Indicates That The Ad Spec Overlaps Gutter Margin
52	XCOUPON	☐	XCOUPON	XFELD	CHAR	1	0	IS-M: Ad Spec is a Coupon Advertisement Indicator
53	COUPON_KNZ	☐	COUPON_KNZ	TEXT10	CHAR	10	0	IS-M: Coupon Identification Number
54	COUPON_LGE	☐	COUPON_LGE	PLAZLAGE	CHAR	2	0	IS-M: Position of the Coupon Relative to Ad Spec Position	*
55	SUJET_NR	☐	SUJET_NR	TEXT10	CHAR	10	0	IS-M: Subject Number
56	MOTEXTINF1	☐	MOTEXTINF1	CHAR30	CHAR	30	0	IS-M: Freely Definable Additional Information on Ad Spec
57	MOTEXTINF2	☐	MOTEXTINF2	CHAR30	CHAR	30	0	IS-M: Freely Definable Additional Information on Ad Spec
58	MOTEXTINF3	☐	MOTEXTINF3	CHAR30	CHAR	30	0	IS-M: Freely Definable Additional Information on Ad Spec
59	MOTEXTINF4	☐	MOTEXTINF4	CHAR30	CHAR	30	0	IS-M: Freely Definable Additional Information on Ad Spec
60	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
61	SI_NUMMER	☐	ISM_SI_NUMMER	SI_NUMMER	CHAR	10	0	IS-M: Ad Insert Number
62	ERSCHDAT	☐	ERSCHDAT	DATUM	DATS	8	0	Publication Date
63	JHAEDAT	☐	JHAEDAT	DATUM	DATS	8	0	IS-M: JHAE date
64	BEARB	☐	SINSBEARB	SIBEAR_ART	CHAR	2	0	IS-M: Ad Insert Processing Type	*
65	SIMENGE_RH	☐	DSPMGE_RH	STMENGE	DEC	9	0	IS-M: Non-Reader Circulation for TMC
66	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	*
67	BEGRP_STAT	☐	BEGRP_STAT	BEGRP_STAT	CHAR	4	0	IS-M: BU Grouping for Statistics	*
68	IKO_STAT	☐	IKO_STAT	INHALTSKOM	CHAR	8	0	IS-M: Statistical content component	*
69	KENNZIFFER	☐	PAM_KENNZI	PAM_KENNZI	CHAR	10	0	IS-M: Identification Number
70	.INCLUDE	☐				0	0	IS-M/AM: Include for Ad Spec Design
71	TYPO_NR	☐	TYPO_NR	TYPONR	CHAR	8	0	IS-M: Typography Number
72	RAHMENTYP	☐	RAHMENTYP	RAHMENTYP	CHAR	8	0	IS-M: Border Type	TJH35
73	RAHMENSTAE	☐	RAHMENSTAE	NUM2	NUMC	2	0	IS-M: Border Width
74	RAHMENEINH	☐	RAHMENEINH	MEINS	UNIT	3	0	IS-M: Unit of measurement for border width	T006
75	INVERSKNZ	☐	INVERSKNZ	XFELD	CHAR	1	0	IS-M: Reversed Indicator
76	RASTER	☐	RASTERUNG	RASTERUNG	CHAR	2	0	IS-M: Grid Spacing	TJH37
77	STYLE	☐	ISM_AMC_STYLE	ISM_AMC_STYLE	CHAR	30	0	IS-M: Style for IS-M/AMC
78	TEMPLATE	☐	ISM_AMC_TEMPLATE	ISM_AMC_TEMPLATE	CHAR	30	0	IS-M: Template for IS-M/AMC
79	.INCLUDE	☐				0	0	IS-M/AM: Include for Attributes for Sub Ad Specs/Linking
80	TMOT_KENNZ	☐	TMOT_KENNZ	TMOTIV_KE	CHAR	6	0	IS-M/AM: Sub ad spec/linked ad specs indicator	TJH75
81	TMOT_NR	☐	TMOT_NR	NUMC2	NUMC	2	0	IS-M: Position of the Sub Ad Spec Within the Chain
82	TMOT_ANZ	☐	TMOT_ANZ	NUM02	NUMC	2	0	IS-M: Number of sub ad specs in an ad spec chain
83	TMOT_BEZUG	☐	TMOT_BEZUG	PAM_MOTIV	NUMC	6	0	IS-M: Reference to header ad spec for linked ad specs	JHAMOT
84	TMOT_LAGE	☐	TMOT_LAGE	MOT_LAGE	CHAR	4	0	IS-M: Position of Sub Ad Spec (Relative to Header Ad Spec)	TJH77
85	TMOT_KOMM	☐	TMOT_KOMM	TEXT30	CHAR	30	0	IS-M: Comment on location of sub ad spec
86	TMOT_UEBER	☐	TMOT_UEBER	PAM_MOTIV	NUMC	6	0	IS-M: Assigned Sub Ad Spec for Gutter Bleed Formats	*
87	BREITETMOT	☐	BREITETMOT	GROESSE	QUAN	7	3	IS-M: Totalled Widths for Linked Sub Ad Specs
88	BREITETMEH	☐	BREITETMEH	ISPEINHEIT	UNIT	3	0	IS-M: Unit of Measure.for the Totalled Sub Ad Specs Width	TJH57
89	HOEHETMOT	☐	HOEHETMOT	GROESSE	QUAN	7	3	IS-M: Totalled Heights for Linked Sub Ad Specs
90	HOEHETMEH	☐	HOEHETMEH	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Sub Ad Spec Height Totals	TJH61
91	XUVMOT	☐	XUVMOT	XFELD	CHAR	1	0	IS-M: "Ad spec data incomplete" indicator
92	XPRNOTW	☐	XPRNOTW	XFELD	CHAR	1	0	IS-M: Ad Spec Check Required But Not Performed
93	XPRINHNOTW	☐	XPRINHNOTW	XFELD	CHAR	1	0	IS-M: Content Check Required But Not Performed
94	XKUNK_NOTW	☐	XKUNK_NOTW	XFELD	CHAR	1	0	IS-M: Customer correction necessary but not performed
95	XMOTPROD	☐	XMOTPROD	XFELD	CHAR	1	0	IS-M: Ad Spec Technically Complete Indicator
96	XDIFF_SIZE	☐	XDIFF_SIZE	XFELD	CHAR	1	0	IS-M: Alternative Actual Size
97	XHOEHE_GR	☐	XHOEHE_GR	XFELD	CHAR	1	0	IS-M: Height cannot be entered
98	XBREITE_GR	☐	XBREITE_GR	XFELD	CHAR	1	0	IS-M: Width Cannot be Entered
99	XBREIEH_GR	☐	XBREIEH_GR	XFELD	CHAR	1	0	IS-M: Unit of measurement for width cannot be entered
100	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
101	XRESERV	☐	XRESERV	XFELD	CHAR	1	0	IS-M: Reservation indicator
102	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	*
103	EIN_ART	☐	JHAE_ART	AVMPOS_ART	CHAR	2	0	IS-M: Schedule Line Type	*
104	WERBK_TYP	☐	WERBK_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Advertising Combination Type	*
105	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
106	WERBK_POS	☐	WERBK_POS	AVM_PNR	NUMC	3	0	IS-M: Combination Sale Grouping Item Number	*
107	WERBK_UPOS	☐	WERBK_UPOS	AVM_UPNR	NUMC	4	0	IS-M: Combination Sale Grouping Sub-Item
108	WERBK_EINT	☐	WERBK_EINT	AVMENR	NUMC	6	0	IS-M: Combination Sale Grouping for Schedule Line Number	*
109	NOTIZKNZ	☐	NOTIZKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Notes are Available for an OPM Objct

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCJHAEADD	BEGRP_ST_E	TJJ67	BEGRP_STAT		1	CN
2	MCJHAEADD	BREITETMEH	TJH57	ISPEINHEIT	REF	1	CN
3	MCJHAEADD	HOEHETMEH	TJH61	ISPEINH_H	REF	1	CN
4	MCJHAEADD	IKO_STAT_E	JJTIKO	INHALTSKOM
5	MCJHAEADD	MOTSIZE_ME	TJH57	ISPEINHEIT	REF	1	CN
6	MCJHAEADD	RAHMENEINH	T006	MSEHI	REF	1	CN
7	MCJHAEADD	RAHMENTYP	TJH35	RAHMENTYP	REF	1	CN
8	MCJHAEADD	RASTER	TJH37	RASTER	REF	1	CN
9	MCJHAEADD	TMOT_BEZUG	JHAMOT	MOTIV	REF
10	MCJHAEADD	TMOT_KENNZ	TJH75	TMOT_KENNZ	REF	1	CN
11	MCJHAEADD	TMOT_LAGE	TJH77	TMOT_LAGE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in