Generated by Jive on 2013-04-23+02:001

Want to add a field in MB51 O/p

anis bazmi 891 posts since Sep 8, 2008

Want to add a field in MB51 O/p Jul 20, 2009 1:12 PM

Dear experts ,

I want to add a field of vendor name LFA1-NAME1 to the std MB51 o/p as in the std o/p only

vendor number is being displayed .

I made a query to serve the purpose by joining MKPF - MSEG & LFA1

BUT

Unlike in std report , I could not put a +/- sign to the qty issued as some of the documentswere cancelled /reversed .

Due to this the summation of the qty issued was wrong.

Hence pls suggest me a method to take care of this.

Regards

Anis

Eduardo Hinojosa 4,075 posts since Aug 16, 2010

Re: Want to add a field in MB51 O/p Jul 20, 2009 1:36 PM

Hi,

Want to add a field in MB51 O/p

Generated by Jive on 2013-04-23+02:002

Check Note 357187 - MB51: Fields in field catalog / selection screen.

Other idea, if you don't use the field MSEG-SGTXT, you can populate it with theenhancement MBCF0002

I hope this helps you

Regards,

Eduardo

anis bazmi 891 posts since Sep 8, 2008

Re: Want to add a field in MB51 O/p Jul 20, 2009 1:50 PM

Hello Eduardo,

Thanks for the reply ...

Could u pls tell me what shud be the approach if one wants to use the enhancement MBCF0002.

As i perceive , u r suggesting to use a user exit to replace MSEG-SGTXT with the desiredfield ??

Pls guide

Want to add a field in MB51 O/p

Generated by Jive on 2013-04-23+02:003

Thanks in advance

Anis

Eduardo Hinojosa 4,075 posts since Aug 16, 2010

Re: Want to add a field in MB51 O/p Jul 20, 2009 2:00 PM

Hi,

You can crate a zeta report (eg: ZMB51, but I dont suggest it, MB51 is so complex).

If you want try with the enhancement, the steps are:

1. Create a project with tcode CMOD

2. Set the enhancement. Go to the userexit (funcition module EXIT_*)

3. In the coding, double clic on the ZX* include. The system ask you if you want create it.Your answer: YES. Create it with an own package.

4. Set this coding and set a break point.

IF NOT i_mseg-lifnr IS INITIAL.

e_sgtxt = i_dm07m-name1.

ENDIF.

5. Dont forget activate all (project, and all ABAP objects). If when you do a MM movement,the system stop in you breakpoint, it means that it works OK.

Want to add a field in MB51 O/p

Generated by Jive on 2013-04-23+02:004

I hope this helps you

Regards,

Eduardo

anis bazmi 891 posts since Sep 8, 2008

Re: Want to add a field in MB51 O/p Jul 20, 2009 3:31 PM

Hello Eduardo ,

As directed by you we have made the said code changes ,

Still we observe that the MSEG-SGTXT field shows the item text .

We would like this to be replaced by LFA1-NAME1

this field is to be fetched by MSEG-LIFNR .

Pls Guide us

Regards

Anis

Eduardo Hinojosa 4,075 posts since Aug 16, 2010

Re: Want to add a field in MB51 O/p Jul 20, 2009 3:39 PM

Hi,

Want to add a field in MB51 O/p

Generated by Jive on 2013-04-23+02:005

It's no necessary. In this enhancement you have available a set of data without you needsearch them with any 'SELECT', so you avoid problems of performance. Set the break-pointand check the values of structures I_VM07M and I_DM07M. So i_dm07m-name1 must bepopulated with the name of the vendor.

Regards,

Eduardo

Rahul Srivastava 66 posts since Oct 21, 2011

Re: Want to add a field in MB51 O/p Apr 28, 2012 11:43 AM

Dear Eduardo,

I_VM07M and I_DM07M??????

these object does not exist into system.

your answer is wrong.

subhash karipi 147 posts since Nov 20, 2008

Re: Want to add a field in MB51 O/p Jul 20, 2009 1:43 PM

Dear,

Instead going to SQVI you directly include vendor number in std report MB51.

Want to add a field in MB51 O/p

Generated by Jive on 2013-04-23+02:006

You can directly use the following setting

spro>MM>Inventory management and physical inventory> reporting>Define field selectionfor material document list

where click new entires

and add

RM07DOCS MSEG LIFNR Vendor Account Number

and select as per your requirement

selection screen or output list

anis bazmi 891 posts since Sep 8, 2008

Re: Want to add a field in MB51 O/p Jul 20, 2009 2:04 PM

Hello subhash ,

Thanks for the reply

But the problem is that the field for vendor name ( not vendor number ) is not present in theMSEG table.

Altho in material document the same is fetched by a structure .

Want to add a field in MB51 O/p

Generated by Jive on 2013-04-23+02:007

Pls help as in how to go about it ?

Regards

Anis

Anamika Roy 966 posts since Jun 12, 2009

Re: Want to add a field in MB51 O/p Jul 20, 2009 2:43 PM

Hi,

Go to SPRO -- MM -- Inventory Management and Physical Inventory -- Reporting -- DefineField Selection for Material Document List

For this you need to copy the programe name from MB51, then add the table name and felidas per your requirment check hte selection screen and output screen

regards