SAP ABAP Table MCJHAGA (IS-PAM: LIS communication structure for order bill.dataset)

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	MCJHAGA	Table Relationship Diagram
Short Description	IS-PAM: LIS communication structure for order bill.dataset

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

History

Last changed by/on	SAP	20130529
SAP Release Created in