P_REASON_CODE_TRACE

@AbapCatalog.sqlViewName: 'PREASONCODETRACE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #INHERITED 
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Fetching and Process of Reason Code Tracing'

@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
define view P_REASON_CODE_TRACE as select from wbhk as tc_k
             inner join wbhi as tc_i on tc_k.tkonn = tc_i.tkonn
             inner join /accgo/t_rc_trac as rc_table on tc_i.tkonn = rc_table.trading_contract
                                                     and tc_i.tposn = rc_table.item_number
                                                     and tc_i.tposn_sub = rc_table.commodity_subitem_number
             left outer join wbhd as tc_d on tc_k.tkonn = tc_d.tkonn
             left outer join usr21 as usr21 on rc_table.user_name = usr21.bname
             left outer join adrp as adrp on usr21.persnumber = adrp.persnumber
{            tc_i.tkonn,
             tc_i.tposn,
             tc_i.tposn_sub,
             tc_i.matnr,
             tc_k.company_code,
             tc_k.vkorg,
             tc_k.spart,
             tc_k.vtweg,
             tc_d.ekorg,
             tc_k.tctyp,
             rc_table.user_name,
             usr21.persnumber,
             adrp.name_text,
             rc_table.termno,
             rc_table.condition_type,
             rc_table.is_basis,
             rc_table.reason_code,
             rc_table.fetched_value,
             rc_table.fetched_market_currency,
             rc_table.fetched_priced_quantity,
             rc_table.fetched_priced_unit,
             rc_table.pp_amount,
             rc_table.pp_currency,
             rc_table.pp_quantity,
             rc_table.pp_unit,
             rc_table.recorded_value,
             rc_table.recorded_market_currency,
             rc_table.recorded_priced_quantity,
             rc_table.recorded_priced_unit,
             rc_table.timestamp,
             rc_table.event 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/ACCGO/T_RC_TRAC",
"ADRP",
"USR21",
"WBHD",
"WBHI",
"WBHK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/