Hello everybody,
Please I need your help, as I have the following code:
DATA: lw_001 TYPE ztranstab_001.
SELECT MAX( date )
FROM zmdmq_tr_t_001
INTO lw_001-date
WHERE field1 EQ '2016' AND
field2 EQ '11' AND
field3 EQ 'xx' AND
field4 EQ '21'.
The trouble is that, in DEV environment the program works well and founds and brings the wanted record (trying to obtain maximum date when certain field equals 11, xx and 21).
But, in QAS I have transported the program, and when executing, it indicates SY-SUBRC = 0 (which means a record was found), but in 'lw_001-date' it shows '000000', and when looking up the records manually in the table through SE16N and filtering by the fields specified before (gjahr, id_esp, especie and nivel) I can see that the maximum date, accomplishing all fields, is in this case '20160702'.
Is like the table would have records with '000000' or something like that but table is correctly filled. Could it be something about transport request or dynpro transport missing so program does not recognize table?
Thanks in advance.
Kleight.