Add additional fields in Standard reports like MB5S

[Former Member]

Hi,

We have requirement to add new standard fields in Standard Reports..

in MB5S we just get vendor Code in the report.. we need Vendor Description also.. and also we get only PO Number and item No in the report.. we need to get display of PO description also, please suggest how to get the required field in the standard report..?

one more BASIC but very important problem i'm trying to find solution... is there any Report or Table which will take both PO Number and PO Line item No as the Input field...

so that we can just copy the MB5S report..ie PO Nos and its Line items.. and place the respective PO number and item number combined.. to get the PO line item description.. Vendor description...and other required details of the POs...

i know there are lot of PO report transaction like ME2N, ME2K, ME80FN, but i think it is not asking for PO and its Line item combinedly...there are 2 separate field for PO and the line items, which do not match properly..and it gets sorted out as per the descending order.. which makes the report go wrong.

if this reports ask for both PO and line items combinedly then we can input our POs with Line items.. say 1000's of POs with there "n" number of line items accordingly...

say for example if i want to know the description of 100 POs with the specified line items as attached in the attachment how will i place them in a report to get the same..?

Requesting to throw some light on this issue,

Thanks and regards

Saritha

[Former Member]

Hello Satitha,

The report MB5S gives you the details for clearing accounts.

As per your requirement :

- Pls refer report GR/IR mintenance - T. Code MR11

- This report has the input value as "po no" and "item no."

- Also, this have the vendor description.

Hope, MR11 will solve your prob.

Regds,

Nilesh

[Former Member]

Thanks you for your Reply.

i think MR11 is a sophisticated transaction which cannot be provided to Users.. which may be misused..

I need some report or transaction which will allow list of POs along with Line items as Input field... as it will solve most of our Reporting problem...

Thanks and regards

Saritha

[Former Member]

pls note, MR11 shows same data as of MB5S

You can give user authorizations to prevent posting of MR11.

As per my observation, MR11 has entry parameter as po no. and po item no.

Regds,

Nilesh

[Former Member]

Hi Nilesh,

i know there are lot of PO report transaction like ME2N, ME2K, ME80FN, and even MB5S which has input field for PO number and also PO line item separately...

but it is not asking for PO and its Line item combinedly...there are 2 separate field for PO and the line items, which do not match properly..and it gets sorted out as per the descending order.. which makes the report go wrong.

if this reports ask for both PO and line items combinedly then we can input our POs with Line items.. say 1000's of POs with there "n" number of line items accordingly...

say for example we have PO numbers with line items as below... ( ( this is un sorted complete list of PO with Line items. ))

PO Number	Items
4500000010	10
	20
	30
	40
4500000011	10
	20
	30
4500000012	10
	20
4500000013	10
	20
4500000014	10
4500000015	10
	20
	30
4500000016	10
	20
4500000017	10
4500000018	10
4500000019	10
	20
4500000020	10

the sorted list of above List which for which we require additional details are as below.. ( sorted from the above list)  PO with line items as below..

(  here if i want additional details like description details, Plant, Net order value etc...for the Below selected)

PO Number	Items
4500000010	10
	20
4500000011	30
	40
4500000012	10
	20
4500000013	10
	20
4500000014	10
4500000015	10
4500000016	10
	20
4500000017	10
4500000018	10
4500000019	20
4500000020	10

here when i give the PO details in one field ie... "Purchasing Document" field. and the Item details in another field..ie.. "Item" Field..

The Item Number 30 and 40 which has to be for 4500000011 is calculated for 4500000010 PO,

result is i'm getting details of PO 4500000010 with item 30 and 40 details which is not called for... actually i need 4500000011 with details of item 30 and 40..

i mean to say there is no proper synchronization between PO numbers and the Line items we provide in many reports say ME2N, ME80FN.. how to synchoronize this..

i hope i have explained the issue...

Please let me know if i'm not clear..

Thanks and regards

Saritha

[AmalaSrinivasa]

Hi Saritha,

1.) If you are looking for purchase order numbers along with only specific line items  in your report output you can go as below

ME2N-->Dynamic Selections-->Purchasing Document Item--> select Purchasing Document  & Item;

suppose you want to see only line item 20 double click on the line item and select = option and execute then all PO's will come with only line item 20.

2.) If you are looking for  PO net value, Goods receipt value, Invoiced value and Down payment value in singe transaction. The same we have carried out by enabling the corresponding fields from the  structure MEREP_OUTTAB_PURCHDOC and writing the code to corresponding fields for all PO reports which are starting with ME2*

3.) User can do the modifications  of report output in EXCEL also

Please let me know for further details

R,

Amal

[appasaheb_nagargoje]

This message was moderated.

[Former Member]

Hi

I dont think there is any SAP Standard Report that can meet your requirments. I see 2 Options

1. Try to use Queries to achieve what you want or

2. Make a copy of the report RM07MSAL and make changes in them through ABAP Code and attach the report to MB5S or create a new TCode ZMB5S

Regards

Jayaram