SAP ABAP Table RJHA421 (IS-PAM: Screen structure for general 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	RJHA421	Table Relationship Diagram
Short Description	IS-PAM: Screen structure for general 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: Order-Publishing-Media Item Structure
3	.INCLUDE	☐				0	0	IS-M/AM: Order-Publishing-Media Item
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
6	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
7	.INCLUDE	☐				0	0	IS-M/AM: Include for Pure Item Attributes
8	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
9	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
10	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
11	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
12	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
13	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
14	XEINTEILG	☐	XEINTEILG	XFELD	CHAR	1	0	IS-M: Indicator for modification at subordinate ord. level
15	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
16	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
17	.INCLUDE	☐				0	0	IS-PAM: Agent attributes outside agent assignment
18	VERMITTLER	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
19	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
20	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
21	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
22	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
23	WERBK_POS	☐	WERBK_POS	AVM_PNR	NUMC	3	0	IS-M: Combination Sale Grouping Item Number	JHAP
24	WERBK_UPOS	☐	WERBK_UPOS	AVM_UPNR	NUMC	4	0	IS-M: Combination Sale Grouping Sub-Item
25	WERBK_EINT	☐	WERBK_EINT	AVMENR	NUMC	6	0	IS-M: Combination Sale Grouping for Schedule Line Number	JHAE
26	REF_AVM_NR	☐	REF_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Reference Order Number of Preceding Order	JHAK
27	REF_POS_NR	☐	REF_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Reference Item Number of Preceding Item	JHAP
28	SUC_AVM_NR	☐	SUC_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Order Number of Subsequent Document	JHAK
29	SUC_POS_NR	☐	SUC_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Item Number of Subsequent Item	JHAP
30	VORL_AVMNR	☐	VORL_AVMNR	AVM_NR	CHAR	10	0	IS-M: Order Number of the Preceding Document	JHAK
31	VORL_POSNR	☐	VORL_POSNR	AVM_PNR	NUMC	3	0	IS-M: Item number of the Preceding Item	JHAP
32	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
33	NOTIZKNZ	☐	NOTIZKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Notes are Available for an OPM Objct
34	.INCLUDE	☐				0	0	IS-PAM: Include Customer Outline Agreement Indicator
35	XRABATT	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
36	XMITZRAB	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
37	XBONUS	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
38	XMITZBON	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
39	.INCLUDE	☐				0	0	IS-M/AM: Surcharges And Discounts (Update)
40	RAB1_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
41	RAB1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
42	RAB1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
43	RAB2_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
44	RAB2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
45	RAB2_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
46	RAB3_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
47	RAB3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
48	RAB3_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
49	RAB4_BETR	☐	JRABMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent discount
50	RAB4_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
51	RAB4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
52	RAB4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
53	RAB4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
54	RAB5_BETR	☐	JRABBETR	WERTV6	CURR	11	2	IS-M/AM: Amount discount
55	RAB5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
56	RAB5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
57	RABE_BETR	☐	JRABBETR	WERTV6	CURR	11	2	IS-M/AM: Amount discount
58	RABE_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
59	RABE_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
60	ZUS1_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
61	ZUS1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
62	ZUS1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
63	ZUS2_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
64	ZUS2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
65	ZUS2_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
66	ZUS3_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
67	ZUS3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
68	ZUS3_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
69	ZUS4_BETR	☐	JZUSMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent surcharge
70	ZUS4_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
71	ZUS4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
72	ZUS4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
73	ZUS4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
74	ZUS5_BETR	☐	JZUSBETR	WERTV6	CURR	11	2	IS-M/AM: Amount Surcharge
75	ZUS5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
76	ZUS5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
77	ZUSE_BETR	☐	JZUSBETR	WERTV6	CURR	11	2	IS-M/AM: Amount Surcharge
78	ZUSE_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
79	ZUSE_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
80	FPRG_BETR	☐	JGPRBETR	WERTV6	CURR	11	2	IS-M/AM: Basic Price
81	FPRG_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
82	FPRG_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
83	FPRG_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
84	FPRG_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
85	FPR1_BETR	☐	JVPRBETR	WERTV6	CURR	11	2	IS-M/AM: Agreed price
86	FPR1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
87	FPR1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
88	XRABZU	☐	XRABZU	XFELD	CHAR	1	0	IS-M: Discount/Surcharge Exists Indicator
89	WAER_IPZA	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
90	XUZUO_LOE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
91	.INCLUDE	☐				0	0	IS-PAM: Status attributes for order item
92	XUVFAKT	☐	XUVFAKT	XFELD	CHAR	1	0	IS-M: Billing is Incomplete
93	XUVGP	☐	XUVGP	XFELD	CHAR	1	0	IS-M: Business Partner Is Incomplete
94	XUVPREIS	☐	XUVPREIS	XFELD	CHAR	1	0	IS-M: Incomplete with regard to pricing
95	XUVABSCHL	☐	XUVABSCHL	XFELD	CHAR	1	0	IS-M: Contract Assignment is Incomplete
96	XUVVZ	☐	XUVVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Incomplete
97	XUVKPV	☐	XUVKPV	XFELD	CHAR	1	0	IS-M: Incomplete Manual Header/Item Sales Agent Assignment
98	XGENEINT	☐	XGENEINT	XFELD	CHAR	1	0	IS-M: Schedule lines are not current
99	XGENGRPF	☐	XGENGRPF	XFELD	CHAR	1	0	IS-M: Billing Dataset Is Yet To Be Generated
100	XRESERV	☐	XRESERV	XFELD	CHAR	1	0	IS-M: Reservation indicator
101	XRESBEST	☐	XRESBEST	XFELD	CHAR	1	0	IS-M: Reservation confirmed
102	XFAKTMIN1	☐	XFAKTMIN1	XFELD	CHAR	1	0	IS-M: Partially Billed (At Least 1 Billing Dataset Billed)
103	XFAKTALL	☐	XFAKTALL	XFELD	CHAR	1	0	IS-M: Billing Performed For All Billing Datasets
104	XSPERR_BON	☐	XSPERR_BON	XFELD	CHAR	1	0	IS-M: "Blocked for reasons of creditworthiness" indicator
105	XKOMMFRGB	☐	XKOMMFRGB	XFELD	CHAR	1	0	IS-M: Commercial release necessary but not performed
106	XNACHBEARB	☐	XNACHBEARB	XFELD	CHAR	1	0	IS-M: Post-Editing Required
107	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
108	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
109	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
110	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
111	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
112	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
113	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
114	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
115	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
116	STAFO	☐	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	TMCB
117	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
118	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
119	.INCLUDE	☐				0	0	IS-PAM: Purchase Order Data Include
120	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
121	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
122	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
123	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
124	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
125	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
126	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
127	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
128	PARNR	☐	ISM_CNTCT_PRSN	BU_PARTNER	CHAR	10	0	IS-M: Contact Person	*
129	ZUKOMM	☐	JZUKOMM	TEXT50	CHAR	50	0	IS-M: Additional Communication Data
130	.INCLUDE	☐				0	0	IS-M/AM: Product Hierarchy (S&P): Include for JHAP
131	PRDH_HERKUNFT	☐	ISM_PRDH_HERKUNFT	CHAR002	CHAR	2	0	IS-M/AM: Origin Key
132	PRDH_PRODUKT	☐	ISM_PRDH_PROD	ISM_PRDH_PRODUKT	CHAR	11	0	IS-M/AM: Product
133	.INCLUDE	☐				0	0	IS-M/AM: Order-Publishing-Media Item Structure (Not DB)
134	PREIS_OM	☐	PREIS_OM	WERTV8	CURR	15	2	IS-M: Price excluding VAT
135	PREIS_IM	☐	PREIS_IM	WERTV8	CURR	15	2	IS-M: Price including VAT
136	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
137	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
138	MWST_BETR	☐	GRMWSTBETR	WERTV7	CURR	13	2	IS-M: Value-Added Tax Amount
139	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
140	PREIS_KPW1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
141	PREIS_KPW2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
142	WAEHRG_KOP	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
143	VERM_NAME	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
144	BSARK_TXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
145	AP_NAME	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
146	XSUCFKP	☐	XSUCFKP	XFELD	CHAR	1	0	IS-M/AM: Indicator: Subsequent Billing Items Exist
147	BRAN_PAM_TEXT	☐	VTEXT	TEXT20	CHAR	20	0	Description
148	KAMPAGNE_TEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
149	UPSELL_PROP	☐	UPSELL_PROP	ISM_UPSELL_PROP	CHAR	10	0	IS-M/AM: Upselling Proposal
150	COPYVAR_NEW_ITEM	☐	COPYVAR_NEW_ITEM	KOPIERVAR	CHAR	4	0	IS-M: Copying Variant Used to Create Item in Current Dialog	*
151	XADV_CHNGD	☐	ISM_XADV_CHNGD	XFELD	CHAR	1	0	IS-M/AM: Advertiser Changed Due to Sold-to Party Change
152	XSUCRR	☐	XSUCRR	XFELD	CHAR	1	0	IS-M/AM: Indicator: Successor Revenue Recognition Exists
153	BELEGEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
154	BE_KURZ	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
155	BEKENNZ	☐	BEKENNZ	XFELD	CHAR	1	0	IS-M: Booking Unit Indicator
156	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
157	INHKK_TEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
158	STAT_AMPEL	☐	STAT_AMPEL	SYCHAR132	CHAR	132	0	IS-M: Status visualization
159	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	RJHA421	AVM_NR	JHAK	AVM_NR
2	RJHA421	BEDNR	JJTVB	BEDNR	KEY	1	CN
3	RJHA421	BELEGEINH	JJTBE	BELEINH
4	RJHA421	BRAN_PAM	TBRC	BRACO
5	RJHA421	BSARK	T176	BSARK	REF	C	CN
6	RJHA421	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
7	RJHA421	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
8	RJHA421	MANDT	T000	MANDT
9	RJHA421	POS_ART	TJH17	AVMPOS_ART
10	RJHA421	PROSL	TJH23	PRSCHL	KEY	1	CN
11	RJHA421	PSTYV	TJHAP	PSTYV	REF	1	CN
12	RJHA421	REF_AVM_NR	JHAK	AVM_NR	REF	1	CN
13	RJHA421	REF_POS_NR	JHAP	POS_NR	REF	1	CN
14	RJHA421	STAFO	TMCB	STAFO	REF	1	CN
15	RJHA421	STORNOGRND	TJHSTOG	STORNOGRD	REF	1	CN
16	RJHA421	SUC_AVM_NR	JHAK	AVM_NR	REF	1	CN
17	RJHA421	SUC_POS_NR	JHAP	POS_NR	REF	1	CN
18	RJHA421	VNR	JJTVV	VNR	KEY	1	CN
19	RJHA421	VORL_AVMNR	JHAK	AVM_NR	REF	1	CN
20	RJHA421	VORL_POSNR	JHAP	POS_NR	REF	1	CN
21	RJHA421	WAEHRG	TCURC	WAERS	REF	1	CN
22	RJHA421	WAEHRG_KOP	TCURC	WAERS	REF	1	CN
23	RJHA421	WERBK_EINT	JHAE	EIN_NR		1	CN
24	RJHA421	WERBK_POS	JHAP	POS_NR		1	CN
25	RJHA421	WERBK_TYP	TJH91	WKOMBI_TYP		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in