Reagarding table name for payments

[Former Member]

Hi All,

iam new to MM,

please tell me the table name for payments,

information about payments,

and is there any standard bapi for getting all payments for purchase orders....

Thank you.

Sumalatha

[Former Member · Accepted solution]

hi,

Briefly ...u cannot get the status of payment in either RBKP ( invoice document ) or BKPF( account document ).

We can get the payment status ( of accounting document ),

simply if the value of

RBKP -XBLNR exists in BSAK-XBLNR , then it is paid item.

RBKP -XBLNR exists in BSIK-XBLNR , then it is due item.

u can use the common field in both tables is XBLNR to develope report .

Regards

vengaladasu

Edited by: vengaladasu on Oct 21, 2008 11:27 AM

[Former Member · Accepted solution]

Thank you vengaladasu,

do you know about standard bapi or function module to get payments.

[Former Member · Accepted solution]

hi,

no,

it is really surprising why sap doesnot provide such reports .

u need to develop a Z-report as per ur requirement .

regards

venga

[Former Member · Accepted solution]

Ok i will generate z-report for that ,

thank you.

[Former Member · Accepted solution]

hello,

u need to consider partial payments ,cancellation, advance payments ,subsequent credit and debit .

it is really a complicated report .

all the best

venga

[pankaj_singh9]

Hi,

Tables are;

BKPF - Accounting Document Header

BSIK - Accounting: Secondary Index for Vendors

BSAK - Accounting: Secondary Index for Vendors (Cleared Items)