Report Writer

[Former Member]

hi

I have a Report writer Report "Statutory Income Statement". The output is based on Company code and Profit Centre Group. The report has a drilldown report assigned to it "RGGD1300 - Totals record display GD13".

When I Click on a line item for a Profit centre, I am able to drill down to transaction GD13, but when I click on a line item for a Profit Centre Group, I get ABAP dump as below.

"Runtime Error DBIF_RSQL_INVALID_RSQL

Exception CX_SY_OPEN_SQL_DB"

The termination occurred in the ABAP program "GP_GLX_ZZA01T" in "FETCH".

The main program was "RGGD1300 ".

L_COUNTER = 0.

C_S_CURSOR-SUBRC = 0.

WHILE I_PACKAGE_SIZE EQ 0 OR

L_COUNTER LT I_PACKAGE_SIZE.

FETCH NEXT CURSOR C_S_CURSOR-CURSOR

INTO CORRESPONDING FIELDS OF TABLE G_T_RECORDS

PACKAGE SIZE L_PSIZE.

Please Help.

Any valuable suggestions will be rewarded.

Thanks

Subin.

[Former Member]

hi

I have a Report writer Report "Statutory Income Statement". The output is based on Company code and Profit Centre Group. The report has a drilldown report assigned to it "RGGD1300 - Totals record display GD13".

When I Click on a line item for a Profit centre, I am able to drill down to transaction GD13, but when I click on a line item for a Profit Centre Group, I get ABAP dump as below.

"Runtime Error DBIF_RSQL_INVALID_RSQL

Exception CX_SY_OPEN_SQL_DB"

The termination occurred in the ABAP program "GP_GLX_ZZA01T" in "FETCH".

The main program was "RGGD1300 ".

L_COUNTER = 0.

C_S_CURSOR-SUBRC = 0.

WHILE I_PACKAGE_SIZE EQ 0 OR

L_COUNTER LT I_PACKAGE_SIZE.

FETCH NEXT CURSOR C_S_CURSOR-CURSOR

INTO CORRESPONDING FIELDS OF TABLE G_T_RECORDS

PACKAGE SIZE L_PSIZE.

Please Help.

Any valuable suggestions will be rewarded.

Thanks

Subin.

[former_member226999]

It sounds like a buffering issue with the database. Did you contact your basis team for this?

[Former Member]

hi

I have a Report writer Report "Statutory Income Statement". The output is based on Company code and Profit Centre Group. The report has a drilldown report assigned to it "RGGD1300 - Totals record display GD13".

When I Click on a line item for a Profit centre, I am able to drill down to transaction GD13, but when I click on a line item for a Profit Centre Group, I get ABAP dump as below.

"Runtime Error DBIF_RSQL_INVALID_RSQL

Exception CX_SY_OPEN_SQL_DB"

The termination occurred in the ABAP program "GP_GLX_ZZA01T" in "FETCH".

The main program was "RGGD1300 ".

L_COUNTER = 0.

C_S_CURSOR-SUBRC = 0.

WHILE I_PACKAGE_SIZE EQ 0 OR

L_COUNTER LT I_PACKAGE_SIZE.

FETCH NEXT CURSOR C_S_CURSOR-CURSOR

INTO CORRESPONDING FIELDS OF TABLE G_T_RECORDS

PACKAGE SIZE L_PSIZE.

Please Help.

Any valuable suggestions will be rewarded.

Thanks

Subin.

[Former Member]

No comments