SAP ABAP Table RJHAPSVB (IS-PAM: Update structure for JHAPS)

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	RJHAPSVB	Table Relationship Diagram
Short Description	IS-PAM: Update structure for JHAPS

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

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in