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 60 of 91
Checking existing password policy of SAP HANA system
You can check this information under New User in SAP HANA. The below snapshot shows the New User dialog in SAP HANA Studio and the password rule that is displayed when hovering over the password field.
Read MoreSetting password expire notification in SAP HANA
Parameter password_expire_warning_timeDefault Value 14 (days)Parameter definitionNotification is transmitted via the database client (ODBC or JDBC) and it is up to the client application to provide this information to the user.If you enter the value 0, the user does not receive notification that his or her password is due to expire.The system also monitors when user passwords are due to expire and issues a medium priority alert. This may be useful for technical database users since password expiration results in the user being locked, which may affect application availability. It is recommended that you disable the password lifetime check of technical ...
Read MoreUsing database view in SAP HANA
A view in a database is defined as Virtual table which derives its data from one or more columns of one table or multiple tables. A view can be created using tables of one or more database and is stored in database where it is created.You can find views in SAP HANA Studio under schema name −
Read MoreLogging in SAP using command line
sapshcut.exe command can be used to log in to SAP from command line as shown in below example:ProcedureAdd the directory that contains the sapshcut.exe command to your system or user path. The sapshcut.exe command is installed as part of the SAP client into the following directory: C:\Program Files\SAP\FrontEnd\SAPguiTo add additional directories to the system or user path on Windows systems, select Control Panel > System > Advanced > Environment Variables.The .bat file must be named sapshcut.bat must be located in your default path preceding the sapshcut.exe file.The following parameters are passed to the sapshcut.bat file when called from a predefined ...
Read MoreChanging program title in SAP
SET TITLEBAR function should be called from a module that is called from PBO of your screen.The title which you are providing should be active. This can be checked by loading your program in SE80 and check the program information in the tree to the right.
Read MoreUsing SAP Gateway service in SAP Web project
Please executes the below steps to get the services added −Define service in your manifest.json file?"sap.app": { [...], "dataSources": { "mainService": { "uri": "Path of your service", "type": "OData", "settings": { "odataVersion": "X.X", "localUri": "localService/metadata.xml" } } }, [...]The model definition should be implemented in your manifest.json file?"models": { [...], "": { "dataSource": "mainService", "settings": { "metadataUrlParams": { "sap-documentation": "heading" }, "defaultBindingMode": "TwoWay" } } },
Read MoreHiding SAP ABAP table control column
You can use the structure CXTAB_CONTROL that has the following components:INVISIBLE C(1) Flag (X or blank) for visibility of entire table control.You can use sample program: RSDEMO02 that allow you to modify properties of table control and view the results.When you use this Table control INVISIBLE, this changes the content to “xxxxxxxxxxxx” like a hidden password. If you want to hide the complete column including data and header, your code should be like this −MODULE MODIFY_100 OUTPUT. DATA wa_tabctrl TYPE cxtab_column .looping the table controlLOOP AT TABCTRL-COLS INTO WA_TABCTRL. IF WA_TABCTRL-NAME = 'POSNR'. When you get on the desired screen you ...
Read MoreChecking SAP configuration for Plant Maintenance
Plant maintenance (PM) status can be categorized into two status:System status and User status. System status is used by the system for recognizing business transactions for a certain object type. Ideally System status cannot be changed by Users. They are defined by SAP and hence are immutable.Whereas User status relies on how it is set in the configuration. User Status is defined as per the business requirements.To modify the User status follow the below stepsGo to SPRO → Plan Maintenance and Customer Service → Maintenance and Service Processing → Maintenance and Service Orders → General Data → User status for ...
Read MoreGetting number of rows in table in an itab in SAP
There is a function “LINES” that can be used to get the number of lines in a table. Here is the code that can be used −DESCRIBE TABLE LINES VR1The variable VR1 will contain the number of rows.
Read MoreMaking an SAP ABAP program to wait
You can use WAIT to hold the program for few seconds. Here is the syntaxSyntaxWAIT UP TO 36 SECONDSHowever, you need to be careful about using it. WAIT does an implicit commit. So you need to be sure that the commit does not corrupt the database. It also releases the work process.An alternative is to use below code −CALL FUNCTION 'ENQUE_SLEEP' EXPORTING seconds = 36.
Read More