Wiki

SAP BUSINESS ONE

None Defined

BP Activity Query

select clgcode,

    case [Action] 
          when `C` then `Phone Call` 
          when `E` then `Note` 
          when `M` then `Meeting` 
          when `N` then `Other` 
          when `P` then `Campaign`
          when `T` then `Task` end as `Activity`, 
          oclt.Name as ActivityType, 
          OCLS.Name as ActivitySubject,
          t0.U_NAme as AssignedTo,
          T1.U_NAme as AssignedBy,
          OCLG.CardCode, OCRD.CardName,
          ocpr.Name as ContactPerson          

from oclg

    left join oclt on oclt.code = oclg.cntcttype 
    left join ocls on ocls.code = oclg.cntctsbjct
    left join ousr T0 on t0.internal_k = oclg.attenduser
    left join ousr T1 on t1.internal_k = oclg.assignedBy
    left join ocrd on ocrd.cardcode = oclg.cardcode
    left join ocpr on oclg.cntctcode = ocpr.cntctcode

Solution

24 Oct 2012