SAP ABAP Table RJHA481 (IS-M/AM: Screen Structure for Ad Insert Item List)

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	RJHA481	Table Relationship Diagram
Short Description	IS-M/AM: Screen Structure for Ad Insert Item List

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	MARK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
2	.INCLUDE	☐				0	0	IS-M/AM: OPM Ad Insert Item
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
5	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
6	.INCLUDE	☐				0	0	IS-M/AM: Include for Specific Ad Insert Attributes
7	BEARB	☐	SINSBEARB	SIBEAR_ART	CHAR	2	0	IS-M: Ad Insert Processing Type	TJH03
8	BLGMENGE	☐	BLGMGE_PAM	STMENGE	DEC	9	0	IS-M: Delivery Quantity for Ad Insert
9	TZUSMENGE	☐	TZUSMENGE	PRZ32	DEC	5	2	IS-M: Additional Tech.Quantity in % (Ad Insert)
10	DISPMENGE	☐	DSPMGE_PAM	STMENGE	DEC	9	0	IS-M: Planning Quantity for Ad Inserts
11	BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
12	XBERMENGE_FIX	☐	JXBERMENGE_FIX	XFELD	CHAR	1	0	IS-M/AM: Calculation Quantity is Fixed indicator
13	POSTMENGE	☐	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
14	SIMENGE_RH	☐	DSPMGE_RH	STMENGE	DEC	9	0	IS-M: Non-Reader Circulation for TMC
15	MUSTER_T	☐	MUSTER_T	MUSTER_ANZ	NUMC	4	0	IS-M: Number of Samples (Technical)
16	MUSTER_P	☐	MUSTER_P	MUSTER_ANZ	NUMC	4	0	IS-M: Number of Samples for Trial Runs (Ad Insert)
17	XFREMDBEIL	☐	XFREMDBEIL	XFELD	CHAR	1	0	IS-M: Indicator - subject to postal charges (ad insert)
18	XBEILAGHW	☐	XBLGHINW	XFELD	CHAR	1	0	IS-M: Insert Note Required Indicator
19	XRESTHSHLT	☐	XRESTHSHLT	XFELD	CHAR	1	0	IS-M: Total Market Coverage
20	RESTHSHLT_DATUM	☐	ISM_DELTA_COVERAGE_DATE	DATUM	DATS	8	0	IS-M: Alternative Date for Total Market Coverage
21	XTRANZ	☐	XTRANZEIGE	XFELD	CHAR	1	0	IS-M: Carrier Ad Required Indicator
22	XTBEL_SI	☐	XTBEL_SI	XFELD	CHAR	1	0	IS-M: Selective Booking of an AI BU
23	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
24	SI_GEWICHT	☐	ISM_SI_GEWICHT	ISPMNG9	QUAN	9	3	IS-M: Ad Insert Weight
25	MEINHGEWBL	☐	MEINHGEWBL	MEINS	UNIT	3	0	IS-M: Unit of Weight for Ad Insert	T006
26	SI_ENTSPFL	☐	ISM_SI_ENTSPFL	XFELD	CHAR	1	0	IS-M: Waste Disposal Required Indicator
27	SI_VERBWER	☐	ISM_SI_VERBWER	XFELD	CHAR	1	0	IS-M: Tie-In Ads Indicator
28	ANZSEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
29	.INCLUDE	☐				0	0	IS-PAM: Date Attributes
30	TERM_TYP	☐	TERMINTYP	TERMINTYP	CHAR	1	0	IS-M/AM: Date Category Copy Number/Publication Date	TJH55
31	ANFANG_PER	☐	ANFANG_PER	PAM_PERIOD	CHAR	14	0	IS-M: Start of Copy/Publication Date Period
32	ENDE_PER	☐	ENDE_PER	PAM_PERIOD	CHAR	14	0	IS-M: End of Period - Issue/Publication Date
33	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
34	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
35	BIS_PLUS	☐	BIS_PLUS	BIS_PLUS	CHAR	1	0	IS-M: Indicates a Period ("-") or 2 Dates ("+")
36	ANZ_SCHALT	☐	ANZ_SCHALT	ANZ_SCHALT	NUMC	3	0	IS-M: Number of Placements
37	TERM_ZYKL	☐	ANZ_ZYKLUS	ANZ_ZYKLUS	CHAR	4	0	IS-M: Frequency for Ad Publication	TJJ57
38	TERMINART	☐	TERMINART	TERMINART	CHAR	1	0	IS-M/AM: Type of Publication Date
39	ERSCH_T	☐	ERSCH_T	DATUM	DATS	8	0	IS-M: Publication Date
40	WUNSCH_T	☐	WUNSCH_T	DATUM	DATS	8	0	IS-M/AM: Date Required
41	.INCLUDE	☐				0	0	IS-M/AM: Include for Weekday String
42	X_MONTAG	☐	JHT_MONTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Monday
43	X_DIENSTAG	☐	JHT_DIENSTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Tuesday
44	X_MITTWOCH	☐	JHT_MITTWOCH	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Wednesday
45	X_DONNERST	☐	JHT_DONNERST	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Thursday
46	X_FREITAG	☐	JHT_FREITAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Friday
47	X_SAMSTAG	☐	JHT_SAMSTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Saturday
48	X_SONNTAG	☐	JHT_SONNTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Sunday
49	.INCLUDE	☐				0	0	IS-M/AM: Status Indicator for Ad Insert Item
50	XUVSI	☐	XUVSI	XFELD	CHAR	1	0	IS-M: Ad Insert Data Incomplete Indicator
51	XSI_WARTET	☐	XSI_WARTET	XFELD	CHAR	1	0	IS-M: Ad Insert Is On The Waiting List Indicator
52	XDISPOSITI	☐	XDISPOSITI	XFELD	CHAR	1	0	IS-M: Planning Has Taken Place Indicator
53	XSI_PLAZ	☐	XSI_PLAZ	XFELD	CHAR	1	0	IS-M: Ad insert "positioned" indicator
54	XMUSTER_OK	☐	XMUSTER_OK	XFELD	CHAR	1	0	IS-M: Sample Received and Checked Indicator
55	XSI_VORH	☐	XSI_VORH	XFELD	CHAR	1	0	IS-M: AI Copies Exist
56	XUVTECH	☐	XUVTECH	XFELD	CHAR	1	0	IS-M: Incomplete Regarding Technical System (Gen.)
57	XTECH_MIN1	☐	XTECH_MIN1	XFELD	CHAR	1	0	IS-M: Tech.process.started (for at least 1 schedule line)
58	XTECH_EE	☐	XTECH_EE	XFELD	CHAR	1	0	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
59	.INCLUDE	☐				0	0	IS-M/AM: Characteristics for Individual Use
60	MERKMAL0	☐	MERK0_PS	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Individual Use (Ad Insert Item)
61	MERKMAL1	☐	MERK1_PS	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Ad Insert Item)
62	MERKMAL2	☐	MERK2_PS	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Ad Insert Item)
63	MERKMAL3	☐	MERK3_PS	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Ad Insert Item)
64	MERKMAL4	☐	MERK4_PS	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Ad Insert Item)
65	MERKMAL5	☐	MERK5_PS	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Ad Insert Item)
66	MERKMAL6	☐	MERK6_PS	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Ad Insert Item)
67	MERKMAL7	☐	MERK7_PS	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Ad Insert Item)
68	MERKMAL8	☐	MERK8_PS	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Individual Use (Ad Insert Item)
69	MERKMAL9	☐	MERK9_PS	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Ad Insert Item)
70	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	TJH89
71	KONKAUSKOM	☐	KONKAUSKOM	TEXT35	CHAR	35	0	IS-M: Comment on competitor exclusion
72	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
73	SORTWORT	☐	SORTWORT	TEXT10	CHAR	10	0	IS-M: Sort Word
74	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
75	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
76	XTEXT_INT	☐	XTEXT_INT	XFELD	CHAR	1	0	IS-M: Internal positioning comment indicator
77	XTEXT_EXT	☐	XTEXT_EXT	XFELD	CHAR	1	0	IS-M: External positioning comment exists indicator
78	.INCLUDE	☐				0	0	IS-M/AM: Include for Pure Item Attributes
79	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
80	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
81	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
82	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
83	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
84	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
85	XEINTEILG	☐	XEINTEILG	XFELD	CHAR	1	0	IS-M: Indicator for modification at subordinate ord. level
86	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
87	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
88	.INCLUDE	☐				0	0	IS-PAM: Agent attributes outside agent assignment
89	VERMITTLER	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
90	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
91	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
92	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
93	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
94	WERBK_POS	☐	WERBK_POS	AVM_PNR	NUMC	3	0	IS-M: Combination Sale Grouping Item Number	JHAP
95	WERBK_UPOS	☐	WERBK_UPOS	AVM_UPNR	NUMC	4	0	IS-M: Combination Sale Grouping Sub-Item
96	WERBK_EINT	☐	WERBK_EINT	AVMENR	NUMC	6	0	IS-M: Combination Sale Grouping for Schedule Line Number	JHAE
97	REF_AVM_NR	☐	REF_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Reference Order Number of Preceding Order	JHAK
98	REF_POS_NR	☐	REF_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Reference Item Number of Preceding Item	JHAP
99	SUC_AVM_NR	☐	SUC_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Order Number of Subsequent Document	JHAK
100	SUC_POS_NR	☐	SUC_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Item Number of Subsequent Item	JHAP
101	VORL_AVMNR	☐	VORL_AVMNR	AVM_NR	CHAR	10	0	IS-M: Order Number of the Preceding Document	JHAK
102	VORL_POSNR	☐	VORL_POSNR	AVM_PNR	NUMC	3	0	IS-M: Item number of the Preceding Item	JHAP
103	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
104	PREIS_OM	☐	PREIS_OM	WERTV8	CURR	15	2	IS-M: Price excluding VAT
105	PREIS_IM	☐	PREIS_IM	WERTV8	CURR	15	2	IS-M: Price including VAT
106	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
107	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
108	MWST_BETR	☐	GRMWSTBETR	WERTV7	CURR	13	2	IS-M: Value-Added Tax Amount
109	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
110	BELEGEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
111	BE_KURZ	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
112	BEKENNZ	☐	BEKENNZ	XFELD	CHAR	1	0	IS-M: Booking Unit Indicator
113	INHKK_TEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
114	STAT_AMPEL	☐	STAT_AMPEL	SYCHAR132	CHAR	132	0	IS-M: Status visualization
115	EINTL_ANZ	☐	EINTL_ANZ	NUMC6	NUMC	6	0	IS-M: Number of Schedule Lines in an Item
116	NE_TERMIN	☐	NE_TERMIN	DATUM	DATS	8	0	IS-M: Next/Last Publication Date
117	NE_HEFT	☐	NE_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Copy Number for the Next/Last Publication

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHA481	AVM_NR	JHAK	AVM_NR
2	RJHA481	BEARB	TJH03	BEARB	KEY	1	CN
3	RJHA481	BEDNR	JJTVB	BEDNR	KEY	1	CN
4	RJHA481	BRAN_PAM	TBRC	BRACO	REF	1	CN
5	RJHA481	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
6	RJHA481	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
7	RJHA481	KONKAUS	TJH89	KONKAUS	KEY
8	RJHA481	MANDT	T000	MANDT
9	RJHA481	MEINHGEWBL	T006	MSEHI
10	RJHA481	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
11	RJHA481	POS_NR	JHAP	POS_NR
12	RJHA481	PRODH	JJT179	PRODH
13	RJHA481	PROSL	TJH23	PRSCHL	KEY	1	CN
14	RJHA481	PSTYV	TJHAP	PSTYV	REF	1	CN
15	RJHA481	REF_AVM_NR	JHAK	AVM_NR	REF	1	CN
16	RJHA481	REF_POS_NR	JHAP	POS_NR	REF	1	CN
17	RJHA481	SI_TYP	TJH29	SI_TYP
18	RJHA481	SUC_AVM_NR	JHAK	AVM_NR	REF	1	CN
19	RJHA481	SUC_POS_NR	JHAP	POS_NR	REF	1	CN
20	RJHA481	TERM_TYP	TJH55	TERM_TYP	REF	1	CN
21	RJHA481	TERM_ZYKL	TJJ57	RHYTHMUS
22	RJHA481	VNR	JJTVV	VNR	KEY	1	CN
23	RJHA481	VORL_AVMNR	JHAK	AVM_NR	REF	1	CN
24	RJHA481	VORL_POSNR	JHAP	POS_NR	KEY	1	CN
25	RJHA481	WERBK_EINT	JHAE	EIN_NR		1	CN
26	RJHA481	WERBK_POS	JHAP	POS_NR		1	CN
27	RJHA481	WERBK_TYP	TJH91	WKOMBI_TYP		1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in