topic Re: MB5B in Application Development and Automation Discussions

MB5B

Former Member — Wed, 26 Apr 2006 08:33:19 GMT

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

Re: MB5B

Former Member — Wed, 26 Apr 2006 08:35:36 GMT

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

Re: MB5B

Former Member — Wed, 26 Apr 2006 08:38:14 GMT

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

Re: MB5B

Former Member — Wed, 26 Apr 2006 08:44:47 GMT

do you have an example for this report

Re: MB5B

Former Member — Wed, 26 Apr 2006 08:49:55 GMT

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

Re: MB5B

Former Member — Wed, 26 Apr 2006 08:54:00 GMT

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 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

Re: MB5B

Former Member — Wed, 26 Apr 2006 08:55:08 GMT

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

Re: MB5B

Former Member — Wed, 26 Apr 2006 08:57:53 GMT

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

Re: MB5B

Former Member — Wed, 26 Apr 2006 08:59:10 GMT

i sure that your answer is good

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

Re: MB5B

Former Member — Wed, 26 Apr 2006 09:03:58 GMT

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

Re: MB5B

Former Member — Wed, 26 Apr 2006 09:06:39 GMT

BESTAND is a table in the program RM07MLBD for TRANS MB5B

it hold data that i need

Re: MB5B

Former Member — Wed, 26 Apr 2006 09:12:36 GMT

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

Re: MB5B

Former Member — Wed, 26 Apr 2006 09:27:44 GMT

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

Re: MB5B

Former Member — Wed, 26 Apr 2006 09:34:21 GMT

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

Re: MB5B

Former Member — Mon, 15 May 2006 08:10:07 GMT

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.