Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from horacio zapettini on Oct 27 at 3:02 PM And... where are you running this select? (in an abap program? or outside of sap?)
| | | ---------------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. __.____._ |  _.____.__ |
