Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need to join to two tables based on if condition

we are trying to join two tables based on below condition

if TE_TM_ENTRY_MO.RSRC_TP='EMPLOYEE'

then TE_TM_ENTRY_MO should be joined with LBR_PERSON_MSTR bsed on the condition "TE_TM_ENTRY_MO.EMP_ID=LBR_PERSON_MSTR.MYHR_ID

else if TE_TM_ENTRY_MO.RSRC_TP<>'EMPLOYEE'

then TE_TM_ENTRY_MO should be joined with LBR_PERSON_MSTR based on the condition "TE_TM_ENTRY_MO.EMP_ID=LBR_PERSON_MSTR.NUID"

Please let me know how to implement in BO Universe.

Tags:
Not what you were looking for? View more on this topic or Ask a question