ABAP CDS View Case Statement and Join Condition

[pragi2028]

Hi All,

I'm new to CDS View, Can someone help me with the below logics

If PERSNUMBER is null in BUT000, get the ADDRNUMBER from BUT020 and pass to ADR6 for email address - this one in join condition

If email address entry is only one assign that, If multiple email addresses found, pick where ADR6-FLGDEFAULT is 'X' 

Thanks in Advance !!

[Sandra_Rossi]

Try learning first. Ask ChatGPT/Generative AI if you don't want.