08-16-2016 7:26 AM
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
08-16-2016 7:42 AM
Hi Dushan,
Check this relation
BSEG-HKONT = PAYR-UBHKT.
Regards,
E.Ananthachari.
08-16-2016 8:21 AM
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.
08-16-2016 7: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.
08-16-2016 8: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