Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Question from AlexanderD on Oct 27 at 2:18 PM 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.  _.____.__ |
