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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJH_OP_AMORDBID	ABSCHL_NR	JHTVABRUF	VTNR	REF	C	CN
2	RJH_OP_AMORDBID	ABSCHL_NR2	JHTVABRUF	VTNR	REF	C	CN
3	RJH_OP_AMORDBID	ABSCHL_NR3	JHTVABRUF	VTNR	REF	C	CN
4	RJH_OP_AMORDBID	ABSCHL_PO2	JHTVABRUF	POSNR	REF	C	CN
5	RJH_OP_AMORDBID	ABSCHL_PO3	JHTVABRUF	POSNR	REF	C	CN
6	RJH_OP_AMORDBID	ABSCHL_POS	JHTVABRUF	POSNR	REF	C	CN
7	RJH_OP_AMORDBID	ACT_ABSCH2	JHTVKO	VTNR	REF	C	CN
8	RJH_OP_AMORDBID	ACT_ABSCH3	JHTVKO	VTNR	REF	C	CN
9	RJH_OP_AMORDBID	ACT_ABSCHL	JHTVKO	VTNR	REF	C	CN
10	RJH_OP_AMORDBID	AZART_AREA	TJJ13	AZART_AREA		1	CN
11	RJH_OP_AMORDBID	BREITE_EH	TJH57	ISPEINHEIT	REF	1	CN
12	RJH_OP_AMORDBID	CCACT	SKA1	SAKNR	REF	1	CN
13	RJH_OP_AMORDBID	CCWAE	TCURC	WAERS	REF	1	CN
14	RJH_OP_AMORDBID	FAKSPP	TVFS	FAKSP	KEY	1	CN
15	RJH_OP_AMORDBID	HOEHE_EH	TJH61	ISPEINH_H	REF	1	CN
16	RJH_OP_AMORDBID	KALKS	TVKD	KALKS	KEY	1	CN
17	RJH_OP_AMORDBID	KARENZ_ME	T006	MSEHI	KEY	1	CN
18	RJH_OP_AMORDBID	KDGRP	T151	KDGRP	REF	1	CN
19	RJH_OP_AMORDBID	KONDA	T188	KONDA	KEY	1	CN
20	RJH_OP_AMORDBID	KUKARR_K	TJJ95	KUKARR	KEY	1	CN
21	RJH_OP_AMORDBID	KURST	TCURV	KURST	REF	1	CN
22	RJH_OP_AMORDBID	PERFK	TFACD	IDENT	KEY	1	CN
23	RJH_OP_AMORDBID	PLTYP	T189	PLTYP	REF	1	CN
24	RJH_OP_AMORDBID	RCAVA	TCCRC	RCODE	REF	1	CN
25	RJH_OP_AMORDBID	RCAVR	TCCRC	RCODE	REF	1	CN
26	RJH_OP_AMORDBID	RCAVZ	TCCRC	RCODE	REF	1	CN
27	RJH_OP_AMORDBID	RCCVV	TCCRC	RCODE
28	RJH_OP_AMORDBID	RCRSP	TCCRC	RCODE	REF	1	CN
29	RJH_OP_AMORDBID	WAERG	TCURC	WAERS	KEY	1	CN
30	RJH_OP_AMORDBID	ZLSCH	T042Z	ZLSCH	REF	1	CN
31	RJH_OP_AMORDBID	ZUS_BERECH	TJH57	ISPEINHEIT	REF	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in	463