maintainance order wise report

[Former Member]

Hi, All.......

We r developing one report for PM in BI.........The requirement is that there are several consumable material like oil, grease, petrol etc which r assigned against PM orders as components. Under location tab we r having various PM location maintainance objects and respective cost center against which it is going to book the cost of consumable.

what i need is that i shld able to see PM orderwise consumption of consumable material w.r.t to their PM location(STORT) ,Cost center(KOSTL).

I m able to get consumption data for movt.261 issue from stores against PM order for that Consumables.

But in which table i can get PM location(STORT) and respective cost center in relation with PM orders.

Pls give ur valuable inputs....

Yogesh......

[Former Member · Accepted solution]

You have the service order number aready, using this you should use table AUFK to determine the following:

STORT - Location. That's what you were looking for.

KOSTV - Responsible Cost Center. This is what I think you may be looking for.

KOSTL is contained in MCIPMIS. If this is what you require, it can be is found using field OBJNR from table AUFK as the key in table MCIPMIS.

[vineet_sharma4]

dear yogesh..

in table AUFK itself you can get both the STORT & KOSTL with respect to maintenance order.

vin..

[peter_atkin]

Yogesh,

Also have a look at table ILOA (Location & Account Assignment Data)

The links are:

AUFK-AUFNR -> AFIH-AUFNR

AFIH-ILOAN -> ILOA-ILOAN

PeteA

[Former Member]

This message was moderated.