I_TrdgContractOptionItemDet

@AbapCatalog.sqlViewName: 'ICNTRCTOPTITMDET'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: #CDS_MODELING_DATA_SOURCE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Interface Layer for Trading Contract Optionality Item Detail'
define view I_TrdgContractOptionItemDet as select from /accgo/t_cakoptn as Optionality
inner join P_TrdgContrOptionalityCategory as OptionalityCategory on Optionality.opnlty_id = OptionalityCategory.opnlty_id
left outer join I_CmmdtyDrvtvGenericDomainVH  as OptnType on  Optionality.opnlty_typ = OptnType.DomainValue
                                                          and OptnType.SAPDataDictionaryDomain = '/ACCGO/D_OPTN_TYPE'
left outer join /accgo/t_crpssnt as CropYearText on  Optionality.crop_season_id = CropYearText.crop_season_id
                                                 and CropYearText.spras = $session.system_language
left outer join I_UnitOfMeasureText as _UnitOfMeasure on  _UnitOfMeasure.UnitOfMeasure = Optionality.uom_time_unit
                                                      and _UnitOfMeasure.Language      = $session.system_language
{
      key tkonn as TradingContractNumber,
      key tposn as TradingContractItem,
      key Optionality.opnlty_id as ACMContractOptionsID,
      key value_typ as ACMContractOptionsValueType,
      key seq_no as ACMContractOptionsSequenceNmbr,
      opnlty_typ as ACMTradingContractOptionsType,
      Optionality.crop_season_id as ACMContractOptionsCropSeasonID,
      source_loc as ACMContrOptionsSourceLocation,
      mode_id as ModeOfTransport,
      means_id as ACMContrOptionsMnsOfTransport,
      optn_val as ACMContractOptionsValue,
      uom as ACMContractOptionsUnit,
      uom_time_unit as ACMContractOptionsTimeUnit,
      _UnitOfMeasure.UnitOfMeasureName as DurationUnitName,
      type as ACMContractOptionsPremDiscType,
      prem_disc as ACMContractOptionsPremDiscVal,
      currency as ACMContractOptionsPremDiscCrcy,
      @Semantics.quantity.unitOfMeasure: 'ACMContractOptionsPremDiscUnit'
      per_uom as ACMContractOptionsPremDiscQty,
      @Semantics.unitOfMeasure: true
      uom_pd as ACMContractOptionsPremDiscUnit,
      default_optn as ACMIsDefaultContractOptions,
      OptionalityCategory.text as ACMContractOptionsCategoryName,
      CropYearText.option_txt as ACMCropSeasonText,
      OptnType.DomainText as ACMContractOptionsTypeName
}