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 71 of 91
Getting error message: Scalar type not allowed in SAP HANA
Few points about your code to create a Stored Procedure, that you can edit and tryPROCEDURE "SLT_DELETE"."HCDW.IT.IT::TO_TIMESTAMP_CALL" (IN IN_DATE DECIMAL(15), OUT OUT_DATE TIMESTAMP) LANGUAGE SQLSCRIPT AS --DEFAULT SCHEMA --READS SQL DATA AS BEGIN select to_timestamp(IN_DATE) into OUT_DATE FROM DUMMY; END;In Line32, you have used below:SELECT: ORGID_ARTIKEL intoHowever correct syntax should be like:SELECT "ORGID_ARTIKEL" into
Read MoreCreating Index in Column based tables in SAP HANA
Note that an index not necessary to be NOT NULL. You can create an Index in SAP HANA database by using below query:CREATE INDEX IDX_MY_INDEX ON TABLE1 (MY_COLUMN);To know more about SAP HANA database, Modeling, and Administration features, you can refer our SAP HANA Text and Video tutorials:https://www.tutorialspoint.com/sap_hana/https://www.tutorialspoint.com/sap_hana_online_training/index.asp
Read MoreUsing SAP OLE code to take an internal table and paste it into an excel file
Note that you have to use “double quotation” for all the text you have to put into one cell and then connect cell with 0X09 and 0X0A for next column and next row respectively.Check the below code as it fills two cells with 2 lines:CONSTANTS: nextC TYPE abap_char1 VALUE cl_abap_char_utilities=>horizontal_tab, nextR TYPE abap_char1 VALUE cl_abap_char_utilities=>newline, quot TYPE abap_char1 VALUE '"'. DATA: buffer TYPE string. CONCATENATE quot 'R1C1L1' nextR 'R1C1L2' quot nextC quot 'R1C2L1' nextR 'R1C2L2' quot INTO buffer.
Read MoreDisplaying Source code of RFC in SAP system
You can check this information in table REPOSRC and column name is “DATA”.You can also make use of RPY_FUNCTIONMODULE_READ_NEW - this will return the source as well. This Function module uses changing Parameters.
Read MoreExposing employee master data from SAP HR system using Web Service
In a general scenario, when you have ICF configured you can expose SAP system business objects and jobs via BAPI. It is very easy to create and expose BAPI as a web service. As there are only few web services for SAP HR module in SAP system however you can transform a BAPI or ABAP function into a web service. If there is no such function you can create one easily.To find details about BAPI from Function module, use T-Code: SE37 and enter Functional module name for SAP HR module. Below is the list of existing HR function modules in ...
Read MoreExposing xsjs file data through web browser in SAP HANA
Note that you have to ensure that Port number 80+ should be open on network. Also URL you are using should be properly built. Below is correct path:server:port/repository_path/file_nameIn your case, you should be using:host: hanacloud port: 8000 (80 + instance_number) SAP HANA Repository tree: mdo -> sap -> sflight -> test -> test.xsjsSo your URL should be in this format:hanacloud:8000/mdo/sap/sflight/test/test.xsjs
Read MoreWriting a material on SAP system via .NET Connector
Once you create material, you need to call BAPI- BAPI_TRANSACTION_COMMIT. “BAPI_TRANSACTION_COMMIT” is called to COMMIT a database operation. As COMITT statement can’t be called inside BAPI, we call this BAPI to complete COMMIT.Let us say you are editing some table fields in BAPI- as per failure or success, you can perform a COMMIT or ROLLBACK.To perform a COMMIT call BAPI_TRANSACTION_COMMIT. Below is sample COMITT:CALL FUNCTION 'BAPI_TRANSACTION_COMMIT' * EXPORTING * wait = "bapita-wait IMPORTING return = "bapiret2 . " BAPI_TRANSACTION_COMMITYou can see full documentation about BAPI_TRANSACTION_COMMIT:FU BAPI_TRANSACTION_COMMIT____________________________________________________Short TextExecute external Commit when using BAPIsFunctionality:This method executes a COMMIT WORK ...
Read MoreCalling SAP Web Service to get data in Flash dashboard
You can also try hosting your Flash application on SAP box. Following approaches can be used:Using Transaction: SICF, you can change the default host’s default service to point to BSP application and then add crossdomain.xml file as MIME.You can also configure ICM to manage this and it sits between the outside world making HTTP, HTTPS, SMTP requests and the SAP System.Method 1:First, you need to create a BSP application -> Create -> MIME Object and import crossdomain.xml file and activate the application. Next is to execute transaction SIC with default settings -> Double click the default_host, go to the Default ...
Read MoreHow to have a structure with a table in ABAP?
The basic rule while specifying a table within a structure is that you have to give a non-unique constraint to that field.TYPES: myType TYPE TABLE OF string WITH NON-UNIQUE DEFAULT KEYThen use this in the structure definition:TYPES: BEGIN OF ty_itab, ….. myTable type myType, …….. TYPES: END OF ty_itab.
Read MoreFinding items in SAP Tree using Function
When you use string “1\1” in Java, it gives a valid path and returns the right key. You need the following code:SapTree tree = ...; // initialize somewhere String parentKey = tree.findNodeKeyByPath("1"); tree.expandNode(parentKey); String key = tree.findNodeKeyByPath("1\1");
Read More