Skip to Content
1
Jul 03, 2007 at 07:36 PM

Vendor Information from MM or FI

44 Views

Hi BW experts,

We have a requirement to bring the Crystal reports from R/3 into BW.

The report needs to have: Vendor Number, PO Num, Invoice NUm, Invoice Date, Invoice Status, Activity Date, Posting Date,Invoice Verification Date, Invoice Amount, User Name, Business unit.

I want to know whether this comes from FI or from MM module. FI- AP does not have Invoice Date, Invoice Status, Invoice Verification Date. But i found the table: RBKP which has Invoice related info for the Vendors.

Terms Definition:

Username = Network or User ID of person who coded or approved an invoice. We need the report to be selectable on coded, approved or all

Business Unit = Department

Activity Date = Date service was provided or goods delivered

Posting Date = Accounting month invoice was posted in

Invoice Date = Document Date in SAP, date of actual invoice and not necessarily the activity date

Invoice Status = Approved in SAP Workflow by person who has proper authority, Parked is waiting to be coded, Requiring Approval is waiting on approval

Please help me in addressing this issue whether the data is coming from FI -AP module or from MM module.

Thanks in Advance

Regards,

Bala