Skip to Content
0
Former Member
Mar 02, 2010 at 04:52 PM

SELECTsentence returns sy-subrc = 4 in PRD client

111 Views

Hi;

I´m facing this problem, is a Z development that works ok in DEV client and in PRD client doesn't.

the problem is in a select sentece, this program has been running for a long time and sudenly it fails.

this is the select code original that started failing just yesterday:

SELECT * FROM mchb

WHERE matnr = t_eban-matnr AND

werks = t_eban-reswk AND "utilzar el centro suministrador no el werks

lvorm = ' ' AND "CHAR 1 0 Petición de borrado para datos (todos) de stock lotes

sperc = ' ' AND "CHAR 1 0 Indicador de bloqueo para inventario

clabs > 0. " sacar solo los lotes que tangan saldo.

  • here other sentences

ENDELECT.

this select in PRD client returns sy-subrc = 4, but when i browse the mchb table with se16 tcode it has data, i put the same matnr werks lvorm = '' sperc = '' and clbas > 0 and i get data.

so i decide to change a little bit the code, because i tryed recompilng the Z report in DEV a pass it to PRD again but it didn´t work.

this is the new code tha works ok in DEV client but not in PRD client:

SELECT * INTO TABLE tmchb FROM mchb

WHERE matnr = t_eban-matnr AND

werks = t_eban-reswk AND "utilzar el centro suministrador no el werks

lvorm = '' AND "CHAR 1 0 Petición de borrado para datos (todos) de stock lotes

sperc = '' AND "CHAR 1 0 Indicador de bloqueo para inventario

clabs > 0. " sacar solo los lotes que tangan saldo.

so, as can you see i just created an internal table TMCHB just to take the data in a table, but it displays sy-subrc = 4 again.

Any help.

David Fúnez

Corp. Mandofer