Aggregation in MIRO

[Thorben_Hald]

Hi

What are the options in SAP to create own defined layouts for MIRO with aggregation on columns that are not a part of the default aggregation layouts provided by SAP?

My "simple" requirement is to have an aggregation on the column Condition Type (DRSEG-KSCHL) under "Planned Delivery Cost" in MIRO.

Example:

A PO is created with 10 lines - each line have a purchase price and two delivery cost conditions - freight and customs.

Now in MIRO I would like to be able to go to planned delivery cost and choose a layout that aggregates the 10 lines into two lines - one line for each delivery cost condition.

Is this possible?

I do not understand fully the OLMRLIST transaction so I appreciate any input

Thanks

Thorben Hald

[PollyGan · Accepted solution]

No, I don't think it's possible to realize it via layout. The lines proposed is hard coded, and they're saved in internal tables...

[Prasoon]

Hi,

    The condition type based aggregation is not defined in standard as of my knowledge. In MIRO, standard aggregation can happen only for the criteria mentioned in the path: OLMR - Incoming Invoice - Aggregation - Preset Aggregation Criteria. You may check whether the aggregation based on any other available criteria can be used in your case.

    If you still want to go with condition type based aggregation, you may check the feasibility of development. But please note that the structure DRSEG and the include CI_COBL are critical structures used in many areas.

    In addition, you may refer the note: 311496, which explains the system design.

Regards,

AKPT

[former_member183424]

There are no facility for invoice verification. System will always call the cost as per line item. It wont summarize upon condition type (even any other).

You may need to do it your self by using some badi or exit. Look into the OSS note for various badi 1156325 - BAdIs in the Logistics Invoice Verification environment

[Former Member]

Hi Thoron,

But why you want to aggregate these 10 items. If you aggregate then you will not able to track the cost as per material.

Thanks,

Arun

[Thorben_Hald]

Yes I will

By activating a business function SAP makes the "unplanned delivery cost" field available for planned delivery costs.

So for example if I have 10 lines with different values that was accrued during GR, SAP will sum those lines to a total value in MIRO - as per standard.

The actual invoice for these delivery cost lines will not detail what the actual invoice value is for each line - but just a total sum.

So what I will do is to put the difference between the sum of the 10 lines and the actual invoice, into the unplanned delivery cost field.

SAP will spread the difference automatically on the 10 lines based on the accrued value of each line.

So in fact by activating this business function AND having an aggregate I have solved the classic issue of having to adjust manually all lines on MIRO to match the invoice.

And in most cases for delivery costs, the invoice will not split the cost per PO line and therefore most companies will post the difference to a G/L account and thus not have the actual effect hit the material valuation.

/Thorben Hald