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
SAP Basis Articles
Page 28 of 50
Ending a connection with SAP Instance and stop scripting
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;
Read MoreConnecting system with SAP system using a Web Service
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.
Read MoreIn SAP Crystal Reports XI, return records that match multiple conditions
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 MoreCreating a variable with dynamic variable type in SAP ABAP
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 MoreUsing constants in ABAP OO method
Your INCLUDE should only contain definitions of constants nothing else and then the answer is straightforward.Select Goto → Class - whichever local definition and then add an INCLUDE statement. This will expose all the constants “INCLUDE” in your implementation.
Read MoreIs it possible to delete the actives while you are running a loop over an internal table in SAP ABAP?
DELETE command will have a result. You should make sure that once you delete the row, there should not be any reference or use of row subsequently in the loop. The best is to use CONTINUE as soon as you perform deletion. I will suggest avoiding “DELETE lt_itab INDEX sy-tabix” because it will change the sy-tabix i.e. table index. In case if you just want to delete the current row in the loop then you can simply use.“DELETE lt_itab”One more thing if you are using statement “DELETE lt_itab FROM ls_wa” then whether knowingly or unknowingly, you are deleting the same lines ...
Read MoreSorting List in SAP UI5 project
Yes, you can. You can use the available sorter property available on the List. It lets you specify all the required details. For e.g. −I have specified the employee collection to be sorted on the basis of the name of the employee and specified that the sorting should be in descending manner. It should also consider grouping while sorting the data.
Read MoreNot able to get the difference between two dates (SAP)
It’s a very basic operation that you do in database. You can try using DateAdd function available and use the date overload of the function. You need to pass one date as negative so in actual the difference is calculatedSELECT DATEADD(d,-[dateTwo], [dateOne]) AS 'Difference in Dates' FROM [TABLE]Here‘d’ refers to the day.
Read MoreUsing a SQL View in SAP BusinessOne
Yes, it is possible to use a view in Business one client and you can use it too. Please find below a sample format that you should be using to query the view in business one environment −SELECT FROM [dbo].[]I have done the same and it is working for me.
Read MoreConnect to dynamic URL within OData in SAP project
You can try and create a URL in your code which you can read from config or XML.Here is a sample code snippet −String uri = // Can read from config or anywhere string odQuery = "?$format=json" var req = WebRequest.Create(uri+"/"+ odQuery); req.Method = "GET"; var streamreader = new StreamReader(stream: request.GetResponse().GetResponseStream()); string response = streamreader.ReadToEnd(); //json responseThis is a sample code snippet but you can modify it as per your use case.
Read More