
Quick Contact
SAP Tutorial
- 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
Sap Abab
Sap FI
- 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
Import and Export in SAP HANA
Import/Export in SAP HANA
The import and export options are used to transport database objects such as information views, data tables, landscapes, etc to other systems or within the same system. In addition to database objects, importing of metadata from other systems is also done using these options.
The import and export options save a user’s time and effort to recreate the objects on a target system. Users can easily transfer database objects to target systems using the import and export options available in SAP HANA Studio.
In SAP HANA Studio, there are a number of ways in which data objects can be imported and exported.
-
Import options
There are two folders which provide different methods to import; an SAP HANA folder and an SAP HANA Content folder.
The options within SAP HANA folder are:
- Catalog Objects
- ESRI Shapefiles
- Landscape
The options within SAP HANA Content folder are:
- Data from Local File
- Delivery Unit
- Developer Mode
- Mass Import of Metadata
- SAP NetWeaver BW Models
- Selective Import of Metadata
-
Export options
Similar to the import options, there are two folders available for exporting; an SAP HANA folder and an SAP HANA Content folder. There are various export methods available within these folders.
The options within SAP HANA folder are:
- Catalog Objects
- Landscape
The options within SAP HANA Content folder are:
- Change and Transport System (CTS)
- Delivery Unit
- Developer Mode
- SAP Support Mode
In the following sections, we will discuss all the different types of import and export methods in detail. We will also learn how to perform these methods in SAP HANA Studio.
Importing Data in SAP HANA
In this section, we will see how to import data from external systems using different options given under the SAP HANA content folder.
You can access the import and export options in the SAP HANA Studio either in the File menu or in the SAP HANA Modeler section on the right of SAP HANA Modeler perspective.
Click on Import option and an Import dialog box will appear. In this dialog, you will see seven different import methods. You can select one of these seven options to import the data.
We have explained each method separately in the sections below:
-
-
Data from Local File
Import data from flat files such as .txt, .csv, .xml, .xls, .xlsx etc. to the local system. To import the flat files like csv and xml, click on the Data from Local File option. And click Next. Select a target system from which you wish to import the file. Click Next.
-
1.1. Define Import Properties
A dialog will appear asking you to define all the import properties such as Source File, Header Rows, Field Delimiter, Import All Data Or Not, Target Table, etc. You can import the data into an existing file or create a new file under a schema to accommodate the data. Click on Next> to continue.
1.2. Manage Table Definition and Data Mappings
In the next window, you will get table definition and data mapping options. Here you can assign a primary key, select attributes and measures, view a summary of the table and map the imported contents into an existing column.
1.3. Summary View
Upon clicking Next, you will get a summary view of the resultant table with imported data. The details of the table such as Source File Name, Target Table Name, Target Table Schema are also displayed here.
Click on Finish to successfully complete the import. You can confirm this import by checking the presence of the table (if newly created) or refreshing the contents of existing ones.
-
-
Delivery Unit
Select the Delivery Unit option and click Next. Select a target system from which you wish to import the file. Click Next.
Importing through Delivery Unit
In the import dialog, enter the importing details for the delivery unit. Select a delivery unit file from the server or client source. Assign the actions upon importing like overwrite inactive versions an activate objects.
The activate objects automatically activates the imported objects once the delivery unit gets successfully imported. You can also select an activation mode.
The details of the delivery unit i.e. the object and the package name are also displayed.
-
Developer Mode
Select the Developer Mode option and click Next. Select a target system from which you wish to import the file. Click Next.
Selecting System Folder
In the developer mode import dialog, you can browse the system to select the folder containing the object of interest.
Next, you can add the desired database object from the selected folder. Select a package (from Objects for Import section) and click on Add button to import it into SAP HANA system.
-
Mass Import of Metadata
The Mass Import of Metadata option imports all the metadata i.e. table definitions residing in SAP ERP source systems using SAP load controllers.
To import metadata using this method, select the Mass Import of Metadata option and click Next. Select a target system from which you wish to import the file. Click Next.
Connection Details
Enter the SAP ERP system connection details to establish a connection with the source and import the metadata through this window. You need to fill the following details:
-
4.1. Source Details
-
-
- System Name
- Host Name
- Schema Name
-
4.2. Target Details
-
- Server Name
- Instance Number
- Schema
- OS User
-
SAP NetWeaver BW Models
The SAP NetWeaver method is used to import Business Warehouse models from the SAP NetWeaver platform.
-
Selective Import of Metadata
The selective import of metadata option imports the metadata or information about only selected data tables or objects from the SAP ERP systems.
- It is different from the Mass Import of Metadata option as in that option the entire metadata of all the database objects residing in the SAP ERP system is imported into SAP HANA. Whereas in Selective Import of Metadata, only selected object’s metadata is imported into SAP HANA.
-
Landscape and Tables
By the Landscape option, you can import entire landscapes into SAP HANA. These landscapes are essentially the ones which were previously exported into a local system.
In addition to this, by using the Tables option, you can import the tables and their contents of the exported tables into the target system.
Exporting Data in SAP HANA
To export data from SAP HANA, we open an Export dialog by clicking on the Export option from the file menu or SAP HANA Modeler perspective section.
The Export dialog box will show four export methods under the SAP HANA Content folder. Let’s discuss the four export options in detail.
-
Change and Transport System (CTS)
The Change and Transport System (CTS) method is used to export the database objects such as information views created in ABAP programs. The CTS method is essentially used by the CTS support teams.
-
Delivery Unit
A delivery unit is a single entity or unit that maps multiple packages to it. All the packages mapped in a specific delivery unit are transported to other systems as a single unit.
The delivery unit method is used to export packages and other relevant database objects to a HANA Server (another HANA system) or to a local client (local machine).
Selecting Delivery Unit
Select the Delivery Unit option and click Next. Select a target system from which you wish to import the file. Click Next.
In the export dialog box, fill in the details specific to the delivery unit you wish to export.
Select the Delivery Unit from the drop-down list of available units (only exports data from the selected time frame), select a filter of Time Interval and select the Export Location, File Name. Click on Next.
A summary page will appear showing the details of the export. The details shown are, Delivery Unit name, From Date, To Date, File Name, File Path. Click on Finish.
You can also verify the export occurred successfully by checking for the delivery unit in the target folder in the target system.
-
Developer Mode
The Developer Mode method is essentially used to export individual database objects to a location in the local client system. It is different from the delivery unit method as in that you have to export multiple packages enclosed in a single unit and cannot export individual files.
To use this option, select the Developer Mode option and click Next. Select a target system from which you wish to import the file. Click Next.
Selecting Objects
In the next dialog, you can select an individual view from a package and add it for exporting, after it selects a target location i.e. a folder within your local system.
Click on Finish to complete the export.
You can confirm a successful export by checking for the exported view in the target folder. If the folder is present in the target location, the export process is successful.
-
SAP Support Mode
By this method, you can export database objects and data for SAP support purposes. Users use this export method in case of errors to seek help in troubleshooting and debugging from the SAP Support team.
In the SAP Support Mode option, you simply have to select the data object facing issues and add it into the Selected section.
Then choose the export location, i.e. to server or local client. Add the required details and click on Finish. The database object will be exported to the support team’s system successfully.
-
Landscape and Tables
Using the Landscape option, you can export entire landscapes from SAP HANA to target systems.
In addition to this, by the Tables option, you can export tables and their contents from SAP HANA to the target system.
Apply now for Advanced SAP Course