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.



No comments:

Post a Comment