Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

4 REPLIES 4

former_member194965
Active Participant
0 Kudos

Hi Dushan,

Check this relation


BSEG-HKONT = PAYR-UBHKT.


PAYR-CHECT(Cheque number)

Regards,

E.Ananthachari.

0 Kudos

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.

sanjeev_mishra_15aug
Active Participant
0 Kudos

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.

raymond_giuseppi
Active Contributor
0 Kudos

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