Skip to Content
0
Former Member
May 30, 2012 at 05:52 AM

FMS SQL Codes for SAPB1

48 Views

Hi Experts,

I'm creating formatted search in marketing documents but I can't seem to complete for I having an error with my sql codes. Please see the sample codes below

Select Case $[ORDR.OWNER]

When '2' then (SELECT GroupCode FROM OCRD WHERE GroupCode LIKE 'Branch1')

When '3' then (SELECT GroupCode FROM OCRD WHERE GroupCode LIKE 'Branch2')

When '4' then (SELECT GroupCode FROM OCRD WHERE GroupCode LIKE 'Branch3')

else

' '

end

The number 2, 3, & 4 is the Employee Code. What I want to happen is, first I'm going to select the employee and from that the business partner List will be filtered in marketing data base on the branch that was tagged to employee master data. Can someone help me fix my sql codes? Thanks in advance.

Regards,

Horhe