number of distinct values for an SAP table

As you all know SAP provides a direct way to query database by ABAP programs. However sometimes we don’t have a chance to transport ABAP programs easily.On the other hand we have to write database queries in SAP to get complicated calculations. (Nowadays HANA provides SQL editor for this purpose)
For above purpose you can use SQL Command Editor in DBACOCKPIT. By using this editor you can write any complex query with OpenSQL. For example to calculate number of distinct BANFN in EBAN table you can use the following OpenSQL query.

select count(distinct BANFN) from EBAN

Here is the DBADOCKPIT screenshot.


You may also like

  • SAP HANA as a secondary database (0)
    After SAP has introduced HANA , i could finally had a chance to explore it. As a soft switch to HANA technology , companies can make use of HANA as a second database. Because it will not […]
  • other references to SM66 process ID field (0)
    Process ID is a key attribute for SAP performance monitoring. It has references in mayn places in SAP administration. As you know SAP global work process overview() is the main place for […]
  • navigating to ABAP editor for related code line (0)
    Recently i have needed an ABAP program which reports ABAP programs with the related code line. My intention was catching Select sql statements without in connection keyword. By this means […]