Good Receipt Number and Invoice Verification Number in MM?

[former_member367551]

Dear forumers,

Which fields do I refer to in the MM module (from the ABAP Dictionary database tables) for "Good Receipt Number" and "Invoice Verification Number"?

Please help. I've been searching out these fields for so long already now, but I still can't make sense of things.

My apologies for such a newbie question. Appreciate any inputs at all.

[GauthamV]

hi,

use these fields.

MBLNR

BELNR.

[former_member367551]

Gautham,

How does Good Receipt Number tele with BELNR (Number of Material Document)? I don't quite understand it here. Please elaborate, if possible.

And, what about the Invoice Verification Number? How do I get this?

[GauthamV]

hi,

whenever we r creating a goods reciept using MIgo transaction the material document is generated.

In the same way after creating invoice using MIRO transaction another document is generated internally.

for MIGO : mkpf,mseg

for MIRO : rbkp,rseg

for FB01 : bkpf,bseg tables.

[Former Member]

hi,

iam giving u the list of MM tables..

http://www.sap-img.com/general/sap-r3-tables.htm

click on MM tabl;es

[former_member367551]

Deepthi,

Thanks for sending me the link. I have a list of the MM tables earlier too, but I still can't seem to find the proper fields for Good Receipt Number and Invoice Verification Number.

[Former Member]

hi,

XUNPL & WESBS from EKBE table

XABLN from MKPF table

XWSBR & WEMPF from MSEG table

Edited by: deepthi dandibhotla on Sep 22, 2008 1:10 PM

[Former Member]

hi,

when goods receipt is done a material document is created which affects table mkpf and mseg, field is MBLNR.

coming to invoice verification the tables affectes are RSEG and field is BELNR.

Rgds.,

subash

[Former Member]

EINE check dis table for invoice verification number..

field :webre for invoice verification number.

AFFW check dis table for goods receipt number

wempf is the field for goods receipt number.

hope it helps.

Edited by: deepika reddy on Sep 22, 2008 1:59 PM

[Former Member]

Hi,

1. Through MSEG table get the GR number, PO Number & Material

Number.

2. That PO number, material number & EWTP = 'Q' pass to EKBE.

3. Here we get the BELNR ==> Invoice Verification Number.

Thanks & Regards,

Durai.V

[Former Member]

Hi,

For GRN,its MBLNR found in MKPF and MSEG.

For Invoice Verification,its BELNR found in BKPF.

Regards,

Jeet K Bhatt

[former_member367551]

Dear forumers,

Thanks for all your inputs. Appreciate it a lot.

I've made some confirmations and found that the Goods Receipt Number is MSEG-MBLNR (with condition MSEG-BWART = '101') and the Invoice Verification Number is EKBE-BELNR (with condition EKBE-VGABE = '2').