Skip to Content
0
Former Member
Aug 10, 2012 at 12:25 PM

Retreving Valid sales orders within the date range

125 Views

Hi All,

I Had a date field in the selection screen which is not a manadatory.

If user enter date i need to retreive the valid sales orders which falls in the date range which is given in the selection screen.

I tried but its not coming correctly.

for eg:

I given range like 14.01.2012 to 31.01.2012...in the selection screen

when I cheked in VBAK table one sale order whose valid from date(ANGDT) is 14.01.2009 and valid todate(BNDDT) is 31.12.2012

Another sale order whose valid from date(ANGDT) is 11.01.2009 and valid todate(BNDDT) is 15.12.2012

so both sale orders should come...

If i given range like 16.01.2012 to 31.01.2012 in the selection screen then only one sale order should come...i.e.

the sale order whose valid from date(ANGDT) is 14.01.2009 and valid todate(BNDDT) is 31.12.2012 should come...

For this what condition i need to give..

Is there any thoughts to acheive this..

Regards

Ram