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