Skip to Content
author's profile photo Former Member
Former Member

How to get the cheque no from G/L Account Number.

I want to get the cheque no using G/L Account Number. I am using BSIS and BSAS table to get the BELNR(Accounting Document Number).
I don't know how to build a relationship to get the cheque no. Please help

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Aug 16, 2016 at 06:42 AM

    Hi Dushan,

    Check this relation


    BSEG-HKONT = PAYR-UBHKT.


    PAYR-CHECT(Cheque number)

    Regards,

    E.Ananthachari.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thankz for the reply, But I want to get the BELNR(Doc nos) from the G/L Account Number. Then get the purchase order no according to that BELNR nos. using that PO no i want to make a relationship to get the cheque no.

  • Posted on Aug 16, 2016 at 06:44 AM

    Hi Dushan,

    Generally this information can be found in the table PAYR,

    In case you cant find your solution you can also try for the table RFITEMGL_NO_ITEM.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 16, 2016 at 07:52 AM

    Read PAYR field CHECT with keys zbukr = bkpf-bukrs, vblnr = bkpf-belnr and gjahr = bkpf-gjahr

    (Or analyze FM GET_INVOICE_DOCUMENT_NUMBERS which provides list of docs related to a cheque)

    Regards,

    Raymond

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.