SAP ABAP Table RJHAPVB (IS-PAM: Update structure for JHAP)

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	RJHAPVB	Table Relationship Diagram
Short Description	IS-PAM: Update structure for JHAP

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHAPVB	AVM_NR	JHAK	AVM_NR
2	RJHAPVB	BEDNR	JJTVB	BEDNR	KEY	1	CN
3	RJHAPVB	BRAN_PAM	TBRC	BRACO
4	RJHAPVB	BSARK	T176	BSARK	REF	C	CN
5	RJHAPVB	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
6	RJHAPVB	MANDT	T000	MANDT
7	RJHAPVB	POS_ART	TJH17	AVMPOS_ART
8	RJHAPVB	PROSL	TJH23	PRSCHL	KEY	1	CN
9	RJHAPVB	PSTYV	TJHAP	PSTYV	REF	1	CN
10	RJHAPVB	REF_AVM_NR	JHAK	AVM_NR	REF	1	CN
11	RJHAPVB	REF_POS_NR	JHAP	POS_NR	REF	1	CN
12	RJHAPVB	STAFO	TMCB	STAFO	REF	1	CN
13	RJHAPVB	STORNOGRND	TJHSTOG	STORNOGRD	REF	1	CN
14	RJHAPVB	SUC_AVM_NR	JHAK	AVM_NR	REF	1	CN
15	RJHAPVB	SUC_POS_NR	JHAP	POS_NR	REF	1	CN
16	RJHAPVB	VNR	JJTVV	VNR	KEY	1	CN
17	RJHAPVB	VORL_AVMNR	JHAK	AVM_NR	REF	1	CN
18	RJHAPVB	VORL_POSNR	JHAP	POS_NR	REF	1	CN
19	RJHAPVB	WERBK_EINT	JHAE	EIN_NR		1	CN
20	RJHAPVB	WERBK_POS	JHAP	POS_NR		1	CN
21	RJHAPVB	WERBK_TYP	TJH91	WKOMBI_TYP		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in