SAP ABAP Table JHAERL (IS-M: OPM Ad Error Log for Schedule Line Generation)

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	JHAERL	Table Relationship Diagram
Short Description	IS-M: OPM Ad Error Log for Schedule Line Generation

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	POS_NR	☑	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
4	ERR_NR	☑	ERR_NR	AVM_ENR	NUMC	4	0	IS-M: Order-Publishing-Media Error Number
5	OBJ_ART	☐	BE_OBJART	BE_OBJART	CHAR	2	0	IS-M: Object Type - BU Object
6	GENERR_TYP	☐	GENERR_TYP	GENERR_TYP	CHAR	1	0	IS-M: Error Type during Schedule Line Generation
7	DATUM	☐	BE_DATUM	DATUM	DATS	8	0	IS-M: Date on Which a BU is "Published"
8	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	JJTBE
9	BELEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
10	INHALTSKOM	☐	INHALTSKOM	INHALTSKOM	CHAR	8	0	IS-M: Content Component	JJTIKO
11	INHK_LEV1	☐	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	JJTIKO
12	.INCLUDE	☐				0	0	IS-M: Structure for proposed dates reference
13	RASTER	☐	RASTER_PAM	RASTER_PAM	CHAR	3	0	IS-M: Grid for IS-M/AM Order
14	VAVARTYP	☐	VAVARTYP	VAVARTYP	CHAR	2	0	Issue Variant Type	*
15	DATUM_EIN	☐	DATUM	DATUM	DATS	8	0	Date
16	DATE_FROM	☐	DATUM	DATUM	DATS	8	0	Date
17	DATE_TO	☐	DATUM	DATUM	DATS	8	0	Date
18	WOCHE	☐	PAM_WEEK	PAM_WEEK	ACCP	6	0	IS-M: Week in year YYYYWW
19	MONAT	☐	PAM_MONTH	PAM_MONTH	ACCP	6	0	IS-M: Month in year
20	AUSGABE	☐	HEFT_NR	PAM_PERIOD	CHAR	14	0	IS-M: Copy Number with Year
21	VAUSGB	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	JDTVAUSGB
22	ANNSCHLUSS	☐	ANNSCHLUSS	ANNSCHLUSS	QUAN	6	0	IS-M: Order Deadline (Duration before Publication Date)
23	ANNSCHL_EH	☐	ANNSCHL_EH	MEINS	UNIT	3	0	IS-M: Time Unit for Order Deadline	T006
24	UHRZEIT_AS	☐	UHRZEIT_AS	UHRZEIT	TIMS	6	0	IS-M: Time of Order Deadline
25	ANNAHMEBIS	☐	ANNAHMEBIS	DATS	DATS	8	0	IS-M: Order Deadline Date
26	WS_TIMESLC	☐	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	TJJW1
27	WS_BLOCK	☐	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	TJJW3
28	WS_STELLE	☐	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
29	WS_LEN	☐	WS_LENGTHI	WS_LENGTH	NUMC	4	0	IS-M: Actual length of commercial in seconds
30	MIN_LAENGE	☐	MIN_LAENGE	WS_LENGTH	NUMC	4	0	IS-M: Minimum length of a commercial in seconds
31	MAX_LAENGE	☐	MAX_LAENGE	WS_LENGTH	NUMC	4	0	IS-M: Maximum length of a commercial in seconds
32	PLAZIERUNG	☐	PLAZIERANW	PLAZIERANW	CHAR	2	0	IS-M/AM: Positioning Instruction	*
33	ANZ_PRO_X_MAX	☐	ANZ_PRO_X	NUM3	NUMC	3	0	IS-M: Number of Times a Fixed Space be Assigned
34	ANZ_PRO_X_IST	☐	ANZ_PRO_X	NUM3	NUMC	3	0	IS-M: Number of Times a Fixed Space be Assigned
35	PLAZ_ONL	☐	PLAZ_ONL	PLAZ_ONL	CHAR	4	0	IS-M: Online Positioning Instruction	TJJPLZONL

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHAERL	ANNSCHL_EH	T006	MSEHI	REF	1	CN
2	JHAERL	AVM_NR	JHAK	AVM_NR	KEY	1	CN
3	JHAERL	BELEINH	JJTBE	BELEINH	REF	1	CN
4	JHAERL	INHALTSKOM	JJTIKO	INHALTSKOM	REF	1	CN
5	JHAERL	INHK_LEV1	JJTIKO	INHALTSKOM	REF	1	CN
6	JHAERL	MANDT	T000	MANDT	KEY	1	CN
7	JHAERL	PLAZ_ONL	TJJPLZONL	PLAZ_ONL	REF	1	CN
8	JHAERL	POS_NR	JHAP	POS_NR	KEY	1	CN
9	JHAERL	UR_BELEINH	JJTBE	BELEINH	REF	1	CN
10	JHAERL	VAUSGB	JDTVAUSGB	VAUSGB		1	CN
11	JHAERL	WS_BLOCK	TJJW3	WS_BLOCK	REF	1	CN
12	JHAERL	WS_TIMESLC	TJJW1	WS_TIMESLC	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in