Skip to Content
author's profile photo Former Member
Former Member

Help restricting report output

Hi All,

Just a quick caveat before I expose my significant ignorance, I have no SAP training or background. Nearly all of my SAP knowledge has come from Google 😊 Unfortunately I've come to an impasse that even Google can't help me with 😔

Ive been working on some log analysis for my client. Some of the information I get from them comes from SAP, so I've been attempting to automate the SAP request from Perl. Ive done a bunch of work and found out what their transaction names translate to, and I can now call the report from Perl using SAP::Rfc.

The code I use looks like this:

-


#!/usr/bin/perl

use strict;

use warnings;

use SAP::Rfc;

use Data::Dumper;

my $rfc = new SAP::Rfc(

ASHOST => 'host',

USER => $uid,

PASSWD => $password,

CLIENT => '100',

SYSNR => 'PD1',

TRACE => '1');

my $interface = $rfc->discover("INST_EXECUTE_REPORT");

$interface->PROGRAM( "RSUSR002" );

$rfc->callrfc( $interface );

print Dumper \$interface;

$rfc->close();

-


What I need to do now is define the from date, from time, to date and to time to restrict the number of rows returned by this report. Ive looked through the traces and the Dumper dumps to try and find the answer with no luck, and as mentioned Google has let me down too 😔

Can anyone help me, or provide a small hint? 😊

Thanks for your help!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2009 at 10:45 PM

    Hi Everyone,

    I have not had any luck finding out how to address my problem. Does anyone know of a better location for this query?

    Thanks!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2009 at 10:59 PM

    Moved to the Security Forum...

    For me it not surprising that you did not get an answer. The program has a selection screen (where are your paremeters for it?) and it is a "static" report which returns the current user information (there are no parameters for from and to dates and times).

    Please explain what your client wants. There must be a better way of doing it... 😊

    Cheers,

    Julius

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2009 at 12:17 AM

    Hi,

    I've been given reports that humans produce for review. They would like to automate the collection of the information from SAP as well as the analysis jobs that have been created.

    My initial idea was to have my job run the reports the humans do, however I've not been able to find any information on how to use SAPRFC to do such a thing, so I resorted to looking at tables via RFC_READ_TABLE. This is working so some extent however I currently can't find out what a users organisaitonal unit is, and even if I did, I don't know how to build a query with SAPRFC to do the lookup.

    Has anyone had any experience joining tables using RFC_READ_TABLE, or perhaps a more appropriate function?

    Thanks!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.