BOL Relation Between root object Product and BTOrder

[Former Member]

Hi

I am need experts suggestion related to data population in my enhanced custom view which is for transaction history.

I have enhanced component PRD_FACTSHEET where I have added custom view for transaction history.

Standard component getting input data from window controller context node which has business root object 'Product'.

Now I am in search to get all business transactions where this 'Product' and BTorder or through BOL relations from root

object product to reach business transaction data .

Valuable suggestion will be appreciated.

Thanks and regards

Viren

[Former Member]

Hi Viren,

I do not think there is a relationship between Product and Business Transaction. The easiest way is to write a query as mentioned below:

data: lt_guids     type crmt_object_guid_tab,

IF lv_product IS NOT INITIAL.

    SELECT DISTINCT header FROM crmd_order_index INTO TABLE lt_guids

                                                 WHERE      process_type_ix IN ('TA', 'ZTA' )

                                                  AND           product_id eq lv_product.

  ENDIF.

You can also add Inner Joins with CRMD_ORDERADM_H and CRM_JEST (for status) tables to add other restrictions.

Thank you

Anji