To get the Invoice and document no field

[Former Member]

Hi gurus

I'm taking vbeln from vbrk to show the document no. But it contains both Document no and Invoice no . records. Which table should I refer to get these field records segergated.

Plz Reply immidiately

Regards

Shubhra

[Former Member]

Hi,

If you are taking records from VBRK, both document no and Invoice No are one and the same. There is no difference between the 2.

Only thing you can diffrentiate between diff types of invoices based on billing type field (FKART).

Regards,

JLN

[Former Member]

Hi

the answer given by is not helping me.Plz reply in elaborate process.

Regards

Shubhra

[Former Member]

Hi all

Will anybody will help me in getting the table name which contains billing document no and accounting document no.

With regards

Shubhra

[Former Member]

Hi,

For Billing Document no: VBRK (Header Table) & VBRP (Item Table).

For Accounting Document No: BKPF (Header table)

BSID (Customer Open Items Table)

BSAD (Customer Closed Items table)

BSIK (Vendor Open Items Table)

BSAD (Vendor Closed Items Table).

Regards,

JLN

[Former Member]

hi

check out this tables

VBRP Billing Document: Item Data

VBRK Billing Document: Header Data

VBLNR - Document Number of the Payment Document in the table <b> REGUH </b>

VBLNR - Document Number of the Payment Document in the table <b>REGUP </b>

Reward points if it is helpful.

Thanks&Regards

Lokesh