NSR duplicaten
73 counter
16:04 2d17u

NSR duplicaten
73 counter

Open SQL selection

In status since 01.01.2026 at 22:36
Delay 200m (3u) (sensor is processed with a delay)
Use the SQL console in Eclipse to determine what the selection does in detail. With this sensor, a free-format SQL statement can be executed on any table or tables you need. The record count or a selected result field will be used as the sensor KPI.All without involving Abap coding.

De NSR duplicaten


o Name of the selection NSRDUPS

Overview SQL statement


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

Overview of results

NSR numberCounter
1231231232
123453
1234562
12345672
123456784
12345678902
200309584
2003534410
2003704122
200474937
200606492
200640813
200973212
200988242
201152703
201707715
202764972
202765702
202765712
202768162
202810772
202953552
203152832
203158622
300450282
300450302
300450332
300452182
300454752
300454762
300454792
300454802
300454812
300454822
300454842
300454852
300454862
300455292
300455302
300455312
300455842
300455862
300455892
300455902
300456962
300505002
301020102
301029284
301031012
301064512
301065772
301065782
301066303
301078052
301078133
301078823
301079572
301080225
301080233
301080292
301080312
301080322
301080432
301084102
3010858111
301087852
301111542
301111572
301120323
301132643
301136842
709245323
NULL5235
General information on the sensor: warning: no warning level, error: no error level, sensor name: SQL NSR duplicaten, parameter value: NAME:NSRDUPS, class/method: ZCL_SENSORS_OPENSQL=>SENSOR_SQL, duration: 234ms.