Report for non-settled completed assets records

[Former Member]

Hello, colleagues!

We got a trouble, I will appreciate your helpful answer!

We want to use a common report, where we can observe several selected WBS elements with corresponding numbers of completed assets which are linked to WBS by settlement rule. In this report we need to see non-settled assets(WBS) too (its important). I tried to use "S_ALR_87012058 - List of Origins of Asset Debits" but it only shows already settled assets.

[former_member195427 · Accepted solution]

Hi,

   Check the below given links. hope , it may be useful:

http://scn.sap.com/thread/1936661

http://scn.sap.com/thread/1001030

Regards

Ankur

[nishan_dev]

Hello Dmitry Ostapenko,

Around two year back, we also have similar requirement and was able to do that, with a ZTransaction which was calling all the WBS Element with their status, so from where we can easily find out which WBS Element is associated with which Asset, and at what status is that WBS Element sitting on.

To accomplish that, you have to work with ABAper to join 4 tables.

a)PRPS

b)COBRA

c) COBRB

d) ANLA

Best luck,

Nishan Dev

[Former Member]

Thank you, colleagues! It seems so, that we need to create a query or ABAP-report. I studied COBRA, COBRB - they contain all that I need. Okay...

[Former Member]

Hi Dmitry,

Try this-

1. Join table COBRA & COBRB (Primary key-Settl. rec. obj. no.).

This may suffice your requirement.

Regards,

Pranav