Convert SYDATUM Date Type to MM-DD-YY Format in SAP ABAP

Alankritha Ammu
Updated on 13-Feb-2020 10:53:43

5K+ Views

It depends if you want to write it to a list screen or you want to convert it to a text variable. To write it to a list screen, you can use below code −WRITE I_my_dateMM/DD/YYYYTo convert it to a text variable, you can use below command −WRITE l_my_dateTO l_my_text MM/DD/YYYYIf you want to set the date in SAPscript form, you can use SET DATE MASK command. You can specify date fields to be printed in specified format −/: SET DATE MASK= 'date_mask'In the date mask, you can use the following codes −DD: day (two digits) DDD: day name - ... Read More

Using an Angular App as SAP Fiori Application

Anjana
Updated on 13-Feb-2020 10:51:11

711 Views

As you mentioned, you are moving to SAP so it means you are moving to SAP HANA Cloud platform or backend SAP system. You can continue with just HTML Angular application that can connect to the backend via an OData service. Angular JS is JavaScript library that adds lot of features to your application. One thing to note here that if you are planning to use Fiori Launchpad, it could be an issue.Following are the advantages/disadvantages of using angular framework:AdvantagesUsing Angular, you can develop complex High interactive rich internet web application.Angular application can be easily integrated with third-party library like Kendo ... Read More

What Happens If MySQL Query Returns No Rows

varun
Updated on 13-Feb-2020 10:33:15

2K+ Views

From the output returned by MySQL, it is very much clear that how many rows are there in the result set along with the execution time.ExampleFor example, in the following MySQL output we can see there are 3 rows in the result set.mysql> Select * from ratelist ORDER BY Price LIMIT 3; +----+------+-------+ | Sr | Item | Price | +----+------+-------+ |  5 | T    |   250 | |  1 | A    |   502 | |  2 | B    |   630 | +----+------+-------+ 3 rows in set (0.00 sec)But suppose if MySQL query has ... Read More

Convert Byte Literals to Python Strings

Rajendra Dharmkar
Updated on 13-Feb-2020 10:32:41

486 Views

To convert byte literals to Python strings, you need to decode the bytes. It can be done using the decode method on the bytes object.  example>>> b"abcde".decode("utf-8") u'abcde'You can also map bytes to chr if the bytes represent ASCII encoding as follows −bytes = [112, 52, 52] print("".join(map(chr, bytes)))Outputp44

Use of Underscore Keyword in Java 9

raja
Updated on 13-Feb-2020 10:29:35

2K+ Views

In earlier versions of Java, the underscore ("_") has used as an identifier or to create a variable name. Since Java 9, the underscore character is a reserved keyword and can't be used as an identifier or variable name. If we use a single underscore character as an identifier, the program fails to compile and throws a compile-time error because now it is a keyword and can't be used as a variable name in Java 9 or later versions.Examplepublic class UnderscoreKeywordTest {    public static void main(String args[]) {       int _ = 50       System.out.println(_);   ... Read More

Ending a Connection with SAP Instance and Stop Scripting

Hayat Azam
Updated on 13-Feb-2020 10:24:41

2K+ Views

This can be resolved by ensuring that you destroy all reference to public objects at the end of your script.In Excel VBA, you can use the following to do this −Set session = NothingIn C#, you should be using below −obj = Null;

Connecting System with SAP System using a Web Service

Shahyan Ali
Updated on 13-Feb-2020 10:23:30

731 Views

The best solution of this is to regenerate web service code the client system. Navigate to Add Service Reference in Visual Studio and regenerate WSDL code.

Return Records That Match Multiple Conditions in SAP Crystal Reports XI

Raja Ali
Updated on 13-Feb-2020 10:22:43

226 Views

It is advisable to use functions to pass such filter conditions in CR. Also try changing the order of your condition like −({PR.cov} = "A" and {PR.cov}="B") or {PR.cov} = "A" Try using function like this: {@A}:if {PR.cov} = "A" then 1 else 0To create custom functions in Crystal Report, navigate to Report Menu → Formula Expert → Right Click on Custom Functions → NewIt is advisable to use custom functions when you have multiple parameters to pass in the condition. You can also use the following when you have two string parameters −( 'A' IN {?cov} OR {PR.cov} IN ... Read More

View List of Tables in Another MySQL Database

seetha
Updated on 13-Feb-2020 10:16:22

195 Views

With the help of SHOW TABLES From Database_name query, we can see the tables of another database. Here Database_name is the name of the database which we are not using currently. Consider the following example in which we run the query for getting the list of tables in database name ‘tutorial’.mysql> show tables from tutorial; +--------------------+ | Tables_in_tutorial | +--------------------+ | employee           | | showzerofill       | | student            | +--------------------+ 3 rows in set (0.00 sec)

Creating a Variable with Dynamic Variable Type in SAP ABAP

Fendadis John
Updated on 13-Feb-2020 10:12:00

3K+ Views

You can use RTTS related API to create a Standard table like RANGE which has components like 'LOW', 'HIGH', 'EQ' and 'OPTION'data:    rr_data              type ref to data,    rt_range_string      type range of string,    rs_range_string      like line of rt_range_string,    rt_component         type abap_component_tab,    rs_component         type line of abap_component_tab,    rt_range_components  type abap_component_tab,    ro_struc_descr       type ref to cl_abap_structdescr,    ro_table_descr       type ref to cl_abap_tabledescr,    ro_data_descr        type ref to cl_abap_datadescr.field-symbols type ... Read More

Advertisements