11-01-2007 8:31 PM
Can you tell me what is wrong with this statement. I get an ABAP runtime error.
DBIF_RSQL_INVALID_RSQL.
RSQL ERROR 23 WHEN ACCESSING TABLE "BKPF"
START-OF-SELECTION.
SELECT BUDAT BLDAT BLART XBLNR_ALT BKTXT XSNET WAERS FROM BKPF INTO
IT_BKPF
WHERE BUKRS = '0004'
AND BLDAT > '2007/01/01'.
11-01-2007 8:33 PM
Hi,
Please try this.
SELECT BUDAT BLDAT BLART XBLNR_ALT BKTXT XSNET WAERS
FROM BKPF
INTO TABLE IT_BKPF
WHERE BUKRS = '0004'
AND BLDAT > '20070101'.
Regards,
Ferry Lianto
11-01-2007 8:58 PM
Try,
SELECT BUDAT BLDAT BLART XBLNR_ALT BKTXT XSNET WAERS FROM BKPF INTO TABLE
IT_BKPF
WHERE BUKRS = '0004'
AND BLDAT > '20070101'.
Also check the fields in the internal table should be in the same sequence as in the Select Query ( BUDAT BLDAT BLART XBLNR_ALT BKTXT XSNET WAERS ).
Regards,
Abhishek
11-01-2007 8:58 PM
11-01-2007 9:00 PM
Try:
into corresponding fields of table it_bkpf
But also make sure you are using the correct date format as suggested by Ferry.
Rob
Message was edited by:
Rob Burbank
11-01-2007 9:21 PM
How do you check the order? I also tried the into corresponding fields and it didn't fix it.
11-01-2007 9:25 PM
Some time when there is a load on the system db then it gives such error.
Also there might be one other reason that some body might locked the table for some other operation.
Try to execute it after some time.
Thanks,
Srinivas
11-01-2007 9:49 PM
Hi,
Please try this ... and check the syntax declaration of IT_BKPF,
DATA: BEGIN OF IT_BKPF OCCURS 0,
BUDAT LIKE BKPF-BUDAT,
BLDAT LIKE BKPF-BLDAT,
BLART LIKE BKPF-BLART,
XBLNR_ALT LIKE BKPF-XBLNR_ALT,
BKTXT LIKE BKPF-BKTXT,
XSNET LIKE BKPF-XSNET,
WAERS LIKE BKPF-WAERS.
DATA: END OF IT_BKPF.
SELECT BUDAT BLDAT BLART XBLNR_ALT BKTXT XSNET WAERS
FROM BKPF
INTO TABLE IT_BKPF
WHERE BUKRS = '0004'
AND BLDAT > '20070101'.
Regards,
Ferry Lianto
11-01-2007 9:52 PM
The problem is field XBLNR_ALT,
Even if u try to select this from the data browser it takes a lot of time. I dont know the reason behind it yet but Iam trying to find out. try doing without it.
rgds
Sameer
11-01-2007 9:53 PM
Jarrett,
Hope this code helps.
data : it_bkpf like bkpf occurs 0.
SELECT BUDAT BLDAT BLART XBLNR_ALT BKTXT XSNET WAERS FROM BKPF
into corresponding fields of table
IT_BKPF
WHERE BUKRS = '0004'
AND BLDAT > '20070101'.
Regards
Veera
11-01-2007 9:58 PM
Same thing, the message I get is the Termination occurred in line 36 which is
and bldat > '20070101'
11-01-2007 11:00 PM
Can you check in SE16 for the table BKPF the no.of entries in the table
for the condition BUKRS = '0004'
AND BLDAT > '20070101' ?
Is it giving dump there or taking too much time or the no. of entries are large ?
Regards,
aj
11-02-2007 1:19 PM
11-02-2007 1:52 PM
Look at system log via transaction SM21 to get more information on the error. Usually RSQL ERROR come from operation system.
"Mapping of field incorrect"
<i>Look also for OSS note with keyword "XBLNR_ALT" there are many recent (2007) notes.</i>
Regards
12-09-2013 12:50 PM
It was the same with me. My declaration for "TYPES" wasn't like my "SELECT".
I have a tip: In your "SELECT", select all fields that was declared in your "TYPES".
Example:
TYPES: BEGIN OF ty_bkpf,
bukrs TYPE BKPF-BUKRS,
belnr TYPE BKPF-BELNR,
blart TYPE BKPF-BLART,
budat TYPE BKPF-BUDAT.
TYPES: END OF ty_bkpf.
DATA: T_BKPF TYPE TABLE OF ty_bkpf,
SELECT BUKRS BELNR BLART BUDAT
INTO TABLE T_BKPF
FROM BKPF
WHERE MONAT = '11'
AND GJAHR = '2013'.
Best Regards