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

Reports

Hi all,

i have a requirement as follows,

I have 4 reports namely zrep1, zrep2, zrep3,zrep4.

now wat user does is...

1.I execute the report zrep1 and use this result doing manual calculation.

2.I execute zrep2 , use the result of zrep1 and zrep2 perform manual caluculation .

3. i execute zrep3 and use the result of zrep1,zrep2 and zrep3 and do manual calcuation.

NOTE:Every report has screens and user enters the values in the screen.

Now my user requirement is he does not want to do this manually and want the system to do .

So how should i get the values of executed results and make the system to do calculation.

Plz give me suggestions.

Thanks ,

Azee.

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 Sep 28, 2005 at 08:31 AM

    u can use import / export data to memory...

    EXPORT obj1 ... objn TO DATA BUFFER f.

    - EXPORT obj1 ... objn TO MEMORY.

    - EXPORT obj1 ... objn TO SHARED MEMORY itab(ar) ID key.

    - EXPORT obj1 ... objn TO SHARED BUFFER itab(ar) ID key.

    - EXPORT obj1 ... objn TO DATABASE dbtab(ar) ID key.

    - EXPORT obj1 ... objn TO DATASET dsn(ar) ID key.

    - EXPORT (itab) TO ... .

    IMPORT obj1 ... objn FROM DATA BUFFER f.

    - IMPORT obj1 ... objn FROM MEMORY.

    - IMPORT obj1 ... objn FROM SHARED MEMORY itab(ar) ID key.

    - IMPORT obj1 ... objn FROM SHARED BUFFER itab(ar) ID key.

    - IMPORT obj1 ... objn FROM DATABASE dbtab(ar) ID key.

    - IMPORT obj1 ... objn FROM DATASET dsn(ar) ID key.

    - IMPORT obj1 ... objn FROM LOGFILE ID key.

    - IMPORT DIRECTORY INTO itab FROM DATABASE dbtab(ar) ID key.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2005 at 08:37 AM

    hi,

    use Export and Import options

    for ex. use export in zrep1

    import the values in zrep2

    sasi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2005 at 08:49 AM

    Hi,

    Since it is is a custom report I suggest you to modify it such that it stores the value of each report in Memory

    ( Do not use IMOPORT/EXPORT as it will be cleared when the current session ends).

    I believe you can't transfer internal table to memory using SET/GET Parameters.

    From your explanation I understood that you need calculation part alone to be done by the system and the execution of reports will be done by you.If my understanding is wronh please revert.

    The solution would be exporting/importing internal tables to database indexes.

    So in each report, just before they being displayed add teh below code

    DATA :w_indx_docov TYPE indx-usera.

    w_indx_docov = sy-uname.

    EXPORT (int_table) indx(<b>XX</b>) ID w_indx_docov.

    Note : Replace <b>XX</b> with any 2 characters.This characters should be different for each internal table. Otherwise the content will be overwritten.

    Similarly IMPORT it using

    IMPORT (int_table)FROM DATABASE indx(XX) ID w_indx_docov..

    <b>For your current scenario</b>

    <b>EXPORT</b> internal table to database index in end of report <b>zrep1.</b>

    In <b>zrep2</b> IMPORT from the database Index.

    Please let me know if you need furher help.

    Please reward points if you find this explanation useful.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi SivaKumar,

      well i think u have got me partly right,

      here i go with more detail,

      Report zrep1 needs to be executed every day with a variant, i need a field value from zrep1 and perform calculation ex tab1-fld1.

      Result of zrep1 i use to calculate productivity for Inbound.

      Rport2 zrep2 is executed every day , i need field value from zrep2 ( ex tab2-fld2) and zrep1.

      say i use tab1-field1 + tab2-field2 to perform reqúired calclation.

      Result of zrep1 and zrep2 i calculate the productivity for Replenishment.

      I need this values to be stored for historical reason,

      as this ill be used to run monthly reports and yearly too.

      By using IMPORT AND EXPORT it ill be stored temporarly.

      I hope it's clear wat i want.

      Thanks,

      Azee

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.