select distinctĪnd T077Y.SPRAS = 'E' and LFA1.KTOKK = 'Z012' and LFA1. I tried to add the case when for the query anycodings_mysql and sub-query as per below but I'm getting anycodings_mysql errors, please help. Where LFA1.ADRNR = adr6.ADDRNUMBER and adr6.PERSNUMBER = '')Īnd T077Y.SPRAS = 'E' and LFA1.KTOKK = 'Z012' and LFA1.SPERQ not in ('99', '06', '07', '11','10','12') Make use of table - LFA1 and ADR6 and field SMTP ADDR. Inner join dgSAP_077Y as T077Y on LFA1.KTOKK = T077Y.KTOKK SELECT SINGLE smtpaddr FROM adr6 INTO lemailid WHERE ADDRNUMBER ladrnr. anycodings_mysql Else 'GOOD' select distinct SELECT SINGLE adrnr FROM lfa1 INTO ladrnr WHERE lifnr llifnr. I need to modify the below code using a CASE anycodings_mysql WHEN scenario where I want to add a new anycodings_mysql column to identify records returned as 'BAD' anycodings_mysql for the results returned in the below query.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |