topic Query Issue with adding a static value in Application Development and Automation Discussions

Query Issue with adding a static value

Former Member — Mon, 28 Jul 2008 16:05:14 GMT

I have written a query in SAP that works the way I need it to. I am going to schedule it so that SAP does a file transfer of the output to another area where the data will be accumulated.

My problem is that I want the name of the system to appear at the end of each line but it is not in any table I can find to match up with the userid.

EX:

UserID Group System

JDOE HR Query Group P201

The field for system is not in any tables but I want to add it and give it a constant/static value all the time in the output.

Any ideas?

Thanks!

Justin Dauby -- SAP Security Analyst

Kimball International Inc.,

Re: Query Issue with adding a static value

Former Member — Mon, 28 Jul 2008 17:28:55 GMT

The name of the system is not in a table, but rather a structure called SYST. You can evaluate it using the system field sy-sysid.

Another option is to call function module RFC_SYSTEM_INFO. The export parameter RFCSI_EXPORT will deliver the system id from component RFCSYSID of the structure RFCSI.

Cheers,

Julius

Re: Query Issue with adding a static value

Former Member — Mon, 28 Jul 2008 17:49:10 GMT

I am looking for a way to just specify in the InfoSet to place a static value in the query output. Maybe the query can do that but I thought the InfoSet is where I would define that.

Thanks!

~ Justin