Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
data: begin of itab occurs 0,
v_number like ztable-number,
v_date like ztable-date,
v_time like ztable-time,
end of itab.
SELECT number date time
INTO table itab
FROM ztable
UP TO 1 ROWS
WHERE zpro = sy-repid AND
werks IN r_plant
ORDER BY number descending.
But before we going to use Select Single we must be knw the filed/fields wch r in where condition is key field or not...if it is key field it is better suppose it is not key filed "Up to 1 rows" is only better thing...
anyhow for select single no need endselect.
for up to 1 rows alos we can avoid endselect by using TABLE key word..
data: begin of itab occurs 0,
v_number like ztable-number,
v_date like ztable-date,
v_time like ztable-time,
end of itab.
SELECT number date time
INTO table itab
FROM ztable
UP TO 1 ROWS
WHERE zpro = sy-repid AND
werks IN r_plant
ORDER BY number descending.
Bluesky
