Found 694 Articles for SAP HANA

Finding minimum value across different columns in SAP HANA

Rishi Raj
Updated on 05-Dec-2019 09:20:19

388 Views

You need to use LEAST instead of min as below:“SELECT ID, LEAST(DAY_1, DAY_2, DAY_3) FROM ...” Please make sure that none of the values in your column in “NULL”.

Storing Personal Information in LDAP/AD or in SAP HR module

Daniol Thomas
Updated on 30-Jul-2019 22:30:20

106 Views

LDAP can store sensitive information but it is not recommended to store sensitive information in LDAP from a security point of view. This information should go to some HR information or you can also develop a middleware to store this information. You can use EMP ID to track this information back to middleware or LDAP.

Make a custom function call without using SAP NetWeaver

mkotla
Updated on 30-Jul-2019 22:30:20

92 Views

I know a couple of ways how can you can go ahead and use the RFC you have created from SAPUI5 but without using SAP NetWeaver.You can try to create a web service or a REST service which uses the RFC that you have created. Host the service in the SAP environment and then you can use the service in SAP UI5 with the help of URL.Or you can go for a SICF service and have a handler for the service. In the handler of the service, you can have the same logic for fetching the content as you have ... Read More

Different ways to interact with SAP system from a web application

Lakshmi Srinivas
Updated on 14-Feb-2020 09:59:21

572 Views

Using any of above method depends on what you are connecting, and version of your SAP system. You can use Standard BAPI’s to read or update a service order. BAPI is a Remote Function Call RFC with a standard API.In latest releases of SAP ERP, many of Function Modules are exposed as Web Services.In SAP system, you need to follow some administration task to allow access to SAP system. Following T-Codes can be used: SICF or SOAMANAGER.When you install ABAP Application Server, all the services are available in an inactive state. When a call is made to a URL, multiple ... Read More

Using SAP connector 3.0 on an MVC application

Krantik Chavan
Updated on 06-Dec-2019 11:03:47

203 Views

Try adding a new row before calling SetValue. Please check the below:employeeHoli.Append(); employeeHoli.SetValue("ColumnName", "0000345");You use a table parameter that can hold multiple lines. You have to append the above lines that will return some structure and you can fill that structure.

Negation logic in SAP ABAP

vanithasree
Updated on 05-Dec-2019 09:46:16

339 Views

You can use BOOLC to sort out your requirement. It should be like thisVarbool= BOOLC( NOT Logical operation)But be clear in your implementation, as ABAP does not have true bool type. It does not store true or false in bool type rather it stores ‘X’ or ‘’ for true and false respectively.You can also try to use XSDBOOL instead of BOOLC.

Passing data from one report to another in ABAP using SUBMIT \\\

Vikyath Ram
Updated on 30-Jul-2019 22:30:20

211 Views

There doesn't seem to be any error in your syntax. Please verify if you declared the variables correctly. In case they are defined correctly, try the extended syntax check to see the error. The extended check can be done by going to PROGRAM => Check => Extended Syntax Check.

Updating default value of new column in SAP system

Rishi Raj
Updated on 30-Jul-2019 22:30:20

275 Views

It is not good practice to update default values to a column as this will not be visible directly in the system and will not be picked by CTS. Also, there is no option in the SAP/ABAP environment of adding default values to the table column. If you choose to make the new column have NON-NULL values, you will have to manually update default values and it will take a lot of time to modify the table.  The best way is to choose your default value as spaces, zeroes and so on depending upon the type of column.

Information for obsolete functions in SAP ABAP

Vikyath Ram
Updated on 05-Dec-2019 10:21:38

211 Views

Generally, the information is present in the obsolete function module documentation itself. Here is snapshot of information for “DOWNLOAD” function.

Error while using LOOP…..WHERE in SAP ABAP

Rishi Raj
Updated on 30-Jul-2019 22:30:20

230 Views

LOOP….WHERE condition was included recently in ABAP. Could you please verify your version?  This will work only on a version of 7.0 Ehp2 or higher.

Advertisements