hi all,
i have a problem writing the select statement for a condition please help.
If account group = Z001, Z008, or Z009, Select from VBAK using KUNNR = Customer Account Number where AUDAT is most recent.
Else
Select from VBPA using KUNNR = Customer Account Number where Sales Order number is most recent. Then select Sales Order VBAK where VBELN = VBPA-VBELN to obtain SO doc date.