Skip to Content
avatar image
Former Member

Reagarding table name for payments

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 21, 2008 at 05:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hello,

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

      it is really a complicated report .

      all the best

      venga

  • Oct 21, 2008 at 05:11 AM

    Hi,

    Tables are;

    BKPF - Accounting Document Header

    BSIK - Accounting: Secondary Index for Vendors

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

    Add comment
    10|10000 characters needed characters exceeded