SAP ABAP Table JHAGA (IS-M/AM: Order-Publishing-Media Billing 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	TRANSP	Transparent table
Transparent table	JHAGA	Table Relationship Diagram
Short Description	IS-M/AM: Order-Publishing-Media Billing Dataset

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	JHAP
4	GRUPPABRNR	☑	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset
5	BELEGEINH	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
6	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	JJTBE
7	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JHAISZ
8	REGULIERER	☐	GPNR_RG	GPNR	CHAR	10	0	IS-M: Payer Business Partner	JGTGPNR
9	GPNR_RECH	☐	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	JGTGPNR
10	MOTIV	☐	MOTIV_NR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Number (Ad)	JHAMOT
11	GFMANUAEND	☐	GFMANUAEND	XFELD	CHAR	1	0	IS-M: Billing Dataset Changed Manually
12	GF_STATUS	☐	GF_STATUS	PAM_STATUS	CHAR	2	0	IS-M: Billing Dataset Status
13	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
14	AB_BRUTTO	☐	AB_BRUTTO	WERTV8	CURR	15	2	IS-M: Contract Gross
15	KB_BRUTTO	☐	AB_BRUTTO	WERTV8	CURR	15	2	IS-M: Contract Gross
16	AB_BR_WAEH	☐	AB_BR_WAEH	WAERS	CUKY	5	0	IS-M: Gross Contract Currency	TCURC
17	.INCLUDE	☐				0	0	IS-M/AM: Surcharges And Discounts (Update)
18	RAB1_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
19	RAB1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
20	RAB1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
21	RAB2_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
22	RAB2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
23	RAB2_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
24	RAB3_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
25	RAB3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
26	RAB3_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
27	RAB4_BETR	☐	JRABMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent discount
28	RAB4_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
29	RAB4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
30	RAB4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
31	RAB4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
32	RAB5_BETR	☐	JRABBETR	WERTV6	CURR	11	2	IS-M/AM: Amount discount
33	RAB5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
34	RAB5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
35	RABE_BETR	☐	JRABBETR	WERTV6	CURR	11	2	IS-M/AM: Amount discount
36	RABE_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
37	RABE_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
38	ZUS1_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
39	ZUS1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
40	ZUS1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
41	ZUS2_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
42	ZUS2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
43	ZUS2_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
44	ZUS3_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
45	ZUS3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
46	ZUS3_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
47	ZUS4_BETR	☐	JZUSMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent surcharge
48	ZUS4_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
49	ZUS4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
50	ZUS4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
51	ZUS4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
52	ZUS5_BETR	☐	JZUSBETR	WERTV6	CURR	11	2	IS-M/AM: Amount Surcharge
53	ZUS5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
54	ZUS5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
55	ZUSE_BETR	☐	JZUSBETR	WERTV6	CURR	11	2	IS-M/AM: Amount Surcharge
56	ZUSE_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
57	ZUSE_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
58	FPRG_BETR	☐	JGPRBETR	WERTV6	CURR	11	2	IS-M/AM: Basic Price
59	FPRG_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
60	FPRG_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
61	FPRG_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
62	FPRG_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
63	FPR1_BETR	☐	JVPRBETR	WERTV6	CURR	11	2	IS-M/AM: Agreed price
64	FPR1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
65	FPR1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
66	XRABZU	☐	XRABZU	XFELD	CHAR	1	0	IS-M: Discount/Surcharge Exists Indicator
67	WAER_IPZA	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
68	XUZUO_LOE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
69	.INCLUDE	☐				0	0	IS-PAM: Include for Business Data
70	WAERG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
71	FAKSPP	☐	PAM_FAKSP	FAKSP	CHAR	2	0	IS-M: Billing Block	TVFS
72	XSEPFKKOPF	☐	XSEPFKKOPF	XFELD	CHAR	1	0	Separate billing document for sales order
73	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
74	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
75	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
76	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
77	FAKDATUM	☐	JHFKTER	DATUM	DATS	8	0	IS-M: Planned Billing/Settlement Date
78	VORAUSKNZ	☐	VORAUSKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Advance Billing Required
79	VORAUSRCH	☐	VORAUSRCH	XFELD	CHAR	1	0	IS-M: "Advance billing required" indicator
80	XRECHN	☐	XRECHN	XFELD	CHAR	1	0	IS-M: Invoice Requested Indicator
81	XKFMAEND	☐	XKFMAEND	XFELD	CHAR	1	0	IS-M: Business Data was Changed Manually Indicator
82	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
83	XORTSPREIS	☐	XORTSPREIS	XFELD	CHAR	1	0	IS-M/AM: Local Customer Indicator
84	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer	TVKD
85	KUKARR_K	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
86	KARENZ	☐	JKARENZ	JKARENZ	NUMC	4	0	IS-M: Grace Period for Price Changes
87	KARENZ_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
88	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
89	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
90	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
91	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
92	AE	☐	AGEN_AE	AGEN_AE	CHAR	1	0	IS-M: Agency Commission Entitlement
93	.INCLUDE	☐				0	0	IS-PAM: Include for Material Tax Classification
94	TAXM1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material	*
95	TAXM2	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material	*
96	TAXM3	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material	*
97	TAXM4	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material	*
98	TAXM5	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material	*
99	TAXM6	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material	*
100	TAXM7	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material	*
101	TAXM8	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material	*
102	TAXM9	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material	*
103	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
104	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
105	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
106	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
107	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
108	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
109	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
110	XAB_AUS	☐	XAB_AUS	XFELD	CHAR	1	0	IS-M: Contract Exclusion Requirement Applies Yes/No
111	.INCLUDE	☐				0	0	IS-M/AM: Contracts Entered in JHAGA
112	ACT_ABSCHL	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
113	ABSCHL_NR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVABRUF
114	ABSCHL_POS	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	JHTVABRUF
115	.INCLUDE	☐				0	0	IS-PAM: Include Customer Outline Agreement Indicator
116	XRABATT	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
117	XMITZRAB	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
118	XBONUS	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
119	XMITZBON	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
120	XMANUELL	☐	XMANUELL1	XFELD	CHAR	1	0	IS-M: Contract Assignments Changed Manually Indicator
121	AB_RABATT	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
122	AB_PREIS	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
123	AKTBONUS	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
124	ACT_ABSCH2	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
125	ABSCHL_NR2	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVABRUF
126	ABSCHL_PO2	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	JHTVABRUF
127	XRABATT2	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
128	XMITZRAB2	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
129	XBONUS2	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
130	XMITZBON2	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
131	XMANUELL2	☐	XMANUELL	XFELD	CHAR	1	0	IS-M: Manual post-editing has taken place
132	AB_RABATT2	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
133	AB_PREIS2	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
134	AKTBONUS2	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
135	ACT_ABSCH3	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
136	ABSCHL_NR3	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVABRUF
137	ABSCHL_PO3	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	JHTVABRUF
138	XRABATT3	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
139	XMITZRAB3	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
140	XBONUS3	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
141	XMITZBON3	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
142	XMANUELL3	☐	XMANUELL	XFELD	CHAR	1	0	IS-M: Manual post-editing has taken place
143	AB_RABATT3	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
144	AB_PREIS3	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
145	AKTBONUS3	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
146	PREIS_OM	☐	PREIS_OM	WERTV8	CURR	15	2	IS-M: Price excluding VAT
147	PREIS_IM	☐	PREIS_IM	WERTV8	CURR	15	2	IS-M: Price including VAT
148	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
149	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
150	MWST_BETR	☐	GRMWSTBETR	WERTV7	CURR	13	2	IS-M: Value-Added Tax Amount
151	XPREISAEND	☐	XPREISAEND	XFELD	CHAR	1	0	IS-M: Price Was Changed Indicator
152	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
153	NETWFP	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
154	MWSBFP	☐	MWSBFP	WERTV7	CURR	13	2	IS-M: Tax Amount for Billing Item in Document Currency
155	BER_TERMIN	☐	BER_TERMIN	DATUM	DATS	8	0	IS-M: Date Services were Created for Settlement Purposes
156	BER_TERMIN_BIS	☐	BER_TERMIN_BIS	DATUM	DATS	8	0	IS-M: End Date for Service Creation in Terms of Settlement
157	BER_HEFT	☐	ISM_BER_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Service Creation Copy Number for Settlement
158	TERM_TYP	☐	TERMINTYP	TERMINTYP	CHAR	1	0	IS-M/AM: Date Category Copy Number/Publication Date	TJH55
159	VAVARTYP	☐	VAVARTYPTA	VAVARTYP	CHAR	2	0	Actual issue variant type	TJD05
160	OFFSET_FAK	☐	OFFSET_FAK	OFFSET_FAK	NUMC	2	0	IS-M: Offset in days for billing date
161	OFFSET_VZ	☐	OFFSET_VZ	PAM_VZ	CHAR	1	0	IS-M: Billing offset sign
162	XKARENZ	☐	XKARENZ	XFELD	CHAR	1	0	IS-M: Use Grace Period Yes / No
163	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
164	STRUK_HTYP	☐	IKO_HIETYP	IKO_HIETYP	CHAR	2	0	IS-M: Content Component Hierarchy Type	TJJ51
165	STRUK_HVAR	☐	STRUK_HVAR	IKO_HIEVAR	CHAR	6	0	IS-M: Content Component Structural Hierarchy Variant	TJJ55
166	PREIS_HTYP	☐	IKO_HIETYP	IKO_HIETYP	CHAR	2	0	IS-M: Content Component Hierarchy Type	TJJ51
167	PREIS_HVAR	☐	PREIS_HVAR	IKO_HIEVAR	CHAR	6	0	IS-M: Content Component Hierarchy Variant for Pricing	TJJ55
168	IHKOMP	☐	INHK_PRICE	INHALTSKOM	CHAR	8	0	IS-M: Content component from price hierarchy	JJTIKO
169	SEITE_FSP	☐	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	TJJ47
170	SEITE_FORM	☐	SEITE_FORM	SEITE_FORM	CHAR	2	0	IS-M: Page Format	TJJ01
171	SMM_SFSP	☐	MENGE_SMM	DEC10_3	DEC	13	3	IS-M: Size in column mm
172	SFSP_ABR	☐	SFSP_ABR	SEITE_FSP	CHAR	4	0	IS-M: Column Format for Settlement	TJJ47
173	SMM_ABR	☐	MENGE_SMM	DEC10_3	DEC	13	3	IS-M: Size in column mm
174	FACT_ABR	☐	FACT_ABR	DECV1_3	DEC	4	3	IS-M: Conversion Factor for Settlement
175	WERBK_TYP	☐	WERBK_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Advertising Combination Type	TJH91
176	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
177	ABS_MAL	☐	JHRSMAL	JHRSMAL	DEC	5	0	IS-M: Number for Contract Standing
178	.INCLUDE	☐				0	0	IS-M: Include for size fields relevant to settlement
179	AZART_AREA	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	TJJ13
180	BREITE	☐	BREITE_VER	GROESSE	QUAN	7	3	IS-M: Ad Spec Width for Settlement
181	BREITE_EH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	TJH57
182	HOEHE	☐	HOEHE_VER	GROESSE	QUAN	7	3	IS-M: Clearable Height for Ad Spec
183	HOEHE_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	TJH61
184	ZUS_MENGE	☐	BER_MENGE	GROESSE	QUAN	7	3	IS-M: Number of Additional Ad Spec Calculation Units
185	ZUS_BERECH	☐	MEINH_ZUS	ISPEINHEIT	UNIT	3	0	IS-M: Additional Unit of Measure for Settlement	TJH57
186	MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
187	LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
188	AZART_GEST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
189	AZART_FORM	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	TJJ17
190	AZART_FARB	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	TJJ11
191	AZART_SOND	☐	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	TJJ49
192	FKART	☐	FKART_PAM	FKART_PAM	CHAR	4	0	IS-M/AM: Billing/Settlement Document Type	TJH05
193	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	*
194	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
195	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
196	BLGMENGE	☐	BLGMENGE	STMENGE	DEC	9	0	IS-M: Order Quantity for Insertion
197	DISPMENGE	☐	DISPMENGE	STMENGE	DEC	9	0	IS-M: Planning Quantity of Carrying Issue
198	VRTMENGE	☐	VRTMGI_PAM	STMENGE	DEC	9	0	IS-M/AM: Actual Quantity for Distribution
199	BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
200	POSTMENGE	☐	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
201	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
202	SIGEWICHT	☐	VAGEWIST	ISPMNG9	QUAN	9	3	Actual Issue Weight
203	SIGEW_ME	☐	MEINHVAGEI	MEINS	UNIT	3	0	Unit of weight for actual issue weight	T006
204	SI_GEWKL	☐	ISM_SI_GEWKL	SI_GEWKL	CHAR	4	0	IS-M: Ad inserts weight price group	TJHGEWKL
205	SI_SEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
206	SI_SEKL	☐	ISM_SI_SEKL	SI_SEKL	CHAR	4	0	IS-M: Price Group for Ad Insert Pages	TJHSEKL
207	WS_TIMESLC	☐	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	TJJW1
208	WS_BLOCK	☐	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	TJJW3
209	WS_STELLE	☐	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
210	XUNITERROR	☐	XUNITERROR	XFELD	CHAR	1	0	IS-M: Quantity Conversion Error Indicator
211	XAEPROV	☐	XAEPROV	XFELD	CHAR	1	0	IS-M: Agency Commission Credit Memo Indicator
212	ZW_GRABRNR	☐	ISM_TWIN_BILLING_DATASET_NO	GRUPPABR	NUMC	3	0	IS-M: Twinned Billing Dataset for Separate Agency Commission	JHAGA
213	JAEPRBASIS	☐	JAEPRBASIS	WERTV7	CURR	13	2	IS-M: Agency commission basis
214	ANZ_ANFS	☐	ANZ_ANFS	ANZ_ANFS	NUMC	3	0	IS-M: No.of Placements Qual.for Disc.Due to Pub.in Other BUs
215	ANZ_WNFS	☐	ANZ_WNFS	ANZ_ANFS	NUMC	3	0	IS-M: No.of Placements Qual.For Dis.Due to Publc.On Oth.Days
216	.INCLUDE	☐				0	0	IS-PAM: Status characteristics for billing dataset
217	XFAKT_EE	☐	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator
218	XPROVMIN1	☐	XPROVMIN1	XFELD	CHAR	1	0	Partial Commission (At Least 1 Sales Agent Assignment Comm.)
219	XPROVALL	☐	XPROVALL	XFELD	CHAR	1	0	Commission Calculated For All Sales Agent Assignments Ind.
220	XUVVZ	☐	XUVVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Incomplete
221	XERL_EE	☐	XERL_EE	XFELD	CHAR	1	0	IS-M: Revenue Distribution Performed
222	XABS_EE	☐	XABS_EE	XFELD	CHAR	1	0	IS-M: Contract Final Settlement Performed
223	XPREIS_EE	☐	XPREIS_EE	XFELD	CHAR	1	0	IS-M: Pricing completed
224	XCCAUTNOTW	☐	XCCAUTNOTW	XFELD	CHAR	1	0	IS-M/AM: Payment card authorization required
225	XCMP_FAILED	☐	XCMP_FAILED	XFELD	CHAR	1	0	IS-M/AM: Credit check failed
226	.INCLUDE	☐				0	0	IS-PAM: Characteristics for individual use (billing dataset)
227	MERKMAL0	☐	MERK0_GA	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Billing Dataset)
228	MERKMAL1	☐	MERK1_GA	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Billing Dataset)
229	MERKMAL2	☐	MERK2_GA	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Billing Dataset)
230	MERKMAL3	☐	MERK3_GA	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Billing Dataset)
231	MERKMAL4	☐	MERK4_GA	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Billing Dataset)
232	MERKMAL5	☐	MERK5_GA	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Billing Dataset)
233	MERKMAL6	☐	MERK6_GA	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Billing Dataset)
234	MERKMAL7	☐	MERK7_GA	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Billing Dataset)
235	MERKMAL8	☐	MERK8_GA	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Individual Use (Billing Dataset)
236	MERKMAL9	☐	MERK9_GA	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Billing Dataset)
237	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
238	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
239	REF_VBELN	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	JHTFK
240	REF_POSNR	☐	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document	JHTFP
241	XFCNCL	☐	JH_XCNCL	XFELD	CHAR	1	0	IS-M/AM: Reversal Indicator for Billing Item
242	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
243	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
244	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
245	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
246	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
247	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
248	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
249	CMPRE_FLT	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
250	FORMAT_ONL	☐	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)	*
251	RRREL	☐	ISMRR_RELTYP	ISMRR_RELTYP	CHAR	1	0	IS-M/AM: Revenue Recognition Category
252	RRSTA	☐			CHAR	1	0
253	X_SL_CONTCOMP_CH	☐	ISM_PUB_CHAN_SL_CONTCOMP_CHNGD	XFELD	CHAR	1	0	Publication Change: Content Component for Sched.Line Changed

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in