Can any one please execute the program in ECC 6.0 - Dynamic Select Dump

[Former Member]

Hi,

I am getting dump when I execute the following code in ECC 6.0 with Oracle DB. it works fine in 46, 47 unicode and non unicode and ERP2004.

If I remove the period '.' after '''4500016938''' it works fine. I just want to make sure it is ECC 6.0 issue.

TABLES: EKKO.

DATA L_WHERECOND TYPE TEXT50 OCCURS 0 WITH HEADER LINE.

CONCATENATE 'EBELN' 'EQ' '''4500016938''' '.'

INTO L_WHERECOND SEPARATED BY SPACE.

APPEND L_WHERECOND.

SELECT SINGLE * FROM EKKO

WHERE (L_WHERECOND).

WRITE: SY-SUBRC.

WRITE: EKKO-EBELN, ekko-ebeln.

I really appriciate for your help.

Thanks

Swamy

[Former Member]

Hi,

I am getting dump when I execute the following code in ECC 6.0 with Oracle DB. it works fine in 46, 47 unicode and non unicode and ERP2004.

If I remove the period '.' after '''4500016938''' it works fine. I just want to make sure it is ECC 6.0 issue.

TABLES: EKKO.

DATA L_WHERECOND TYPE TEXT50 OCCURS 0 WITH HEADER LINE.

CONCATENATE 'EBELN' 'EQ' '''4500016938''' '.'

INTO L_WHERECOND SEPARATED BY SPACE.

APPEND L_WHERECOND.

SELECT SINGLE * FROM EKKO

WHERE (L_WHERECOND).

WRITE: SY-SUBRC.

WRITE: EKKO-EBELN, ekko-ebeln.

I really appriciate for your help.

Thanks

Swamy

[Former Member]

short dump for me too in ECC6

EDIT: when i removed the '.' it worked, too.

Message was edited by:

robert phelan

[Former Member]

Thanks Robert, Can you please tell me what is database you use?

[RichHeilman]

We are running DB2.

Regards,

RIch Heilman

[RichHeilman]

Yes, you do not need the "." at the end. The period is after the WHERE clause

WHERE (L_WHERECOND).    "<<---- RIGHT HERE

BTW, got a dump in my ECC6.0 system too.

Regards,

RIch Heilman

[Former Member]

Thanks Robert & Rich. What database you are using?

Swamy