topic Re: DATE Comparison in Application Development and Automation Discussions

DATE Comparison

Former Member — Thu, 06 Apr 2006 07:36:25 GMT

I am new to ABAP, I want to know how to choose data from VBAK which has ERDAT ( Date of creation ) after a particular date say 15-08-2004..

Re: DATE Comparison

Former Member — Thu, 06 Apr 2006 07:38:53 GMT

Hi rahul,

1. simple.

2. just copy paste in new program.

(u can give any date on selection screen)

report abc.

*----

data : vbak like table of vbak with header line.

*----

parameters : erdat like vbak-erdat default sy-datum.

*----

select * from vbak

into table vbak

<b>where erdat > erdat.</b>

*----

regards,

amit m.

Re: DATE Comparison

Former Member — Thu, 06 Apr 2006 07:39:02 GMT

hi Rahul

use select statement for that

v_date type d value '15082004'.

<b>select * from vbak

into table vbak

where erdat > v_date</b>

Re: DATE Comparison

athavanraja — Thu, 06 Apr 2006 07:39:37 GMT

Welcome to SDN.

data: itab type standard table of VBAK .

select * from vbak into table itab where erdat gt '20040815' .

http://help.sap.com

Regards

Raja

Re: DATE Comparison

Former Member — Thu, 06 Apr 2006 07:41:14 GMT

Hi Rahul,

Use

SELECT * FROM VBAK INTO TABLE ITAB

WHERE ERDAT > 'GIVE THE DATE'.

HOPE THIS HELPS,

PRIYA.

Re: DATE Comparison

Former Member — Thu, 06 Apr 2006 07:41:28 GMT

Hi,


data: it_vbak type  table of vbak .

select *
      from vbak
      into table it_vbak
    where erdat gt '20040815' .

Regards

vijay

Re: DATE Comparison

Former Member — Thu, 06 Apr 2006 07:42:30 GMT

Hi,

select erdat from VBAK into v_erdat where erdat > '15.08.2004'.

IF u want select all fileds use

select * from vbak into itab where erdat > '15.08.2004'.

holp this will help you.

Regards,

Sreevani.