Found 1044 Articles for SAP

Difference Between Great Plains and SAP

Md. Sajid
Updated on 13-Feb-2023 11:43:20
The business software industry is brimming with possibilities, each with its features and benefits. Great Plains and SAP are two of the most popular software packages. While both have a wide variety of capabilities, there are several major distinctions. Both Great Plains and SAP are enterprise resource planning (ERP) software. Microsoft created Great Plains, while a German corporation called SAP created SAP. Great Plains is for small to medium-sized organizations, whereas SAP is for large corporations. Great Plains is less expensive than SAP and can be installed more quickly, although it lacks several of SAP's sophisticated capabilities. Both ... Read More

Difference between ERP and SAP

Pradeep Kumar
Updated on 26-Jul-2022 07:03:33
Every company will, at some time, find it necessary to implement a management system of some kind. This will allow the company to more effectively manage its information and resources, which will, in turn, lead to an improvement in the overall effectiveness of the company's operations.In order to effectively manage the business processes and automate the majority of the functions connected to technology, services, and human resources, there must be a plan to place a system of apps that are integrated with one another. The goal is to improve productivity by automating company processes in order to cut down on ... Read More

Exploring ERP Modules of Oracle E-Business Suite

Sharon Christine
Updated on 24-Jan-2020 07:13:07
The acronym ERP stands for enterprise resource planning. It refers to the systems and software packages used by organizations to manage day-to-day business.Oracle E-Business Suite is one of the most reputed ERP product which is currently available in the market – developed by Oracle. In the world of enterprise resource planning, very few software products have really made to the top ranks when it comes to worldwide implementations. Based on market share – SAP, Microsoft Dynamics are the close vendors who try to get the ERP share in almost all the regions.What is Oracle E-Business Suite?Oracle’s E-Business Suite (also known ... Read More

Loading an individual column in SAP HANA using SQL

SAP Developer
Updated on 13-Mar-2020 07:59:07
Yes, you can open SQL console and execute the statement −LOAD (, ...);This SQL query will load or unload entire column into or from main memory. Its load status is TRUE or FALSE. The table's load status is PARTIALLY.

Load and unload a table in SAP HANA using SQL query

SAP Developer
Updated on 13-Mar-2020 08:00:05
In SAP HANA, it is possible to manually load and unload individual tables and table columns.You can perform loading of table to precisely measure the total or “worst case” amount of memory used by a particular table.A table is unload from database to actively free up memory.You can use following SQL queries to perform load/unload of table −LOAD UNLOAD

Uninstalling license key in SAP HANA using Studio

SAP Developer
Updated on 13-Mar-2020 08:03:33
You can uninstall the license key (LICENSE ADMIN) using one of the following options −In SAP HANA Studio →In the Systems view, right-click the system and choose Properties → Licenses tab On the System License page choose Delete License Key.SQL console −You can also run the SQL command UNSET SYSTEM LICENSE ALL to remove all licenses.

Privilege to install a new license key in locked HANA system

SAP Developer
Updated on 30-Jul-2019 22:30:22
With system privilege LICENSE ADMIN, you can connect to the database and execute license-related queries- obtain previous license data, install a new license key, and delete installed license keys.

Lock down of SAP HANA system

SAP Developer
Updated on 13-Mar-2020 08:04:19
A SAP HANA system lockdown in the following scenarios −The temporary license key has expired.When a temporary license key is in use and the hardware key has changed.When permanent license key has expired and it is not renewed within 28 days.When installed license key is an enforced license key and the current memory consumption exceeds the licensed amount plus the tolerance.When all license keys installed in your database are deleted.You can’t run a query in lockdown mode and only a License Administrator can connect to database.

Copying or moving a tenant database in SAP HANA

SAP Developer
Updated on 13-Mar-2020 08:06:04
When you move or copy a tenant database, data is replicated from the original tenant database to the new tenant database in the target system. Following tables shows type of data replication for different type of data −Data and logs of the tenant databaseYesTrace and log files   NoData backups    NoConfiguration (*.ini) files with tenant-database-specific values                 NoCertificates and certificate collections stored in the tenant database    Yes                 

Diagnosis file of unavailable tenant in SAP HANA database

SAP Developer
Updated on 13-Mar-2020 08:06:40
When a tenant database is unavailable due to some performance problems, the tenant database administrator can't access diagnosis files. In this case, a system administrator can access the diagnosis files of the tenant database from the system database using the SAP HANA studio.In the SAP HANA studio, open the Administration editor and choose Diagnosis Files and diagnosis files of the system database are displayed.Using the Database filter, select the tenant database → whose diagnosis files you want to see and diagnosis files of the selected tenant database will be displayed.
1 2 3 4 5 ... 105 Next