SAP ABAP Table RJHA441 (IS-M/AM: Screen structure for distribution items 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	RJHA441	Table Relationship Diagram
Short Description	IS-M/AM: Screen structure for distribution items 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 Distribution 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 distribution attributes
7	JVTBEPMART	☐	JVTBEPMART	JVTBEPMART	CHAR	4	0	IS-M/AM: Distribution Planned Quantity Types	TJJBEVTPA
8	VRTMENGE_V	☐	VRTMGV_PAM	STMENGE	DEC	9	0	IS-M/AM: Planned Quantity for Distribution Full Booking
9	VRTMENGE	☐	VRTMGI_PAM	STMENGE	DEC	9	0	IS-M/AM: Actual Quantity for Distribution
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	BLGMENGE	☐	JVTLFMNG	STMENGE	DEC	9	0	IS-M/AM: Delivery quantity for distribution
13	XTBEL_VT	☐	XTBEL_VT	XFELD	CHAR	1	0	IS-M: Selective Booking For Distribution BU Indicator
14	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	*
15	SI_GEWICHT	☐	ISM_SI_GEWICHT	ISPMNG9	QUAN	9	3	IS-M: Ad Insert Weight
16	MEINHGEWBL	☐	MEINHGEWBL	MEINS	UNIT	3	0	IS-M: Unit of Weight for Ad Insert	T006
17	SI_ENTSPFL	☐	ISM_SI_ENTSPFL	XFELD	CHAR	1	0	IS-M: Waste Disposal Required Indicator
18	SI_VERBWER	☐	ISM_SI_VERBWER	XFELD	CHAR	1	0	IS-M: Tie-In Ads Indicator
19	ANZSEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
20	.INCLUDE	☐				0	0	IS-PAM: Date Attributes
21	TERM_TYP	☐	TERMINTYP	TERMINTYP	CHAR	1	0	IS-M/AM: Date Category Copy Number/Publication Date	TJH55
22	ANFANG_PER	☐	ANFANG_PER	PAM_PERIOD	CHAR	14	0	IS-M: Start of Copy/Publication Date Period
23	ENDE_PER	☐	ENDE_PER	PAM_PERIOD	CHAR	14	0	IS-M: End of Period - Issue/Publication Date
24	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
25	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
26	BIS_PLUS	☐	BIS_PLUS	BIS_PLUS	CHAR	1	0	IS-M: Indicates a Period ("-") or 2 Dates ("+")
27	ANZ_SCHALT	☐	ANZ_SCHALT	ANZ_SCHALT	NUMC	3	0	IS-M: Number of Placements
28	TERM_ZYKL	☐	ANZ_ZYKLUS	ANZ_ZYKLUS	CHAR	4	0	IS-M: Frequency for Ad Publication	TJJ57
29	TERMINART	☐	TERMINART	TERMINART	CHAR	1	0	IS-M/AM: Type of Publication Date
30	ERSCH_T	☐	ERSCH_T	DATUM	DATS	8	0	IS-M: Publication Date
31	WUNSCH_T	☐	WUNSCH_T	DATUM	DATS	8	0	IS-M/AM: Date Required
32	.INCLUDE	☐				0	0	IS-M/AM: Include for Weekday String
33	X_MONTAG	☐	JHT_MONTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Monday
34	X_DIENSTAG	☐	JHT_DIENSTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Tuesday
35	X_MITTWOCH	☐	JHT_MITTWOCH	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Wednesday
36	X_DONNERST	☐	JHT_DONNERST	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Thursday
37	X_FREITAG	☐	JHT_FREITAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Friday
38	X_SAMSTAG	☐	JHT_SAMSTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Saturday
39	X_SONNTAG	☐	JHT_SONNTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Sunday
40	.INCLUDE	☐				0	0	IS-M/AM: Distribution Item Status Indicator
41	XUVSI	☐	XUVSI	XFELD	CHAR	1	0	IS-M: Ad Insert Data Incomplete Indicator
42	XVT_PLAZ	☐	XVT_PLAZ	XFELD	CHAR	1	0	IS-M: Indicator distribution "positioned"
43	XMUSTER_OK	☐	XMUSTER_OK	XFELD	CHAR	1	0	IS-M: Sample Received and Checked Indicator
44	XSI_VORH	☐	XSI_VORH	XFELD	CHAR	1	0	IS-M: AI Copies Exist
45	XUVTECH	☐	XUVTECH	XFELD	CHAR	1	0	IS-M: Incomplete Regarding Technical System (Gen.)
46	XTECH_MIN1	☐	XTECH_MIN1	XFELD	CHAR	1	0	IS-M: Tech.process.started (for at least 1 schedule line)
47	XTECH_EE	☐	XTECH_EE	XFELD	CHAR	1	0	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
48	.INCLUDE	☐				0	0	IS-M/AM: Characteristics for individual use. Distribution
49	MERKMAL0	☐	MERK0_PV	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Individual Use (Distributn Item)
50	MERKMAL1	☐	MERK1_PV	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Distributn Item)
51	MERKMAL2	☐	MERK2_PV	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Distributn Item)
52	MERKMAL3	☐	MERK3_PV	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Distributn Item)
53	MERKMAL4	☐	MERK4_PV	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Distributn Item)
54	MERKMAL5	☐	MERK5_PV	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Distributn Item)
55	MERKMAL6	☐	MERK6_PV	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Distributn Item)
56	MERKMAL7	☐	MERK7_PV	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Distributn Item)
57	MERKMAL8	☐	MERK8_PV	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Individual Use (Distributn Item)
58	MERKMAL9	☐	MERK9_PV	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Distributn Item)
59	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	TJH89
60	KONKAUSKOM	☐	KONKAUSKOM	TEXT35	CHAR	35	0	IS-M: Comment on competitor exclusion
61	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
62	SORTWORT	☐	SORTWORT	TEXT10	CHAR	10	0	IS-M: Sort Word
63	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
64	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
65	.INCLUDE	☐				0	0	IS-M/AM: Include for Pure Item Attributes
66	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
67	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
68	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
69	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
70	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
71	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
72	XEINTEILG	☐	XEINTEILG	XFELD	CHAR	1	0	IS-M: Indicator for modification at subordinate ord. level
73	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
74	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
75	.INCLUDE	☐				0	0	IS-PAM: Agent attributes outside agent assignment
76	VERMITTLER	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen
77	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
78	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
79	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
80	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
81	WERBK_POS	☐	WERBK_POS	AVM_PNR	NUMC	3	0	IS-M: Combination Sale Grouping Item Number	JHAP
82	WERBK_UPOS	☐	WERBK_UPOS	AVM_UPNR	NUMC	4	0	IS-M: Combination Sale Grouping Sub-Item
83	WERBK_EINT	☐	WERBK_EINT	AVMENR	NUMC	6	0	IS-M: Combination Sale Grouping for Schedule Line Number	JHAE
84	REF_AVM_NR	☐	REF_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Reference Order Number of Preceding Order	JHAK
85	REF_POS_NR	☐	REF_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Reference Item Number of Preceding Item	JHAP
86	SUC_AVM_NR	☐	SUC_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Order Number of Subsequent Document	JHAK
87	SUC_POS_NR	☐	SUC_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Item Number of Subsequent Item	JHAP
88	VORL_AVMNR	☐	VORL_AVMNR	AVM_NR	CHAR	10	0	IS-M: Order Number of the Preceding Document	JHAK
89	VORL_POSNR	☐	VORL_POSNR	AVM_PNR	NUMC	3	0	IS-M: Item number of the Preceding Item	JHAP
90	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
91	PREIS_OM	☐	PREIS_OM	WERTV8	CURR	15	2	IS-M: Price excluding VAT
92	PREIS_IM	☐	PREIS_IM	WERTV8	CURR	15	2	IS-M: Price including VAT
93	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
94	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
95	MWST_BETR	☐	GRMWSTBETR	WERTV7	CURR	13	2	IS-M: Value-Added Tax Amount
96	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
97	BELEGEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
98	BE_KURZ	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
99	BEKENNZ	☐	BEKENNZ	XFELD	CHAR	1	0	IS-M: Booking Unit Indicator
100	INHKK_TEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
101	STAT_AMPEL	☐	STAT_AMPEL	SYCHAR132	CHAR	132	0	IS-M: Status visualization
102	EINTL_ANZ	☐	EINTL_ANZ	NUMC6	NUMC	6	0	IS-M: Number of Schedule Lines in an Item
103	NE_TERMIN	☐	NE_TERMIN	DATUM	DATS	8	0	IS-M: Next/Last Publication Date

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in