cancel
Showing results for 
Search instead for 
Did you mean: 

Invoice Verification Tables

Former Member
0 Kudos

Hi Friends,

we have a requirement in that we need to know the corresponding tables for invoice verification, i have gone through with the following tables BKPF,BSEG,RSEG,MSEG AND MKPF, i am getting confusion while selecting the corresponding table for the following Po No, Invoice Number, Invoice Date, Invoice Amount.

Please update me which one is the correct table.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Yes Thanks i have got expected Result

Thanks to every one

Former Member
0 Kudos

Hi,

RBKP table and fetch BELNR data then RBKP pass the BELNR and fetch

BLDAT/BUDAT by passing LIFNR fetch vendor code pass the vendor code LFA1 fetch

TIN NO in VAT_TIN

Passing BELNR document no fetch EBELN Purchasing Document Number

Go to MAKT fetch material description MAKTX

RSEG-MATNR, fetch MENGE Quantity

RSEGu2013MATNR, fetch BSTME Unit of Measure Unit

Go to RBKP and fetch the BELNR Document Number and for that BELNR get LFBNR

Pass this LFBNR to MKPF and GET BUDAT Material Received date.

Go to EKPO table fetch NETWR Net valu

Thanks,

Raviteja

former_member191564
Active Contributor
0 Kudos

Dear expert

p.o no:EKKO

invoice no, inv amt (table-field BSIK-BELNR, BSIK-DMBTR)

Regards

Ajeesh.s

Former Member
0 Kudos

Hi Subhu,

Following are the tables related to invoice verification:

For invoice header RBKP

for line item RSEG

and in FI

for header BKPF

for line item BSEG

Regards,

Jams

narasimhulu_konnipati
Active Contributor
0 Kudos

Hi Subbu,

Invoice verification tables

MIRO - RSEG and RKPF

FI - BSEG and BKPF

Thanks