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.
Well, that's all for now. I really hope this information be useful for you.
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 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 |
Well, that's all for now. I really hope this information be useful for you.
