Drilldown Reporting

This chapter provides information about the Drilldown reporting functionality provided by Drilldown.

Prerequisites

Make sure that the following prerequisite tasks are complete:

1. SAP Fiori launchpad is installed.
2. In SAP GUI for Windows, perform the following tasks using the transaction code PFCG:
   • /MAGSW/SCD_ADMIN_ROLE: Assign this role to the administrators who need to configure source systems through Fiori Launchpad.
   • /MAGSW/SCD_ROLE: Assign this role to the users who require access to the Manage Journal Entries app (SCD) in Fiori Launchpad.
3. The Manage Journal Entries app (SCD) provided by SAP is configured in Fiori Launchpad.
4. Data load for Transaction and Drilldown are complete.
5. The source systems are configured through the Manage SCD - Sources app as follows:
   1. Log on to SAP Fiori launchpad with your SAP GUI user credentials.
   2. On the Home page, select insightsoftware Configuration > Manage SCD Sources. The SCD Resource > Standard page appears.
   3. Select Create. The SCD Resource > General Information page appears.
   4. Provide the source system details as follows:
      • In the SRC System Id field, enter the source system identifier that is same as the value in the RDSOURCESYSTEM column of the source-specific staging table for Drilldown.
      • In the Logical System field, enter the logical system name that you have defined for your source system in SAP S/4HANA.
      • In the System Type field, depending on your source system, type one of the following source system type values:
        • Oracle E-Business Suite:002
        • JD Edwards EnterpriseOne:001
        • Oracle PeopleSoft:003
        • Microsoft Dynamics AX:004
        • Microsoft Dynamics NAV:005
        • Microsoft Dynamics SL:006
        • Microsoft Dynamics GP:007
        • Epicor iScala:013
        • Infor CloudSuite Industrial (SyteLine):012
        • Infor Baan:014
        • Workday:015
        • QAD:011
        • NetSuite:010
        • Deltek Costpoint:009
        • 1C:Enterprise:016
        • Flat file:008
      • Optionally, enter the description, short description, and long description of the source system in the respective fields.
   5. Select Save. The SCD Resource > Standard page appears with the list of source systems that are configured. A sample screenshot is as follows.
      

Note: To ensure that the Drilldown reporting works accurately for the UniversalConnector (UC)/Flat file source, make the following important changes for the AP_BKPF_VIEW, AR_BKPF_VIEW, and GL_BKPF_VIEW views:

• Customize the SENDER_COMP column from the BKTXT column (for example, 204:45678) in the S4_BKPF table.
• Make sure that the DOC_NUMBER column corresponds to XBLNR in the S4_BKPF table.

Order-to-Cash Drilldown Reporting

After loading the data into SAP S/4HANA, you can use the SAP Fiori app Manage Journal Entries (SCD) to access the sales order details of your transaction data in your source instance.

For example, for an Accounts Receivable transaction, you can drill down by the invoice number or sales order number to view the details of the corresponding invoice or sales order in your source system.

To access sales order details through Drilldown report

1. Log on to SAP Fiori launchpad with your SAP GUI user credentials.
2. On the Home page, select insightsoftware Applications > Manage Journal Entries (SCD). The Manage Journal Entries page appears.
3. Specify the required filters, and select Go. The journal entries are displayed.
4. Select the journal entry for which you want to see the details. A shortcut menu with links appears.
5. Select Journal Entry Data. The Journal Entry Data page displays the invoice and sales order information for the selected journal entry.
   

Procure-to-Pay Drilldown Reporting

You can drill down by the journal entries in SAP S/4HANA to view the details of the corresponding invoices or purchase orders in your source instance.

To access the purchase order details through Drilldown report

1. Log on to SAP Fiori launchpad with your SAP GUI user credentials.
2. On the Home page, select insightsoftware Applications > Manage Journal Entries (SCD). The Manage Journal Entries page appears.
3. Specify the required filters, and select Go. The journal entries are displayed.
4. Select the journal entry for which you want to see the details. A shortcut menu with links appears.
5. Select Journal Entry Data. The Journal Entry Data page displays the invoice, purchase order, and goods receipt details for the selected journal entry.
   

General Ledger Drilldown Reporting

You can drill down by the journal entries in SAP S/4HANA to view the corresponding general ledger details of your transaction data in your source instance.

To access general ledger details through Drilldown report

1. Log on to SAP Fiori launchpad with your SAP GUI user credentials.
2. On the Home page, select insightsoftware Applications > Manage Journal Entries (SCD). The Manage Journal Entries page appears.
3. Specify the required filters, and select Go. The journal entries are displayed.
4. Select the journal entry for which you want to see the details. A shortcut menu with links appears.
5. Select Journal Entry Data. The Journal Entry Data page displays the general ledger information, such as general ledger account, ledger type, business unit, and document type, for the selected journal entry.