topic Re: Does a table exist with kernel information? in Application Development and Automation Discussions

Does a table exist with kernel information?

Former Member — Mon, 12 Oct 2009 12:16:24 GMT

Hey there,

I want to get some information about the kernel by using a oracle database connect (from non-SAP). Until now, I have found different tables showing me release, version, support packages and so on (CVERS, UVERS, etc.). But is there also a table where I can find the kernel information?

Thanks in advance

Michael

Re: Does a table exist with kernel information?

Former Member — Mon, 12 Oct 2009 12:25:22 GMT

Check the FM 'SYSTEM_INFO to get the kernel information

Re: Does a table exist with kernel information?

ThomasZloch — Mon, 12 Oct 2009 12:26:54 GMT

This is how System->Status pulls it up:

call 'SAPCORE' id 'ID' field 'VERSION'
                 id 'TABLE' field kernel_version-*sys*.

So I guess there is no transparent table with this info.

Thomas

Re: Does a table exist with kernel information?

Former Member — Mon, 12 Oct 2009 12:28:57 GMT

What does FM stand for?

Re: Does a table exist with kernel information?

Former Member — Mon, 12 Oct 2009 12:29:53 GMT

Thanks for your answers, but I want to know a SQL-select statement, nothing with ABAP.

Re: Does a table exist with kernel information?

Former Member — Mon, 12 Oct 2009 12:31:09 GMT

FM stands for Function Module. Goto SE37 and write the name given above by Vikranth there and execute it.

Edited by: vijetasap on Oct 12, 2009 2:32 PM

Re: Does a table exist with kernel information?

Former Member — Mon, 12 Oct 2009 12:33:48 GMT

FM stands for function module. As Thomas pointed that there is no transperant table for this, you cannot use a select query. you will have to call the function module SYSTEM_INFO to get the kernel information. Please search in SCN as to how to call that function module

Re: Does a table exist with kernel information?

Former Member — Mon, 12 Oct 2009 12:37:39 GMT

Okay, thank you ..

Are there any possibilities to get the kernel infos using the databaseconnect without SAP? Maybe with oracle specific means?

Re: Does a table exist with kernel information?

Former Member — Mon, 12 Oct 2009 12:43:21 GMT

Hi,

Try the FM TH_SAPREL2 (behind you find the old good one C ThSysInfo as in RFC_SYSTEM_INFO)

success.

Gr., Frank

PS: i have not read the full forum, maybe someone else had arlready given this answer

Re: Does a table exist with kernel information?

Former Member — Mon, 12 Oct 2009 12:46:24 GMT

Probably u need to create or called a RFC based on SYSTEM_INFO or calling SYSTEM_INFO in order to export the kernel data,

Just as Bensen wrote, there's RFC_SYSTEM_INFO

P.s.: RFC_SYSTEM_INFO doesn't seem to do the same thing of SYSTEM_INFO (but I've just given a look at both ABAP code)

Max

Re: Does a table exist with kernel information?

Former Member — Mon, 12 Oct 2009 13:00:02 GMT

Well, okay .. it seems like there is no table for it .. so I have to think it over .. just googled and saw, that there is a solution between php and sap called saprfc .. so I will try this. Here I can also execute these FMs ..

Thank you all!

Michael