Skip to Content
0
Former Member
May 12, 2008 at 09:41 AM

select query

28 Views

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.