invoice and Purchase Order info from r/3

[Former Member]

Hi All,

I have a new requirement. I need to extract the following information from r/3. So can anyone please let me know the base tables in r/3 where I can find the following fields.

The fields that I need is:

1. Purchase Order number & PO Line Item number

2. Goods receipt number & Goods Receipt Date

3. Invoice number (and item number if any) & INVOICE DATE

Any help is greatly appreciated.

Points are assured.

Thanks in advance.

[Former Member · Accepted solution]

You need work with follwing BC DSs...

1. Purchase Order number & PO Line Item number: (2LIS_02_ITM)

2. Goods receipt number & Goods Receipt Date (2LIS_03_BF)

3. Invoice number (and item number if any) & INVOICE DATE (You need to create custom DS on EKBE Table as we don't have any standard DS.)

Nagesh Ganisetti.

*assign points if it helps.

[Former Member · Accepted solution]

Hi Nagesh,

Thanks for the reply.

I found the PO and PO Line Item number in 2LIS_02_ITM but how do I buid the relationship with invoice info and goods receipt info?

PO info <--> invoice info <---> Goods recipt info.

And by the way I could not find the Goods receipt number & Goods Receipt Date in 2LIS_03_BF. Can you tell me which fields in that data source corresponds to the goods receipt number and goods receipt date.

[Former Member · Accepted solution]

BF will have PO Document Numebr and Item in reference fields.

EKBE table has PO information i.e. PO Number and Item.

You need to take PO and Item from BF, with whihc you can integrate PO and Item.

You need to get PO and Item from EKBE table, which you can integrate with PO.

Take a look 2 DSs and 1 table and Let us know if you have any Questions.

Nagesh Ganisetti.

• assign points if it helps.

[justin_molenaur2 · Accepted solution]

So is the Invoice information found in EKBE or VBRK/VBRP?

I am thinking that VBRP with a SD document type of M should do it, right?

Justin

[Former Member · Accepted solution]

We are discussing About Vendor invoices, not Customer Invoices.

Customer Invoices stored in VBRK and VBRP tables only as you suggested.

Nagesh Ganisetti.

[justin_molenaur2 · Accepted solution]

Thanks for the clarification.

[Former Member · Accepted solution]

Hi All,

Thanks very much for the replies and your suggestions.

I think I got all the fields I need in EKBE table.

1. PO number (EBELN)

2. PO line number (EBELP)

3. Goods receipt number (BELNR- material doc number when VGABE-transaction/eventtype is 1) and Line item number (BUZEI)

4. Goods receipt date (Entered on - CPUDT)

5. Invoice number (BELNR- material doc number when VGABE-transaction/eventtype is 2) and Line item number (BUZEI)

6. Invoice date (Entered on - CPUDT)

But I manager has changed the requirement and now he wants the payment date (the clearing date(AUGDT) in BSEG table) also.

So problem is I am unable to relate the above information with this clearing date.

So Can you please help me here.

Thanks in advance...

[Former Member · Accepted solution]

Any ideas or suggestions??

[Former Member · Accepted solution]

I think that you must done all this questions to the functional analyst responsable of the module....they must know tha data and where is stored...is not responsibility of a BW guy to know every field of every table for the queries that the users want....

Regards

[Former Member · Accepted solution]

As you said, earlier... you can work directly wih EKBE Tables which will give PO Informatio, GR Information and IR Information.

You can attach Clearing Document Date as well. You need to lot of work for that.

IN EKBE tables, we have Transaction Type field 1: GR 2: IR.

1st enahnce Your DS on EKBE for Clearing Date.

If transaction Type eq 2, attach Clearing Document Date from BSEG to your DS.

You are good go. In the BI, split the Data into GR and IR Based on Transaction type.

Nagesh Ganisetti.

• assign points if it helps.

[Former Member · Accepted solution]

Nagesh,

Thanks for the suggestion.

In order to connect this invoice information to the clearing date on bseg table, we dont have the invoice number/item number in the BSEG with which I can connect to the EKBE table of Material doc number (transaction/event type is 2).

[Former Member · Accepted solution]

if the Transaction type '2'... Material Document = Invoice Document.Item = Invoice Item.

Assign points if it helps.

[Former Member]

Hi,

Please refer the below link,

http://www.erpgenie.com/abap/tables_mm.htm

http://www.erpgenie.com/abap/tables_sd.htm

Thanks, ABY

[Former Member]

Hi,

1. Purchase Order Number : EKPO-EBELN

Line Item : EKPO-EBELP

2. Goods Receipt Number : MSEG-MBLNR

Goods Receipt Date : MKPF-BUDAT

3. Invoice number : VBRK-VBELN

Invoice Date : VBRK-FKDAT

Line Item : VBRP-POSNR

Regards,

Morpheus.

[Former Member]

Hi Morpheus.

Thanks for the table and field names.

I actually need to build the relationship between PO info, Goods recipt info and Invoice Info....

Example: for a particular PO this is the goods recipt number and date, and this is the invoice number and invoice date....

So can you please explain me how to make connection (common fields) between all the tables you mentioned?

Please let me know.