SAP Master Data Governance 8.0 SP03 on HANA 1.0

CUSTOMER

2016-07

MASTER DATA GOVERNANCE, FINANCIALS DEMO EXPERIENCE: IMPORT G/L ACCOUNT WITH INITIAL LOAD TOOL

Background information You are a consultant for MDG-F, and you want to import G/L account extracted from an ECC system to the MDG-F hub. Note: In this demo, when you log on with user mdg100-01, please replace ## specified in any data with 01. If you log on with user mdg100-02, replace ## with 02, and so on. You can use any user from mdg100-01 to mdg100-30.

DEMO Scenario 1. Check Imported XML files in server folder The requirement is to check your .xml files in the server folder. [Step1] Check Initial Load Directory Transaction FILE: Your Logical file path: MDG_INITIAL_LOAD_##, get the physical path, and run transaction AL11 to check the .xml there.

2. Import G/L accounts The requirement is to carry out an initial load of the accounts from the file into the change request. Customizing settings – Data-relevant 1. MDGIMG-> Master Data Governance-> General Settings-> Data Transfer-> Define File Source and Archive Directories for Data Transfer. Check your directory MDG_INITIAL_LOAD_## defined in Customizing.

Customizing settings – Change Request relevant 2. 3. 4. 5.

Check Business Activity ACCL. Check the change request type ACCLP1. Check the workflow step assignment for change request type ACCLP1. Run transaction PPOM to verify that your user is assigned as workflow processor under MDG Financial Data Administrator.

[Task 1] Simulate Import of G/L Accounts Open the workcenter Financial Accounting Governance. Go to Data Exchange-> Data Transfer. Select Import Master Data, check and enter the following attributes before choosing Simulate Import: Object Type: General Ledger Account Master - ACCA Description: Import GL Account ## Edition: Select your edition 2013_Q3. Change Request Type: ACCLP1 Scheduling: Import Now Data Sources: Object Type: General Ledger Account Master Source Directory: MDG_INITIAL_LOAD_##

Choose the Simulate Import button. The system displays the Run Number.

2

[Task 2] Initial Load Monitoring After having triggered the simulation run, choose Display Monitoring. The system automatically displays the Run Number in the search criteria. Check the status of the run in the search result list. Refresh the search result list until the status turns green or red. It should be green. In case of an error, please check it together with you trainer. In case of a red status, select the Run Number to open the log and to check details. Display the details of the run, check which accounts were imported, and write down the Account number.

[Task 3] Import G/L Accounts When the status of the simulation run is green, trigger the Import. Choose Display Monitoring, select the Run Number link to open the log, and find your change request number at the end of the log messages.

3. Exercise 3 – Process and approve G/L accounts The requirement is to process your change request successfully until your data is activated, and to verify that your accounts were imported to MDG.

[Step1] Process Change Request Go to your change request inbox. Find and open your change request. In case of any error, correct it, and finalize the processing of your change request.

[Step2] Approve Change Request Refresh your change request inbox. Make sure the change request status is changed to Final Check to be performed. Open your change request, and approve it. [Step3] Find your imported GL Account in MDG-F Go to the Search G/L Account application, and verify that all your G/L Accounts were successfully imported.

3

Demo Script 1. Check Imported XML files in your folder The requirement is to check your .xml files in the server folder. [Task 1] Check Initial Load Directory and .xml Transaction FILE: Your Logical file path: MDG_INITIAL_LOAD_## Logical file path is defined Transaction FILE: Your Logical file path: MDG_INITIAL_LOAD_##

1.1

4

Make sure your file exists in your folder Transaction AL11: Find directory name DIR_INSTANCE, doubleclick the Directory, folder ‘load’, double-click, and double-click your subfolder GRP##. You should see 3 .xml files for Accounts ACCOUNTS_CC_554_Z ME800.xml, ACCOUNTS_COA_554_ ZME800.xml, ACCOUNTS_DESCR_55 4_ZME800.xml. You can double-click the file to check the content, but you don’t have to do this for this exercise.

5

2. Import G/L accounts The requirement is to carry out an initial load of the accounts from a file into a change request. Customizing settings – Data-relevant 1. MDGIMG-> Master Data Governance-> General Settings-> Data Transfer-> Define File Source and Archive Directories for Data Transfer. Check your directory MDG_INITIAL_LOAD_## defined in Customizing.

Customizing settings – Change Request-relevant 2. 3. 4. 5.

Check Business Activity ACCL. Check change request type ACCLP1. Check the workflow step assignment for change request type ACCLP1. Run transaction PPOM to verify that your user is assigned as workflow processor under MDG Financial Data Administrator.

1. Check Data Transfer Directory: MDGIMG->General Settings->Data Transfer->Define File Source and Archive Directories for Data Transfer. Make sure your logical file path MDG_INITIAL_LOAD_## is defined here.

