SAP ABAP Table MCJHAPB (IS-PAM: Reference structure from MCJHAP for LIS func.module)

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	MCJHAPB	Table Relationship Diagram
Short Description	IS-PAM: Reference structure from MCJHAP for LIS func.module

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	Update Indicator for Statistics Updating
2	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
3	.INCLUDE	☐				0	0	IS-M: Order item, LIS communication structure
4	.INCLUDE	☐				0	0	IS-M/AM: Order-Publishing-Media Item
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
7	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
8	.INCLUDE	☐				0	0	IS-M/AM: Include for Pure Item Attributes
9	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
10	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
11	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
12	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
13	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
14	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
15	XEINTEILG	☐	XEINTEILG	XFELD	CHAR	1	0	IS-M: Indicator for modification at subordinate ord. level
16	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
17	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
18	.INCLUDE	☐				0	0	IS-PAM: Agent attributes outside agent assignment
19	VERMITTLER	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
20	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
21	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
22	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
23	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
24	WERBK_POS	☐	WERBK_POS	AVM_PNR	NUMC	3	0	IS-M: Combination Sale Grouping Item Number	JHAP
25	WERBK_UPOS	☐	WERBK_UPOS	AVM_UPNR	NUMC	4	0	IS-M: Combination Sale Grouping Sub-Item
26	WERBK_EINT	☐	WERBK_EINT	AVMENR	NUMC	6	0	IS-M: Combination Sale Grouping for Schedule Line Number	JHAE
27	REF_AVM_NR	☐	REF_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Reference Order Number of Preceding Order	JHAK
28	REF_POS_NR	☐	REF_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Reference Item Number of Preceding Item	JHAP
29	SUC_AVM_NR	☐	SUC_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Order Number of Subsequent Document	JHAK
30	SUC_POS_NR	☐	SUC_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Item Number of Subsequent Item	JHAP
31	VORL_AVMNR	☐	VORL_AVMNR	AVM_NR	CHAR	10	0	IS-M: Order Number of the Preceding Document	JHAK
32	VORL_POSNR	☐	VORL_POSNR	AVM_PNR	NUMC	3	0	IS-M: Item number of the Preceding Item	JHAP
33	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
34	NOTIZKNZ	☐	NOTIZKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Notes are Available for an OPM Objct
35	.INCLUDE	☐				0	0	IS-PAM: Include Customer Outline Agreement Indicator
36	XRABATT	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
37	XMITZRAB	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
38	XBONUS	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
39	XMITZBON	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
40	.INCLUDE	☐				0	0	IS-M/AM: Surcharges And Discounts (Update)
41	RAB1_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
42	RAB1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
43	RAB1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
44	RAB2_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
45	RAB2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
46	RAB2_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
47	RAB3_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
48	RAB3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
49	RAB3_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
50	RAB4_BETR	☐	JRABMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent discount
51	RAB4_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
52	RAB4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
53	RAB4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
54	RAB4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
55	RAB5_BETR	☐	JRABBETR	WERTV6	CURR	11	2	IS-M/AM: Amount discount
56	RAB5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
57	RAB5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
58	RABE_BETR	☐	JRABBETR	WERTV6	CURR	11	2	IS-M/AM: Amount discount
59	RABE_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
60	RABE_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
61	ZUS1_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
62	ZUS1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
63	ZUS1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
64	ZUS2_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
65	ZUS2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
66	ZUS2_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
67	ZUS3_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
68	ZUS3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
69	ZUS3_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
70	ZUS4_BETR	☐	JZUSMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent surcharge
71	ZUS4_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
72	ZUS4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
73	ZUS4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
74	ZUS4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
75	ZUS5_BETR	☐	JZUSBETR	WERTV6	CURR	11	2	IS-M/AM: Amount Surcharge
76	ZUS5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
77	ZUS5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
78	ZUSE_BETR	☐	JZUSBETR	WERTV6	CURR	11	2	IS-M/AM: Amount Surcharge
79	ZUSE_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
80	ZUSE_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
81	FPRG_BETR	☐	JGPRBETR	WERTV6	CURR	11	2	IS-M/AM: Basic Price
82	FPRG_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
83	FPRG_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
84	FPRG_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
85	FPRG_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
86	FPR1_BETR	☐	JVPRBETR	WERTV6	CURR	11	2	IS-M/AM: Agreed price
87	FPR1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
88	FPR1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
89	XRABZU	☐	XRABZU	XFELD	CHAR	1	0	IS-M: Discount/Surcharge Exists Indicator
90	WAER_IPZA	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
91	XUZUO_LOE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
92	.INCLUDE	☐				0	0	IS-PAM: Status attributes for order item
93	XUVFAKT	☐	XUVFAKT	XFELD	CHAR	1	0	IS-M: Billing is Incomplete
94	XUVGP	☐	XUVGP	XFELD	CHAR	1	0	IS-M: Business Partner Is Incomplete
95	XUVPREIS	☐	XUVPREIS	XFELD	CHAR	1	0	IS-M: Incomplete with regard to pricing
96	XUVABSCHL	☐	XUVABSCHL	XFELD	CHAR	1	0	IS-M: Contract Assignment is Incomplete
97	XUVVZ	☐	XUVVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Incomplete
98	XUVKPV	☐	XUVKPV	XFELD	CHAR	1	0	IS-M: Incomplete Manual Header/Item Sales Agent Assignment
99	XGENEINT	☐	XGENEINT	XFELD	CHAR	1	0	IS-M: Schedule lines are not current
100	XGENGRPF	☐	XGENGRPF	XFELD	CHAR	1	0	IS-M: Billing Dataset Is Yet To Be Generated
101	XRESERV	☐	XRESERV	XFELD	CHAR	1	0	IS-M: Reservation indicator
102	XRESBEST	☐	XRESBEST	XFELD	CHAR	1	0	IS-M: Reservation confirmed
103	XFAKTMIN1	☐	XFAKTMIN1	XFELD	CHAR	1	0	IS-M: Partially Billed (At Least 1 Billing Dataset Billed)
104	XFAKTALL	☐	XFAKTALL	XFELD	CHAR	1	0	IS-M: Billing Performed For All Billing Datasets
105	XSPERR_BON	☐	XSPERR_BON	XFELD	CHAR	1	0	IS-M: "Blocked for reasons of creditworthiness" indicator
106	XKOMMFRGB	☐	XKOMMFRGB	XFELD	CHAR	1	0	IS-M: Commercial release necessary but not performed
107	XNACHBEARB	☐	XNACHBEARB	XFELD	CHAR	1	0	IS-M: Post-Editing Required
108	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
109	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
110	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
111	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
112	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
113	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
114	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
115	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
116	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
117	STAFO	☐	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	TMCB
118	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
119	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
120	.INCLUDE	☐				0	0	IS-PAM: Purchase Order Data Include
121	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
122	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
123	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
124	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
125	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
126	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
127	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
128	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
129	PARNR	☐	ISM_CNTCT_PRSN	BU_PARTNER	CHAR	10	0	IS-M: Contact Person	*
130	ZUKOMM	☐	JZUKOMM	TEXT50	CHAR	50	0	IS-M: Additional Communication Data
131	.INCLUDE	☐				0	0	IS-M/AM: Product Hierarchy (S&P): Include for JHAP
132	PRDH_HERKUNFT	☐	ISM_PRDH_HERKUNFT	CHAR002	CHAR	2	0	IS-M/AM: Origin Key
133	PRDH_PRODUKT	☐	ISM_PRDH_PROD	ISM_PRDH_PRODUKT	CHAR	11	0	IS-M/AM: Product
134	.INCLUDE	☐				0	0	IS-M: Include for Specific Ad Item Attributes
135	INHK_TECH1	☐	INHK_TECH1	INHALTSKOM	CHAR	8	0	IS-M: Technical Content Component (Positioning View)	JJTIKO
136	INHK_TLEV1	☐	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	*
137	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
138	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
139	INHK_KLEV1	☐	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	*
140	MVA_INHALT	☐	MVA_INHALT	MVA_INHALT	CHAR	4	0	IS-M: Media Publication Content Type	TJJ23
141	PLAZIERUNG	☐	PLAZIERANW	PLAZIERANW	CHAR	2	0	IS-M/AM: Positioning Instruction	TJJ65
142	AZART_PLAZ	☐	AZART_PLAZ	AZART_PLAZ	CHAR	4	0	IS-M: Ad Type with Regard to General Positioning	TJJ15
143	TEC_AVM_NR	☐	TEC_AVM_NR	CHAR10	CHAR	10	0	IS-M: Order number in technical system
144	XPLANUNG	☐	X_PLANUNG	XFELD	CHAR	1	0	IS-M: Relevant for planning indicator
145	XBLATTBEST	☐	XBLATTBEST	XFELD	CHAR	1	0	IS-M: Page-Defining Indicator
146	TBEL	☐	TEILBEL	TEILBEL	CHAR	2	0	IS-M: Selective Booking (Advertisement Item Type)	TJHTBEL
147	.INCLUDE	☐				0	0	IS-PAM: Include for Box Number Attributes
148	CHIFFRE_NR	☐	CHIFFRE	CHIFFRE_NR	CHAR	10	0	IS-M/AM: Box Number
149	CHIFFRE_KZ	☐	CHIFFRE_KZ	CHIFFRE_KZ	CHAR	1	0	IS-M: Box Number Indicator	TJH59
150	CHIFFRE_OR	☐	CHIFFRE_OR	VKBUR	CHAR	4	0	IS-M: Box Number Location	TVBUR
151	.INCLUDE	☐				0	0	IS-M/AM: Include for Specific Ad Insert Attributes
152	BEARB	☐	SINSBEARB	SIBEAR_ART	CHAR	2	0	IS-M: Ad Insert Processing Type	TJH03
153	BLGMENGE	☐	BLGMGE_PAM	STMENGE	DEC	9	0	IS-M: Delivery Quantity for Ad Insert
154	TZUSMENGE	☐	TZUSMENGE	PRZ32	DEC	5	2	IS-M: Additional Tech.Quantity in % (Ad Insert)
155	DISPMENGE	☐	DSPMGE_PAM	STMENGE	DEC	9	0	IS-M: Planning Quantity for Ad Inserts
156	BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
157	XBERMENGE_FIX	☐	JXBERMENGE_FIX	XFELD	CHAR	1	0	IS-M/AM: Calculation Quantity is Fixed indicator
158	POSTMENGE	☐	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
159	SIMENGE_RH	☐	DSPMGE_RH	STMENGE	DEC	9	0	IS-M: Non-Reader Circulation for TMC
160	MUSTER_T	☐	MUSTER_T	MUSTER_ANZ	NUMC	4	0	IS-M: Number of Samples (Technical)
161	MUSTER_P	☐	MUSTER_P	MUSTER_ANZ	NUMC	4	0	IS-M: Number of Samples for Trial Runs (Ad Insert)
162	XFREMDBEIL	☐	XFREMDBEIL	XFELD	CHAR	1	0	IS-M: Indicator - subject to postal charges (ad insert)
163	XBEILAGHW	☐	XBLGHINW	XFELD	CHAR	1	0	IS-M: Insert Note Required Indicator
164	XRESTHSHLT	☐	XRESTHSHLT	XFELD	CHAR	1	0	IS-M: Total Market Coverage
165	RESTHSHLT_DATUM	☐	ISM_DELTA_COVERAGE_DATE	DATUM	DATS	8	0	IS-M: Alternative Date for Total Market Coverage
166	XTRANZ	☐	XTRANZEIGE	XFELD	CHAR	1	0	IS-M: Carrier Ad Required Indicator
167	XTBEL_SI	☐	XTBEL_SI	XFELD	CHAR	1	0	IS-M: Selective Booking of an AI BU
168	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
169	SI_GEWICHT	☐	ISM_SI_GEWICHT	ISPMNG9	QUAN	9	3	IS-M: Ad Insert Weight
170	MEINHGEWBL	☐	MEINHGEWBL	MEINS	UNIT	3	0	IS-M: Unit of Weight for Ad Insert	T006
171	SI_ENTSPFL	☐	ISM_SI_ENTSPFL	XFELD	CHAR	1	0	IS-M: Waste Disposal Required Indicator
172	SI_VERBWER	☐	ISM_SI_VERBWER	XFELD	CHAR	1	0	IS-M: Tie-In Ads Indicator
173	ANZSEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
174	.INCLUDE	☐				0	0	IS-PAM: Include for service
175	MATNR	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	JJTDIEN
176	MENGE	☐	DIEN_MENGE	MENG13	QUAN	13	3	IS-M: Service Quantity
177	ERBTERM_V	☐	ERBTERM_V	DATUM	DATS	8	0	IS-M: Service Performance Period From
178	ERBTERM_B	☐	ERBTERM_B	DATUM	DATS	8	0	IS-M: Service Performance Period To
179	DIENTYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	*
180	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
181	COPY_NO_START	☐	ISM_COPY_NO_START	PAM_PERIOD	CHAR	14	0	IS-M/AM: Start of Period for Copy
182	COPY_NO_END	☐	ISM_COPY_NO_END	PAM_PERIOD	CHAR	14	0	IS-M/AM: End of Period for Copy
183	.INCLUDE	☐				0	0	IS-M: Short and Long Texts
184	KURZTEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
185	LANGTEXT	☐	BEZEICHN50	TEXT50	CHAR	50	0	IS-M: Long Text
186	DIEN_BE	☐	DIEN_BE	BELEINH	CHAR	10	0	IS-M: Service: Assigned Booking Unit	*
187	DIEN_IKO	☐	DIEN_IKO	INHALTSKOM	CHAR	8	0	IS-M: Service: Assigned Content Component	*
188	.INCLUDE	☐				0	0	IS-M/AM: Characteristics for Individual Use
189	MERKMAL0	☐	MERK0_EA	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Individual Use (Ad Schedule Line)
190	MERKMAL1	☐	MERK1_EA	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Ad Schedule Line)
191	MERKMAL2	☐	MERK2_EA	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Ad Schedule Line)
192	MERKMAL3	☐	MERK3_EA	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Ad Schedule Line)
193	MERKMAL4	☐	MERK4_EA	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Ad Schedule Line)
194	MERKMAL5	☐	MERK5_EA	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Ad Schedule Line)
195	MERKMAL6	☐	MERK6_EA	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Ad Schedule Line)
196	MERKMAL7	☐	MERK7_EA	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Ad Schedule Line)
197	MERKMAL8	☐	MERK8_EA	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Individual Use (Ad Schedule Line)
198	MERKMAL9	☐	MERK9_EA	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Ad Schedule Line)
199	.INCLUDE	☐				0	0	IS-PAM: Include for Specific Commercial Attributes
200	WS_ART	☐	WSPOT_ART	WSPOT_ART	CHAR	4	0	IS-M: Commercial Type	TJJ41
201	.INCLUDE	☐				0	0	IS-M/AM: Distribution Item Status Indicator
202	XUVSI	☐	XUVSI	XFELD	CHAR	1	0	IS-M: Ad Insert Data Incomplete Indicator
203	XVT_PLAZ	☐	XVT_PLAZ	XFELD	CHAR	1	0	IS-M: Indicator distribution "positioned"
204	XMUSTER_OK	☐	XMUSTER_OK	XFELD	CHAR	1	0	IS-M: Sample Received and Checked Indicator
205	XSI_VORH	☐	XSI_VORH	XFELD	CHAR	1	0	IS-M: AI Copies Exist
206	XUVTECH	☐	XUVTECH	XFELD	CHAR	1	0	IS-M: Incomplete Regarding Technical System (Gen.)
207	XTECH_MIN1	☐	XTECH_MIN1	XFELD	CHAR	1	0	IS-M: Tech.process.started (for at least 1 schedule line)
208	XTECH_EE	☐	XTECH_EE	XFELD	CHAR	1	0	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
209	.INCLUDE	☐				0	0	IS-M/AM: Online Item Data for LIS Communication Structure
210	BOOK_OL	☐	ISM_BOOK_OL	ISM_BOOK_OL	CHAR	4	0	IS-M/AM: Booking Type for Online Advertising	TJHBOOKOL
211	OLP_START	☐	ONLPOS_START	DATUM	DATS	8	0	IS-M/AM: Start Date for Online Ad
212	OLP_ENDE	☐	ONLPOS_ENDE	DATUM	DATS	8	0	IS-M/AM: End Date for Online Ad
213	XTEXT_INT	☐	XTEXT_INT	XFELD	CHAR	1	0	IS-M: Internal positioning comment indicator
214	XTEXT_EXT	☐	XTEXT_EXT	XFELD	CHAR	1	0	IS-M: External positioning comment exists indicator
215	AE_NR_OL	☐	AENVERS_NR	AENVERS_NR	NUMC	4	0	IS-M: Last Change Version for Technical System
216	.INCLUDE	☐				0	0	IS-M: LIS communication structure, order data item extra
217	XBASIS_BE	☐	XBASIS_BE	XFELD	CHAR	1	0	IS-M: Basic Booking Unit (Sales View) Indicator
218	ANFANG_PER	☐	ANFANG_PER	PAM_PERIOD	CHAR	14	0	IS-M: Start of Copy/Publication Date Period
219	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	*
220	STGKUP	☐	STGKU	STGKU	CHAR	1	0	Customer Statistics Group	*
221	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	*
222	VRTMENGE	☐	VRTMGE_PAM	STMENGE	DEC	9	0	IS-M: Planning Quantity for Ad Inserts
223	TERM_TYP	☐	TERMINTYP	TERMINTYP	CHAR	1	0	IS-M/AM: Date Category Copy Number/Publication Date	*
224	ENDE_PER	☐	ENDE_PER	PAM_PERIOD	CHAR	14	0	IS-M: End of Period - Issue/Publication Date
225	BIS_PLUS	☐	BIS_PLUS	BIS_PLUS	CHAR	1	0	IS-M: Indicates a Period ("-") or 2 Dates ("+")
226	ANZ_SCHALT	☐	ANZ_SCHALT	ANZ_SCHALT	NUMC	3	0	IS-M: Number of Placements
227	TERM_ZYKL	☐	ANZ_ZYKLUS	ANZ_ZYKLUS	CHAR	4	0	IS-M: Frequency for Ad Publication	*
228	TERMINART	☐	TERMINART	TERMINART	CHAR	1	0	IS-M/AM: Type of Publication Date
229	ERSCH_T	☐	ERSCH_T	DATUM	DATS	8	0	IS-M: Publication Date
230	WUNSCH_T	☐	WUNSCH_T	DATUM	DATS	8	0	IS-M/AM: Date Required
231	.INCLUDE	☐				0	0	IS-M/AM: Include for Weekday String
232	X_MONTAG	☐	JHT_MONTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Monday
233	X_DIENSTAG	☐	JHT_DIENSTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Tuesday
234	X_MITTWOCH	☐	JHT_MITTWOCH	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Wednesday
235	X_DONNERST	☐	JHT_DONNERST	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Thursday
236	X_FREITAG	☐	JHT_FREITAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Friday
237	X_SAMSTAG	☐	JHT_SAMSTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Saturday
238	X_SONNTAG	☐	JHT_SONNTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Sunday
239	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	*
240	KONKAUSKOM	☐	KONKAUSKOM	TEXT35	CHAR	35	0	IS-M: Comment on competitor exclusion
241	SORTWORT	☐	SORTWORT	TEXT10	CHAR	10	0	IS-M: Sort Word
242	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	MCJHAPB	AVM_NR	JHAK	AVM_NR	KEY	1	CN
2	MCJHAPB	AZART_PLAZ	TJJ15	AZART_PLAZ	REF	1	CN
3	MCJHAPB	BEARB	TJH03	BEARB	KEY	1	CN
4	MCJHAPB	BEDNR	JJTVB	BEDNR	KEY	1	CN
5	MCJHAPB	BOOK_OL	TJHBOOKOL	BOOK_OL		1	CN
6	MCJHAPB	BRAN_PAM	TBRC	BRACO	REF	1	CN
7	MCJHAPB	BSARK	T176	BSARK	REF	C	CN
8	MCJHAPB	CHIFFRE_KZ	TJH59	CHIFFRE_KZ	REF	1	CN
9	MCJHAPB	CHIFFRE_OR	TVBUR	VKBUR	REF	1	CN
10	MCJHAPB	INHK_KFM	JJTIKO	INHALTSKOM		1	CN
11	MCJHAPB	INHK_TECH1	JJTIKO	INHALTSKOM	REF	1	CN
12	MCJHAPB	INHK_TECH2	JJTIKO	INHALTSKOM	REF	1	CN
13	MCJHAPB	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
14	MCJHAPB	MANDT	T000	MANDT
15	MCJHAPB	MATNR	JJTDIEN	MATNR	REF	1	CN
16	MCJHAPB	MEINHGEWBL	T006	MSEHI
17	MCJHAPB	MVA_INHALT	TJJ23	MVA_INHALT	KEY	1	CN
18	MCJHAPB	PLAZIERUNG	TJJ65	PLAZIERANW	REF	1	CN
19	MCJHAPB	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
20	MCJHAPB	PROSL	TJH23	PRSCHL	KEY	1	CN
21	MCJHAPB	PSTYV	TJHAP	PSTYV	REF	1	CN
22	MCJHAPB	REF_AVM_NR	JHAK	AVM_NR	REF	1	CN
23	MCJHAPB	REF_POS_NR	JHAP	POS_NR	REF	1	CN
24	MCJHAPB	SI_TYP	TJH29	SI_TYP
25	MCJHAPB	STAFO	TMCB	STAFO	REF	1	CN
26	MCJHAPB	STORNOGRND	TJHSTOG	STORNOGRD	REF	1	CN
27	MCJHAPB	SUC_AVM_NR	JHAK	AVM_NR	REF	1	CN
28	MCJHAPB	SUC_POS_NR	JHAP	POS_NR	REF	1	CN
29	MCJHAPB	TBEL	TJHTBEL	TBEL	REF	1	CN
30	MCJHAPB	VNR	JJTVV	VNR	KEY	1	CN
31	MCJHAPB	VORL_AVMNR	JHAK	AVM_NR	REF	1	CN
32	MCJHAPB	VORL_POSNR	JHAP	POS_NR	REF	1	CN
33	MCJHAPB	WERBK_EINT	JHAE	EIN_NR		1	CN
34	MCJHAPB	WERBK_POS	JHAP	POS_NR		1	CN
35	MCJHAPB	WERBK_TYP	TJH91	WKOMBI_TYP		1	CN
36	MCJHAPB	WS_ART	TJJ41	WSPOT_ART	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in