Sales Stage History Table / Search Objects

[Former Member]

Dear experts,

I need to report sales stage history of an opportunity and therefore want to create an own datasource, as nothing is in there for this request in standard.

Now my question: Is there any Search Object for the Sales Stage History? I didn't find one.

And if its not: Nevermind, I'm happy with a database table as well - Do you know where Sales Stage History is stored in database?

Thank you very much,

BR Matthias

[Former Member]

^ I know this is an old post, but anyone know a solution for this ?

I am also facing a requirement where I need to create a report from the Sales Stage history but unable to find a starting point.

[Former Member]

Hello,

yes, I've found a solution.

I've created a own datasource extractor function and called the RFC CRM_CDORDER_DISPLAY with parameter i_no_dialogue = "X" in it.

CALL FUNCTION 'CRM_CDORDER_DISPLAY'
         EXPORTING
           iv_object             = extract_data-object_id
           iv_bus                = 'BUS2000111'
*         IV_ITEM_INT           =
*         IT_VARIANT            =
*         I_APPLICATIONID       =
*         I_SCREEN_START_COLUMN = 0
*         I_SCREEN_START_LINE   = 0
*         I_SCREEN_END_COLUMN   = 0
*         I_SCREEN_END_LINE     = 0
           i_no_dialogue         = 'X'
*         IV_HEADER_GUID        =
         IMPORTING
           ausg                  = lt_oppty_history.

All you have to do afterwards is delete the entries you don't need from lt_oppty_history.

I'm happy if I could help you with this information.

BR Matthias

[Former Member]

Hello Matthias,

You can also use function module CRM_PHASEN_HISTORIE. It will provide the duration as seen in UI. No need to calculate the same from the change log.

CALL FUNCTION 'CRM_PHASEN_HISTORIE'
           EXPORTING
             iv_guid           = lv_guid
           IMPORTING
             ph_ausg           = lt_stages
           EXCEPTIONS
             entries_not_found = 1
             OTHERS            = 2.

Regards

Biswa