SAP ABAP Table JHAP (IS-M/AM: Order-Publishing-Media Item)

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	TRANSP	Transparent table
Transparent table	JHAP	Table Relationship Diagram
Short Description	IS-M/AM: Order-Publishing-Media Item

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in