R_VarConfigurationInstanceTP

DDL: R_VARCONFIGURATIONINSTANCETP Type: view_entity TRANSACTIONAL Package: VCH_RAP_CFG

Variant Configuration Instance - TP

R_VarConfigurationInstanceTP is a Transactional CDS View that provides data about "Variant Configuration Instance - TP" in SAP S/4HANA. It reads from 1 data source (ibin) and exposes 27 fields with key fields VarConfigurationBusObjectKey, VarConfigurationBusObjectType, VarConfignInstceInternalID. It has 3 associations to related views. Part of development package VCH_RAP_CFG.

Data Sources (1)

SourceAliasJoin Type
ibin ibin from

Associations (3)

CardinalityTargetAliasCondition
[0..*] R_VarConfignCharacteristicTP _Characteristic
[0..*] R_VarConfignVariantConditionTP _VariantCondition
[0..*] R_VarConfignInstceCharcGroupTP _CharacteristicGroup

Annotations (7)

NameValueLevelField
EndUserText.label Variant Configuration Instance - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY VarConfigurationBusObjectKey
KEY VarConfigurationBusObjectType
KEY VarConfignInstceInternalID
VariantConfigurationInstance
VarConfignParInstceInternalID
VarConfignStatus
Product
Class
ClassType
BillOfMaterialItemCategory
BillOfMaterialItemNumber
IdentifierBOMItem
BOMItemHasFixedQuantity
BillOfMaterialItemQuantity
BillOfMaterialItemUnit
VariantConfigurationQuantity
VarConfignQuantityUnit
UnitOfMeasureISOCode
VarConfignQuantityISOUnit
BOMItemIsSalesRelevant
MaterialIsConfigurable
FixedItemCategory
BillOfMaterialItemObjectType
_VariantConfiguration _VariantConfiguration
_Characteristic _Characteristic
_CharacteristicGroup _CharacteristicGroup
_VariantCondition _VariantCondition
@EndUserText.label: 'Variant Configuration Instance - TP'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #S,
  dataClass: #MIXED
}

@VDM.viewType: #TRANSACTIONAL
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/
define view entity R_VarConfigurationInstanceTP
  as select from ibin
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] }*/
  association to parent R_VariantConfigurationTP       as _VariantConfiguration on  $projection.VarConfigurationBusObjectType = _VariantConfiguration.VarConfigurationBusObjectType
                                                                                and $projection.VarConfigurationBusObjectKey  = _VariantConfiguration.VarConfigurationBusObjectKey
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] }*/
  composition [0..*] of R_VarConfignCharacteristicTP   as _Characteristic
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] }*/
  composition [0..*] of R_VarConfignVariantConditionTP as _VariantCondition
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] }*/
  composition [0..*] of R_VarConfignInstceCharcGroupTP as _CharacteristicGroup
{
  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,
      cast ('' as ib_instance)                                     as VariantConfigurationInstance,
      cast (0 as vch_hl_cfg_instance_id)                           as VarConfignParInstceInternalID,
      cast ('' as vch_hl_ext_confign_status preserving type )      as VarConfignStatus,
      cast ('' as matnr)                                           as Product,
      cast ('' as klasse_d)                                        as Class,
      cast ('' as klassenart)                                      as ClassType,
      cast ('' as postp preserving type )                          as BillOfMaterialItemCategory,
      cast ('' as vdm_sposn)                                       as BillOfMaterialItemNumber,
      cast ('' as cs_itmid)                                        as IdentifierBOMItem, // BillOfMaterialItemIdentifier,

      cast ('' as fmnge preserving type )                          as BOMItemHasFixedQuantity,
      @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
      cast (0 as kmpmg )                                           as BillOfMaterialItemQuantity,
      cast ('' as kmpme)                                           as BillOfMaterialItemUnit,
      // BillOfMaterialType for OBJECT_TYPE needed in revive action

      @Semantics.quantity.unitOfMeasure: 'VarConfignQuantityUnit'
      cast (0  as vch_hl_quantity_amount )                         as VariantConfigurationQuantity,
      cast ('' as vcr_msehi)                                       as VarConfignQuantityUnit,
      cast ('   ' as isocd_unit preserving type )                  as UnitOfMeasureISOCode, // mussweg

      cast ('   ' as isocd_unit preserving type )                  as VarConfignQuantityISOUnit,
      cast ('' as vcr_is_sales_relevant_bom_item preserving type ) as BOMItemIsSalesRelevant,
      cast ('' as kzkfg preserving type )                          as MaterialIsConfigurable,
      cast ('' as postp preserving type )                          as FixedItemCategory,
      cast ('' as objty preserving type )                          as BillOfMaterialItemObjectType,

      /* Associations */
      _VariantConfiguration,
      _Characteristic,
      _CharacteristicGroup,
      _VariantCondition
}
where 1 = 2