R_VarConfignPossibleValueTP

DDL: R_VARCONFIGNPOSSIBLEVALUETP Type: view_entity TRANSACTIONAL Package: VCH_RAP_CFG

Possible Values in Variant Confign - TP

R_VarConfignPossibleValueTP is a Transactional CDS View that provides data about "Possible Values in Variant Confign - TP" in SAP S/4HANA. It reads from 1 data source (ibin) and exposes 28 fields with key fields VarConfigurationBusObjectKey, VarConfigurationBusObjectType, VarConfignInstceInternalID, Characteristic, VariantConfigurationValueID. It has 2 associations to related views. Part of development package VCH_RAP_CFG.

Data Sources (1)

SourceAliasJoin Type
ibin ibin from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_VariantConfigurationTP _Root _Root.VarConfigurationBusObjectType = $projection.VarConfigurationBusObjectType and _Root.VarConfigurationBusObjectKey = $projection.VarConfigurationBusObjectKey
[1..1] R_VariantConfigurationTP _VariantConfiguration _VariantConfiguration.VarConfigurationBusObjectType = $projection.VarConfigurationBusObjectType and _VariantConfiguration.VarConfigurationBusObjectKey = $projection.VarConfigurationBusObjectKey

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Possible Values in Variant Confign - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY VarConfigurationBusObjectKey
KEY VarConfigurationBusObjectType
KEY VarConfignInstceInternalID
KEY Characteristic
KEY VariantConfigurationValueID
VarCnfCharacteristicValue
VarCnfCharcValueDescription
VarCnfCharcFromQuantity
VarCnfCharcFromQuantityUnit
VarCnfCharcFromQuantityISOUnit
VarCnfCharcToQuantity
VarCnfCharcToQuantityUnit
VarCnfCharcToQuantityISOUnit
VarCnfCharcFromNumericValue
VarCnfCharcToNumericValue
VarCnfCharcFromDate
VarCnfCharcToDate
VarCnfCharcFromTime
VarCnfCharcToTime
VarCnfCharcFromAmount
VarCnfCharcToAmount
VarCnfCharcCurrency
VarCnfCharcValueIntervalType
VarConfignValueAssignmentType
ValueIsMasterData
_Characteristic _Characteristic
_VariantConfiguration _VariantConfiguration
_Root _Root
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Possible 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
define view entity R_VarConfignPossibleValueTP
  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