SAP ABAP Table JHAPS (IS-M/AM: OPM Ad Insert Item)

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	JHAPS	Table Relationship Diagram
Short Description	IS-M/AM: OPM Ad Insert Item

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	.INCLUDE	☐				0	0	IS-M/AM: Include for Specific Ad Insert Attributes
5	BEARB	☐	SINSBEARB	SIBEAR_ART	CHAR	2	0	IS-M: Ad Insert Processing Type	TJH03
6	BLGMENGE	☐	BLGMGE_PAM	STMENGE	DEC	9	0	IS-M: Delivery Quantity for Ad Insert
7	TZUSMENGE	☐	TZUSMENGE	PRZ32	DEC	5	2	IS-M: Additional Tech.Quantity in % (Ad Insert)
8	DISPMENGE	☐	DSPMGE_PAM	STMENGE	DEC	9	0	IS-M: Planning Quantity for Ad Inserts
9	BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
10	XBERMENGE_FIX	☐	JXBERMENGE_FIX	XFELD	CHAR	1	0	IS-M/AM: Calculation Quantity is Fixed indicator
11	POSTMENGE	☐	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
12	SIMENGE_RH	☐	DSPMGE_RH	STMENGE	DEC	9	0	IS-M: Non-Reader Circulation for TMC
13	MUSTER_T	☐	MUSTER_T	MUSTER_ANZ	NUMC	4	0	IS-M: Number of Samples (Technical)
14	MUSTER_P	☐	MUSTER_P	MUSTER_ANZ	NUMC	4	0	IS-M: Number of Samples for Trial Runs (Ad Insert)
15	XFREMDBEIL	☐	XFREMDBEIL	XFELD	CHAR	1	0	IS-M: Indicator - subject to postal charges (ad insert)
16	XBEILAGHW	☐	XBLGHINW	XFELD	CHAR	1	0	IS-M: Insert Note Required Indicator
17	XRESTHSHLT	☐	XRESTHSHLT	XFELD	CHAR	1	0	IS-M: Total Market Coverage
18	RESTHSHLT_DATUM	☐	ISM_DELTA_COVERAGE_DATE	DATUM	DATS	8	0	IS-M: Alternative Date for Total Market Coverage
19	XTRANZ	☐	XTRANZEIGE	XFELD	CHAR	1	0	IS-M: Carrier Ad Required Indicator
20	XTBEL_SI	☐	XTBEL_SI	XFELD	CHAR	1	0	IS-M: Selective Booking of an AI BU
21	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
22	SI_GEWICHT	☐	ISM_SI_GEWICHT	ISPMNG9	QUAN	9	3	IS-M: Ad Insert Weight
23	MEINHGEWBL	☐	MEINHGEWBL	MEINS	UNIT	3	0	IS-M: Unit of Weight for Ad Insert	T006
24	SI_ENTSPFL	☐	ISM_SI_ENTSPFL	XFELD	CHAR	1	0	IS-M: Waste Disposal Required Indicator
25	SI_VERBWER	☐	ISM_SI_VERBWER	XFELD	CHAR	1	0	IS-M: Tie-In Ads Indicator
26	ANZSEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
27	.INCLUDE	☐				0	0	IS-PAM: Date Attributes
28	TERM_TYP	☐	TERMINTYP	TERMINTYP	CHAR	1	0	IS-M/AM: Date Category Copy Number/Publication Date	TJH55
29	ANFANG_PER	☐	ANFANG_PER	PAM_PERIOD	CHAR	14	0	IS-M: Start of Copy/Publication Date Period
30	ENDE_PER	☐	ENDE_PER	PAM_PERIOD	CHAR	14	0	IS-M: End of Period - Issue/Publication Date
31	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
32	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
33	BIS_PLUS	☐	BIS_PLUS	BIS_PLUS	CHAR	1	0	IS-M: Indicates a Period ("-") or 2 Dates ("+")
34	ANZ_SCHALT	☐	ANZ_SCHALT	ANZ_SCHALT	NUMC	3	0	IS-M: Number of Placements
35	TERM_ZYKL	☐	ANZ_ZYKLUS	ANZ_ZYKLUS	CHAR	4	0	IS-M: Frequency for Ad Publication	TJJ57
36	TERMINART	☐	TERMINART	TERMINART	CHAR	1	0	IS-M/AM: Type of Publication Date
37	ERSCH_T	☐	ERSCH_T	DATUM	DATS	8	0	IS-M: Publication Date
38	WUNSCH_T	☐	WUNSCH_T	DATUM	DATS	8	0	IS-M/AM: Date Required
39	.INCLUDE	☐				0	0	IS-M/AM: Include for Weekday String
40	X_MONTAG	☐	JHT_MONTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Monday
41	X_DIENSTAG	☐	JHT_DIENSTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Tuesday
42	X_MITTWOCH	☐	JHT_MITTWOCH	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Wednesday
43	X_DONNERST	☐	JHT_DONNERST	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Thursday
44	X_FREITAG	☐	JHT_FREITAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Friday
45	X_SAMSTAG	☐	JHT_SAMSTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Saturday
46	X_SONNTAG	☐	JHT_SONNTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Sunday
47	.INCLUDE	☐				0	0	IS-M/AM: Status Indicator for Ad Insert Item
48	XUVSI	☐	XUVSI	XFELD	CHAR	1	0	IS-M: Ad Insert Data Incomplete Indicator
49	XSI_WARTET	☐	XSI_WARTET	XFELD	CHAR	1	0	IS-M: Ad Insert Is On The Waiting List Indicator
50	XDISPOSITI	☐	XDISPOSITI	XFELD	CHAR	1	0	IS-M: Planning Has Taken Place Indicator
51	XSI_PLAZ	☐	XSI_PLAZ	XFELD	CHAR	1	0	IS-M: Ad insert "positioned" indicator
52	XMUSTER_OK	☐	XMUSTER_OK	XFELD	CHAR	1	0	IS-M: Sample Received and Checked Indicator
53	XSI_VORH	☐	XSI_VORH	XFELD	CHAR	1	0	IS-M: AI Copies Exist
54	XUVTECH	☐	XUVTECH	XFELD	CHAR	1	0	IS-M: Incomplete Regarding Technical System (Gen.)
55	XTECH_MIN1	☐	XTECH_MIN1	XFELD	CHAR	1	0	IS-M: Tech.process.started (for at least 1 schedule line)
56	XTECH_EE	☐	XTECH_EE	XFELD	CHAR	1	0	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
57	.INCLUDE	☐				0	0	IS-M/AM: Characteristics for Individual Use
58	MERKMAL0	☐	MERK0_PS	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Individual Use (Ad Insert Item)
59	MERKMAL1	☐	MERK1_PS	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Ad Insert Item)
60	MERKMAL2	☐	MERK2_PS	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Ad Insert Item)
61	MERKMAL3	☐	MERK3_PS	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Ad Insert Item)
62	MERKMAL4	☐	MERK4_PS	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Ad Insert Item)
63	MERKMAL5	☐	MERK5_PS	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Ad Insert Item)
64	MERKMAL6	☐	MERK6_PS	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Ad Insert Item)
65	MERKMAL7	☐	MERK7_PS	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Ad Insert Item)
66	MERKMAL8	☐	MERK8_PS	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Individual Use (Ad Insert Item)
67	MERKMAL9	☐	MERK9_PS	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Ad Insert Item)
68	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	TJH89
69	KONKAUSKOM	☐	KONKAUSKOM	TEXT35	CHAR	35	0	IS-M: Comment on competitor exclusion
70	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
71	SORTWORT	☐	SORTWORT	TEXT10	CHAR	10	0	IS-M: Sort Word
72	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
73	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
74	XTEXT_INT	☐	XTEXT_INT	XFELD	CHAR	1	0	IS-M: Internal positioning comment indicator
75	XTEXT_EXT	☐	XTEXT_EXT	XFELD	CHAR	1	0	IS-M: External positioning comment exists indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHAPS	AVM_NR	JHAK	AVM_NR	KEY	1	CN
2	JHAPS	BEARB	TJH03	BEARB	KEY	1	CN
3	JHAPS	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
4	JHAPS	KONKAUS	TJH89	KONKAUS	KEY	1	CN
5	JHAPS	MANDT	T000	MANDT	KEY	1	CN
6	JHAPS	MEINHGEWBL	T006	MSEHI
7	JHAPS	POS_NR	JHAP	POS_NR	KEY	1	CN
8	JHAPS	PRODH	JJT179	PRODH	REF	1	CN
9	JHAPS	SI_TYP	TJH29	SI_TYP
10	JHAPS	TERM_TYP	TJH55	TERM_TYP	REF	1	CN
11	JHAPS	TERM_ZYKL	TJJ57	RHYTHMUS

History

Last changed by/on	SAP	20050224
SAP Release Created in