SAP ABAP Table ISMAM_TXW_JHAP (DART 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	INTTAB	Structure
Structure	ISMAM_TXW_JHAP	Table Relationship Diagram
Short Description	DART IS-M/AM: Order-Publishing-Media Item

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	471