SAP ABAP Table MCJHAGAB (IS-M: Reference structure for MCJHAGA for LIS func.mod. S)

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	MCJHAGAB	Table Relationship Diagram
Short Description	IS-M: Reference structure for MCJHAGA for LIS func.mod. S

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-PAM: LIS communication structure for order bill.dataset
4	.INCLUDE	☐				0	0	IS-M/AM: Order-Publishing-Media Billing Dataset
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	JHAP
8	GRUPPABRNR	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	*
9	BELEGEINH	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
10	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	JJTBE
11	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JHAISZ
12	REGULIERER	☐	GPNR_RG	GPNR	CHAR	10	0	IS-M: Payer Business Partner	JGTGPNR
13	GPNR_RECH	☐	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	JGTGPNR
14	MOTIV	☐	MOTIV_NR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Number (Ad)	JHAMOT
15	GFMANUAEND	☐	GFMANUAEND	XFELD	CHAR	1	0	IS-M: Billing Dataset Changed Manually
16	GF_STATUS	☐	GF_STATUS	PAM_STATUS	CHAR	2	0	IS-M: Billing Dataset Status
17	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
18	AB_BRUTTO	☐	AB_BRUTTO	WERTV8	CURR	15	2	IS-M: Contract Gross
19	KB_BRUTTO	☐	AB_BRUTTO	WERTV8	CURR	15	2	IS-M: Contract Gross
20	AB_BR_WAEH	☐	AB_BR_WAEH	WAERS	CUKY	5	0	IS-M: Gross Contract Currency	TCURC
21	.INCLUDE	☐				0	0	IS-M/AM: Surcharges And Discounts (Update)
22	RAB1_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
23	RAB1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
24	RAB1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
25	RAB2_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
26	RAB2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
27	RAB2_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
28	RAB3_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
29	RAB3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
30	RAB3_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
31	RAB4_BETR	☐	JRABMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent discount
32	RAB4_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
33	RAB4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
34	RAB4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
35	RAB4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
36	RAB5_BETR	☐	JRABBETR	WERTV6	CURR	11	2	IS-M/AM: Amount discount
37	RAB5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
38	RAB5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
39	RABE_BETR	☐	JRABBETR	WERTV6	CURR	11	2	IS-M/AM: Amount discount
40	RABE_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
41	RABE_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
42	ZUS1_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
43	ZUS1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
44	ZUS1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
45	ZUS2_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
46	ZUS2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
47	ZUS2_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
48	ZUS3_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
49	ZUS3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
50	ZUS3_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
51	ZUS4_BETR	☐	JZUSMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent surcharge
52	ZUS4_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
53	ZUS4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
54	ZUS4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
55	ZUS4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
56	ZUS5_BETR	☐	JZUSBETR	WERTV6	CURR	11	2	IS-M/AM: Amount Surcharge
57	ZUS5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
58	ZUS5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
59	ZUSE_BETR	☐	JZUSBETR	WERTV6	CURR	11	2	IS-M/AM: Amount Surcharge
60	ZUSE_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
61	ZUSE_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
62	FPRG_BETR	☐	JGPRBETR	WERTV6	CURR	11	2	IS-M/AM: Basic Price
63	FPRG_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
64	FPRG_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
65	FPRG_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
66	FPRG_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
67	FPR1_BETR	☐	JVPRBETR	WERTV6	CURR	11	2	IS-M/AM: Agreed price
68	FPR1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
69	FPR1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
70	XRABZU	☐	XRABZU	XFELD	CHAR	1	0	IS-M: Discount/Surcharge Exists Indicator
71	WAER_IPZA	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
72	XUZUO_LOE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
73	.INCLUDE	☐				0	0	IS-PAM: Include for Business Data
74	WAERG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
75	FAKSPP	☐	PAM_FAKSP	FAKSP	CHAR	2	0	IS-M: Billing Block	TVFS
76	XSEPFKKOPF	☐	XSEPFKKOPF	XFELD	CHAR	1	0	Separate billing document for sales order
77	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
78	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
79	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
80	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
81	FAKDATUM	☐	JHFKTER	DATUM	DATS	8	0	IS-M: Planned Billing/Settlement Date
82	VORAUSKNZ	☐	VORAUSKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Advance Billing Required
83	VORAUSRCH	☐	VORAUSRCH	XFELD	CHAR	1	0	IS-M: "Advance billing required" indicator
84	XRECHN	☐	XRECHN	XFELD	CHAR	1	0	IS-M: Invoice Requested Indicator
85	XKFMAEND	☐	XKFMAEND	XFELD	CHAR	1	0	IS-M: Business Data was Changed Manually Indicator
86	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
87	XORTSPREIS	☐	XORTSPREIS	XFELD	CHAR	1	0	IS-M/AM: Local Customer Indicator
88	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer	TVKD
89	KUKARR_K	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
90	KARENZ	☐	JKARENZ	JKARENZ	NUMC	4	0	IS-M: Grace Period for Price Changes
91	KARENZ_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
92	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
93	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
94	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
95	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
96	AE	☐	AGEN_AE	AGEN_AE	CHAR	1	0	IS-M: Agency Commission Entitlement
97	.INCLUDE	☐				0	0	IS-PAM: Include for Material Tax Classification
98	TAXM1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material	*
99	TAXM2	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material	*
100	TAXM3	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material	*
101	TAXM4	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material	*
102	TAXM5	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material	*
103	TAXM6	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material	*
104	TAXM7	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material	*
105	TAXM8	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material	*
106	TAXM9	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material	*
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	XAB_AUS	☐	XAB_AUS	XFELD	CHAR	1	0	IS-M: Contract Exclusion Requirement Applies Yes/No
115	.INCLUDE	☐				0	0	IS-M/AM: Contracts Entered in JHAGA
116	ACT_ABSCHL	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
117	ABSCHL_NR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVABRUF
118	ABSCHL_POS	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	JHTVABRUF
119	.INCLUDE	☐				0	0	IS-PAM: Include Customer Outline Agreement Indicator
120	XRABATT	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
121	XMITZRAB	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
122	XBONUS	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
123	XMITZBON	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
124	XMANUELL	☐	XMANUELL1	XFELD	CHAR	1	0	IS-M: Contract Assignments Changed Manually Indicator
125	AB_RABATT	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
126	AB_PREIS	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
127	AKTBONUS	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
128	ACT_ABSCH2	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
129	ABSCHL_NR2	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVABRUF
130	ABSCHL_PO2	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	JHTVABRUF
131	XRABATT2	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
132	XMITZRAB2	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
133	XBONUS2	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
134	XMITZBON2	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
135	XMANUELL2	☐	XMANUELL	XFELD	CHAR	1	0	IS-M: Manual post-editing has taken place
136	AB_RABATT2	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
137	AB_PREIS2	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
138	AKTBONUS2	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
139	ACT_ABSCH3	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
140	ABSCHL_NR3	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVABRUF
141	ABSCHL_PO3	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	JHTVABRUF
142	XRABATT3	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
143	XMITZRAB3	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
144	XBONUS3	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
145	XMITZBON3	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
146	XMANUELL3	☐	XMANUELL	XFELD	CHAR	1	0	IS-M: Manual post-editing has taken place
147	AB_RABATT3	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
148	AB_PREIS3	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
149	AKTBONUS3	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
150	PREIS_OM	☐	PREIS_OM	WERTV8	CURR	15	2	IS-M: Price excluding VAT
151	PREIS_IM	☐	PREIS_IM	WERTV8	CURR	15	2	IS-M: Price including VAT
152	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
153	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
154	MWST_BETR	☐	GRMWSTBETR	WERTV7	CURR	13	2	IS-M: Value-Added Tax Amount
155	XPREISAEND	☐	XPREISAEND	XFELD	CHAR	1	0	IS-M: Price Was Changed Indicator
156	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
157	NETWFP	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
158	MWSBFP	☐	MWSBFP	WERTV7	CURR	13	2	IS-M: Tax Amount for Billing Item in Document Currency
159	BER_TERMIN	☐	BER_TERMIN	DATUM	DATS	8	0	IS-M: Date Services were Created for Settlement Purposes
160	BER_TERMIN_BIS	☐	BER_TERMIN_BIS	DATUM	DATS	8	0	IS-M: End Date for Service Creation in Terms of Settlement
161	BER_HEFT	☐	ISM_BER_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Service Creation Copy Number for Settlement
162	TERM_TYP	☐	TERMINTYP	TERMINTYP	CHAR	1	0	IS-M/AM: Date Category Copy Number/Publication Date	TJH55
163	VAVARTYP	☐	VAVARTYPTA	VAVARTYP	CHAR	2	0	Actual issue variant type	TJD05
164	OFFSET_FAK	☐	OFFSET_FAK	OFFSET_FAK	NUMC	2	0	IS-M: Offset in days for billing date
165	OFFSET_VZ	☐	OFFSET_VZ	PAM_VZ	CHAR	1	0	IS-M: Billing offset sign
166	XKARENZ	☐	XKARENZ	XFELD	CHAR	1	0	IS-M: Use Grace Period Yes / No
167	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
168	STRUK_HTYP	☐	IKO_HIETYP	IKO_HIETYP	CHAR	2	0	IS-M: Content Component Hierarchy Type	TJJ51
169	STRUK_HVAR	☐	STRUK_HVAR	IKO_HIEVAR	CHAR	6	0	IS-M: Content Component Structural Hierarchy Variant	TJJ55
170	PREIS_HTYP	☐	IKO_HIETYP	IKO_HIETYP	CHAR	2	0	IS-M: Content Component Hierarchy Type	TJJ51
171	PREIS_HVAR	☐	PREIS_HVAR	IKO_HIEVAR	CHAR	6	0	IS-M: Content Component Hierarchy Variant for Pricing	TJJ55
172	IHKOMP	☐	INHK_PRICE	INHALTSKOM	CHAR	8	0	IS-M: Content component from price hierarchy	JJTIKO
173	SEITE_FSP	☐	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	TJJ47
174	SEITE_FORM	☐	SEITE_FORM	SEITE_FORM	CHAR	2	0	IS-M: Page Format	TJJ01
175	SMM_SFSP	☐	MENGE_SMM	DEC10_3	DEC	13	3	IS-M: Size in column mm
176	SFSP_ABR	☐	SFSP_ABR	SEITE_FSP	CHAR	4	0	IS-M: Column Format for Settlement	TJJ47
177	SMM_ABR	☐	MENGE_SMM	DEC10_3	DEC	13	3	IS-M: Size in column mm
178	FACT_ABR	☐	FACT_ABR	DECV1_3	DEC	4	3	IS-M: Conversion Factor for Settlement
179	WERBK_TYP	☐	WERBK_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Advertising Combination Type	TJH91
180	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
181	ABS_MAL	☐	JHRSMAL	JHRSMAL	DEC	5	0	IS-M: Number for Contract Standing
182	.INCLUDE	☐				0	0	IS-M: Include for size fields relevant to settlement
183	AZART_AREA	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	TJJ13
184	BREITE	☐	BREITE_VER	GROESSE	QUAN	7	3	IS-M: Ad Spec Width for Settlement
185	BREITE_EH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	TJH57
186	HOEHE	☐	HOEHE_VER	GROESSE	QUAN	7	3	IS-M: Clearable Height for Ad Spec
187	HOEHE_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	TJH61
188	ZUS_MENGE	☐	BER_MENGE	GROESSE	QUAN	7	3	IS-M: Number of Additional Ad Spec Calculation Units
189	ZUS_BERECH	☐	MEINH_ZUS	ISPEINHEIT	UNIT	3	0	IS-M: Additional Unit of Measure for Settlement	TJH57
190	MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
191	LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
192	AZART_GEST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
193	AZART_FORM	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	TJJ17
194	AZART_FARB	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	TJJ11
195	AZART_SOND	☐	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	TJJ49
196	FKART	☐	FKART_PAM	FKART_PAM	CHAR	4	0	IS-M/AM: Billing/Settlement Document Type	TJH05
197	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	*
198	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
199	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
200	BLGMENGE	☐	BLGMENGE	STMENGE	DEC	9	0	IS-M: Order Quantity for Insertion
201	DISPMENGE	☐	DISPMENGE	STMENGE	DEC	9	0	IS-M: Planning Quantity of Carrying Issue
202	VRTMENGE	☐	VRTMGI_PAM	STMENGE	DEC	9	0	IS-M/AM: Actual Quantity for Distribution
203	BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
204	POSTMENGE	☐	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
205	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
206	SIGEWICHT	☐	VAGEWIST	ISPMNG9	QUAN	9	3	Actual Issue Weight
207	SIGEW_ME	☐	MEINHVAGEI	MEINS	UNIT	3	0	Unit of weight for actual issue weight	T006
208	SI_GEWKL	☐	ISM_SI_GEWKL	SI_GEWKL	CHAR	4	0	IS-M: Ad inserts weight price group	TJHGEWKL
209	SI_SEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
210	SI_SEKL	☐	ISM_SI_SEKL	SI_SEKL	CHAR	4	0	IS-M: Price Group for Ad Insert Pages	TJHSEKL
211	WS_TIMESLC	☐	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	TJJW1
212	WS_BLOCK	☐	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	TJJW3
213	WS_STELLE	☐	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
214	XUNITERROR	☐	XUNITERROR	XFELD	CHAR	1	0	IS-M: Quantity Conversion Error Indicator
215	XAEPROV	☐	XAEPROV	XFELD	CHAR	1	0	IS-M: Agency Commission Credit Memo Indicator
216	ZW_GRABRNR	☐	ISM_TWIN_BILLING_DATASET_NO	GRUPPABR	NUMC	3	0	IS-M: Twinned Billing Dataset for Separate Agency Commission	JHAGA
217	JAEPRBASIS	☐	JAEPRBASIS	WERTV7	CURR	13	2	IS-M: Agency commission basis
218	ANZ_ANFS	☐	ANZ_ANFS	ANZ_ANFS	NUMC	3	0	IS-M: No.of Placements Qual.for Disc.Due to Pub.in Other BUs
219	ANZ_WNFS	☐	ANZ_WNFS	ANZ_ANFS	NUMC	3	0	IS-M: No.of Placements Qual.For Dis.Due to Publc.On Oth.Days
220	.INCLUDE	☐				0	0	IS-PAM: Status characteristics for billing dataset
221	XFAKT_EE	☐	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator
222	XPROVMIN1	☐	XPROVMIN1	XFELD	CHAR	1	0	Partial Commission (At Least 1 Sales Agent Assignment Comm.)
223	XPROVALL	☐	XPROVALL	XFELD	CHAR	1	0	Commission Calculated For All Sales Agent Assignments Ind.
224	XUVVZ	☐	XUVVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Incomplete
225	XERL_EE	☐	XERL_EE	XFELD	CHAR	1	0	IS-M: Revenue Distribution Performed
226	XABS_EE	☐	XABS_EE	XFELD	CHAR	1	0	IS-M: Contract Final Settlement Performed
227	XPREIS_EE	☐	XPREIS_EE	XFELD	CHAR	1	0	IS-M: Pricing completed
228	XCCAUTNOTW	☐	XCCAUTNOTW	XFELD	CHAR	1	0	IS-M/AM: Payment card authorization required
229	XCMP_FAILED	☐	XCMP_FAILED	XFELD	CHAR	1	0	IS-M/AM: Credit check failed
230	.INCLUDE	☐				0	0	IS-PAM: Characteristics for individual use (billing dataset)
231	MERKMAL0	☐	MERK0_GA	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Billing Dataset)
232	MERKMAL1	☐	MERK1_GA	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Billing Dataset)
233	MERKMAL2	☐	MERK2_GA	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Billing Dataset)
234	MERKMAL3	☐	MERK3_GA	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Billing Dataset)
235	MERKMAL4	☐	MERK4_GA	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Billing Dataset)
236	MERKMAL5	☐	MERK5_GA	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Billing Dataset)
237	MERKMAL6	☐	MERK6_GA	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Billing Dataset)
238	MERKMAL7	☐	MERK7_GA	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Billing Dataset)
239	MERKMAL8	☐	MERK8_GA	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Individual Use (Billing Dataset)
240	MERKMAL9	☐	MERK9_GA	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Billing Dataset)
241	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
242	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
243	REF_VBELN	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	JHTFK
244	REF_POSNR	☐	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document	JHTFP
245	XFCNCL	☐	JH_XCNCL	XFELD	CHAR	1	0	IS-M/AM: Reversal Indicator for Billing Item
246	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
247	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
248	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
249	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
250	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
251	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
252	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
253	CMPRE_FLT	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
254	FORMAT_ONL	☐	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)	*
255	RRREL	☐	ISMRR_RELTYP	ISMRR_RELTYP	CHAR	1	0	IS-M/AM: Revenue Recognition Category
256	RRSTA	☐			CHAR	1	0
257	X_SL_CONTCOMP_CH	☐	ISM_PUB_CHAN_SL_CONTCOMP_CHNGD	XFELD	CHAR	1	0	Publication Change: Content Component for Sched.Line Changed
258	.INCLUDE	☐				0	0	IS-M/AM: Non-Key Fields for JHAGA2
259	.INCLUDE	☐				0	0	IS-M/AM: Payment cards: Data in JHAGA
260	CCAUA	☐	CCAUA	CCAUA	CHAR	1	0	Payment cards: Authorization type
261	CCOLD	☐	CCOLD	XFELD	CHAR	1	0	Payment cards: Authorization has expired
262	CCVAL	☐	CCVAL	XFELD	CHAR	1	0	Payment cards: Amount changed
263	CCPRE	☐	CCPRE	XFELD	CHAR	1	0	Payment cards: Preauthorization
264	CCACT	☐	CCACT	SAKNR	CHAR	10	0	G/L Account Number for Payment Card Receivables	SKA1
265	AUTWV	☐	AUTWV	WERTV8	CURR	15	2	Payment cards: Amount to be authorized
266	AUDAT_CC	☐	AUDAT_CC	DATUM	DATS	8	0	Payment cards: Authorization date
267	AUTIM	☐	AUTIM	UZEIT	TIMS	6	0	Payment cards: Authorization time
268	CCALL	☐	CCALL	CCALL	CHAR	1	0	Payment cards: Status when external system is called?
269	REACT	☐	REACT_SD	REACT_SD	CHAR	1	0	Payment cards: Response to authorization checks
270	AUTWR	☐	AUTWR	WERTV8	CURR	15	2	Payment cards: Authorized amount
271	CCWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
272	AUNUM	☐	AUNUM	CHAR10	CHAR	10	0	Payment cards: Authorization number
273	AUTRA	☐	AUTRA	CHAR15	CHAR	15	0	Payment cards: Authoriz. reference code of clearing house
274	RCAVR	☐	RCAVR_CC	CHAR4	CHAR	4	0	Payment Cards: Result of Address Check (Address Result)	TCCRC
275	RCAVA	☐	RCAVA_CC	CHAR4	CHAR	4	0	Payment Cards: Result of Address Check (Address Approval)	TCCRC
276	RCAVZ	☐	RCAVZ_CC	CHAR4	CHAR	4	0	Payment Cards: Result of Address Check (ZIP Code Result)	TCCRC
277	RCRSP	☐	RCRSP_CC	CHAR4	CHAR	4	0	Payment cards: Result of card check (response code)	TCCRC
278	.INCLUDE	☐				0	0	Response for Card Verification Value
279	RCCVV	☐	ISM_RCCVV_CC	CHAR4	CHAR	4	0	Results Check for Card Verification Value	TCCRC
280	.INCLUDE	☐				0	0	IS-M/AM: Credit Management: Billing Dataset Credit Fields
281	CMPSA	☐	CMPSA	CMPSZ	CHAR	1	0	Status of static credit limit check
282	CMPSB	☐	CMPSB	CMPSZ	CHAR	1	0	Status of dynamic credit limit check in the credit horizon
283	CMPSC	☐	CMPSC	CMPSZ	CHAR	1	0	Status of credit check against maximum document value
284	CMPSE	☐	CMPSE	CMPSZ	CHAR	1	0	Status of credit check against customer review date
285	CMPSF	☐	CMPSF	CMPSZ	CHAR	1	0	Status of credit check against open items due
286	CMPSG	☐	CMPSG	CMPSZ	CHAR	1	0	Status of credit check against oldest open items
287	CMPSH	☐	CMPSH	CMPSZ	CHAR	1	0	Status of credit check against highest dunning level
288	CMPS0	☐	CMPS0	CMPSZ	CHAR	1	0	Status of credit check for customer reserve 1
289	CMPS1	☐	CMPS1	CMPSZ	CHAR	1	0	Status of credit check for customer reserve 2
290	CMPS2	☐	CMPS2	CMPSZ	CHAR	1	0	Status of credit check for customer reserve 3
291	CMPSM	☐	CMPSM	CMPSZ	CHAR	1	0	Credit check data is obsolete
292	CMGST	☐	ISMAM_CMGST	CMGST	CHAR	1	0	IS-M/AM: Credit Management: Overall Status of Credit Checks
293	.INCLUDE	☐				0	0	IS-M/AM Quantity Determination in JHAGA2
294	MF_BER_MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
295	MF_COA_MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
296	MF_COA_LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
297	.INCLUDE	☐				0	0	IS-M/AM: Multiple Placements JHAGA2
298	INS_SERIES_RULE	☐	ISM_INSERTION_SERIES_RULE	ISM_INSERTION_SERIES_RULE	CHAR	4	0	IS-M/AM: Series Rule	TJHINSSER
299	INS_SERIES	☐	ISM_INSERTION_SERIES	CHAR4	CHAR	4	0	IS-M/AM: Unique Identification of a Series Found
300	INS_SERIES_NO	☐	ISM_INSERTION_SERIES_NO	NUM4	NUMC	4	0	IS-M/AM: Unique Billing Dataset Number Within a Series
301	.INCLUDE	☐				0	0	IS-M/AM: Order-Publishing-Media Billing Dataset Ad Size
302	ORIGINAL_AD_SIZE	☐	ISM_ORIGINAL_AD_SIZE	MENG13	QUAN	13	3	Original Complete Ad Size
303	.INCLUDE	☐				0	0	IS-M: LIS communication structure, order data item extra
304	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	*
305	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
306	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
307	AGENTUR1	☐	AGENTUR	GPNR	CHAR	10	0	IS-M: Agency	JGTGPNR
308	AGENTUR2	☐	AGENTUR	GPNR	CHAR	10	0	IS-M: Agency	JGTGPNR
309	AGENTUR3	☐	AGENTUR	GPNR	CHAR	10	0	IS-M: Agency	JGTGPNR
310	AGENTUR4	☐	AGENTUR	GPNR	CHAR	10	0	IS-M: Agency	JGTGPNR
311	BEGRP_STAT	☐	BEGRP_STAT	BEGRP_STAT	CHAR	4	0	IS-M: BU Grouping for Statistics	TJJ67
312	IKO_STAT	☐	IKO_STAT	INHALTSKOM	CHAR	8	0	IS-M: Statistical content component	JJTIKO
313	TERMINSPEZ	☐	TERMINSPEZ	TERMINSPEZ	CHAR	6	0	IS-M/AM: Specify Dates for Date Combinations	TJJ71
314	IKO_STAT_H	☐	IKO_STAT	INHALTSKOM	CHAR	8	0	IS-M: Statistical content component	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCJHAGAB	ABSCHL_NR	JHTVABRUF	VTNR	KEY	1	CN
2	MCJHAGAB	ABSCHL_NR2	JHTVABRUF	VTNR	REF	C	CN
3	MCJHAGAB	ABSCHL_NR3	JHTVABRUF	VTNR		C	CN
4	MCJHAGAB	ABSCHL_PO2	JHTVABRUF	POSNR	REF	C	CN
5	MCJHAGAB	ABSCHL_PO3	JHTVABRUF	POSNR		C	CN
6	MCJHAGAB	ABSCHL_POS	JHTVABRUF	POSNR	KEY	1	CN
7	MCJHAGAB	AB_BR_WAEH	TCURC	WAERS		1	CN
8	MCJHAGAB	ACT_ABSCH2	JHTVKO	VTNR	REF	C	CN
9	MCJHAGAB	ACT_ABSCH3	JHTVKO	VTNR		C	CN
10	MCJHAGAB	ACT_ABSCHL	JHTVKO	VTNR	KEY	1	CN
11	MCJHAGAB	AGENTUR1	JGTGPNR	GPNR	REF	1	CN
12	MCJHAGAB	AGENTUR2	JGTGPNR	GPNR	REF	1	CN
13	MCJHAGAB	AGENTUR3	JGTGPNR	GPNR	REF	1	CN
14	MCJHAGAB	AGENTUR4	JGTGPNR	GPNR	REF	1	CN
15	MCJHAGAB	AVM_NR	JHAK	AVM_NR	KEY	1	CN
16	MCJHAGAB	AZART_AREA	TJJ13	AZART_AREA		1	CN
17	MCJHAGAB	AZART_FARB	TJJ11	AZART_FARB	KEY	1	CN
18	MCJHAGAB	AZART_FORM	TJJ17	AZART_FORM	KEY	1	CN
19	MCJHAGAB	AZART_GEST	TJJ19	AZART_GEST	KEY	1	CN
20	MCJHAGAB	AZART_SOND	TJJ49	AZART_SOND	REF	1	CN
21	MCJHAGAB	BEGRP_STAT	TJJ67	BEGRP_STAT		1	CN
22	MCJHAGAB	BELEGEINH	JJTBE	BELEINH	KEY	1	CN
23	MCJHAGAB	BREITE_EH	TJH57	ISPEINHEIT	REF	1	CN
24	MCJHAGAB	CCACT	SKA1	SAKNR		1	CN
25	MCJHAGAB	CCWAE	TCURC	WAERS	REF	1	CN
26	MCJHAGAB	DRERZ	JDTDRER	DRERZ	REF	1	CN
27	MCJHAGAB	FAKSPP	TVFS	FAKSP
28	MCJHAGAB	FKART	TJH05	FKART	REF	1	CN
29	MCJHAGAB	GPNR_RECH	JGTGPNR	GPNR	REF	1	CN
30	MCJHAGAB	HOEHE_EH	TJH61	ISPEINH_H	REF	1	CN
31	MCJHAGAB	IHKOMP	JJTIKO	INHALTSKOM	REF	1	CN
32	MCJHAGAB	IKO_STAT	JJTIKO	INHALTSKOM		1	CN
33	MCJHAGAB	INSERENT	JHAISZ	INSERENT	KEY	1	CN
34	MCJHAGAB	INS_SERIES_RULE	TJHINSSER	INS_SERIES_RULE
35	MCJHAGAB	KALKS	TVKD	KALKS
36	MCJHAGAB	KARENZ_ME	T006	MSEHI	KEY	1	CN
37	MCJHAGAB	KDGRP	T151	KDGRP	REF	1	CN
38	MCJHAGAB	KONDA	T188	KONDA
39	MCJHAGAB	KUKARR_K	TJJ95	KUKARR
40	MCJHAGAB	KURST	TCURV	KURST	REF	1	CN
41	MCJHAGAB	LAGME	T006	MSEHI	REF	1	CN
42	MCJHAGAB	MANDT	T000	MANDT
43	MCJHAGAB	MOTIV	JHAMOT	MOTIV	REF	1	CN
44	MCJHAGAB	PERFK	TFACD	IDENT
45	MCJHAGAB	PLTYP	T189	PLTYP	REF	1	CN
46	MCJHAGAB	POS_NR	JHAP	POS_NR	KEY	1	CN
47	MCJHAGAB	PREIS_HTYP	TJJ51	IKO_HIETYP	KEY	1	CN
48	MCJHAGAB	PREIS_HVAR	TJJ55	IKO_HIEVAR	KEY	1	CN
49	MCJHAGAB	PSTYV	TJHAP	PSTYV	KEY	1	CN
50	MCJHAGAB	PVA	JDTPVA	PVA	REF	1	CN
51	MCJHAGAB	RCAVA	TCCRC	RCODE		1	CN
52	MCJHAGAB	RCAVR	TCCRC	RCODE		1	CN
53	MCJHAGAB	RCAVZ	TCCRC	RCODE		1	CN
54	MCJHAGAB	RCCVV	TCCRC	RCODE
55	MCJHAGAB	RCRSP	TCCRC	RCODE	REF	1	CN
56	MCJHAGAB	REF_POSNR	JHTFP	POSNR	REF	1	CN
57	MCJHAGAB	REF_VBELN	JHTFK	VBELN	REF	1	CN
58	MCJHAGAB	REGULIERER	JGTGPNR	GPNR	REF	1	CN
59	MCJHAGAB	SEITE_FORM	TJJ01	SEITE_FORM	KEY	1	CN
60	MCJHAGAB	SEITE_FSP	TJJ47	SEITE_FSP	KEY	1	CN
61	MCJHAGAB	SFSP_ABR	TJJ47	SEITE_FSP	REF	1	CN
62	MCJHAGAB	SIGEW_ME	T006	MSEHI	REF	1	CN
63	MCJHAGAB	SI_GEWKL	TJHGEWKL	SI_GEWKL	REF	1	CN
64	MCJHAGAB	SI_SEKL	TJHSEKL	SI_SEKL	REF	1	CN
65	MCJHAGAB	SI_TYP	TJH29	SI_TYP	REF	1	CN
66	MCJHAGAB	STAFO	TMCB	STAFO	REF	1	CN
67	MCJHAGAB	STORNOGRND	TJHSTOG	STORNOGRD	REF	1	CN
68	MCJHAGAB	STRUK_HTYP	TJJ51	IKO_HIETYP	REF	1	CN
69	MCJHAGAB	STRUK_HVAR	TJJ55	IKO_HIEVAR	REF	1	CN
70	MCJHAGAB	TERMINSPEZ	TJJ71	TERMINSPEZ		1	CN
71	MCJHAGAB	TERM_TYP	TJH55	TERM_TYP	KEY	1	CN
72	MCJHAGAB	UR_BELEINH	JJTBE	BELEINH	REF	1	CN
73	MCJHAGAB	VAVARTYP	TJD05	VAVARTYP	KEY	1	CN
74	MCJHAGAB	WAERG	TCURC	WAERS		1	CN
75	MCJHAGAB	WERBK_TYP	TJH91	WKOMBI_TYP	REF	1	CN
76	MCJHAGAB	WS_BLOCK	TJJW3	WS_BLOCK	REF	1	CN
77	MCJHAGAB	WS_TIMESLC	TJJW1	WS_TIMESLC	REF	1	CN
78	MCJHAGAB	ZLSCH	T042Z	ZLSCH	REF	1	CN
79	MCJHAGAB	ZUS_BERECH	TJH57	ISPEINHEIT	REF	1	CN
80	MCJHAGAB	ZW_GRABRNR	JHAGA	GRUPPABRNR	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in