Tables for prices in utilities quotations

[former_member710155]

Hello Experts

Could you assist me in finding the links between the tables
used for holding the prices in utilities quotations?

The actual pricing condition values are held in table CRMD_ISU_PRAT  that can
be linked via guid field to table CRMD_ISU_PRA1 that holds the pricing version. 

From here I can't reach the quotation table CRMD_ORDERADM_H.
I've tried the usual suspect CRMD_LINK and some tables found in the SQL trace.

Best regards

Razvan Z

[Former Member · Accepted solution]

Hi Razvan,

Tables

CRMD_ISU_PRAT -GUID = CRMD_ORDERADM_I - GUID

CRMD_ORDERADM_I-HEADER = CRMD_ORDERADM_H-GUID

If you are on CRM 7.0+ then you can use the code as well as below.

Via Code: class method CL_CRM_ISU_ORDER_INFO=>GET_HEADER_GUID( IV_GUID = CRMD_ISU_PRAT-GUID ).

Regards,

Naresh

[former_member710155 · Accepted solution]

Thank you for the quick answer!

Best regards

Razvan Zainea