Not able to Retrieve Transaction Data based on the property of master data

[rishi4892]

Hi,

I am trying to retrieve transaction data based on property of Master Data for ACCOUNT (property  ACCTYPE = ‘EXP’)

in BPC 10 version for netweaver.

Transaction data is present at backend, But I am not getting data in Internal table after running RSDRI Query.

I am using this code.

DATA: lt_sel TYPE uj0_t_sel,
ls_sel TYPE uj0_s_sel.

ls_sel-dimension = 'ACCOUNT'.
ls_sel-attribute = 'ACCTYPE'.
ls_sel-sign = 'I'.
ls_sel-option = 'EQ'.
ls_sel-low = 'EXP'.
APPEND ls_sel TO lt_sel.

lo_query = cl_ujo_query_factory=>get_query_adapter(
i_appset_id = lv_environment_id
i_appl_id = lv_application_id ).
lo_query->run_rsdri_query(
EXPORTING
it_dim_name = lt_dim_list " BPC: Dimension List
it_range = lt_sel" BPC: Selection condition
if_check_security = ABAP_FALSE " BPC: Generic indicator

    IMPORTING
et_data = <lt_query_result>

    et_message = lt_message

    ).

Data is coming if i use ID of ACCOUNT directly, for e.g.

ls_sel-dimension = 'ACCOUNT'.
ls_sel-attribute = 'ID'.
ls_sel-sign = 'I'.
ls_sel-option = 'EQ'.
ls_sel-low = 'PL110.

APPEND ls_sel TO lt_sel.

so in this case data is coming , but it is not coming for property.

So Please can you help me on this.

Thanks,

Rishi

[Former Member · Accepted solution]

Hi Rishi,

There are 2 steps you need to do,.

1. read all the master data with the property you required into a internal table.  in your case use ACCTYPE' = EXP

2. read transaction data with the masterdata you just selected.

Then you will get all your results.

Andy