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
SAP Articles
Page 45 of 91
Checking tables in a schema in SAP HANA database
You can check this detail using a SQL query in HANA. You have to pass schema name in Where condition. Try running below SQL query and this will show you list of all tables in a schema.Select distinct BASE_OBJECT_NAME from "SYS"."OBJECT_DEPENDENCIES" where BASE_SCHEMA_NAME like 'AF_HANA';AH_HANA- Schema name
Read MoreChecking all the list of fields for a table in SAP HANA
You can check this detail using a SQL query in HANA. You have to pass schema name in Where condition. Try running below SQL query −SELECT "DEPENDENT_OBJECT_NAME" from "SYS"."OBJECT_DEPENDENCIES" WHERE "BASE_SCHEMA_NAME" = 'AF_HANA' AND "BASE_OBJECT_NAME" = 'STORE' AND "DEPENDENT_OBJECT_NAME" like '%hier%';
Read MoreUsing Where-Used option in SAP HANA Modeling
With use of Where-used functionality you can easily find this information. Right click on object name → Where-Used
Read MoreDeleting inactive objects in SAP HANA
In SAP HANA, you can delete all inactive objects in workspace. In HANA Modeler Perspective → Delete Inactive Objects..You can also revert to last active version if exists.
Read MoreAdding rows in an internal table with header line in SAP ABAP
Note that you shouldn’t use headers with internal tables. As you are using it, and header of in_table2 is empty. Use the loop to print it as below −LOOP AT in_table2. "here in_table2 means table (an internal table) WRITE / in_table2. "here in_table2 means the header of the table (a structure) ENDLOOP.When you have headers with internal tables, you shouldn’t use it in the same way. You should use field symbols for looping and append like this −FIELD-SYMBOLS: LIKE LINE OF in_table2[]. LOOP AT in_table2[] ASSIGNING . WRITE / . ENDLOOP.
Read MoreChecking transaction list waiting for lock-in SAP HANA
M_BLOCKED_TRANSACTIONS System View is used to provide a transaction list waiting for locks.You can run the following SQL query in the editor −SELECT * FROM M_BLOCKED_TRANSACTIONS;Details available under M_BLOCKED_TRANSACTIONS System View in SAP HANA
Read MoreTransforming XML file into fixed length flat file in SAP
This is an EDIfact invoice. Try using the script, and it can help − ERROR: The maximum length of "TABNAM" is 10 characters. ERROR: The maximum length of "MANDT" is 3 characters. ERROR: The maximum length of "ACTION" is 3 characters. ERROR: The maximum length of "KZABS" is 1 character. There are various sites which provide a built-in script to convert your EDIfact to XSLT. Check this site and it may also help −https://www.codeproject.com/Articles/11278/EDIFACT-to-XML-to-Anything-You-Want
Read MoreMaintaining print program, routines, and forms in SAP in QM02
You configure print program and output controls in IMG. Run T-Code: SPRO →Search for Output control or Print controlCheck Shop Papers for Notification types and mention Shop Papers has the ABAP Form and print Program as shown below -
Read MorePassing to method geticon in SAPUI5
SAP UI supports custom formatter functions. formatter="function" is used to specify a function to format cell data prior to display.formatter="function"Try using formatter function as below −icon : { parts : ["answer"], formatter : function(answerValue){ return self.getIcon(answerValue); } }Refer below link to know more about custom formatter functions −https://sapui5.hana.ondemand.com/#/topic/07e4b920f5734fd78fdaa236f26236d8
Read MorenStore data in format of XML string in SAP HANA system
In older SAP HANA versions, no XML functions were provided. With HANA 2.0, these two functions are provided- XMLEXTRACT and XMLEXTRACTVALUE for extracting XML string in SAP HANA.Use of XMLEXTRACTXMLEXTRACT(, [, ])Syntax to use −Specifies an XML document of type CLOB, NCLOB, VARCHAR, or NVARCHAR.Specifies an XPath expression of type VARCHAR or NVARCHAR.Specifies a namespace declaration of type VARCHAR or NVARCHAR.DescriptionReturns the matching XML element. The return value is of type VARCHAR/NVARCHAR or CLOB/NCLOB depending on the type given for .If an XML element is empty (for example, ), then an empty result is returned. If an XML element ...
Read More