How to translate a python string according a given dictionary?

Rajendra Dharmkar
Published on 12-Dec-2017 14:50:19
We can use the method translate() which returns a copy of the string in which all characters have been translated using table (constructed with the maketrans() function in the string module), optionally deleting all characters found in the string deletechars.  examplefrom string import maketrans   # Required to call maketrans function. ... Read More

While changing Partner number, VBA code keeps running while interacting with SAP system

Mohd Altamas
Published on 12-Dec-2017 09:34:35
The best possible solution to avoid this issue is by adding breakpoints to the best places. This issue is common with VBA and C# while debugging code includes COM libraries.

How to convert lowercase letters in string to uppercase in Python?

Rajendra Dharmkar
Published on 12-Dec-2017 12:55:07
You can use the upper() method in Python to convert all lowercase letters in string to uppercase. For example:>>> 'HellO'.upper() HELLO >>> 'leaning tower of pisa'.upper() 'LEANING TOWER OF PISA'

How to invert case for all letters in a string in Python?

Rajendra Dharmkar
Published on 12-Dec-2017 12:37:03
String class has a method called swapcase() for swapping case of all letters. You can use it as follows:>>> 'Hello World 123'.swapcase() 'hELLO wORLD 123' >>> 'Make America Great Again'.swapcase() 'mAKE aMERICA gREAT aGAIN'

Using SAP T-code SM37 to check background jobs in SAP system

Paul Richard
Published on 08-Dec-2017 14:13:26
In SM37 you can only see the scheduled background jobs as it is not used for foreground jobs. Below shows an initial screen of SM37 Transaction code:

Using Aggregate function to fetch values from different tables in SAP

Published on 08-Dec-2017 14:09:18
First of all, the example you gave has different description for a fund. So, you should know which one to be kept. If you want to keep any description, you can use the below query using aggregation functionsSELECT    X1."FundName"    , min( X0."Dscription")    , X0."FundId" FROM INV1 X0 ... Read More

Inserting an Array to a table in SAP HANA database

Published on 08-Dec-2017 13:22:25
As far as I know, there is no direct way of inserting an Array using SQL query. You will first have to combine the columns (EMPL_Id + Skill Id) using the code and then do a bulk insert to the database.

Edit an ABAP Program using Transaction SE93, SE80

George John
Published on 08-Dec-2017 13:20:12
You need to go to SE93 and input your Transaction code. It will display program name behind your transaction code. You can edit the programs using SE80 and SE38.  Below shows Transaction code: SE93 Following shows Transaction Code SE80 to edit an ABAP program by opening ABAP Development workbench: ... Read More

Viewing field names or tables names of the forms in SAP Business One

Jai Janardhan
Published on 08-Dec-2017 13:03:40
It is possible that the older version of SAP B1 may not show you all the fields of all the forms. If you have the latest version, you should be able to see the data sources that are mapped to given field. You need to open the forms in SAP ... Read More

How to remove all trailing whitespace of string in Python?

Rajendra Dharmkar
Published on 12-Dec-2017 11:45:39
We can use the method rstrip() which returns a copy of the string in which all specified chars have been stripped from the end of the string. The default char to be trimmed is whitespace. For example:>>> '   Hello   '.rstrip() '   Hello' >>> 'Ninja Turtles the movie ... Read More