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

how can i combine 3 standard programs into one program and add some cutome

hi there gurus,

i am creating a stock aging reprot, currently the users are getting the datas as they want from mb5l,mb51,mc46.

1.they request me to get the material number, mat.desc, download qty on that day, uom, from mb5l,

2.mb51, to download the consumed qty for past 12 months, and also the value

3. mc46 to see the days last the material consumed.

all this has to be extracted using GL account.

i try all kind of thungs, but could not able to extarct the datas.

plz guide me through.

thank you.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 03:35 AM

    i dont know much about these three transaction but i thnk you may use the below satement to do the needful

    from help.sap.com-

    -


    Program accessed

    REPORT report1.

    DATA text TYPE c LENGTH 10.

    SELECTION-SCREEN BEGIN OF SCREEN 1100.

    SELECT-OPTIONS: selcrit1 FOR text,

    selcrit2 FOR text.

    SELECTION-SCREEN END OF SCREEN 1100.

    CALL SELECTION-SCREEN '1100' STARTING AT 10 10.

    Calling program

    REPORT report2.

    DATA: text TYPE c LENGTH 10,

    rspar_tab TYPE TABLE OF rsparams,

    rspar_line LIKE LINE OF rspar_tab,

    range_tab LIKE RANGE OF text,

    range_line LIKE LINE OF range_tab.

    ...

    rspar_line-selname = 'SELCRIT1'.

    rspar_line-kind = 'S'.

    rspar_line-sign = 'I'.

    rspar_line-option = 'EQ'.

    rspar_line-low = 'ABAP'.

    APPEND rspar_line TO rspar_tab.

    range_line-sign = 'E'.

    range_line-option = 'EQ'.

    range_line-low = 'H'.

    APPEND range_line TO range_tab.

    range_line-sign = 'E'.

    range_line-option = 'EQ'.

    range_line-low = 'K'.

    APPEND range_line TO range_tab.

    SUBMIT report1 USING SELECTION-SCREEN '1100'

    WITH SELECTION-TABLE rspar_tab

    WITH selcrit2 BETWEEN 'H' AND 'K'

    WITH selcrit2 IN range_tab

    AND RETURN.

    Result

    After report1 has been accessed by report2, the selection tables for the selection criteria selcrit1 and selcrit2 in the program accessed contain the following entries:

    SIGN OPTION LOW HIGH

    selcrit1 I EQ ABAP

    selcrit2 I BT H K

    selcrit2 E EQ H

    selcrit2 E EQ K

    Edited by: Sumesh Nair on Jan 31, 2008 9:13 AM

    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.