Skip to Content
0
Former Member
Aug 04, 2009 at 11:32 AM

To get customer whose creation date is < 540 days

36 Views

Hi all,

How can I get the customer who does not made any sale activity from today to less than 540 days before?

I made logic as follows

Get customer from knvv whose create date is less than 540 days

For the customer obtained from above, I will check vbak table to fetch document

With the vbak document I will check the overall status of document from VBUK table

Is the above logic is correct ?

Thanks,

Sowmya