09-25-2012 6:48 AM
Hi,
Getting a dump, please help.
Runtime Errors DBIF_RSQL_INVALID_RSQL
Except. CX_SY_OPEN_SQL_DB
Date and Time 2012-09-25 07:12:11
Short text
Error in module RSQL of the database interface.
What happened?
Error in the ABAP Application Program
The current ABAP program "ZMMPRO_SAP_TO_SWING" had to be terminated because it
has
come across a statement that unfortunately cannot be executed.
Error analysis
An exception occurred that is explained in detail below.
The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught
in
procedure "GET_DATA" "(METHOD)", nor was it propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated that the
exception would occur, the current program is terminated.
The reason for the exception is:
In a SELECT access, the read file could not be placed in the target
field provided.
Either the conversion is not supported for the type of the target field,
the target field is too small to include the value, or the data does not
have the format required for the target field.
Missing RAISING Clause in Interface
Program ZMMPRO_SAP_TO_SWING
Include ZMMPRN_SAP_TO_SWING_METHOD
Row 116
Module type (METHOD)
Module Name GET_DATA
Trigger Location of Exception
Program ZMMPRO_SAP_TO_SWING
Include ZMMPRN_SAP_TO_SWING_METHOD
Row 169
Module type (METHOD)
Module Name GET_DATA
139 ekpo~txz01 ekpo~netpr ekpo~meins
140 ekpo~infnr ekpo~pstyp ekpo~matkl
141 * Begin of change - HPQC defect 10092 - Subrabas
142 ekpo~ktmng
143 * End of change - HPQC defect 10092.
144 *** Start of Change C39050 on 14/11/2011 by Madhwendra ***
145 ekpo~lgort
146 ekpo~peinh
147 *** End of Change C39050 on 14/11/2011 by Madhwendra ***
148 INTO TABLE li_contract
149 FROM ekko INNER JOIN ekpo
150 ON ekko~ebeln EQ ekpo~ebeln
151 * Begin of change - HPQC defect 10092 - Subrabas
152 WHERE ekko~ekorg IN s_ekorg
153 * End of change - HPQC defect 10092.
154 AND ekko~bstyp EQ lc_doccat
155 AND ekko~bsart EQ lc_doctyp
156 AND ekko~loekz EQ space
157 * Begin of change for CR C48905 - ANANDKAR
158 AND ekko~kdate >= sy-datum
159 * End of change for CR C48905 - ANANDKAR
160 AND ekpo~loekz EQ space
161 AND ekpo~werks IN s_werks.
162 * End of change - HPQC defect 10092.
163 IF sy-subrc IS INITIAL.
164 *Start Of Change Under CR55638 By ChandPra On 24/09/2012.
165 li_contract1[] = li_contract[].
166
167 DELETE li_contract1 WHERE pstyp NE '2'.
168
>>> SELECT eina~infnr eina~matnr eina~lifnr
170 eine~ekorg eine~esokz eine~werks eine~waers eine~netpr eine~peinh eine~bprme
171 INTO TABLE li_inforec
172
173 FROM eina INNER JOIN eine
174
175 ON eina~infnr EQ eine~infnr
176
177 FOR ALL ENTRIES IN li_contract1
178 WHERE eina~infnr EQ li_contract1-infnr
179
180 AND eina~matnr EQ ekpo-matnr
181 AND eina~lifnr EQ ekko-lifnr
182 OR ( eine~ekorg LIKE 'HU%' AND eine~ekorg EQ 'HU10' )
183 AND eine~esokz EQ '2'
184 AND eine~werks EQ ekpo-werks.
185 *End Of Change Under CR55638 By ChandPra On 24/09/2012.
186
187
188 LOOP AT li_contract INTO wl_contract.
189 IF ekpo-pstyp EQ 2.
190 READ TABLE li_inforec INTO wl_inforec WITH KEY infnr = wl_contract-infnr.
191 IF sy-subrc IS INITIAL.
192 MODIFY li_contract FROM wl_contract TRANSPORTING netpr.
193 ENDIF.
194 ENDIF.
Moderator message : Not enough re-search before posting, discussion locked.
Message was edited by: Vinod Kumar
09-25-2012 6:57 AM
Hi Prakhar,
can u please check final internal table and select query the sequence of fields are not same as data dictionary sequence..
please check
regards
srini
09-25-2012 7:02 AM
Put your internal table source here.
Did you declare werks as TYPE werks or werks_d? Just a thought!
Thanks,
Shambu
09-25-2012 7:06 AM
Hi,
exactly check ur final internal table li_inforec sequence and field declaration.
09-25-2012 7:27 AM
Do i have to fields tp_contract and tp_inforec in the same sequence??
TYPES
: BEGIN OF tp_contract,
TYPES : BEGIN OF tp_inforec,
infnr TYPE infnr,
matnr TYPE matnr,
lifnr TYPE lifnr,
ekorg TYPE ekorg,
esokz TYPE esokz,
werks TYPE werks_d,
waers TYPE waers,
netpr TYPE netpr,
peinh TYPE einh,
bprme TYPE bprme,
END OF tp_inforec.
09-25-2012 7:35 AM
peinh TYPE einh,
This should be PEINH.
peinh TYPE peinh OR EPEIN,
Thanks,
Shambu
09-25-2012 7:47 AM