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.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

DATE Comparison

Former Member
0 Likes
861

hi

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

1 ACCEPTED SOLUTION
Read only

athavanraja
Active Contributor
0 Likes
773

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

6 REPLIES 6
Read only

Former Member
0 Likes
773

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.

Read only

Former Member
0 Likes
773

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>

Read only

athavanraja
Active Contributor
0 Likes
774

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

Read only

Former Member
0 Likes
773

Hi Rahul,

Use

SELECT * FROM VBAK INTO TABLE ITAB

WHERE ERDAT > 'GIVE THE DATE'.

HOPE THIS HELPS,

PRIYA.

Read only

Former Member
0 Likes
773

Hi,


data: it_vbak type  table of vbak .

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

Regards

vijay

Read only

Former Member
0 Likes
773

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.