DBIF_RSQL_SQL_ERROR SQL error 1555 when accessing table "BSEG".

[siongchao_ng]

dbif-rsql-sql-error-28jun.txt

As attached.

What could be the problem?

Anyone knows how to use package size statement to resolve this problem?

DATA  gi_bseg LIKE bseg OCCURS 0 WITH HEADER LINE.

SELECT * FROM bseg INTO TABLE gi_bseg                                         |
|  806|                      WHERE bukrs = vbrk-bukrs                                              |
|  807|                        AND rebzg = vbrk-vbeln.                                             |
|>>>>>|              IF sy-subrc EQ 0.                                                             |
|  809|                LOOP AT gi_bseg.                                                            |
|  810|                  SUM.                                                                      |
|  811|                ENDLOOP.                       

dbif-rsql-sql-error-28jun.txt

[VXLozano]

two things:

1. google for dbif_rsql_sql_error 1555 and you will find a lot of information about (I presume your system lies on an Oracle DB)
2. never ever write again OCCURS nor WITH HEADER LINE: those things should be banned in the early 80s, but SAP kept them working because retrocompatibility... it's a sign of poor skills or lack of motivation for update them

Check the right side of your screen just now... next to your post there is a section "Similar Questions"... it's pretty useful to SEARCH BEFORE POSTING A QUESTION

[Gourab_Dey · Accepted solution]

Hi Siong,

Can you please try below 2 ways and see whether it is working for you.

Approach 1:Use of SELECT-ENDSELECT with package size:

DATA:
  gi_bseg  LIKE   bseg OCCURS 0 WITH HEADER LINE.

SELECT *
  FROM bseg
  APPENDING TABLE gi_bseg_pck
  PACKAGE SIZE 1000
         where bukrs = vbrk-bukrs
           and rebzg = vbrk-vbeln.

ENDSELECT.

Approach 2: Use of cursor

DATA: cursor TYPE cursor.

OPEN CURSOR cursor FOR
      SELECT *
        FROM bseg
       WHERE bukrs = vbrk-bukrs
         AND rebzg = vbrk-vbeln.

FETCH NEXT CURSOR cursor
        APPENDING TABLE gt_bseg
          PACKAGE SIZE 1000.

Thanks,

Gourab

[VXLozano · Accepted solution]

please, for the sake of every developer working in the XXIst century... replace the OCCURS blasphemies by proper typed table declarations

[Gourab_Dey · Accepted solution]

He has used it in program.I just enhanced his code give him the appoach. Hope you have gone through the entire thread before juming on the sake of occurs 0.

[former_member753791]

Hi Siong Chao Ng,

The problem lies with large amounts of data in select statement.

Solution: I have just modified your code below-

DATA  gi_bseg LIKE bseg OCCURS 0 WITH HEADER LINE.

SELECT * FROM bseg INTO TABLE gi_bseg PACKAGE SIZE 4000                                        |
|  806|                      WHERE bukrs = vbrk-bukrs                                              |
|  807|                        AND rebzg = vbrk-vbeln.                                             |
|>>>>>|              IF sy-subrc EQ 0.                                                             |
|  809|                LOOP AT gi_bseg.                                                            |
|  810|                  SUM.                                                                      |
|  811|                ENDLOOP. 
ENDSELECT.

Regards,

Rohit