How to automatically extract and upload your custom code?


Panaya's solution requires an ABAP program installation on your SAP systems. This program performs the following high-level activities:

  • Extraction of custom developed ABAP code.
  • Identification and extraction of used transactions - finding out which transactions are used in your production system.
  • Extraction of defined systems in Solution Manager. 

Prerequisites

Before starting the installation process, make sure you have the following privileges:

  • Access to your SAP Development, QA and Production system
  • User with development permissions to -
    • Display, create and execute ABAP programs
    • Running jobs
      We recommend selecting a user with SAP_ALL or a similar strong BASIS user authorizations
  • A Panaya username and password
    • The defined user should be assigned with the Code Box - Upload ETL and API Execute premissions
    • The defined user should be assigned to at least one active Panaya project at all times
  • Internet Explorer browser versions 9 and above, Google Chrome 15 and above, or Firefox 16 and above
  • Protocol HTTPS is enabled on the relevant SAP server with Panaya Certificate | Learn more
  • .NET Framework, version 4.6.2 and above
  • Panaya servers support TLS 1.2 only - your SAP system must have the below minimum versions - 
    • CommonCryptoLib 8.4 patch 38
    • SAP kernel - 7.2 patch 88
  • If migrating to HANA, please follow these instructions before you continue with this process

   

Execute the following steps to complete the process:

Step A - Download the ABAP Code

  1. Click on the Settings button, the Configuration view will appear
  2. Before you continue, check that the relevant System appears on the top left corner of the screen
  3. Panaya analysis is based on custom objects extracted from your system. In most cases, there are differences between objects in the development system and the production system. Because we are extracting the custom developed objects only from one instance, please choose the system that best represents your needs for analysis.

    Should you require assistance defining from which system in your landscape you should extract the custom code, our support team will be happy to answer any questions you may have. Please contact our support team at: support@panaya.com
     
  4. Select your current ERP version
  5. Download the ABAP code

    If you are having trouble downloading the code, use the View option to copy and paste the code to your system.
    The extracted code  is dynamically updated for improvements and according to your system needs and project's progress. To avoid delays and for better results you are required to download a new version of the extractor code before every new extraction.

Step B - Create an Executable Program

This step explains how to install Panaya’s ABAP code extraction program on your SAP system. The ABAP extraction program reads the repository objects locally and extracts customer developed objects from the system it runs on. The program also uses RFC connections to extract data from the production and other systems.

  1. Create an executable program named ZPANAYA_EXTRACT_PROG_LIB and import or paste the ABAP code.
  2. Save the program in a change request, should you need to execute it on other systems like QA or Production.

To learn how to install an ABAP program, click here

Step C - Define User Authorizations for RFC connections

Before you continue to the next step, please identify a user for the RFC. 

It is critical that the RFC users have the required authorizations as described here.

Step D - Defining RFC Connections

In this step you will define 3 RFC connections for Production, Solution Manager and BW systems.

Follow these instructions on how to define RFC connections

Step E - Define the Extraction Program

  1. Login to the relevant SAP system
  2. Start transaction SE38
  3. Type the program name ZPANAYA_EXTRACT_PROG_LIB and press the execute button (F8)

  4. The system will automatically perform a version validation check. If the automatic validation cannot be performed, a validate extraction button will appear. In this case, run the validation to avoid extraction failure. 

  5. Under Execution mode, Full Extraction is selected by default.

    Selecting Usage Only will result in an extraction with usage information only.
    To learn how to extract usage statistics only, click here

    Select Background and enter the Background Directory path (e.g. \tmp) on the SAP application server.
  6. For Target system for Roles and Usage extraction, under RFC destination, type - PANAYA_PRD

  7. If Systems' Roles in the Landscape section is available, follow the steps as described here.

  8. For Solution Manager target system for Systems extraction, under RFC destination, type - PANAYA_SM

  9. For BW target system for BW extraction, under RFC destination, type - PANAYA_BW

  10. If migrating to HANA 2.0, under HANA SAP Code Inspector execution mode select between options A, B or C as described in this article.

Note
The program normally runs between 45 minutes to two hours, depending on the extent of custom objects developed in your system and usage information, although in some cases may take longer.

Step F - Set Automatic Custom Code Upload

In this step, you will define the direct upload settings - 

  1. Select the Automatic Upload tab (will only appear if Step E was completed successfully)
  2. Check the Upload extraction to Panaya option
  3. Select the Login via token option (Recommended, as the token never expires)
    Click here to learn how to generate a Panaya token

    You can also select to use the Login via password option (expires periodically)
  4. Under Login Credentials, fill in your Panaya username (used to login to Panaya) and the correspondent token/password

    Note
    The defined user should be assigned with the Code Box - Upload ETL and API Execute permission

    Is you system behind a Proxy?
    If so, you should also provide the Proxy details in the Proxy Configuration section. These details should be provided by your IT administrator - Proxy Host, Port, User and Password
  5. Click on Validate Compress Command to verify that the relevant SAP server is able to perform the compression process.
    If the process is not completed successfully, refer to our Compressions Utility Definition for Version ECC6.0 article
  6. Enter TCODE SMICM and then, from the top menu, select Services (Shift+F1) 
    Verify that -
    - Protocol HTTPS with Service Name/Port 443 appears under Active Services
    - Host Name is similar to your SAP Host Name

    If you do not see this information displayed, contact your SAP Administrator to enable HTTPS protocol support
  7. Click on Validate Login to Panaya to verify that the defined user is able to successfully login to the Panaya cloud via the relevant SAP server

All information uploaded to Panaya via the website is encrypted using SSL technology Read more.

Step G - Execute the Extraction Program

  1. Login to the relevant SAP system
  2. Start transaction SE38
  3. Type the program name ZPANAYA_EXTRACT_PROG_LIB and press the execute button (F8)
  4. Configure the program parameters according to your usual configuration
  5. Make sure the program is selected to run in background
  6. press CTRL+S in order to save a new run variant
  7. Name this variant API_AUTOMATION and provide a description (e.g. Panaya Running Variant)
  8. In the attribute grid locate the Field name P_FILEN (top row) and check the box Save field without values 
  9. Click Save

Step H - Generate a Scheduled Job

  1. Execute transaction SM36
  2. Fill in the job name - ZPANAYA_AUTOMATION_EXTRACT
  3. Click on the Step button
  4. Under ABAP Program section, select ZPANAYA_EXTRACT_PROG_LIB and variant API_AUTOMATION
  5. Save your work. The following step should appear.
  6. Click on the Back buttonand then Start Condition
  7. Click on the Date/Time Button and define the date and time for the Panaya extractor to be executed. 
    Check the Periodic Job option and then click on the Periodic values button.
  8. Select the Weekly option and Save
  9. Click Save again
  10. The following screen will appear

Good to Know!
By default, Automatic Custom Code Upload will update all active projects.
If you wish to update non-upgrade active projects only, you should manually upload your custom code, and select this option when uploading the ZIP file. 

For Release Dynamix - The new extraction will update non-upgrade active projects by default.