cancel
Showing results for 
Search instead for 
Did you mean: 

Ranges in Proxies

Former Member
0 Kudos

Hi,

I have the following fields

Basic Start Date:12/12/2010

Basic End Date:14/12/2010

I need to use these fields for retrieving a production date from plaf table.

The problem is both these dates needs to be the low and high of Production date

Say for Eg., if the production date is p_date,

p_date-low = basic start date

p_date-high = basic end date

Since I can't declare p_date as ranges in proxies, how do i achieve this result.

My select query would be such that

select * from plaf where prod_date in p_date. Something like this.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

This the way you do for a ranges;

*- Create Date

ra_cdt type range of <table Name>-erdat,

rw_cdty_line like line of ra_cdt.

rw_cdty_line-sign = 'I'.

rw_cdty_line-option = 'BT'.

rw_cdty_line-low = from .

rw_cdty_line-high = to.

append rw_cdty_line to ra_cdt.

Answers (0)