Go Coding

Category: ABAP Beginner

  • What is SAP HANA?

    Preface – This post is part of the ABAP Beginner series.

    SAP HANA

    SAP HANA is an acronym which stands for High-Performance Analytic Appliance.

    It is developed and marketed by SAP SE. Its in-memory, column oriented, relational database system make it unique from other database systems available in the market.

    In-memory database are also called Main Memory Database System and it relies on Main Memory (RAM) for Computer Data Storage.

    A Relational Database is a DBMS which utilizes the Primary Key & Foreign Key relationship.

    A Column-Oriented DBMS is a Database system that stores data by column rather than row.

    SAP HANA Database
    General Architecture of SAP HANA Database

    Let us understand the concept of Column Oriented DBMS using an example.

    If we have employee details of 3 Employee in our system, as follow:

    Row ID EMP ID NAME SALARY
    001 1231 BARRY ALLEN 50000
    002 1232 OLIVER QUEEN 60000
    003 1233 JAMES BOND 70000

     

    Row Oriented System:

    In row oriented system, it will be saved as follows (It will not be saved as shown, because real database systems save it in serialized manner):

    001: 1231, BARRY ALLEN, 50000;
    002: 1232, OLIVER QUEEN, 60000;
    003: 1233, JAMES BOND, 70000;

     

    Now if I have to make a search on the basis of SALARY, it will search whole system for that, which is okay in case of low data but slow in case of abundant data. In that case Row Oriented System make Indexes on basis of column as shown below:

    001: 50000;
    002: 60000;
    003: 70000;

     

    The Indexes are faster, the only demerit is that for every column An Index will be required, which will acquire more data in database.

    Column Oriented System:

    In column oriented system, it will be saved as follows:

    1231:001,1232:002,1233:003;
    BARRY ALLEN:001, OLIVER QUEEN: 002, JAMES BOND:003;
    50000:001, 60000:002, 70000:003;

     

    In above example, every row has same type of data i.e. on the basis of column.

    One point to observe is: “In a row-oriented indexed system, the primary key is the Row ID that is mapped from indexed data. In the column-oriented system, the primary key is the data, which is mapped from Row ID”.

    So, if we want to do a search on basis of any column, the searches will be faster as it will be searched only in a single row.

    How to Access SAP HANA:

    SAP HANA utilizes Raw/Open SQL to communicate with database as well as utilizes “ABAP for HANA” which is newer version of ABAP that runs on HANA.

  • What is ERP: Enterprise Resource Planning?

    Preface – This post is part of the ABAP Beginner series.

    What is ERP?

    The acronym ERP stands for Enterprise Resource Planning. In early 90’s when Industries were expanding, then there was a need of a system or structure that will centralize business Information i.e. bring all the Industrial information at a single place. As the name suggests Enterprise needs a planning to manage all its resource i.e. Human Resource, Manufacturing Resource, Production Resource, Capital Resource, etc. In Business world, it refers to the systems & software packages used by organizations/industries  to manage daily business activities, such as procurement,  manufacturing, delivery, accounting,  project management and human resource management.

    Why we need ERP?

    Let us suppose, we don’t have any ERP system. And I am the owner of Tea shops in China. I am planning to expand my tea shop chains across the globe. Now, I have to make a directory of every employee, every sale, every purchase of raw items, every rented shops and etc. Now, if I want to check data for every place, I have to go there physically and check. If each data is maintained in an Excel sheet, then also I have to check them individually. That is the wastage of my time and money. And we have to save both. Thus, the requirement was there to build something that will bring all the data at a single place and further can be verified and using them Business planning’s can be made.

    What is ERP

    The Business Value of ERP:

    • Improves business insights using real time information based reports
    • Lowers operational cost using streamlined business process
    • Enhances collaboration using shared data of users
    • Improves Efficiency using common User Experience across all business process
    • Consistent Infrastructure by bringing everything under same hood
    • Reduces Risk using data Integrity
    • Lowers Management & Operational Cost using uniform & Integrated systems

    Why ERP Suite:

    An ERP Suite always wins over a single point solution as it integrates the entire business module and keeps finance and human resource under control.

    ERP Solutions in Market:

    • SAP
    • FIS Global
    • Oracle
    • Fiserv
    • Intuit Inc.
    • Cerner Corporation
    • Microsoft
    • Ericsson
    • Infor
    • McKesson

    Basic Modules of ERP:

    • Human Resource
    • Inventory
    • Sales & Marketing
    • Purchase
    • Finance & Accounting
    • Customer Relationship Management(CRM)
    • Engineering/ Production
    • Supply Chain Management (SCM)

    Future of ERP:

    Every year technologies evolves and with that the requirement of Vendors and client too. To ease their work process, ERP has to evolve too. As of now, every ERP system is focussing upon their cloud solutions. And sooner the dependency upon on-premise ERP systems will end.

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