MB5B

[Former Member]

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

[Former Member]

how could i get the data of table <b>bestand</b> into itab.

[Former Member]

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

[Former Member]

do you have an example for this report

[Former Member]

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

[Former Member]

and how could i get the data of table bestand into itab.

[Former Member]

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

[Former Member]

BESTAND is a table in the program RM07MLBD for TRANS MB5B

it hold data that i need

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

i sure that your answer is good

but i did not understand can you give me more explation and detalis

[Former Member]

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

[Former Member]

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.