2. Check Business Activity Transaction: MDGIMG Navigation Path: Master Data Governance->General Settings-> Process Modelling->Business Activities-> Create Business Activity Make sure that Business Activity ACCL is listed.

6

3. Check Change Request Type Transaction: MDGIMG Navigation Path: Master Data Governance->General Settings->Process Modelling->Change Request->Create Change Request Make sure that change request type ACCLP1 is listed.

Verify that Business Activity ACCL is assigned.

4. Check workflow step assignment Transaction: MDGIMG Navigation Path: Master Data Governance-> General Settings-> Process Modelling-> Workflow-> Other MDG Workflows-> Assign Processor to Change Request Step Number (Simple Workflow) Processor MDG Organization Unit for Financials is assigned for all steps of change request type ACCLP1.

5. Run transaction PPOM to make sure your user is assigned as workflow processor under position MDG Financial Data Administrator.

[Task 1] Simulate Import of G/L Accounts Workcenter: Financial Accounting Governance -> Data Exchange-> Data Transfer Choose Import Master Data. Check and enter the following attributes before choosing Simulate Import: Object Type: General Ledger Account Master - ACCA Description: Import GL Account ##

7

Edition: Select your edition 2013_Q3. Change Request Type: ACCLP1 Scheduling: Import Now Data Sources: Object Type: General Ledger Account Master Source Directory: MDG_INITIAL_LOAD_##

The system displays the Run Number when you choose the Import or Simulate Import button. Please write down your Run Number. Open Import Master Data application Navigation Path: Top-level menu entry Data Exchange->Data Transfer->Import Master Data

8

Import Settings Enter the following values: Object Type: General Ledger Account Master - ACCA Description: Select your edition 2013_Q3. Change Request Type: ACCLP1 Scheduling: Import Now

Data Sources Object Type: General Ledger Account Master Use F4 help to select Source Directory: MDG_INITIAL_LOAD_##

Simulate Import Choose the Simulate Import button.

9

[Task 2] Initial Load Monitoring After having triggered the simulation run, choose Display Monitoring. The system automatically displays the Run Number in the search criteria. Check the status of the run in the search result list. Refresh the search result list until the status turns green or red. It should be green. In case of an error, please check it together with you trainer. In case of a red status, select the Run Number to open the log and to check details. Display the details of the run, check which accounts were imported, and write down the Account number. Display Monitoring Choose the Display Monitoring button. If the status is not green or red, choose the Refresh button .

Open Details Select the row with your run number, and choose the Show Details button.

10

Show object list Select the number link next to Successful in the Objects Processed section.

[Task 3] Import G/L Accounts If the status of simulation run is green, trigger the Import run. Choose Display Monitoring, select the Run Number link to open the log, and find your change request number in the log list.

3. Request and approve G/L accounts The requirement is to process your change requests successfully until they are activated, and to verify that your accounts were imported to MDG. [Task 1] Process Change Request Go to your change request inbox and find and open your change request. In case of an error, correct it, and finalize the processing of your change request. Enter Change Request Inbox Navigation Path: top-level menu entry Change Requests. If your change request is not displayed in the list, use the Refresh link at the bottom of the table.

Open Change Request Select the Subject link or select it first and choose the Process Change Request button. The system opens a pop-up window.

11

Check and Finalize Processing of Change Request Choose the Check button. If an error occurs, open the Account to correct it there. If there are no errors, select the Finalize Processing button to finalize the processing

[Task 3]Approve Change Request Refresh your change request inbox. Make sure the status of your change request is changed to Final Check to Be Performed. Open your change request and approve it. Go to Change Request Inbox Navigation Path: top-level menu entry Change Requests. If your change request is displayed in the list, use the Refresh link at the bottom of the table.

12

Open Change Request Select the Subject link or select it first and choose the Process Change Request button. The system opens a pop-up window.

Approve Change Request Select the Approve button.

[Task 3] Find your imported GL Account in MDG-F Go to the Search G/L Account application, and make sure all your G/L Accounts have been imported successfully.

13

Open Search G/L Account application Navigation Path: top-level menu entry Change Requests> Search-> G/L Account Centrally

Search accounts Enter your account number as a search criterion for Account, and execute the search. Your imported account is displayed in the result list.

14

Import Trigger the real import by choosing the Import button.

Display Monitoring Choose the Display Monitoring button. If the status is not green or red, choose the Refresh button .

15

Open Log and find change request number Select the link in the Run Number column, and scroll down to the end of the logs. There you will find the change request that you submitted successfully.

16

www.sap.com/contactsap

© 2016 SAP SE or an SAP affiliate company. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company. The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. National product specifications may vary. These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. All other product and service names mentioned are the trademarks of their respective companies. Please see

www.sap.com/corporate-en/legal/copyright/index.epx for additional trademark information and notices.