How to View Vendor wise Payment against WBS element

[former_member591922]

Hi,

Project requirement is to ....to view Vendor wise payment against WBS element....

i have checked standard PS reports like CJIA,S_ALR_********.....,Transaction from FI FBL1n but nothing is working...

After exploring from forums somwhere suggested to go Z Developement or activating Cash management/Fund Management.

Appreciate if somebody help me out in same...as client want to see even..payment given in installaments ...against WBS..?

[Former Member]

Karan

Are the vendor wise payments made against a PO / PO line item or are they downpayments.

For first, i.e. payments against PO/POline item, use transaction ME2K/ ME2J.

or else GL line item reports#

Saurabh

[Former Member]

Hi,

Tode: FB1K

In account : input vendor code

company code:0100

in additional selection click on radio button: (.) None and input clearing date and period.Then press

enter key and will see the details

the clear document wise detail.

Remaining detail report already shared by expert above.

Regards

Sanjeet Kumar

[Former Member]

I will like to suggest an alternative solution without activating Project Cash Management,Please try to expolre functionality invoice plan and used miles stones to address the completion inorder to derive the payment plan into project system.

Regards

Shahzad Khan

[former_member591922]

HI Shahzad,

Could you elaborate the same,how to do the same.

Regards

Karan

[Former Member]

Hi Karan :

Appreciate for your query ,I will provide you brief details and you can discuss with your MM consultant for the needful implementation.

• Public Sector Management-They just need to create Funds Area by Finance people no need to implement the whole module this .Even you can do it's very simple Enterprise Structure --Defination--Financial Accounting--FM Area

It's vital in order for the activation of invoice plan in project system.

• Invoice Plan can be made selecting an Network activity for the installment or percentage based however you are expecting the payment to be made --Details in project System.

• Logisitic people have to assign the purchase order with Invoice plan.
• Invoicing they have to select the invoices .
• Miles stones can be updated in project system to record Actual.

This activity will help you to built the interface on Project System and MM.

Regards

Shahzad Khan

[Former Member]

Hello,

I think you can use these tables BSIK, BSAK and BSEG.

Regards.

[Former Member]

Hi Karan:

Its must for you to active project cash management ,let me know if you require any assistance in the regard.You need to use the special field functionality and bring WBS element on FBl1n report ,then their is functional modules available which bring WBS element on vendor wise.Hope this clue will serve your ambiguity.

Regards

Shahzad

[former_member591922]

Hi Sanjeev,

Thanks for your reply....but PAYR table is not fulfilling the req criteria....

Could you please tell me the tables which can show a link between Vendor and WBS.

As client want the vendor payment done by Finance department partial or complete.

Regards

Karan

[sanjeevc]

BSEG table is fulfilling your requirement.

Regards,

Sanjeev

[Former Member]

Hi,

Try to link the fields from the table EKKN,EKKO and PRPS to get data Vendor PO and WBS element details.

Regards,

BK

[sanjeevc]

if your issue has been resolve then please mark as closed this thread.

Regards,

Sanjeev

[former_member591922]

In current project scenario..Finance team is not ready to activate Fund management..due to burden

it will be appreciated if anybody would tell what are tables i should consider ..if we are paying vendors on installment basis

[sanjeevc]

Check PAYR table.

Regards,

Sanjeev

[Former Member]

Hi Karan

you have to update the project cash  management in t code CJFN-transfer payment for project cash management

then you will be able to see vendor and wbs wise payment report in CJIA

please check and revert back

[Former Member]

Hi Karan,

Check below report if caters your requirement else go for development.

S_ALR_87013573 - Receipts/Expenditure for all fiscal years

For PS Cash management, you can also refer SAP notes mentioned in below link

http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=42697225&bc=true

Regards

Tushar

[former_member591922]

Hi,

I have tried both transaction but they are not giving vendor wise pyment report.

FBL1n is not showing any result when passing WBS element to it.Kindly suggest

Scanario used

suppose if vendor payment is Rs 1000and  for the first installment rs 500 is given then report

should display pa to be given.yment done and balance payment

[sanjeevc]

Hi Karan,

check report for multiple vendor balance S_ALR_87012082 and  FK10N is for single vendor balance report.

Regards,

Sanjeev

[Former Member]

Hi,

Try FBL1N for vendor payment. You can discuss with your FI team on this topics.

Thanks,

Sudhakar

[former_member186385]

Hi,

check the report, if it helps

S_ALR_87013531 -Costs/Revenues/Expenditures/Receipts

regards,

santosh