Work Instruction
Functional Area: Accounts Payable / Compare Vendor Master Data
PurposeDirect Invoice Entry - Vendor Master Data Maintenance
Use this procedure to run a report that shows only Purchasing vendors or AP vendors.
Trigger
Perform this procedure when a vendor master data record requires validation of the Accounting versus Purchasing view data.
Prerequisites
Vendor master record in SAP.
Menu Path
Use the following menu path to begin this transaction:
  • Select AccountingFinancial AccountingAccounts PayableMaster RecordsComparePurchasing – accounting to go to the Purchasing Accounting screen.
Transaction Code
F.48
Business Process Information
Vendor master records can be created using one of 2 methods: created in Financial Accounting (transaction FK01) or created in Purchasing (transaction XK01). All fields on the vendor master record are organized in master data ‘views’. There are 3 possible vendor master data views: General View, Company Code View (sometimes called the Accounting view) and Purchasing View. The views that are available for data input are dependent on the transaction used to enter the data. Transaction FK01 allows for data entry into the General and Company Code views only. Transaction XK01 allows for data entry into all views. Because a vendor master record can be made in different views (i.e. a record may have a General and Purchasing view but no Accounting or a record may have a General and Accounting view but no Purchasing), this report was designed to highlight where these exceptions have occurred.
The master data design adopted at the University allows for a degree of discrepancy. There are some vendors (called AP vendors) that will be created in accounting only using transaction FK01. Accordingly, these vendors will not have a Purchasing view. Additionally, there are some vendors (called Purchasing vendors) that will be created in Purchasing using transaction XK01. Accordingly, these vendors will have all 3 views. It is important to note 2 points:
  • The field status requirement configuration completed by the AP team ensures that all vendor master records have an Accounting view.
  • There will be some overlap between the 2 business areas (AP and Purchasing) and some vendors will have 2 records in the system.
Although this report will not be routinely used by the Vendor Master Data Custodian, it can be used to view Purchasing and AP vendors in a list by view.
Helpful Hints
  • The R/O/C column in the field description tables below defines whether the field is required (R), optional (O), or conditional (C).
  • On certain screens you may have to scroll to view some data entry fields.

Work Instruction
Functional Area: Accounts Payable / Compare Vendor Master Data
Procedure
1. / Start the transaction using the menu path or transaction code.
Vendor Master Data Comparison

2. / As required, complete/review the following fields:
Field / R/O/C / Description
Vendor number / Optional / Number assigned by SAP when a vendor's master record is created
Example:
600000
to / Optional / End value when specifying a range
Example:
600001
Account group / Optional / Summary of attributes that control the creation and maintenance of master records; The account group determines which data is required for the master records and the number range assigned to those master records; You must assign each master record to an account group
Example:
ZLIB
to / Optional / End value when specifying a range
Example:
ZLRE
Creation date / Optional / Date input session was created
Example:
01/25/2005
to / Optional / End value when specifying a range
Example:
01/26/2005
Additional heading / Optional / User defined custom header that will be presented on the report
Example:
Report for Monday and Tuesday
Company code / Optional / Organizational unit within Financial Accounting
Example:
UC
to / Optional / End value when specifying a range
Example:
UC
Purchasing organization / Optional / Code identifying the purchasing subdivision within the company
Example:
UC
to / Optional / End value when specifying a range
Example:
UC
3. / Perform one of the following:
If You Want To See Only / Then
Purchasing vendors / Select to the right of Not created in Fin. Accounting.
Accounting vendors / Select to the right of Not created in Purchasing.
4. / Click .
Vendor Master Data Comparison (2)

5. / Review the displayed information.
6. / Click until you return to the SAP Easy Access screen.
7. / You have completed this transaction.
10/2/2017
Ver: / 09_AP_F48_Comp Ven Mstr Data_0_VenMstrDataMaint.udc
© University of Cincinnati / 1/6
Work Instruction
Functional Area: Accounts Payable / Compare Vendor Master Data
Result
You have run a report that shows only Purchasing vendors or AP vendors.
Comments
None
10/2/2017
Ver: / 09_AP_F48_Comp Ven Mstr Data_0_VenMstrDataMaint.udc
© University of Cincinnati / 1/6