- SAP HANA
- Features of SAP HANA
- Advantages and Disadvantages of SAP HANA
- SAP HANA Architecture
- SAP HANA Use Cases
- SAP Hana Installation
- SAP Hana Studio
- SAP HANA Studio Administration Console
- How to Use SAP HANA System Monitor
- How to Use SAP HANA on Azure
- SAP HANA Modeling – Attributes, Measures, Privileges, Modeling Objects
- Data Warehousing in SAP HANA – Components, Methods, Working & Benefits
- SAP HANA Attribute View – Create Attribute View in 9 Easy Steps
- SAP HANA Analytic View
- SAP HANA Calculation View
- Tables in SAP HANA
- SAP HANA Packages
- Schema in SAP HANA
- How to Create Analytic Privileges in SAP HANA
- SAP HANA Information Composer
- Import and Export in SAP HANA
- Major Components of SAP HANA
- Reporting in SAP HANA
- SAP Bussiness Objects Reporting Tool
- create relational connection in sap hana in 8 steps/
- steps to create olap connection in sap hana/
- How to Connect SAP Lumira with SAP HANA
- Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards
- How to Connect Web Intelligence to SAP HANA in 4 Ways – Seamless Process
- Replication Modes and Types in SAP HANA
- SAP HANA Sidecar Scenario
- SAP HANA Security Guide
- SAP HANA License Management
- Difference between SAP HANA vs SAP S/4 HANA
- What is SAP S/4 HANA?
- S/4HANA Editions
- SAP S/4HANA Lines of Business
- >SAP S/4HANA Deployment Options
- >SAP S/4HANA Overview
- >Introduction of SAP ABAP
- >Overview of SAP ABAP
- >SAP R3 ARCHITECTURE
- >SAP Data Dictionary
- >SAP ABAB Views
- >SAP ABAB database Tables
- >ABAP Constants & Literals
- >ABAP Constants & Literals
- >Types of Tables in SAP
- >Sap Data Object
- >Internal Tables and Work areas
- >Internal Table Operations in SAP ABAP
- >ABAP Report uses Internal tables and Work Areas
- >Select single and Select up to 1 rows
- >Modularization Techniques
- >Techniques of debugging
- >Types Subroutines
- >Reports of Sap Abap
- >Using At Selection Screen Output
- >Select Statements
- >Function Modules
- >Modularization Techniques 2/
- >Subroutines In Sap Abap/
- >Report Of Sap Abap 2
- >Using At Selection Screen Output 2
- >Interactive Reports
- >Interactive Reports Development
- >Interactive Report Using Hide Technique
- >Interactive Report Using Get Cursor Technique
- >Tree List Report
- >Abap Alv Reports/
- >Sap scripts/
- >Purchase Order SAP Script/
- >SAP Smartforms/
- >What is BDC in SAP ? Types of BDC ?/
- >BDC Call transaction for Material Master MM01/
- >SD flow with T-Codes and tables/
- >Introduction to module pool programming in SAP/
- >Functional Specification/
- >ASAP methodology SAP
- >ABAP Development end to end process in Companies
- >SAP SD Sales and Distribution
- Accounting Entries in SAP FICO
- Define Company in SAP
- Creating new companies
- Assign Company Code
- Business Area
- Functional Area
- Credit Control Area in SAP
- Financial Management in SAP
- Segments in SAP
- SAP Enterprise Structure
- General Ledger Accounting
- Fiscal Year Variant in sap
- Posting Period Variants in SAP
- Posting Period Variant to Company Code
- How to Assign company code to field status variants in SAP
- Posting Keys in SAP
- Tolerance Group for Employees in SAP
- Tolerance Groups For G/L Accounts
- Assign Users to Tolerance Groups in SAP
- Enter Global Parameters for Company Code OBY6
- Define Additional Local Currencies for Company code in SAP System
- Chart of Accounts in FICO
- Assign Company Code to Chart of Accounts in SAP
- How to Create G/L Account Group in SAP
- Define Sample Account Rule Types in SAP
- Data Transfer Rules
- Convolutional and recurrent neural network
- Assign company code to rule type in sap
- Create sample account in sap
- Accounting entries in sap fico sap accounting postings
- Financial statement versions in sap
- TAX Check Calculation Procedure in SAP
- Define New Condition types for Taxes
- How to Assign Country to Calculation Procedure
- Specify Structure for Tax jurisdiction code
- How to Create tax codes in SAP – FTXP "FI"
- Assign Tax Codes for Non-Taxable Transactions in SAP FI
- Define Tax Calculation Procedure for GST in SAP"FI"
- Assign Tax Calculation Procedure to Country in SAP for GST"FI"
- Define Access Sequence in SAP for GST"FI"
- Define Condition Types in SAP for GST"FI"
- How to create customer account groups in sap
- How to create number ranges for customer accounts
- Assign number ranges to customer account groups
- How to Assign Number Ranges to Vendor Account Groups in SAP F1
- How to Create Sundry Creditors GL Account in SAP FI
- How to Define Tolerance group for vendors /Customers
- How to Create Vendor Master Data
- Automatic Payment Program Configuration Steps SAP FI
- Create Vendor Account Groups in SAP
- How to Create Number Ranges for Vendor Accounts in SAP
- Maintain terms of payment SAP
- How to Create Customer master data by XD01
- How to Define Dunning Procedures in SAP
- Copy Reference Chart of Depreciation in SAP
- Assign Chart of Depreciation to Company code in SAP
- Specify account determination asset accountng
- How to create screen layout rules asset accounting
- SAP FI: Create Screen Layout Rules
- SAP FI: Maintain Asset Number Ranges – AS08
- Create Investment Program Types in SAP
- Investment profiles
- How to Investment Program Types to Operative objects in SAP
Schema in SAP HANA
A schema is an important structural component of SAP HANA database and gives a logical framework to users. Schemas are important when you work on SAP HANA Studio.
What is a Schema in SAP HANA?
A schema is like a container which contains all the different elements or objects of a relational database. The elements of the system reside in the Catalog node of SAP HANA Information Modeler.
Within the Catalog node, the relational SAP HANA database is divided into sub-databases known as schemas. These schemas, acting as logical containers keep all the objects relevant to the database such as tables, views, functions indexes, stored procedures, etc.
In other words, it categorizes all the important information about a database into folders. The schema is created as a transportable design-time file (with extension “.hdbschema”) which is a generally flat file stored in data repositories.
Components of a Schema in SAP HANA
Each schema consists of a fixed set of folders containing relevant information:
- Column views
- EPM Models
- EPM Query Sources
Types of Schemas in SAP HANA
There are three types of schemas in SAP HANA:
User Defined Schema
The user-defined schema or custom schemas are created by users such as a HANA DBA, System Administrator or a developer. You can create a user-defined schema using an SQL code.
The syntax for creating such a schema is:
CREATE SCHEMA < schema_name>;
Now, if you wish the objects such as tables or views residing under this schema get consumes in other information views or schemas, then you need to grant access at the time of creating a schema.
The syntax for access granting statement is:
GRANT SELECT ON < schema_name> TO SYS_REPO WITH GRANT OPTION
System Defined Schema
The system defined schema contains SAP HANA system information and is created with the SAP HANA database by a system.
There are standard system defined schemas such as _SYS_BIC, _SYS_REPO, _SYS_BI, _SYS_STATISTICS, _SYS_XS, etc. Each of this system defined schema contains information relevant to specific system aspects.
- _SYS_BIC: Contains column views of all the activated objects.
- _SYS_REPO: Contains all the objects available in the repository such as activated objects, inactive objects, runtime objects, package details, etc.
- _SYS_BI: Contains the metadata for the column views.
- _SYS_STATISTICS: Contains information regarding system configuration and parameters.
- _SYS_XS: Contains data related to SAP HANA Extended Applications Services.
SLT Driven Schema
This schema is created when SLT is configured to carry out replication of tables. It will contain all the tables that replicate into SAP HANA through SLT. Such schemas create on Data Provisioning by SLT process.
How to Create Schema in SAP HANA Modeler
We can create schemas in SAP HANA in two ways:
- By creating a user which automatically creates a schema for that user.
- Another method is by creating a customized schema under an existing user without creating a new user.
Below are the steps to create a customized schema:
Open the SQL Console in SAP HANA Modeler.
After that, the SQL Console is ready for you to enter the SQL statement.
CREATE SCHEMA TEST_SCHEMA OWNED BY TRAINER
Enter the SQL statement to create a schema. In the image shown below, the schema named TEST_SCHEMA will create which a pre-existing user, TRAINER, owns
To execute this statement, select the statement written and click on the green execute icon (indicated by the red arrow). You can use keyboard shortcut F8 for this.
A message at the bottom of the console will confirm successful execution.
Then, to find the newly created schema, refresh the Catalog.
After that, the schema will add.
Also, if you go and check the list of users, no new user is added.
Then, you can also drop the table by writing a small code as shown below.
CREATE SCHEMA TEST_SCHEMA OWNED BY TRAINER
DROP SCHEMA TEST_SCHEMA
Apply now for Advanced SAP Course