Found 594 Articles for SAP Basis

Usage of Operator +n and (n) to pass data in ABAP

V Jyothi
Updated on 13-Feb-2020 12:50:32

179 Views

If my date format is in the form DDMMYYYY then Z_Period(4) equals DDMM so (4) means first four characters.If my date format is in the form DDMMYYYY then Z_Period +4 equals YYYY so +4 means after the first four characters.So If I say Z_PERIOD+2(2) then this would result MM- i.e. 2 characters after first 2.Let us see how to use them in a program −\Sample program to understand use of +n and n bit operators data: lv_text(10) type c. lv_text = "World". write: / lv_text+2(2).Output of this code would be “rl”“+n” specifies a string offset“n” specifies length of the ... Read More

Managing user sessions in SAP UI5 application

Daniol Thomas
Updated on 18-Dec-2019 08:42:39

659 Views

You can make use of setTimeout and clearTimeOut functions. In order to trace the activity of the user, you can either make use of mouse move event or key press event or even both.ExampleYou can reset the timer on the occurrence of either of the two events.document.onmousemove = timeOut; document.onkeypress = timeOut; function timeOut () {    clearTimeout();    setTimeout(sessionTimeout, ); }

Fetching attribute of SAP Webdynpro component in new component

Krantik Chavan
Updated on 18-Dec-2019 08:41:11

126 Views

You need to do the below steps in order to pass values from one Webdynpro component to another:Create both componentsIn the first component, create a method which will call the second componentCreate a parameter in the context of the first component which will be passedCall the first component; once the URL has been generated just append the parameter which needs to be passed.

Learning SAP HANA and scope with ABAP-HANA or BI-HANA

Nishtha Thakur
Updated on 30-Jul-2019 22:30:20

210 Views

While you have a valid point that most of the SAP HANA projects are coupled with varied SAP landscape but there does exists a lot of projects which involve only native SAP HANA development.It entirely depends on your interests and knowledge base but sound understanding of the core concepts around data ware housing needs to be clear, if you are planning to build anything utilizing the base concepts.Presently, as per my understanding, clients prefer ABAP on HANA as they have one or other existing ABAP solutions. So, any enhancement using ABAP seems more sensible and appropriate.So I will suggest you ... Read More

Performing Null check using HANA SQL Script

Smita Kapse
Updated on 18-Dec-2019 10:06:46

3K+ Views

You can go for using either NULLIF or COALESCE function to serve your requirement.NULLIF (expression, expression"): This function will return the same type whatever is specified as the first expression.Basically, NULLIF returnsThe first expression if the two expressions are not equal.NULL of type of first expressions if the expressions are equalThe other function available is COALESCE which basically checks if the first Value provided is NULL then it will return the second value.Examplec = COALESCE(b , a)If b is null then the function will return an otherwise b. So If you need to put a null check and use some ... Read More

Using SSIS 2014 with Visual Studio 2012 to integrate with SAP

Anvi Jain
Updated on 30-Jul-2019 22:30:20

142 Views

You made a small mistake but a mistake having a big impact. SSIS 2014 does not support VS 2012 in your case. Just switch to VS 2013, your problem will be resolved.

Using datatype/element for destination in SAP ABAP

Amit Sharma
Updated on 13-Jun-2020 06:50:29

136 Views

You can use RFCDEST.RFCDEST statement specifies the destination value for a Remote Function Call connection and gateway information.Supported Job Types:This statement are optional for the following job types:SAP Batch Input SessionSAP Business Warehouse InfoPackageSAP Business Warehouse Process ChainSAP Data ArchivingSAP Event MonitorSAP Job CopySAP Process MonitorSAP R/3Basic DataTable  RFCDES  Destination table for Remote Function CallField  RFCDEST  Logical Destination (Specified in Function Call)Position 1Syntax to be used:RFCDEST destinationUsing Parameter destinationYou need to specify the destination for the RFC connection and gateway information for an SAP R/3 system. This destination is the destination that is specified in the connection properties file during ... Read More

Debugging a failed Insert statement in SAP ABAP

Rahul Sharma
Updated on 30-Jul-2019 22:30:20

264 Views

Note that in SAP ABAP, sy-subrc == 0 means success. You can use breakpoint before your INSERT statement to ensure if it is a success or not. You can check the possible return value by bringing cursor on it and then press F1 key.Try checking if/else branch in your code snippet.

Generating range of numbers 1…n in SAP HANA

Ali
Ali
Updated on 18-Dec-2019 06:24:21

305 Views

You can use For loop as below:FOR START_CID IN 1..1000 DO    INSERT INTO "TEST_TABLE" VALUES(START_CID,''); END FOR;You can also use a Generator like this:INSERT INTO "TEST_TABLE" SELECT GENERATED_PERIOD_START as CID, '' as CNAME from SERIES_GENERATE_INTEGER(1,1,1001);

Using > operators in SAP HANA

Johar Ali
Updated on 14-Feb-2020 07:50:08

103 Views

You probably need to use cdata sections in your query. The term CDATA means, Character Data. CDATA is defined as blocks of text that are not parsed by the parser, but are otherwise recognized as markup. The predefined entities such as , and & require typing and are generally difficult to read in the markup.Following is the syntax for CDATA section −You have to wrap your queries in CDATA as shown below −         50.    ]]>     For more details about XML CDATA, you can refer below link −https://www.tutorialspoint.com/xml/xml_cdata_sections.htm

Advertisements