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
Database Articles
Page 546 of 546
Using memory analyzer in SAP
There are lots of free and proprietary tools to do the same. You can use Memory Analyzer project done by SAP. It lets you find memory leaks against in-memory objects via simple SQL statements. Also, you can use JHAT (Java Heap Analysis tool) command line tool to examine the memory. It lets you examine heap memory via histogram and can be of good help. Also, you can go for HeapWalker from Netbeans or Visual VM. Also, Eclipse has Eclipse memory analyzer which is a freeware and can handle good size with dump and provides a fair deal of memory analysis.
Read MoreHow to use SUM function for NUMC type field?\\n
NUMC is numeric text. As this is text, SUM function cannot be implemented as it is of type varchar in the database.There is no simple solution to do it. The one method is to copy the data to internal tables, convert the NUMC data into DEC by looping through all the rows, SUM and GROUP them and then convert back the DEC values back to NUMC values.
Read MoreGetting an error invalid Object Name in SAP Business One
It would be easy to guess if you have shared the full query. It seems you have not defined #temp_table. You might need to define temp table as global but it could sum up to other issues.
Read MoreIn SAP Business One SDK, filling a gridview and button saves in database
This can be achieved in multiple ways. You can either use a SAP DI documents, an open SQL or use data transfer workbench for this purpose.You can use a direct SQL write as this is one of straight way to do this. It is also possible to use SAP-DI Documents object to iterate over the Purchase Orders.One more option is using Data Transfer Workbench (DTW), where you export it to a file and then using DTW. It also provides error handling incase any exception occurs.
Read MoreGenerate Database diagram within SAP
Generating the database diagram completely as generated in SQL server or other DBMS is not possible over here. But there are couples of ways that can be of small help in your case. Firstly, you can refer to Object Model guide present in the SAP market place. This guide will explain you the most common relations between the most popular and common business objects It does not cover each and every bit of the database but the most common bad highly usage one are covered. Secondly, if required you can generate diagram of a single table by displaying it in ABAP transaction ...
Read MoreCan’t create a Dictionary Object: View by adding two db tables
When you create a view, it is created on top of multiple database tables using an inner join. Note that basis table of database views should be transparent tables.To create a view on 2 tables, you have to enter the primary table you want to maintain and place the cursor in that field and click on the button below the list of tables and select the other table to add the view. If you are not getting this option, it means Relationship is wrong.To know more about database Views: https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abenddic_database_views.htm
Read More