04-26-2006 9:33 AM
i want to call this trans and load diffrent parameters every time (the parametrs are change all the time, each call) to the selection screen
04-26-2006 9:38 AM
Rani,
This is a report, so you are better using the SUBMIT REPORT statement passing different parameters each time you are calling.
SUBMIT... [VIA SELECTION-SCREEN]
[USING SELECTION-SET <var>]
[WITH <sel> <criterion>]
[WITH FREE SELECTIONS <freesel>]
[WITH SELECTION-TABLE <rspar>].
VIA SELECTION Screen - Will display the SELECTION Screen of MB5B.You can simpley pass the parameters using the WITH Clause.
SUBMIT REPORT xxxx WITH para1 = itab...
Regards,
Ravi
Message was edited by: Ravikumar Allampallam
04-26-2006 9:35 AM
04-26-2006 9:38 AM
Rani,
This is a report, so you are better using the SUBMIT REPORT statement passing different parameters each time you are calling.
SUBMIT... [VIA SELECTION-SCREEN]
[USING SELECTION-SET <var>]
[WITH <sel> <criterion>]
[WITH FREE SELECTIONS <freesel>]
[WITH SELECTION-TABLE <rspar>].
VIA SELECTION Screen - Will display the SELECTION Screen of MB5B.You can simpley pass the parameters using the WITH Clause.
SUBMIT REPORT xxxx WITH para1 = itab...
Regards,
Ravi
Message was edited by: Ravikumar Allampallam
04-26-2006 9:44 AM
04-26-2006 9:49 AM
Unfortunately I don't have an example for this report, but it should not be too difficult. The place where you are calling from, should have the data for the parameters of the report.
Regards,
Ravi
04-26-2006 9:55 AM
04-26-2006 9:57 AM
What is table BESTAND, looks like something specific for your report?
You will have to declare RANGE variables for SELECT OPTIONS of the report and a variable for the PARAMETERS and pass the values through that.
Regards,
Ravi
04-26-2006 10:06 AM
BESTAND is a table in the program RM07MLBD for TRANS MB5B
it hold data that i need
04-26-2006 10:12 AM
Rani,
I am confused now. I thought you wanted to call this transaction MB5B, so if you are calling this, how can a table inside that hold the data you are looking for.
Can you explain in detail, what exactly are you trying to do?
Regards,
Ravi
04-26-2006 10:27 AM
i want to call this transacation with my parameters
and in process i want to move the data that i have to itab in MY Zprog and continue with m y work
04-26-2006 10:34 AM
That is exactly what SUBMIT report does, but you have to set the parameters data from your program and you cannot get any data from the report program.
Submit with the parameters values.
Regards,
Ravi
04-26-2006 9:54 AM
hi
good
here is a example go through this
MB5B uses the following:-
SELECT STATEMENT ( Estimated Costs = 101 , Estimated #Rows = 1 )
5 MERGE JOIN
5 SORT JOIN
5 TABLE ACCESS BY INDEX ROWID MKPF
INDEX RANGE SCAN MKPFBUD
5 SORT JOIN
5 TABLE ACCESS BY INDEX ROWID MSEG
INDEX RANGE SCAN MSEGM
MB51 uses this:-
SELECT STATEMENT ( Estimated Costs = 9 , Estimated #Rows = 1 )
5 NESTED LOOPS
5 TABLE ACCESS BY INDEX ROWID MKPF
INDEX RANGE SCAN MKPFBUD
5 TABLE ACCESS BY INDEX ROWID MSEG
INDEX RANGE SCAN MSEG0
And the "miracle solution" proposed by one of our consultants goes like
this:-
SELECT STATEMENT ( Estimated Costs = 22 , Estimated #Rows = 1 )
5 NESTED LOOPS
5 NESTED LOOPS
5 TABLE ACCESS BY INDEX ROWID MKPF
INDEX RANGE SCAN MKPFBUD
5 TABLE ACCESS BY INDEX ROWID MSEG
INDEX RANGE SCAN MSEG0
5 TABLE ACCESS BY INDEX ROWID MKPF
INDEX UNIQUE SCAN MKPF0
thanks
mrutyun
04-26-2006 9:59 AM
i sure that your answer is good
but i did not understand can you give me more explation and detalis
04-26-2006 10:03 AM
Rani,
Alright, assume you are executing this report individually. You will enter some values for the parameters, right. Similary when you are calling this from a program, we should pass the values.
for example the Material parameter .....
In your program
RANGES : R_MATNR for MARA-MATNR.
R_MATNR-SIGN = 'I'.
R_MATNR-OPTION = 'BT'.
R_MATNR-LOW = '1'.
R_MATNR-HIGH = '100'.
APPEND R_MATNR.
Similary do the same for others as well.
SUBMIT REPORT xxx with matnr = r_matnr .....
Regards,
Ravi
Note : Please mark all the helpful answers
05-15-2006 9:10 AM
Look for
SET PF-STATUS 'DATA_ALV'
in MB5B program.
At this point BESTAND table has been completely filled and ready for output.
You can transfer the table to your internal table after this statement.