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
Storing configuration so that it doesn’t transfer to database in SAP system
I don’t think it can be automated so that configuration is not copied to the database. Try checking SAP Transport and Change Management detail, it could be possible by making some changes in Transport configuration.
Read MoreCondition Variables within Sub-Query in SAP
One line answer - Sub-Queries are not allowed. But if you need to handle your scenario, then you can do the following: Encapsulate your entire query into a stored procedure and then use the stored procedure. Create a view. The view is created to handle either your main query or sub-query. Create a table level variable and store the end results of view in it and then go ahead and fetch the value of table variable in the main query.
Read MoreUsing 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 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