topic Re: Validations for date in Application Development and Automation Discussions

Validations for date

Former Member — Wed, 31 Oct 2007 09:30:51 GMT

Hi guys,

I have a selection screen consisting of two fields......

1. Master Invoice No. and

2. Creation date

My Requirement is when date ranges are used in selection, i need to filter only master invoices that are within this date range.

Please help me out on this.

Thanks and regards,

Girish.

Re: Validations for date

Former Member — Wed, 31 Oct 2007 09:38:18 GMT

what fields you are refering for those 2 fields in the selection screen?

Satish

Re: Validations for date

Former Member — Wed, 31 Oct 2007 09:38:57 GMT

Hi Frank,

To filter the master invoices that are within the date range select your data with the where clause checking that the date field should be in select option like :-

select * from from VBAK into itab

where budat in so_date.

Reward if useful.

Regards,

Shilpi

Re: Validations for date

Former Member — Wed, 31 Oct 2007 09:40:02 GMT

i have a custom table ......ysdtab having the custom field zzmast_inv_nbr and a field erdat.

Can u provide me with a sample code on the validations??

Re: Validations for date

Former Member — Wed, 31 Oct 2007 09:46:44 GMT

Hi,

Go through this link

Reward points if it helps,

Satish

Re: Validations for date

Former Member — Wed, 31 Oct 2007 09:51:23 GMT


SELECT zzmast_inv_nbr erdat 
INTO CORRESPONDING FILEDS OF TABLE itab FROM ysdtab WHERE erdat in s_date.

Message was edited by:

Perez C

Re: Validations for date

Former Member — Wed, 31 Oct 2007 09:59:06 GMT

hi,

u try like this

select * from ysdat into table itab where erdat in s_date. //// if given date field in screen is a select option

select * from ysdat into table itab where erdat >= l_date and erdat <= h_date. // when u use two parameters for date.

for displaying data in screen in screen goto-> [f6] properties -> add from dictionary -> give ur table name -> select all required fields from that table -> drag n drop on to screen.

in ur flow logic.

TABLES: ZSURESH /// declare ur table here. then it will create a work area for u and using it u can do ur requirements.

if helpful reward some points.

with regards,

Suresh Aluri.