WBS element accounting table

[former_member211992]

Dear all

I need to create a report for WBS element and accounting transaction's done for that wbs element , i used PRPS to get wbs element .what is the table to get accounting transaction's thats done for the wbs element , how to link accounitng table and PRPS.

Thanks

[Former Member]

Link ur WBS Element with this BSEG - PROJK

[former_member211992]

Thanks for ur reply ramachandran

i linked prps-pspnt ----> bseg-projk,,im getting wbs element does not exist in the table bseg

[schneidertho]

Hi Karthik, Hi Ramachandran,

not sure if selection via BSEG is a good idea. As far as I recall (correct me, if I am wrong) BSEG is a cluster table and as such cannot have secondary indexes... hence your selection might be quite slow.

Do you really need the single FI (and only FI) postings?

In general my approach would be to read WBS related FI/CO postings through tables COSP/COSS (or alternatively RPSCO).

If you need line items (which then should also have a link to the FI document), you can use COBK, COEP. The link to PRPS is always based on field OBJNR.

Best regards

Thorsten

[former_member211992]

Thanks for ur reply thorsten

I need to get the values which is displaying in statndard tcode CJI3.

[Former Member]

Hi Karthik,

CJI3 is line item report. Please use COEP table as suggested by Thorsten.

Regards

Shrikant

[Former Member]

Hi Kartik,

RSPCO will tell you which one is an Actual(CJI3) and which one is Commitment(CJI5).

Select all OBJNR from RSPCO where WRTTP equals 04 or 11.

SELECT objnr FROM rspco INTO TABLE gt_rspce FOR ALL ENTRIES IN gt_prps

WHERE objnr = gt_prps-objnr AND (wrttp = '04' OR wrttp = '11'.)

Now go to table COVP and get the document details from there by passing the OBJNR values.

Thanks,

Shambu

[former_member211992]

Hi all

The OBJNR which is im seeing in PRPS and COSP entirely different,,in cosp im seeing 14 digit no,but in prps 10digit no,

[Former Member]

In PRPS ONJNR is 22, so is in RSPCO and same in COVP.

Go to SE11  and check.

[former_member211992]

In objnr field im seeing 10 digit no but if i give f4 in that field it shows 22 digit no ,that is right objnr .

[Former Member]

It can also be 10 digits, just copy the relevant objnr and check the tables.

[former_member211992]

im getting 'no table entries found for specified key'

[Former Member]

Then you are doing something wrong.

Go to CJI3.

Run it for a WBS Element.

If you get entries for that WBS element, find the OBJNR of that WBS from PRPS.

Use that OBJNR and put it in COVP-OBJNR.

You can see the Actual entries for that WBS there.

Thanks,

Shambu