system status and database information

[Former Member]

Hi Everyone,

I want to display through an abap program all the system information. i.e the database information etc.

Here for e.g. when we go to system in the menu bar of any screen and then to the option status it displays all the system information.

I want to capture that information and put it in my program so that it displays as the output of my program.

Thanks,

REgards,

Prashant

[Former Member]

Hi,

Which information do you want??

You can check the DDIC structure..SYST

Which contains the system field values in the run time..

Example.

SY-DATUM -> Current date.

SY-UZEIT -> Current time..

Thanks,

Naren

[Former Member]

Hi,

Please try this.

report  zsys_info                               .
 
data: value(69).
 
call function 'SYSTEM_INFO'
  exporting
    key   = 'SAP_VERSION'
  importing
    value = value.
.
write: 'Version ' , value.
call function 'SYSTEM_INFO'
  exporting
    key   = 'SAP_SYSTEM_ID'
  importing
    value = value.
.
write:/ 'system id' , value.
call function 'SYSTEM_INFO'
  exporting
    key   = 'MACHINE_TYPE'
  importing
    value = value.
.
write:/ 'Machine type ' , value.
call function 'SYSTEM_INFO'
  exporting
    key   = 'DBNAME'
  importing
    value = value.
.
write:/ 'DB name' , value.
call function 'SYSTEM_INFO'
  exporting
    key   = 'DBUSER'
  importing
    value = value.
.
write:/ 'DB user' , value.
call function 'SYSTEM_INFO'
  exporting
    key   = 'DBUSER'
  importing
    value = value.
.
write:/ 'DB Host' , value.
call function 'SYSTEM_INFO'
  exporting
    key   = 'CTYPE'
  importing
    value = value.
.
write:/ 'CTYPE' , value.
call function 'SYSTEM_INFO'
  exporting
    key   = 'OPSYS_VERSION'
  importing
    value = value.
.
write:/ 'OPSYS_VERSION' , value.
call function 'SYSTEM_INFO'
  exporting
    key   = 'KERNEL_KIND'
  importing
    value = value.
.
write:/ 'KERNEL_KIND' , value.

Also you can try FM RFC_GET_SYSTEM_INFO and give DESTINATION = 'NONE'.

Regards,

Ferry Lianto

[Former Member]

Hi Guys,

I appreciate your answers but I want to display the Database Data information which shows up in system-status under Database Data. And also the unicode information which is under SAP System Data block.

thanks,

Regards,

Prashant.

[Former Member]

Hi,

SY-DBSYS - Database system

SY-SYSID - Name

SY-HOST - Host

Thanks

Naren

[Former Member]

Hi Naren,

I want to display version of the Database system, i,e if it is oracle then which version is it either 8i. 9i, or 10 g.

Thanks,

Prashant.

[Former Member]

Hi,

use the FM DB_GET_RELEASE to get the database release..

Please reward points for helpful answers..

Thanks,

Naren

[Former Member]

Hi Naren,

Thanks for the reply, how about he unicode information where will I get this.

Thanks,

Prashant.

[Former Member]

Hi,

FM STATUS_ANZEIGEN , is called when you select status ,

please check , it can be helpfull..

Thanks .

[Former Member]

Hi ,

STEXT in TABLE CVERS_TXT , stores SAP release .

Thanks .