I usually use REGEX in all such cases as it is faster and easily readable and would recommend the same to you.You can use something similar as the snippet to get your job done.DATA: lv_para TYPE string. lv_para = ' You &are like& kite &flying& in a &hurricane&'. REPLACE ALL OCCURRENCES OF REGEX '&[^&]+&' IN lv_para WITH ''. WRITE lv_para.Let me explain the regex for you. It should match the first ‘&’, then you can have any combination with multiple occurrences of ‘&’ and the last occurrence of ‘&’ must be matched.

 There are few ways in which you can identify the program for editing if you know the transaction code in advance.Firstly you can useSE93 for identifying the program on basis of the transaction.Secondly, you can run the TCode, and then drill down to program from menu. You can lead to program from System → Status → SAP Data → Repository Data →Program.Lastly, when you run the T-Code, in the SAP GUI you can see an arrow in the bottom of the editor, Just click on it to get more information about the transaction. You can get details including the program ... Read More

 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.

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.

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 More

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 More

The answer is very naïve. If you have any quantity fields or currency fields, you require reference columns and reference table. You need to just add the reference field and table for any such columns in your table.

Yes, there are user specific text settings which can let you stroke in Uppercase or lowercase whatever is you choice. Go to ABAP Editor initial screen using T-Code: SE38You need to go settings under utilities tab. With utilities select ABAP editor tab. Once you have selected ABAP editor tab, select pretty printer section. You will have a handful of options to choose from.

You just need to make a small change. You need to add an “If condition” for handling the tab as shown below − if CO gc_hex_char I think it should sort out your issue and neither it looks like hardcoding or a wrong implementation.

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