cancel
Showing results for 
Search instead for 
Did you mean: 

Invoice number in BKPF, BSEG, BSIk, BSAK, BSID and BSAK tables?

Former Member
0 Kudos

Hello FI Experts,

What is the R/3 field in tables BKPF, BSEG, BSIk, BSAK, BSID and BSAK which gives the details of the Invoice number against which a GL account is created?

Please help me, it is urgent

Sri

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

The Reference field in BSAK does this for me.

Regards,

Positive Parrot

Former Member
0 Kudos

If you have a customer invoice it is BELNR normally so this would be in BSID & BSAD

For a vendor invoice, normally it would be the header reference, and it that case it would be in BKPF, BSIS, BSAS, BSIK & BSAK.

Former Member
0 Kudos

Hi,

Thank you,

Can you please name the R/3 field in these tables which gives the details of the Invoice number? I am not able to find that field, but strongly believe that there should be some field containing the Invoice number..

BELNR is the GL account number, I need invoice number

For example, I created a vendor invoice (tcode: miro) 5105600204 and I can see in the follow up documents that a GL account 420025(belnr) is created for it in BKPF, BSEG and BSIK tables. Now I want to know the invoice number (5105600204) for this GL account 420025 in these tables, but unfortunately I am not able to find any r/3 in these tables containing the value of invoice number.

Please name the R/3 fiels in these tables which gives the invoice number

Sri

Former Member
0 Kudos

It should be in field XBLNR1 and you should be able to see the reference field in all the tables.

Assign points if helpful

Former Member
0 Kudos

Hi,

I am sorry, XBLNR has the value of PO number, not Invoice number.

Sri

Former Member
0 Kudos

To be more clear, I have to show all the vendor Invoice numbers without a PO in my report. how can I achieve this?

Thanks for any help, i will surely award points, please help me it is urgent

Former Member
0 Kudos

try REBZG and REBZZ fields this may contain invoice number

Assign points if helpful

Former Member
0 Kudos

Hi Sunil,

Thanks for ur time, but these two fields are not getting populated.

Any more inputs please

Sri

Former Member
0 Kudos

Is the Accounting document number Belnr different from the number giventhere.

Assign points if helpful

Former Member
0 Kudos

what Invoice number customer or vendor

IF it a customer invoice- It should be in BSID

if it is a vendor invoice it should be in BSIK

Depending upon what field you are using.

It should also be in the table BKPF.

Former Member
0 Kudos

Hi Sunil,

Thank you for the reply.

I need customer Invoice number (r/3 field) in BSID and BSAK, vendor Invoice number(r/3 field) in BSAK and BSIK and Both invoice numbers(r/3 field) in BKPF and BSEG.

Sri

Former Member
0 Kudos

You will fin customer in BSID and BSAk and Vendor in BSAK and BSIK and all of them in BKPF. YOu wount find it in BSEG because it is a line item table.

AsSIgn points if helpful