Any standard report to show WBS,settlement, asset no and asset cost/value

[Former Member]

Hi All,

Please advice . Is there any standard report to show WBS,settlement, asset no and asset cost/value ? I tried tcode kosrlist_pr but it does not show asset cost/value.. it shows only WBS,settlement and asset no.

Thank you.

Best Regards,

Nies

[Former Member · Accepted solution]

Hi,

There are some reports in Information System under accounting - financial accounting - fixed assets which will give a report linking most of the requested fields.For Eg. S_ALR_87010125.

Hope these will be helpful.

Regards

Sreekanth

[Former Member · Accepted solution]

Hi Sreekanth,

Appreciate your advice. However, i have tried to run that report but it cannot shows WBS,asset no and asset value.

Thank you.

Nies

[Former Member · Accepted solution]

Don't think you can get all fields in a single/standard report:

I can suggest you to write a query joining below tables:

PRPS-WBS (Work Breakdown Structure) Element Master Data

COBRB-Distribution Rules Settlement Rule Order Settlement

COSPD-CO Object: Settled Primary Cost Totals

COSSD-CO Object: Settled Secondary Cost Totals

Join these tables with the field OBJNR and list the fields required by you. Think these tables would contain all necessary information/fields you are looking at.

Regards

Sreenivas

[Former Member · Accepted solution]

Hi Sreenivas,

Do you mean by using SQ01 ? do you have documentation step by step how to create query?

Sorry for the inconvinience cause.

Thank you.

Nies

[Former Member · Accepted solution]

You can build the query SQ01 but another simple method is use SQVI

I can mention the high level steps and I don't have any document for it:

T Code: SQVI

Mention a Name for the query and click on create

Mention the title and add any comments.

In the data Source select 'Table Join'

Choose the basis mode (I find this mode is easy)

Choose menu Edit>Insert Table

Mention Table :PRPS

Similarly Insert other tables

Join all (drag and drop the mouse from technical name to same technical name) the tables with OBJNR, delete any other links (to delete right click on the link).

Back

Expand the data fields that appear in the left half of screen

Check the check indicator against the fields for List and selection.

List- This will be shown in the report output (Ex., Settlement type etc., what ever fields you require output)

Selection- This will be available in selection screen (Ex., WBS Element)

Save you query.

Execute

You should be seeing your report.

Regards

Sreenivas

PS: Sure you would counter some issues as you are doing this for 1st time but be assured this works if done properly. Take someone's help.