Category: SAP

  • Phases of SAP on Azure Projects

    Preface – This post is part of the SAP on Azure series.

    Introduction

    Understanding the phases of SAP projects on Azure is a very important aspect for the successful completion of SAP on Azure projects. In this article, we will discuss all the phases in detail and also share official Microsoft Azure documentation.

    Phases of SAP on Azure Projects

    Phases of SAP on Azure Projects is designed by Microsoft in the form of checklist for the customers who are already using SAP NetWeaver. This checklist helps a client to identify small issues and hence prevents bigger future issues. These phases do not include any tasks that are independent of Azure, e.g. SAP GUI related changes.

    Following are the six phases of a SAP on Azure:

    1. Project preparation and planning phase
    2. Pilot phase (strongly recommended)
    3. Non-production phase
    4. Production preparation phase
    5. Go-live phase
    6. Post production phase

    Project preparation and planning phase

    This phase is where you plan your SAP migration or new SAP deployment on Azure. During this phase, we typically create High-level design and Technical design documents to guide us through the project. They cover:

    High-level design document

    • (If migrating): inventory of current SAP landscape including components, applications, network, security, compute, operating system, database, & HA/DR
    • Build the responsibility assignment matrix (RACI)
    • A high-level solution architecture
    • Automation & operation plans, procedures, & processes

    Technical design document

    • A diagram for the solution & architecture including networking, high availability & DR Sizing for computing, memory, storage, & networking
    • Operating System, Database, kernel, & SAP support pack versions
    • Interfaces inventory including SAP & non-SAP

    You can read the checklist here.

    Pilot phase (strongly recommended)

    This is the pilot/proof of concept (POC) phase. This phase is for testing the designs & approaches from the planning phase. In this phase. it is also common to include a full build of HA/DR, security, & scalability testing. Microsoft strongly recommends having this phase as a part of the SAP on Azure journey. You can read the checklist here.

    Non-production phase

    In this phase, we deploy non-production SAP systems on Azure. This deployment should include development systems, unit testing systems, and business regression testing systems. You can read the checklist here.

    Production preparation phase

    In this phase, we deploy production SAP systems on Azure. We incorporate lessons learned & experience from the non-production phase. If migrating we upgrade SAP systems & prepare for data transfer between our current SAP instance location & Azure. You can read the checklist here.

    Go-live phase

    In this phase, we utilize the playbooks from our earlier phases. We execute the steps that have been tested & practised in earlier phases. In this phase, we freeze all changes in processes and configurations. You can read the checklist here.

    Post production phase

    The phase is post production and includes monitoring the deployment, operating & administering the systems. You can read the checklist here.

     

    References

    https://docs.microsoft.com/en-us/azure/virtual-machines/workloads/sap/sap-deployment-checklist

  • Types of SAP on Azure Projects

    Preface – This post is part of the SAP on Azure series.

    Introduction

    SAP and Microsoft have a 25 years of partnership. Microsoft Azure provides end to end support for both SAP on Premise and SAP HANA Cloud. In this article we will try to explore the types of SAP on Azure Projects.

    SAP on Azure Projects

    SAP Projects on Azure are divided into two types, i.e.:

    • Migration
    • Greenfield

    These two types of projects are for a client who is either existing old client or a new client of SAP. Based upon their need they can choose the project. By choosing project, it doesn’t mean that the client need to go and order these types, but it is there to identify the type of infrastructure and services related to the type of SAP project.

    Types of SAP on Azure Projects

    Migration

    This is the most common type of SAP on Azure Projects. This is typically migrating an on-premise instance of SAP (typically ECC) to SAP HANA Cloud or S4HANA.

    Greenfield

    This is the type of SAP for the industries that do not have currently SAP, but wants to start with SAP in the Cloud. It means it is a fresh implementation of SAP.

    You can read more about the projects of SAP on Azure here:

    https://docs.microsoft.com/en-us/azure/virtual-machines/workloads/sap/sap-supported-product-on-azure

    https://docs.microsoft.com/en-us/azure/virtual-machines/workloads/sap/sap-deployment-checklist

  • SAP Cloud Hosting options

    Preface – This post is part of the SAP on Azure series.

    Introduction

    SAP, headquartered in Waldorf, Germany, with a location in Frankfurt, New York and Bangalore, is a large enterprise having ERP & Business objects software as its main product. SAP stands for “System, Applications & Products in Data Processing”. SAP is mainly divided into two parts in terms of hosting i.e. on premise hosting and Cloud Hosting. The SAP on premise hosting is mainly SAP HANA hosting which a relational database. In this article we will discuss in detail regarding SAP cloud hosting options.

    Different SAP Cloud Hosting options

    SAP, with its partnership with different global cloud hosting companies provides the following cloud hosting options:

    • HANA Enterprise Cloud (HEC)
    • AWS
    • GCP
    • Microsoft Azure
    • Alibaba cloud

    Alibaba has signed a contract recently with SAP, and is majorily focused for the clients in China and nearby regions.

    SAP HANA Enterprise Cloud is a HANA service provided by SAP on its contract. All the data was initially saved in SAP environment, later SAP opened it up to an eco-system of external hosting partners such as DXC, IBM Cloud and NTT.

    Comparison of different SAP Cloud Hosting options

    Let us compare the major SAP Cloud Hosting Providers:

    Factors Google Cloud AWS Azure
    Compute Very large VMs SAP S/4HANA up to 4 nodes totalling 48 TB of memory VMs support up to 24TB & 48 TB memory Very large VMs and bare metal for HANA SAP S/4HANA up to 24 TB RAM scale-up, and up to 60TB RAM scale-out
    Storage Cloud Storage EBS & S3 Cloud storage & Elastic File System Azure Storage and Azure NetApp Files
    Network Virtual networking & Interconnect Virtual networking (VCP) & Direct Connect Virtual networking & ExpressRoute
    Security (IAM) Cloud Identity and Access Management (IAM) AWS IAM Azure AD, RBAC, MFA
    Monitoring Custom monitoring agent collects metrics from SAP HANA & sends to Google Cloud Monitoring CloudWatch & CloudTrail Azure Monitor for SAP Solutions
    Automation Automation tool portfolio Automation tool portfolio Automation tool portfolio
    Backups Backups via SAP Backint agent, snapshots, or backup to cloud storage Backups via EC2 Create Image function & Amazon EBS snapshots SAP HANA backup using Azure Backup Highley Available VMs
    HA/DR HA via Linux clustering across regions & zones HA and DR via multiple Availability Zones and Regions HANA system replication / Azure Site Recovery
  • Security in SAP MTA and CAPM

    Preface – This post is part of the SAP Multi-Target Application (MTA) and SAP CAPM series.

    Introduction

    In SAP CAPM and MTA, the security can be taken care using the implementation of best SAP standard practices and using SAP Infrastructure. The entire application is divided into multiple layers such that the user cannot access the database layer or business logic directly from the browser.

    Implementation

    The implementation is an important aspect of security execution. That’s why it has been divided into multiple parts:

    • Development

    The role of the developer is to implement the security aspects wherever required. In case any external API is implemented, he must get it reviewed. Also, in case if a security issue is found, then a proper solution is provided to the developer, and he must implement the same.

    • Review

    The role of the reviewer is to analyze the security of the infrastructure and the services within it. Once the developer completes its development, the entire project is once reviewed and then sent to the tester for further analysis.

    • Penetration Testing

    The penetration testing team performs pen tests using different scenarios and possible ways of intrusion. Based on their analysis, either they mark it passed or come back with issues. These issues are then checked by developers and, once solved, again tested by the tester until the entire application is secure.

     

    Use Case in CAPM and MTA

    Malware check-in Server-Side

    With the help of a malware scanner in Node.js, the documents and files sent to the server are scanned before passing them to the database.

    Encryption & Decryption in Server and Client-side

    The passwords and other important data are encrypted using a standard encryption mechanism

    Destination in Cloud platform

    Destination in Cloud platform not only helps in implementation of CORS services but also hides the visibility of important service location from users

    Role-based access

    The role-based access helps the developer to keep the data safe from unwanted users. The roles are specific to an application, and it is mandatory for the user to have it for access.

  • Service Consumption and Web APIs using SAP ABAP RAP

    Preface – This post is part of the SAP ABAP RAP series.

    Introduction

    In this article, we will see how to create services in SAP RAP (RESTful Application Programming) and consume the same in UI5/Fiori using the given steps:

    1. Create service definition
    2. Expose entities in the Service Definition
    3. Create Service Binding
    4. Publish OData service
    5. Implement OData in UI5/Fiori

    Create Service Definition

    Right-click on Package >> New >> Other Repositories Objects >> Service Definition.
    Provide the details to create a Service Definition.

    SAP RAP Create Service Binding

    Once the Service Definition is created, expose the required entities and activate it.

    expose the required entities

     

    Create Service Binding

    Right-click on Package >> New >> Other Repositories Objects >> Service Binding.
    Provide Package details, Name, Description and Service Definition name. Additionally, select the Binding Type to create Service Binding.

    SAP RAP Create Service Binding

    Verify the information. To expose the service, click on activate.

    You can access the metadata details by following the Service URL provided in Service Binding. To preview the application, click on provided Preview button.

    OData Publish SAP RAP

    How to consume OData create by SAP RAP

    Like any other OData created by CDS or SEGW, the OData of SAP RAP can be used similarly in UI5/Fiori Applications. Read more about OData here.

  • Dealing with Existing Code in SAP RAP

    Preface – This post is part of the SAP ABAP RAP series.

    Introduction

    This article will provide the step-by-step enabling of existing code in RAP. Using the steps below we will learn “Dealing with Existing Code in SAP RAP”.

    Steps:

    1. Create data model with CDS views
    2. Create Behavior Definition
    3. Add transactional behaviour in Behavior Definition
    4. Create Behavior Pool
    5. Implement transactional behavior of the existing application

    Create data model with CDS views

    Click here to follow step 1

    Create Behavior Definition

    Procedure

    1. Right-click on root CDS view
    2. Select New Behavior Definition
    3. Provide the details (Name, Description).
    4. Select implementation type as unmanaged
    5. Click Next and provide the Transport Request number.
    6. Select Finish.

    Create Behavior Definition SAP RAP

    Add transactional behaviour in Behavior Definition

    Add transactional behavior (Create/Update/Delete/Actions) of business objects.

    Add transactional behaviour in Behavior Definition SAP RAP

    Add transactional behaviour in Behavior Definition ABAP RAP

    Create Behavior Pool

    You can assign any number of behavior pools to behavior definition. Within a single global class, you can implement multiple local classes which defines the transactional behavior of the business object.

     

    Procedure

    Behavior Definition >> Right-click >> select New Behavior Implementation >> Provide details >> Finish

    Splitting implementation into different behavior pools

    Figure 1:Splitting implementation into different behavior pools

     

    Behavior Pool

    Figure 2: Behavior Pool

    When you go to Local Types in Behavior Pool, you can see below local classes.

    local classes in Behavioral Pool

    local implementation classes SAP RAP

    Within these local implementation classes, you can implement the business logic of existing behavior objects and test the end-to-end scenario using EML (Entity Manipulation Language) syntax.

  • Enabling the Transactional Behavior of an App in SAP RAP

    Preface – This post is part of the SAP ABAP RAP series.

    Introduction

    This article will provide a step-by-step guide to enable the transactional behaviour of an application in SAP RAP.

    1. Create data model with CDS views
    2. Create Behavior Definition
    3. Add transactional behaviour in Behavior Definition
    4. Create OData service
      1. Create a Service Definition
      2. Expose CDS view
      3. Create Service Binding
      4. Publish OData service
    5. Application preview

    Create data model with CDS views

    Procedure

    1. Launch ADT (ABAP Development Tool).
    2. Select package for your development.
    3. Right-click on package and choose NEW > Other Repository Objects > Core Data Services > Data Definition.
    4. Provide the details (Name, Description).
    5. Select Next and provide the Transport Request number.
    6. Select Finish.
    7. Provide the data source name and add the elements in the CDS views.
    8. Provide the root statement to the top node as shown below.
      data model with CDS views
    9. Similarly, create consumption views and add required annotations.

     

    Result Screen

    Interface view SAP RAP

    Figure 1: Interface view

    Consumption view SAP RAP

    Figure 2: Consumption view

    Create Behavior Definition

    Procedure

    1. Right-click on root CDS view
    2. Select New Behavior Definition
    3. Provide the details (Name, Description).
    4. Select Next and provide the Transport Request number.
    5. Select Finish.

    Create Behavior Definition

    Add transactional behaviour in Behavior Definition

    Add transactional behaviour to Behavior Definition as shown below.

    Add transactional behaviour in Behavior Definition

    Create OData service

    a.       Create Service Definition

    Procedure

    1. Right-click on root CDS view
    2. Select New Service Definition
    3. Provide the details (Name, Description).
    4. Select Next and provide the Transport Request number.
    5. Select Finish.

    Create Service Definition

    b.      Expose CDS view

    Expose CDS view

     

    c.       Create Service Binding

    Procedure

    1. Right-click on Service Definition
    2. Select New Service Binding
    3. Provide the details (Name, Description).
    4. Select Next and provide the Transport Request number.
    5. Select Finish.

    SAP RAP Create Service Binding

    d.      Publish OData Service

    Publish OData Service SAP RAP

    Application Preview

    Fiori App SAP RAP

    Fiori Detail Page SAP RAP

     

  • How to create a SAP ABAP RAP Project

    Preface – This post is part of the SAP ABAP RAP series.

    Introduction

    SAP ABAP RAP provides the intrinsic approach to build SAP Fiori based applications that are optimized for S/4 HANA and can run over on-premise as well as on the cloud. In this article we will learn how to create a SAP ABAP RAP Project.

    Prerequisites

    Before we start with the development of our first project using SAP ABAP RAP, we need a few things ready:

    SAP Cloud Platform ABAP Environment

    You should have access to and an account for SAP Cloud Platform ABAP Environment.

    Development Environment (IDE)

    • Install ABAP Development Toolkit (ADT).

    SAP recommends the latest version of the client installation. The download is available on https://tools.hana.ondemand.com/.

    • Access to and an account for the relevant space in SAP Cloud Platform Cloud Foundry.

    Authorization

    To create development artifacts, you need to have a developer role in the ABAP environment.

    Basic knowledge

    • ABAP Core Data Services (CDS)
    • ABAP Objects
    • ABAP Syntax

    Steps to create a SAP ABAP RAP Project

    1. Create an ABAP CDS View enabled with OData. Follow the steps mentioned here. This ABAP CDS View can be either basic, composite or consumption based upon the use case. The basic view is just a simple view created based upon ABAP table, the composite views are the ones that are created using multiple basic views or existing composite views. The consumption is the one that is consumed by the Fiori Apps (other views too can be consumed, it is created with final annotations such that UI5 has to call just this view and not the others).
    2. The very next thing that we create in ABAP RAP is a behavior definition. You can read the steps here. A behavior definition is an ABAP repository that represents the behavior of business objects in the context of SAP ABAP RAP. This is the place where we define the CRUD operations for the CDS Views.
    3. The last and important step is behavior Implementation. The steps to implement the same is mentioned here. This is the place where business logics are written.

    Thus in above steps we have created an ABAP CDS View, an ABAP OData, behavior definition and behavior Implementation.

    What is SAP RAP

    That’s it, this is how we create a SAP ABAP RAP Project. In our next articles, we will show you the implementation, step by step.

  • Developing Read-Only List Reporting Apps

    Preface – This post is part of the SAP ABAP RAP series.

    Introduction

    Using persistent data sources, we are going to implement a query for the OData service to get an application with the read-only feature. This OData service will be consumed by the Fiori Element application.

    This article will provide the step-by-step guide to build a read-only list reporting application.

    1. Create data model with CDS views.
    2. Add associations to CDS views for navigation purpose.
    3. Add relevant annotations.
    4. Changing UI field labels and description
    5. Create OData service
      1. Create a Service Definition
      2. Expose CDS views
      3. Create Service Binding
      4. Publish OData service
    6. Application preview

    Create data model with CDS views

    Procedure

    1. Launch ADT (ABAP Development Tool).
    2. Select package for your development.
    3. Right-click on package and choose NEW > Other Repository Objects > Core Data Services > Data Definition.
    4. Provide the details (Name, Description).
      Create data model with CDS views
    5. Select Next and provide the Transport Request number.
    6. Select Finish.

    Result Screen

    An inactive version of the data definition is created. You need to provide the data source name and add the elements in the CDS views. Similarly, create all the required CDS views.

    Generated Template code

    Figure 2: Generated Template code

     

    Add associations to CDS views for navigation purpose

    1. Define association and cardinality
      Define association and cardinality
    2. Define mapping condition
      Define mapping condition
    3. Add association element list in CDS view
      Add association element list in CDS view

    Add relevant annotations

    Add required annotations to fields (see the below figure).

    ABAP CDS Annotation

    Changing UI field labels and description

    UI field labels and description allows you to customize your UI application. You can add text annotation (@ObjectModel.text.association:'<_AssocToTextProvider>’),value help (@Consumption.valueHelpDefinition: [{ entity: { name: ‘<target_view>’ , element: ‘<target_element>’ }}]), search capability ( @Search.searchable: true ) and as many functionality to your field element.

    Changing UI field labels and description

    Create OData service

    a.       Create a service definition

    In service definition, we will expose our data models.

    Procedure

    1. Launch ADT (ABAP Development Tool).
    2. Select package for your development.
    3. Right-click on package and choose NEW > Other Repository Objects > Business Service > Service Definition.
    4. Provide the details (Name, Description).
      Create a service definition
    5. Select Next and provide the Transport Request number.
    6. Select Finish.

     

    b.      Expose CDS views

    In service definition, add the CDS view that you want to expose to UI. You can provide an alias also for the same. Once the CDS views are exposed, activate the service definition.

    Expose CDS views

    c.       Create Service Binding

    In service definition, we will expose our data models.

    Procedure

    1. Launch ADT (ABAP Development Tool).
    2. Select package for your development.
    3. Right-click on the package and choose NEW > Other Repository Objects > Business Service > Service Binding.
    4. Provide the details (Name, Description).
      Create Service Binding
    5. Select Next and provide Transport Request number.
    6. Select Finish.

    When you open the created service binding from editor you can see the below screen. As soon as the service binding is created, it is registered in your local system.

    Activate the service binding

    Activate the service binding and it is ready for consumption.

    d.      Publish OData service

    Once you activate the service binding, the OData service is published and is activated in SAP Gateway. Now it can be consumed by UI5 application.

    Publish OData service

    The service URL on the right side will provide the metadata information of OData service. Preview button will navigate you to the resulting UI service.

    Application preview

    The resulting UI5 application will look like this:

    Application preview

  • Introduction to ABAP CDS Views

    Preface – This post is part of the SAP ABAP RAP series.

    Introduction

    SAP ABAP CDS View is used for defining and consuming semantic data models on standard tables or dictionary views. The abbreviation for CDS is Core Data Services. Although SE11 dictionary view and CDS views both create database views at the backend, the ABAP CDS view supersedes the dictionary view in so many ways.

    Difference between dictionary view and CDS View

    Dictionary View CDS View
    Can be created from SAP GUI or Eclipse. Can only be created from Eclipse or SAP HANA Studio.
    Cannot define Annotations. Annotations are provided to enrich metadata.
    Aggregation is not possible. Can provide Aggregation function.
    Grouping is not possible. Grouping can be provided.
    Join can be used. Join and Union both can be used
      Case Expressions can be used.
      Input parameters can be allowed for filtering data and column calculations
      Operators can be used.

    CDS view Types

    There are three different VDM view types:

    • Basic view
    • Composite view
    • Consumption view

    CDS view Types

    Figure 1: CDS view types

    1.      Basic View

    VDM Basic views are created on the top of DDIC tables or views. It is the only view that interacts directly with the database.

    Annotation: @VDM.Viewtype : #BASIC

    Properties for Basic View:

    1. Basic views can directly access the database tables and other basic views.
    2. They have an association with other basic views.
    3. Free of redundancies.
    4. They expose all business data.

     

    2.      Composite view

    The composite view is created on top of the VDM Basic view. It interacts with Basic views for the result set and does not interact with the database directly.

    Annotation: @VDM.Viewtype : #COMPOSITE

    Properties of Composite View:

    1. They can access other Composite views but not database tables.
    2. They can have an association with other composite views and basic views.
    3. Redundancies might be possible.
    4. They should be reusable.

     

    3.      Consumption view

    The consumption views are built on top of Interface views. By the name Consumption, we can assume that this view is meant to be consumed by SAP UI5 through OData, Analytical queries, Transactional service models.

    Annotation: @VDM.Viewtype : #CONSUMPTION

    How to create CDS views in ADT?

    To create a CDS view follow the below steps:

    1. Navigate to New ABAP Repository.
      New ABAP Repository
    2. Select Data Definition.
      Select Data Definition
    3. Provide Package, Name, Description of CDS view.
    4. Now from the given options, select Define View.
      Define View
    5. Define data source name, SQL view name, required annotations and other properties.
      Define data source name
    6. Define data selection Query.
      Define data selection Query
    7. Save and activate.

    How to view the data from CDS Views?

    1. In the DDL source object, navigate to your CDS view.
    2. Right-click and select OPEN DATA PREVIEW. Also, you can open the CDS view and press F8 to view the data.
    3. The output will show you the retrieved data from CDS View.

    Tutorial Video

    You can watch the video below to learn implementation:

    [embedyt] https://www.youtube.com/watch?v=CwWbauSyD4s[/embedyt]