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 27 of 50
Query MDG tables via SAP Studio
An answer to your question is a big “YES”. You can execute queries against the tables either if you are using an ABAP program or also you can execute these queries from native SQL environment.For E.g.DATA: lt_TBL LIKE TABLE OF KNA1. SELECT * from KNA1 INTO lt_TBL up to 5 rows.The snippet above lets you get the 5 rows from table KNA1 table and store in an internal table for further use.
Read MoreFetch the modified date of table in SAP HANA
I think if you would have done some easy research or gone through the available documentation, then you would have got the answer. The reason being you already know the partial answer (SQL example as you said).In SAP HANA database, we have an analogous table “SYS.M_TABLE_STATISTICS”. Just query the table for a table on the basis of last modified date by ordering it. With the use of “M_TABLE_STATISTICS” system view is not transactional. When a DML statement is rolled back, count values in the view remain unchanged.
Read MoreAllow only a possible set of values to choose from while setting value in SAP ABAP
If you need to place a restriction as you said, you can go ahead with using predefined domains on the column or text field.Select Table Field -> Data Element -> Specify DomainWhile specifying the domain you can set the permissible set of values which you want the table field to be set.However please don’t consider as a constraint that we place in database tables, the domain login can still be broken through code.
Read MoreWorking on a cost center report in SAP
I would say even if you are a newbie, it will not be a tough one to generate such report. You have requested for any details about how work orders are related to cost center.All the orders whether they are internal or work, they are linked to a specific cost center. So overall each order will have a cost center and in order to find to which cost center it is associated, you can refer to following tables: COEP or COEJ of Controlling. You can find details about cost center, order, and others over a period of time or year.COEP ...
Read MoreUnderstand more about roles in SAP system
On a high level, both the tables are almost same as both of them deal with storing details about profiles which are generated for a role.Let’s talk about AGR_PROF first. It stores the text of the generated profile which is dependent on language. It stores profile Id as well. So, it results in having only at max one possible combination of a profile and language which is referred to a master profile.To view further details about this Table “AGR_PROF” and the data within it using the relevant SAP transactions such as SE11, SE80 or SE16. Below shows SE11 T-Code −Now ...
Read MoreAnalogous to IN operator of SQL in SAP
You can get similar things done in many ways. You can use an internal table usage or a range table.Let me showcase an example with an internal table for your reference.SELECT Id, Name, DOB FROM sEmployee INTO CORRESPONDING FIELDS OF TABLE result_tab FOR ALL ENTRIES IN internal_tab // internal_tab is an internal table defined with columns WHERE Id = internal_tab -Id AND Name = internal_tab –Name
Read MoreChanged SAP password not working while resetting using BAPI
You are using the structure Password for resetting the password. It is of type “BAPIPWD” and comprises of a field which is again named as “BAPIPWD”When you need to reset the password, you need to specify the correct field name instead of password.JCO.Structure structPassword = userChangeInput.getStructure("PASSWORD"); sPassword.setValue(nPassword, "BAPIPWD");
Read MoreAssign image source dynamically in XML View in Fiori app in SAP UI5
Yes, it can be done but you need to compute the dynamic field.Firstly, you need to mention that the binding is complex so change the flag −“data-sap-ui-bindingSyntax="complex" ”. Then have a helper function which can be used for formatting.fnImageFmtr: function(value) { var imgSrc = "Image" + value; return imgSrc; }And lastly, use the function in the image tag in the XML view.
Read MoreSpecified cast not valid for datetime while using SAP RFC
I think you better use the ParseExact method available over DateTime type. It should work.Please find the code snippet for reference −string dateFormat = "dd.mm.yyyy hh:mm:tt"; DateTime finalDate = DateTime.ParseExact(argumentDate, dateFormat, CultureInfo.InvariantCulture);
Read MoreConverting date type SYDATUM in a format like MM/DD/YY in SAP ABAP
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