Table for Project code and Settlement

[Former Member]

Hi All,

Could anyone advice me in how to find a table that can be shown data for project and settlement ?

Thank you so much

Nies

[bettassoci · Accepted solution]

Hi Nies,

The following report will show you the sender, receiver, settlement distribution method (amount, percent), and settlement rule type... KOSRLIST_PR List of Settlement rules for Projects

What information specifically are you looking for?

Regards,

Kent Bettisworth

[Former Member · Accepted solution]

Hi Kent,

Appreciate for your advice. I am looking for the mass information of Project and WBS that has settlement rule(looking for report that can show Project-WBS and settlement rule inside). Normally, we use transaction code CJ02 or CJ20n to check the settlement rule.

It shows 'Display Settlement rule :Overview' (for example)

Cat:FXA

Settlement Receiver : 5000****

Receiver Short Text : ***

% : 100.00

Equivalance : 0

Amount :

Settlement : AUC/FUL

[Former Member]

Hi,

CJID gives line item settlement details for a given WBS. CN43 gives details of project ID and WBS details. I am not aware of any transaction which gives both, though it could be a gap in my knowledge.

Muraleedharan.R

091 9880028904

[Former Member]

Nies,

For project definition, please check PROJ

For WBS elements, check table PRPS

For the settlement rule, tables COBRA and COBRB

For the settlement values, refer to the cost tables COSPD and COSSD.

I suggest you to refer to transaction RKACSHOW. This will lead you to all the cost tables for a particular object.

Hope this helps

Regards

Martina

[Former Member]

Hi Martina,

Is there any standard report to shows project definition,WBS and settlement?

Thank you.

Nies

[Former Member]

I don't think there's a standard one. But you can create simple custom report using Quickviewer (T Code SQVI) joining tables PRPS and COBRB.

Link the tables with fields PSPNR-PRPS and PS_PSP_PNR-COBRB.

Doesn't require much technical knowledge to create the report with selection criteria's and output parameters.

Regards

Sreenivas