Friday, January 31, 2014

Adding translations in a transport request using SE63 Translation Transport



First of all, ¡Happy New Year! Well, this is the first post of 2014.


When translating objects, like domains, data types, text messages and so on, a transport request is not asked in order to save all the object translations. So, when I noticed that, this really worried me.  But there is a report named RS_LXE_RECORD_TORDER that solves this problem and it is very easy to use. Only you have to do is enter the parameters on the selection screen and execute it. You can enter a date, a user, the object types and other useful parameters. Just a parenthesis about the Target Language field: it seems not to be editable but it is, just select the match code in order to set the target language.

SE Translation Transport Report


Automatically a workbench request is created with the title you have entered on the Request Description and with all the object translations included.

Program Execution Results

 Well, that's all folks. I wish you all the best for this year.

Wednesday, December 18, 2013

Document type code: Where is it on standard transactions screens?

Yeah, this happened to me... Sometimes, when executing some standard transactions like Sales Order (VA03), Billing Invoice (VF03) or Purchase Order (ME23N),  for example, I noticed that the document type code was not displayed on the matchcode, only its description. 

Invoice

Customize Local Layout button
I have to confess that I did not remember where this configuration was immediately on the first times. To display both document type code and description, we only need to change a parameter through the “Customize Local Layout” button (Alt + F12). 
  
 
Menu Interaction Design - Visualization 1
On Menu Interaction Design-Visualization 1, select the options “Show keys within dropdown lists” and “Sort by keys…” and then press the buttons “Apply” and “OK”. 









Reopen the corresponding transaction in order to refresh the screen. Now we can see both document type and description on the matchcode. 

F2 - Invoice

Well, I am not sure if I could be able to write another post before Christmas, so have a very Merry Christmas everyone!



Wednesday, October 23, 2013

CRM_ORDER_READ is all that you can’t leave behind in SAP CRM

By my own experience, I can say that dealing with short time can be a little bit frequent when working in an IT Project, and this time would not be different…


I had to develop a report in order to display all the CRM opportunities data, including the text note. It was my first CRM Report and when I saw all the tables that I needed to access to retrieve data, I thought: “Oh no, it is impossible, there is not enough time to deliver it on time!” So, I took a deep breath and reflect: “certainly there must be a function module that brings all this information” and bingo! It exists and its name is “CRM_ORDER_READ”. All I need to inform is the GUID field, retrieved by CRMD_ORDERADM_H table taking into account the opportunity process it retrieves all the information related to it, including the text lines that was so crucial in this report. 


Do you need to know the status of the order (in my case, the opportunity)? Use CRM_ORDER_READ! Do you need to know about the prices? Don’t think twice, CRM_ORDER_READ! Do you need to know the Customer data? Guess what? CRM_ORDER_READ! Do you need to know the text description field? CRM_ORDER_READ! Do you need to know the Sales Organization description? CRM_ORDER_READ! This function module retrieves us this kind of information and many others. All we have to do is inform in the function module the tables we want to display.

Another important point to comment is that we cannot execute a single test for this function module in transaction SE37 but there is a program that replaces this missing option and its name is… (Suspense music in background) CRM_ORDER_READ! Yeah! This program offers us the possibility to enter the parameters, that are nothing more and nothing less than the import parameters of the function module CRM_ORDER_READ, and then displays the results that correspond to the export parameters.

CRM_ORDER_READ Program
CRM_ORDER_READ Selection-Screen
Here is an example of the program execution and, in detail, the Note Text retrieve in LINES of ET_TEXT table:



CRM_ORDER_READ results
CRM_ORDER_READ results

Well, that's all for now. I really hope this information be useful for you.