| SQL definition | Description | |
| Dubbele adressen, gebaseerd op city, postcode en huisnummer | ||||||||||
| Where used |
| |||||||||
| SQL logic |
select city1, post_code1, house_num1, count( * ) as count
from adrc where addr_group = 'BP' and post_code1 <> '' and house_num1 <> '' and client = @sy-mandt group by city1, post_code1, house_num1 having count( * ) > 1 order by post_code1, house_num1 | |||||||||
|
A brief description of the query, which should explain what
the selection is expected to do (one language only) | ||||||||||
| Where used |
| |||||||||
| SQL logic |
SELECT count( distinct tabname ) as result
FROM DBTABLOG | |||||||||
|
A brief description of the query, which should explain what
the selection is expected to do (one language only) | ||||||||||
| Where used |
| |||||||||
| SQL logic | SELECT distinct tabname FROM DBTABLOG order by tabname | |||||||||
|
The history data on the database has been damaged - leading to a
mis-aligned history settings. This sensor checks whether there are duplicate history-record reviews that should not be there. | ||||||||||
| Where used |
| |||||||||
| SQL logic |
select distinct groupname, sensor, parvalue, logid_hist,
count( * ) as counter from zsensors where logid_hist <> 0 and client = @SY-MANDT group by groupname, sensor, parvalue, logid_hist having count( * ) > 1 | |||||||||
| De NSR duplicaten | ||||||||||
| Where used |
| |||||||||
| SQL logic |
SELECT idnumber as nsr_number, COUNT( idnumber ) AS counter
FROM but0id inner join but000 on but000~partner = but0id~partner and but000~xdele = ' ' and but000~client = @SY-MANDT WHERE but0id~type = 'Z00001' GROUP BY idnumber HAVING COUNT( idnumber ) > 1 ORDER BY idnumber | |||||||||
| Column names |
COUNTER - Counter
NSR_NUMBER - NSR number | |||||||||