P_ON_DEMAND_PRICE_ORDER

@AbapCatalog.sqlViewName: 'PONDEMANDPRCODR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Fetch Price Details for tracking number of hits'

@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
define view P_ON_DEMAND_PRICE_ORDER as select from /accgo/t_prc_odr as log_table
                                              left outer join usr21 as usr21
                                              on              log_table.log_owner = usr21.bname
                                              left outer join adrp as adrp
                                              on              usr21.persnumber = adrp.persnumber
                                              left outer join tbac_dcst as dcs_text
                                              on              log_table.dcs = dcs_text.dcsid
                                              left outer join tbac_mict as mic_text
                                              on              log_table.mic = mic_text.mic
{            log_table.log_owner,
             usr21.persnumber,
             adrp.name_text,
             log_table.dcs,
             dcs_text.text,
             dcs_text.langu as langu_dcs_text,
             log_table.mic,
             mic_text.text as text_mic,
             mic_text.langu as langu_mic_text,
             log_table.maturity_code,
             log_table.ondemand_price,
             log_table.market_currency,
             log_table.quantity,
             log_table.unit,
             log_table.timestamp,
             log_table.pfm,
             log_table.status,
             log_table.no_default_prices,
             log_table.disp_msg_type,
             log_table.disp_msg_id,
             log_table.disp_msg_number,
             log_table.disp_msg_message,
             log_table.cond_type

}