R_VarConfignAssignedValueTP

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Assigned Values in Variant Confign - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/
define view entity R_VarConfignAssignedValueTP
  as select from ibin

  
  association [1..1] to R_VariantConfigurationTP            as _Root           on  _Root.VarConfigurationBusObjectType = $projection.VarConfigurationBusObjectType
                                                                               and _Root.VarConfigurationBusObjectKey  = $projection.VarConfigurationBusObjectKey
  association [1..1] to R_VariantConfigurationTP            as _VariantConfiguration           on  _VariantConfiguration.VarConfigurationBusObjectType = $projection.VarConfigurationBusObjectType
                                                                               and _VariantConfiguration.VarConfigurationBusObjectKey  = $projection.VarConfigurationBusObjectKey

  association        to parent R_VarConfignCharacteristicTP as _Characteristic on  _Characteristic.VarConfigurationBusObjectType = $projection.VarConfigurationBusObjectType
                                                                               and _Characteristic.VarConfigurationBusObjectKey  = $projection.VarConfigurationBusObjectKey
                                                                               and _Characteristic.VarConfignInstceInternalID    = $projection.VarConfignInstceInternalID
                                                                               and _Characteristic.Characteristic                = $projection.Characteristic

{
  key    cast ('' as ibobjkey)                      as VarConfigurationBusObjectKey,
  key    cast ('' as sbo_node_type)                 as VarConfigurationBusObjectType,
  key    cast (0 as vch_hl_cfg_instance_id)         as VarConfignInstceInternalID,
  key    cast ('' as atnam)                         as Characteristic,
  key    cast ('' as vdm_cbase_value_id)            as VariantConfigurationValueID,
         cast ('' as atwrt)                         as VarCnfCharacteristicValue,
         cast ('' as atwtb)                         as VarCnfCharcValueDescription,

         @Semantics.quantity.unitOfMeasure: 'VarCnfCharcFromQuantityUnit'
         @Semantics.quantity.unitOfMeasureSapCode: 'VarCnfCharcFromQuantityUnit'
         @Semantics.quantity.unitOfMeasureIsoCode: 'VarCnfCharcFromQuantityISOUnit'
         cast (0 as vch_hl_value_df34_min)                     as VarCnfCharcFromQuantity,
         cast ('' as msehi)                                    as VarCnfCharcFromQuantityUnit,
         cast ('' as isocd_unit)                               as VarCnfCharcFromQuantityISOUnit,
         @Semantics.quantity.unitOfMeasure: 'VarCnfCharcToQuantityUnit'
         @Semantics.quantity.unitOfMeasureSapCode: 'VarCnfCharcToQuantityUnit'
         @Semantics.quantity.unitOfMeasureIsoCode: 'VarCnfCharcToQuantityISOUnit'
         cast (0 as vch_hl_value_df34_min)          as VarCnfCharcToQuantity,
         cast ('' as msehi)                         as VarCnfCharcToQuantityUnit,
         cast ('' as isocd_unit)                    as VarCnfCharcToQuantityISOUnit,
         cast (0 as vch_hl_value_df34_min)          as VarCnfCharcFromNumericValue,
         cast (0 as vch_hl_value_df34_max)          as VarCnfCharcToNumericValue,
         cast ('' as auspext_date_from)             as VarCnfCharcFromDate,
         cast ('' as auspext_date_to)               as VarCnfCharcToDate,
         cast ('000000' as auspext_time_from)       as VarCnfCharcFromTime,
         cast ('000000' as auspext_time_to)         as VarCnfCharcToTime,
         @Semantics.amount.currencyCode: 'VarCnfCharcCurrency'
         @OData.v2.amount.noDecimalShift: true
         cast (0 as vch_hl_value_df34_min)          as  VarCnfCharcFromAmount,
         @Semantics.amount.currencyCode: 'VarCnfCharcCurrency'
         @OData.v2.amount.noDecimalShift: true
         cast (0 as vch_hl_value_df34_min)          as  VarCnfCharcToAmount,
         cast ('' as waers_curc)                    as VarCnfCharcCurrency,
         
         cast ('' as atcod preserving type)         as VarCnfCharcValueIntervalType,
         cast (0 as vch_hl_assignment_type)         as VarConfignValueAssignmentType,
         cast ('' as boole_d preserving type )      as ValueIsMasterData,

         _Characteristic,
         _VariantConfiguration,
         _Root
}
where 1 = 2