Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by Samual Sam
Page 60 of 151
Early Database Models
A database model determines the logical structure of a database and defines how data can be stored, organized, and manipulated. Before databases were developed, the only way to store data was in file storage systems, which increased complexity as programmers had to perform complex parsing and relating operations to extract data. File Storage Complex, redundant Database Models Structured, ...
Read MoreNoSQL Databases
NoSQL databases (Not Only SQL) are designed for large sets of distributed data. Some big data performance issues that are not effectively handled by relational databases are easily managed by NoSQL databases. They are very efficient at analyzing large-size unstructured data that may be stored across multiple virtual servers in the cloud. Types of NoSQL Databases NoSQL databases are categorized into four main types based on their data model − Document Store JSON-like documents MongoDB ...
Read MoreEnd User Database
An End User Database is a shared database specifically designed for end users who are not concerned with the underlying transactions, operations, or technical details. The end user interacts only with the final product − a software application or interface − and the database presents summarized, meaningful information for their use. Raw Operational Database SQL, Transactions, CRUD Data Processing & Aggregation End User Database Interface Dashboards, Reports, Simple Views ...
Read MoreDifference between an SAP ERP system and DBMS
A DBMS (Database Management System) and an SAP ERP (Enterprise Resource Planning) system serve different purposes. A DBMS manages data storage and retrieval, while an ERP is a complete business application suite that uses a DBMS as one of its components. What is DBMS? A DBMS is a tool or interface used to create, manage, and query databases. Examples include SQL Server, MySQL, Oracle, and PostgreSQL. A DBMS handles data storage, retrieval, indexing, security, and backup. It is mainly designed for and used by technical people like database administrators and developers. What is ERP? ERP (Enterprise ...
Read MoreCallback is not working on remote but working locally in SAP CRM
The issue lies in the class you are using for making a method call. This class is basically making RFC callback with the help of SAP GUI. So, when you are using the function builder, it works well because it has an SAP GUI connection present. But when you are using an external system, the GUI is missing and it doesn't work. Understanding the Problem When working with SAP CRM, callbacks rely on the SAP GUI framework for proper execution. In a local environment, the SAP GUI provides the necessary interface layer for RFC (Remote Function Call) ...
Read MoreUpgraded to SAP.net connector 3.0 is not working in Visual Studio 2008 and 2010
Note that SAP.NET Connector 3.0 doesn’t work similar to the 2.0 connector. There are many significant changes − both improvements and modifications − provided in the .NET 3.0 version. SAP.NET Connector 3.0 Overview SAP .NET Connector 3.0 is the current version of SAP's development environment for communication between the Microsoft .NET platform and SAP systems. With the use of SAP.NET connector, you can connect SAP system to all common programming languages like Visual Basic.NET, C#, or Managed C++ and many more. This is the official SAP documentation link about general capabilities of SAP.NET connector − ...
Read MoreCombining LIKE and CONTAINS operator in SAP HANA
In SAP HANA, you can combine LIKE and CONTAINS operators with regular expressions for advanced string manipulation. When removing duplicate characters from a string, using \1+ only removes consecutive occurrences. To remove all duplicate occurrences while keeping only the last occurrence of each character, you can use the REPLACE_REGEXPR function with a more sophisticated pattern. Using REPLACE_REGEXPR with Regular Expressions The pattern (.)(?=.*\1) works by capturing any character and using a positive lookahead to check if that same character appears later in the string. This allows you to remove all duplicate occurrences except the last one − ...
Read MoreSuppressing the page header till the last page in SAP Crystal Reports 2008
To suppress the page header until the last page in SAP Crystal Reports 2008, you need to use the OnLastRecord function. This function is essential for controlling header visibility based on record position within your report. OnLastRecord Function Function Description: This function returns TRUE when the current record being evaluated is the last record in the report. Returns: Boolean Value (TRUE or FALSE) Action: This function evaluates each record and returns TRUE only when processing the final record in the report. You can use this in conditional suppression formulas to control when headers ...
Read MoreIdentify the database used for backend in ABAP
In SAP ABAP development, identifying the backend database system is essential for writing database-specific code and understanding system architecture. ABAP provides built-in system classes to retrieve this information programmatically. Using CL_DB_SYS Class The CL_DB_SYS class provides the DBSYS_TYPE attribute to fetch the current database type. This system class is available in all SAP systems and returns a standardized database identifier. Example Here's how to identify the database system using ABAP code − DATA: lv_db_type TYPE string. " Get the database system type lv_db_type ...
Read MoreAccessing import parameters passed to a function module in SAP ABAP
ABAP provides several approaches to access import parameters passed to a function module dynamically. This capability is essential when you need to inspect or process function module parameters at runtime without knowing their structure beforehand. Using RPY_FUNCTIONMODULE_READ Function Module ABAP has a function module named RPY_FUNCTIONMODULE_READ which lets you extract metadata about the function module. To be more precise, it lets you extract the parameter structure of function module and once you know the parameters then you can access them dynamically. But it comes at a cost − if ...
Read More