SAP ABAP Table RJHA6203 (IS-PAM: Screen Structure for Central Access - Comm.Overview)

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	RJHA6203	Table Relationship Diagram
Short Description	IS-PAM: Screen Structure for Central Access - Comm.Overview

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 Commercial 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-PAM: Include for Specific Commercial Attributes
6	WS_ART	☐	WSPOT_ART	WSPOT_ART	CHAR	4	0	IS-M: Commercial Type	TJJ41
7	.INCLUDE	☐				0	0	IS-M/AM: Status Indicator for Ad Insert Item
8	XTECH_MIN1	☐	XTECH_MIN1	XFELD	CHAR	1	0	IS-M: Tech.process.started (for at least 1 schedule line)
9	XTECH_EE	☐	XTECH_EE	XFELD	CHAR	1	0	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
10	.INCLUDE	☐				0	0	IS-M/AM: Characteristics for Individual Use
11	MERKMAL0	☐	MERK0_PW	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Individual Use (Commercial Item)
12	MERKMAL1	☐	MERK1_PW	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Commercial Item)
13	MERKMAL2	☐	MERK2_PW	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Commercial Item)
14	MERKMAL3	☐	MERK3_PW	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Commercial Item)
15	MERKMAL4	☐	MERK4_PW	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Commercial Item)
16	MERKMAL5	☐	MERK5_PW	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Commercial Item)
17	MERKMAL6	☐	MERK6_PW	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Commercial Item)
18	MERKMAL7	☐	MERK7_PW	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Commercial Item)
19	MERKMAL8	☐	MERK8_PW	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Commercial Item)
20	MERKMAL9	☐	MERK9_PW	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Commercial Item)
21	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	TJH89
22	KONKAUSKOM	☐	KONKAUSKOM	TEXT35	CHAR	35	0	IS-M: Comment on competitor exclusion
23	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
24	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
25	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
26	EIN_NR	☐	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line	*
27	NE_TERMIN	☐	NE_TERMIN	DATUM	DATS	8	0	IS-M: Next/Last Publication Date
28	S_TERMIN	☐	E_TERMIN	DATUM	DATS	8	0	IS-M: Publication Date
29	WS_TIMESLC	☐	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	TJJW1
30	WS_BLOCK	☐	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	*
31	WS_STELLE	☐	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
32	EINTL_ANZ	☐	EINTL_ANZ	NUMC6	NUMC	6	0	IS-M: Number of Schedule Lines in an Item
33	GFK_CODE	☐	GFK_CODE	CHAR06	CHAR	6	0	IS-M: Society for Consumer Research Code
34	.INCLUDE	☐				0	0	IS-M/AM: Include for Pure Item Attributes
35	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
36	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
37	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
38	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
39	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
40	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
41	XEINTEILG	☐	XEINTEILG	XFELD	CHAR	1	0	IS-M: Indicator for modification at subordinate ord. level
42	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
43	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
44	.INCLUDE	☐				0	0	IS-PAM: Agent attributes outside agent assignment
45	VERMITTLER	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
46	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
47	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
48	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
49	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
50	WERBK_POS	☐	WERBK_POS	AVM_PNR	NUMC	3	0	IS-M: Combination Sale Grouping Item Number	JHAP
51	WERBK_UPOS	☐	WERBK_UPOS	AVM_UPNR	NUMC	4	0	IS-M: Combination Sale Grouping Sub-Item
52	WERBK_EINT	☐	WERBK_EINT	AVMENR	NUMC	6	0	IS-M: Combination Sale Grouping for Schedule Line Number	JHAE
53	REF_AVM_NR	☐	REF_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Reference Order Number of Preceding Order	JHAK
54	REF_POS_NR	☐	REF_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Reference Item Number of Preceding Item	JHAP
55	SUC_AVM_NR	☐	SUC_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Order Number of Subsequent Document	JHAK
56	SUC_POS_NR	☐	SUC_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Item Number of Subsequent Item	JHAP
57	VORL_AVMNR	☐	VORL_AVMNR	AVM_NR	CHAR	10	0	IS-M: Order Number of the Preceding Document	JHAK
58	VORL_POSNR	☐	VORL_POSNR	AVM_PNR	NUMC	3	0	IS-M: Item number of the Preceding Item	JHAP
59	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
60	NOTIZKNZ	☐	NOTIZKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Notes are Available for an OPM Objct
61	BELEGEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
62	BE_KURZ	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
63	BEKENNZ	☐	BEKENNZ	XFELD	CHAR	1	0	IS-M: Booking Unit Indicator
64	ALTINSGPNR	☐	ALTINSGPNR	CHAR15	CHAR	15	0	IS-M: Alternative Customer Number for Advertiser
65	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	*
66	INS_NAME	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
67	INS_ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
68	INSERKNZ	☐	INSERKNZ	XFELD	CHAR	1	0	IS-M: Advertiser Indicator
69	XINSBLANK	☐	XINSBLANK	XFELD	CHAR	1	0	IS-M: Agency Order Without Advertiser Indicator
70	VERM_NAME	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
71	VERMITTKNZ	☐	VERMITTKNZ	XFELD	CHAR	1	0	IS-M: Sales Agent Indicator
72	VTNR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	*
73	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
74	PRODH_TEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
75	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
76	MOTIV	☐	WSMOTIV_NR	PAM_WS_MOT	NUMC	6	0	IS-M: Order ad spec number (commercial)	*
77	MOTIVID	☐	MOTIVID	MOTIVID	CHAR	12	0	IS-M: Assigned ad spec/ad spec file in technical system
78	WS_SENDFRM	☐	WS_SENDFRM	WS_SENDFRM	CHAR	2	0	IS-M: Commercial Design Type	*
79	WS_LENGTHS	☐	WS_LENGTHS	WS_LENGTH	NUMC	4	0	IS-M: Planned length of commercial in seconds
80	WS_LENGTHI	☐	WS_LENGTHI	WS_LENGTH	NUMC	4	0	IS-M: Actual length of commercial in seconds
81	STAT_AMPEL	☐	STAT_AMPEL	SYCHAR132	CHAR	132	0	IS-M: Status visualization
82	AMPEL	☐	ISP_AMPEL	CHAR004	CHAR	4	0	IS-M: Light for representing the status visually
83	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
84	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
85	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
86	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
87	MARK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
88	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
89	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
90	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
91	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
92	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
93	XZEILFARB	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
94	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
95	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
96	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in