Payment Against WBS

[Former Member]

Hi Gurus !

Good day to all !

I need to create a custom report regarding Amount Paid against WBS to Vendor/Supplier

I tried to see this info in FBL1N but WBS field is not populating. What could be the reason?

Now what I do normally is open CJI3 and check the line items with vendor invoices (RMRP) and then extract another report from FBL1N and match the invoices and then which invoices are matching, I check the payment document type kz against it. So that's how I get to know that this invoice is being paid.

I want to create a report for this using SQVI. Can anyone please help me?

Which tables should I use? I would be very grateful if someone could tell me the steps for this.

Thanks

Rabiee

[Former Member]

Hi Rabiee,

Please close this thread if answered.

Regards,

Pranav

[former_member218047]

HI Rabiee,

After execting FBL1n, you have to change the layout of the vendor list item by clicking change Layout.There you have to add WBS element to populate in the final report. Henc you can able to see the Advances for the particular wbs element by using filter icon.

To capture Advances : Use BSIK table by providing the WBS element and can fetch the amount from DBMTR field (Amount in LC).

Actual cost: Use COEP table by providing OBJNR of both wbs element & Network activity(comes in AFVC table) and provide value type 4 & 11 with debit type 1 fetch the value from WKGBTR(Val/COArea Curr).

Commitment cost: Use COOI table by providing OBJNR of wbs element (PRPS)  & network activity(AFVC) and provide value type 21 & 22,fetch the value from WKGBTR.

Please revert if it doesnt work.

Regards

Seshagiri

[Former Member]

Hi Rabiee,

1. For Advances: BSIK table. Field name DMBTR.

2. Use PRPS table for converting WBS element name to object number. This will used as primary for COEP & COOI.

A. Actual cost for WBS Element: Table COEP (Enter Value type 4&11, debit type 1 and with WBS object number)

B. Commitment cost for WBS Element:

    A. Table COOI (Enter value type 21 & 22) Field WKGBTR

Also see this-

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

Regards,

Pranav