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
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
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
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 […]