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 ?