SAP ABAP Table RJHAGA (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 INTTAB    Structure 
Structure RJHAGA   Table Relationship Diagram
Short Description IS-M/AM: Order-Publishing-Media 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 .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 JHTVKO
115 ABSCHL_POS ABS_POSNR ABS_POSNR NUMC 4   0   IS-M: Contract, Item Number JHTVPO
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 INS_PROZ PAM_PROZ JHPROZ33 DEC 6   3   IS-M: Percentage Figure for Cost Distribution  
301 AZGR_INS AZGR_INS NUMC4 NUMC 4   0   Column MM of the Ad Which the Advertiser is Involved In  
302 AZGREH_INS ISPEINHEIT ISPEINHEIT UNIT 3   0   IS-M: Unit of Measurement for Calculating Ad Spec Dimensions *
303 INS_NAME INS_NAME TEXT30 CHAR 30   0   IS-M: Advertiser name  
304 INS_ADRNR ADRNR ADRNR CHAR 10   0   Address *
305 XINSBLANK XINSBLANK XFELD CHAR 1   0   IS-M: Agency Order Without Advertiser Indicator  
306 .INCLUDE       0   0   IS-PAM: INCLUDE for bank data  
307 BANKS BANKS LAND1 CHAR 3   0   Bank country key T005
308 BANKL BANKK BANKK CHAR 15   0   Bank Keys BNKA
309 BANKN BANKN BANKN CHAR 18   0   Bank account number  
310 BKONT BKONT BKONT CHAR 2   0   Bank Control Key  
311 BVTYP BVTYP BVTYP CHAR 4   0   Partner bank type  
312 XEINZUG XEZER XFELD CHAR 1   0   Indicator: Is there collection authorization ?  
313 .INCLUDE       0   0   IS-M/AM: Include for IBAN  
314 IBAN IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
315 REG_NAME TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
316 LAND1 LAND1 LAND1 CHAR 3   0   Country Key *
317 TAXK1 TAXK1 TAXKD CHAR 1   0   Tax classification 1 for customer *
318 TAXK2 TAXK2 TAXKD CHAR 1   0   Tax classification 2 for customer *
319 TAXK3 TAXK3 TAXKD CHAR 1   0   Tax classification 3 for customer *
320 TAXK4 TAXK4 TAXKD CHAR 1   0   Tax classification 4 for customer *
321 TAXK5 TAXK5 TAXKD CHAR 1   0   Tax classification 5 for customer *
322 TAXK6 TAXK6 TAXKD CHAR 1   0   Tax classification 6 for customer *
323 TAXK7 TAXK7 TAXKD CHAR 1   0   Tax classification 7 for customer *
324 TAXK8 TAXK8 TAXKD CHAR 1   0   Tax classification 8 for customer *
325 TAXK9 TAXK9 TAXKD CHAR 1   0   Tax classification 9 for customer *
326 BRAN1 BRAN1_D BRACO CHAR 10   0   Industry code 1 *
327 VKBUR_ZUST VKBURZUS VKBUR CHAR 4   0   Sales office responsible *
328 KALSMAE KALSMAE KALSM CHAR 6   0   IS-M: Pricing Procedure for Agency Commission *
329 ABINHNR ABINHNR GPNR CHAR 10   0   IS-M/AM: Number of Contract Holder JGTGPNR
330 ABINHNR2 ABINHNR GPNR CHAR 10   0   IS-M/AM: Number of Contract Holder JGTGPNR
331 ABINHNR3 ABINHNR GPNR CHAR 10   0   IS-M/AM: Number of Contract Holder JGTGPNR
332 .INCLUDE       0   0   IS-M/AM: Payment Cards: Data in RJHAGA  
333 .INCLUDE       0   0   IS-M/AM: Payment cards: Projection of RJH_CCDATA  
334 CCINS CCINS CCINS CHAR 4   0   Payment cards: Card type TVCIN
335 CCNUM CCNUM CCNUM CHAR 25   0   Payment cards: Card number VCNUM
336 DATBI DATBI_CC DATUM DATS 8   0   Payment Cards: Valid To  
337 CCNAME CCNAME TEXT40 CHAR 40   0   Payment Cards: Name of Cardholder  
338 .INCLUDE       0   0   IS-M/AM: Card Verification Value  
339 CVVAL ISM_CVVAL ISM_CVVAL CHAR 6   0   Card Verification Value  
340 CVVCT ISM_CVVCT ISM_CVVCT CHAR 1   0   Control Field for Card Verification Value  
341 CVVST ISM_CVVST ISM_CVVST CHAR 1   0   Usage Status of Card Verification Value  
342 SETTL SETTL XFELD CHAR 1   0   Payment cards: Settlement carried out  
343 MERCH MERCH MERCH CHAR 15   0   Payment cards: Merchant ID at the clearing house TCCM
344 LOCID LOCID_CC LOCID_CC CHAR 10   0   Payment cards: Point of receipt for the transaction TCCL
345 TRMID TRMID CHAR10 CHAR 10   0   Payment cards: Terminal  
346 CCBTC CCBTC CCBTC CHAR 10   0   Payment cards: Settlement run  
347 RTEXT RTEXT_CC TXT40 CHAR 40   0   Payment cards: Result text  
348 XSUCFKP XSUCFKP XFELD CHAR 1   0   IS-M/AM: Indicator: Subsequent Billing Items Exist  
349 XSUCRR XSUCRR XFELD CHAR 1   0   IS-M/AM: Indicator: Successor Revenue Recognition Exists  
350 ADV_AD_SIZE ISM_ADV_AD_SIZE MENGE13 QUAN 13   3   Share of Ad Size Belonging to the Advertiser  
351 .INCLUDE       0   0   IS-M/AM: Include for SEPA Mandates  
352 MNDID SEPA_MNDID ID035 CHAR 35   0   Unique Referene to Mandate per Payment Recipient  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RJHAGA ABINHNR JGTGPNR GPNR REF C CN
2 RJHAGA ABINHNR2 JGTGPNR GPNR REF C CN
3 RJHAGA ABINHNR3 JGTGPNR GPNR REF C CN
4 RJHAGA ABSCHL_NR JHTVKO VTNR REF C CN
5 RJHAGA ABSCHL_NR2 JHTVABRUF VTNR REF C CN
6 RJHAGA ABSCHL_NR3 JHTVABRUF VTNR REF C CN
7 RJHAGA ABSCHL_PO2 JHTVABRUF POSNR REF C CN
8 RJHAGA ABSCHL_PO3 JHTVABRUF POSNR REF C CN
9 RJHAGA ABSCHL_POS JHTVPO POSNR REF C CN
10 RJHAGA AB_BR_WAEH TCURC WAERS 1 CN
11 RJHAGA ACT_ABSCH2 JHTVKO VTNR REF C CN
12 RJHAGA ACT_ABSCH3 JHTVKO VTNR REF C CN
13 RJHAGA ACT_ABSCHL JHTVKO VTNR REF C CN
14 RJHAGA AVM_NR JHAK AVM_NR    
15 RJHAGA AZART_AREA TJJ13 AZART_AREA 1 CN
16 RJHAGA AZART_FARB TJJ11 AZART_FARB KEY 1 CN
17 RJHAGA AZART_FORM TJJ17 AZART_FORM KEY 1 CN
18 RJHAGA AZART_GEST TJJ19 AZART_GEST KEY 1 CN
19 RJHAGA AZART_SOND TJJ49 AZART_SOND REF 1 CN
20 RJHAGA BANKL BNKA BANKL    
21 RJHAGA BANKS T005 LAND1 REF C CN
22 RJHAGA BELEGEINH JJTBE BELEINH KEY 1 CN
23 RJHAGA BREITE_EH TJH57 ISPEINHEIT REF 1 CN
24 RJHAGA CCACT SKA1 SAKNR REF 1 CN
25 RJHAGA CCINS TVCIN CCINS REF 1 CN
26 RJHAGA CCNUM VCNUM CCNUM REF 1 CN
27 RJHAGA CCWAE TCURC WAERS REF 1 CN
28 RJHAGA DRERZ JDTDRER DRERZ REF 1 CN
29 RJHAGA FAKSPP TVFS FAKSP    
30 RJHAGA FKART TJH05 FKART REF 1 CN
31 RJHAGA GPNR_RECH JGTGPNR GPNR REF 1 CN
32 RJHAGA HOEHE_EH TJH61 ISPEINH_H REF 1 CN
33 RJHAGA IHKOMP JJTIKO INHALTSKOM REF 1 CN
34 RJHAGA INSERENT JHAISZ INSERENT KEY 1 CN
35 RJHAGA INS_SERIES_RULE TJHINSSER INS_SERIES_RULE    
36 RJHAGA KALKS TVKD KALKS    
37 RJHAGA KARENZ_ME T006 MSEHI KEY 1 CN
38 RJHAGA KDGRP T151 KDGRP REF 1 CN
39 RJHAGA KONDA T188 KONDA    
40 RJHAGA KUKARR_K TJJ95 KUKARR    
41 RJHAGA KURST TCURV KURST REF 1 CN
42 RJHAGA LAGME T006 MSEHI REF 1 CN
43 RJHAGA LOCID TCCL LOCID REF C CN
44 RJHAGA MANDT T000 MANDT    
45 RJHAGA MERCH TCCM MERCH    
46 RJHAGA MOTIV JHAMOT MOTIV REF 1 CN
47 RJHAGA PERFK TFACD IDENT    
48 RJHAGA PLTYP T189 PLTYP REF 1 CN
49 RJHAGA POS_NR JHAP POS_NR    
50 RJHAGA PREIS_HTYP TJJ51 IKO_HIETYP KEY 1 CN
51 RJHAGA PREIS_HVAR TJJ55 IKO_HIEVAR KEY 1 CN
52 RJHAGA PSTYV TJHAP PSTYV KEY 1 CN
53 RJHAGA PVA JDTPVA PVA REF 1 CN
54 RJHAGA RCAVA TCCRC RCODE REF 1 CN
55 RJHAGA RCAVR TCCRC RCODE REF 1 CN
56 RJHAGA RCAVZ TCCRC RCODE REF 1 CN
57 RJHAGA RCCVV TCCRC RCODE    
58 RJHAGA RCRSP TCCRC RCODE REF 1 CN
59 RJHAGA REF_POSNR JHTFP POSNR REF 1 CN
60 RJHAGA REF_VBELN JHTFK VBELN REF 1 CN
61 RJHAGA REGULIERER JGTGPNR GPNR REF 1 CN
62 RJHAGA SEITE_FORM TJJ01 SEITE_FORM KEY 1 CN
63 RJHAGA SEITE_FSP TJJ47 SEITE_FSP KEY 1 CN
64 RJHAGA SFSP_ABR TJJ47 SEITE_FSP REF 1 CN
65 RJHAGA SIGEW_ME T006 MSEHI REF 1 CN
66 RJHAGA SI_GEWKL TJHGEWKL SI_GEWKL REF 1 CN
67 RJHAGA SI_SEKL TJHSEKL SI_SEKL REF 1 CN
68 RJHAGA SI_TYP TJH29 SI_TYP REF 1 CN
69 RJHAGA STAFO TMCB STAFO REF 1 CN
70 RJHAGA STORNOGRND TJHSTOG STORNOGRD REF 1 CN
71 RJHAGA STRUK_HTYP TJJ51 IKO_HIETYP REF 1 CN
72 RJHAGA STRUK_HVAR TJJ55 IKO_HIEVAR REF 1 CN
73 RJHAGA TERM_TYP TJH55 TERM_TYP KEY 1 CN
74 RJHAGA UR_BELEINH JJTBE BELEINH REF 1 CN
75 RJHAGA VAVARTYP TJD05 VAVARTYP KEY 1 CN
76 RJHAGA WAERG TCURC WAERS 1 CN
77 RJHAGA WERBK_TYP TJH91 WKOMBI_TYP REF 1 CN
78 RJHAGA WS_BLOCK TJJW3 WS_BLOCK REF 1 CN
79 RJHAGA WS_TIMESLC TJJW1 WS_TIMESLC REF 1 CN
80 RJHAGA ZLSCH T042Z ZLSCH REF 1 CN
81 RJHAGA ZUS_BERECH TJH57 ISPEINHEIT REF 1 CN
82 RJHAGA ZW_GRABRNR JHAGA GRUPPABRNR KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in