Hi Experts,
[1] SUM outside
select
COMP,
SUM( case when COMP = '1000' then count( "PERNR" ) else 0 end ) as "NUM"
from tab
;
[2] SUM inside
select
COMP,
case when COMP = '1000' then SUM( count( "PERNR" ) ) else 0 end as "NUM"
...
Hi Experts,
The need is extracting data from SAAS (CRM on cloud), of which the interface is REST API, using "HTTP Connections to External Server"(SM59) into SAP internal table.
Is there any good case ?
Tks
Hi experts,
In BW/4 , the RSSELDONE is EMPTY.
What is the table instead the RSSELDONE in BW/4 , which stored the request ID of DSO change log and date like RSSELDONE-SELDATE ?
Hi experts,
For example ,
YEAR MON
2022 11100111
I want to update the third "1" to "0" of MON, the result is :
YEAR MON
2022 11000111
And the position maybe a variable , ie, not the third one, but the fourth.
