topic Re: system status and database information in Application Development and Automation Discussions

system status and database information

Former Member — Fri, 09 Mar 2007 01:08:11 GMT

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

Re: system status and database information

Former Member — Fri, 09 Mar 2007 01:10:00 GMT

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

Re: system status and database information

Former Member — Fri, 09 Mar 2007 01:14:35 GMT

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

Re: system status and database information

Former Member — Fri, 09 Mar 2007 01:24:56 GMT

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.

Re: system status and database information

Former Member — Fri, 09 Mar 2007 01:29:45 GMT

Hi,

SY-DBSYS - Database system

SY-SYSID - Name

SY-HOST - Host

Thanks

Naren

Re: system status and database information

Former Member — Fri, 09 Mar 2007 01:31:57 GMT

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.

Re: system status and database information

Former Member — Fri, 09 Mar 2007 01:35:06 GMT

Hi,

use the FM DB_GET_RELEASE to get the database release..

Please reward points for helpful answers..

Thanks,

Naren

Re: system status and database information

Former Member — Fri, 09 Mar 2007 01:38:37 GMT

Hi Naren,

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

Thanks,

Prashant.

Re: system status and database information

Former Member — Fri, 09 Mar 2007 04:28:38 GMT

Hi,

FM STATUS_ANZEIGEN , is called when you select status ,

please check , it can be helpfull..

Thanks .

Re: system status and database information

Former Member — Fri, 09 Mar 2007 04:32:25 GMT

Hi ,

STEXT in TABLE CVERS_TXT , stores SAP release .

Thanks .