SAP ABAP Table RJHA471 (IS-M/AM: Screen structure for commercial 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	RJHA471	Table Relationship Diagram
Short Description	IS-M/AM: Screen structure for commercial 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 Commercial 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-PAM: Include for Specific Commercial Attributes
7	WS_ART	☐	WSPOT_ART	WSPOT_ART	CHAR	4	0	IS-M: Commercial Type	TJJ41
8	.INCLUDE	☐				0	0	IS-M/AM: Status Indicator for Ad Insert Item
9	XTECH_MIN1	☐	XTECH_MIN1	XFELD	CHAR	1	0	IS-M: Tech.process.started (for at least 1 schedule line)
10	XTECH_EE	☐	XTECH_EE	XFELD	CHAR	1	0	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
11	.INCLUDE	☐				0	0	IS-M/AM: Characteristics for Individual Use
12	MERKMAL0	☐	MERK0_PW	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Individual Use (Commercial Item)
13	MERKMAL1	☐	MERK1_PW	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Commercial Item)
14	MERKMAL2	☐	MERK2_PW	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Commercial Item)
15	MERKMAL3	☐	MERK3_PW	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Commercial Item)
16	MERKMAL4	☐	MERK4_PW	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Commercial Item)
17	MERKMAL5	☐	MERK5_PW	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Commercial Item)
18	MERKMAL6	☐	MERK6_PW	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Commercial Item)
19	MERKMAL7	☐	MERK7_PW	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Commercial Item)
20	MERKMAL8	☐	MERK8_PW	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Commercial Item)
21	MERKMAL9	☐	MERK9_PW	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Commercial Item)
22	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	TJH89
23	KONKAUSKOM	☐	KONKAUSKOM	TEXT35	CHAR	35	0	IS-M: Comment on competitor exclusion
24	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
25	.INCLUDE	☐				0	0	IS-M/AM: Include for Pure Item Attributes
26	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
27	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
28	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
29	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
30	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
31	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
32	XEINTEILG	☐	XEINTEILG	XFELD	CHAR	1	0	IS-M: Indicator for modification at subordinate ord. level
33	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
34	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
35	.INCLUDE	☐				0	0	IS-PAM: Agent attributes outside agent assignment
36	VERMITTLER	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
37	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
38	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
39	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
40	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
41	WERBK_POS	☐	WERBK_POS	AVM_PNR	NUMC	3	0	IS-M: Combination Sale Grouping Item Number	JHAP
42	WERBK_UPOS	☐	WERBK_UPOS	AVM_UPNR	NUMC	4	0	IS-M: Combination Sale Grouping Sub-Item
43	WERBK_EINT	☐	WERBK_EINT	AVMENR	NUMC	6	0	IS-M: Combination Sale Grouping for Schedule Line Number	JHAE
44	REF_AVM_NR	☐	REF_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Reference Order Number of Preceding Order	JHAK
45	REF_POS_NR	☐	REF_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Reference Item Number of Preceding Item	JHAP
46	SUC_AVM_NR	☐	SUC_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Order Number of Subsequent Document	JHAK
47	SUC_POS_NR	☐	SUC_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Item Number of Subsequent Item	JHAP
48	VORL_AVMNR	☐	VORL_AVMNR	AVM_NR	CHAR	10	0	IS-M: Order Number of the Preceding Document	JHAK
49	VORL_POSNR	☐	VORL_POSNR	AVM_PNR	NUMC	3	0	IS-M: Item number of the Preceding Item	JHAP
50	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
51	PREIS_OM	☐	PREIS_OM	WERTV8	CURR	15	2	IS-M: Price excluding VAT
52	PREIS_IM	☐	PREIS_IM	WERTV8	CURR	15	2	IS-M: Price including VAT
53	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
54	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
55	MWST_BETR	☐	GRMWSTBETR	WERTV7	CURR	13	2	IS-M: Value-Added Tax Amount
56	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
57	BELEGEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
58	BE_KURZ	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
59	BEKENNZ	☐	BEKENNZ	XFELD	CHAR	1	0	IS-M: Booking Unit Indicator
60	INHKK_TEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
61	STAT_AMPEL	☐	STAT_AMPEL	SYCHAR132	CHAR	132	0	IS-M: Status visualization
62	EINTL_ANZ	☐	EINTL_ANZ	NUMC6	NUMC	6	0	IS-M: Number of Schedule Lines in an Item
63	NE_TERMIN	☐	NE_TERMIN	DATUM	DATS	8	0	IS-M: Next/Last Publication Date
64	MOTIV	☐	WSMOTIV_NR	PAM_WS_MOT	NUMC	6	0	IS-M: Order ad spec number (commercial)	*
65	NOTIZ	☐	MOTIVNOTIZ	TEXT50	CHAR	50	0	IS-M: Note for Ad Spec Design
66	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHA471	AVM_NR	JHAK	AVM_NR	KEY	1	CN
2	RJHA471	BEDNR	JJTVB	BEDNR	KEY	1	CN
3	RJHA471	BRAN_PAM	TBRC	BRACO	REF	1	CN
4	RJHA471	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
5	RJHA471	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
6	RJHA471	KONKAUS	TJH89	KONKAUS	REF	1	CN
7	RJHA471	MANDT	T000	MANDT	KEY	1	CN
8	RJHA471	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
9	RJHA471	POS_NR	JHAP	POS_NR	KEY	1	CN
10	RJHA471	PROSL	TJH23	PRSCHL	KEY	1	CN
11	RJHA471	PSTYV	TJHAP	PSTYV	REF	1	CN
12	RJHA471	REF_AVM_NR	JHAK	AVM_NR	REF	1	CN
13	RJHA471	REF_POS_NR	JHAP	POS_NR	REF	1	CN
14	RJHA471	SUC_AVM_NR	JHAK	AVM_NR	REF	1	CN
15	RJHA471	SUC_POS_NR	JHAP	POS_NR	REF	1	CN
16	RJHA471	VNR	JJTVV	VNR	KEY	1	CN
17	RJHA471	VORL_AVMNR	JHAK	AVM_NR	REF	1	CN
18	RJHA471	VORL_POSNR	JHAP	POS_NR	KEY	1	CN
19	RJHA471	WERBK_EINT	JHAE	EIN_NR		1	CN
20	RJHA471	WERBK_POS	JHAP	POS_NR		1	CN
21	RJHA471	WERBK_TYP	TJH91	WKOMBI_TYP		1	CN
22	RJHA471	WS_ART	TJJ41	WSPOT_ART	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in