Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Internal table?

Former Member
0 Kudos

hi all,

I am using a slelect-option p_cdate.

if user enters any date in input

i have to display only those records

reminig i have to delete.

vkr.

6 REPLIES 6

Former Member
0 Kudos

u can use in operator for select-option..

select * from spfli where carrid in s_carrid.

pls reward if useful.

Former Member
0 Kudos

hi

try this

selection-screen : begin of block blk1 with frame title text-005 no intervals.

select-options : p_date type date .

selection-screen : end of block blk1.

select field1 field2 ....fieldn from table into table itab_xxx where date = p_date.

loop at itab_xxx.

write 😕 itab_xxx-field1,

itab_xxx-field2,

itab_xxx-fieldn.

endloop.

reward if useful....!!

Former Member
0 Kudos

HI

do like this

select * from DBTAB into ITAB where (datefield) = p_date.

reward if useful

vivekanand

Former Member
0 Kudos

Hi,

You can use IN operator with the select-option in the select query to select the specified records based on the input date.

for eg: if p_cdate is the select-option and you want to select from VBAK.

following is the select query for the scenario.

select * from vbak into table itab where erdat in p_cdate( just for example).

NOTE: if a date is entered for p_cdate,then the query will return the records based on the input date. If the select option p_cdate is left BLANK during execution, then all the records will be fetched from VBAK.

Hope this helps you.....

Regards,

Dilli

Former Member
0 Kudos

Hello,

Can u specify the qn clearly. From where u want ot delete and all?

0 Kudos

hi,

i am getting data from a table besed on different input parameters.

in those P_CDATE is a select option and ints a OPTIONAL field.

if user enters date in this i have to filter the output data.

it means i have to disaply those data records only.

vkr.