topic Re: Internal table? in Application Development and Automation Discussions

Internal table?

Former Member — Mon, 17 Sep 2007 11:36:48 GMT

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.

Re: Internal table?

Former Member — Mon, 17 Sep 2007 11:38:43 GMT

u can use in operator for select-option..

select * from spfli where carrid in s_carrid.

pls reward if useful.

Re: Internal table?

Former Member — Mon, 17 Sep 2007 11:42:09 GMT

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....!!

Re: Internal table?

Former Member — Mon, 17 Sep 2007 11:43:22 GMT

do like this

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

reward if useful

vivekanand

Re: Internal table?

Former Member — Mon, 17 Sep 2007 11:44:07 GMT

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

Re: Internal table?

Former Member — Mon, 17 Sep 2007 11:50:40 GMT

Hello,

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

Re: Internal table?

Former Member — Mon, 17 Sep 2007 11:59:23 GMT

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.