Select single mistake
The system run a job tha read a txt file, load the data in a internal table, verify the data with a select single(this is my problem) and if the data is not correct, it will generate a log error, with the same values used in select.
My job read a txt file and update a SAP table daily. ALWAYS read the file correctly, but when i do select single (to verify if the data is true) the select not found the data in the transparent table.
If i try the same process directly (runing direct by system, not job) run normaly.
my select routine:
SELECT SINGLE * FROM ztmm_camolin
WHERE numer = vg_numer
AND linha = tg_lin_entr-l_contr.
IF sy-subrc = 0.
MOVE: sy-uname TO tg_log-usuario,
sy-datum TO tg_log-data,
p_cdbas TO tg_log-divisao,
vg_numer TO tg_log-n_contr,
vg_nfnum TO tg_log-num_nf,
tg_lin_entr-l_contr TO tg_log-l_contr,
vg_kunnr TO tg_log-cliente.
MOVE 'Amostra não encontrada' TO tg_log-msg.