Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from AlexanderD on Oct 27 at 3:14 PM Apologies, I'm running this select in SAP HANA.
| | | ---------------Original Message--------------- From: AlexanderD Sent: Tuesday, October 27, 2015 2:29 PM Subject: WERKS & STAT Table Data? Hi everyone, I'm trying to view the entries which have "CPPD" as the value in WERKS and "I0002" as the value in STAT. Could someone take a look at the information below and help me figure out what I'm missing? The query returns ~479,000 records when it should only return ~13,000. I'm not sure if my joins are incorrect or if I've left out a table or what. Any help is greatly appreciated. select count (a.aufnr) from sapecc.aufk a left outer join sapecc.afko b on a.aufnr = b.aufnr left outer join sapecc.afvc c on b.aufpl = c.aufpl left outer join sapecc.jest d on a.objnr = d.objnr where c.werks = 'CPPD' and d.stat = 'I0002' | | Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today. _.____.__ |