R_VarConfigurationInstanceTP

DDL: R_VARCONFIGURATIONINSTANCETP Type: view_entity TRANSACTIONAL

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 (vch_rap_dummy) and exposes 26 fields with key fields VarConfigurationRootInstance, VarConfigurationBusObjectKey, VarConfigurationBusObjectType, VarConfignInstceInternalID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
vch_rap_dummy vch_rap_dummy 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 #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY VarConfigurationRootInstance
KEY VarConfigurationBusObjectKey
KEY VarConfigurationBusObjectType
KEY VarConfignInstceInternalID
VariantConfigurationInstance
VarConfignParInstceInternalID
VarConfignStatus
Product
Class
ClassType
BillOfMaterialItemCategory
BillOfMaterialItemNumber
IdentifierBOMItem
BOMItemHasFixedQuantity
BillOfMaterialItemQuantity
BillOfMaterialItemUnit
VariantConfigurationQuantity
VarConfignQuantityUnit
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: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}

@VDM.viewType: #TRANSACTIONAL
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity R_VarConfigurationInstanceTP
  as select from vch_rap_dummy
  association to parent R_VariantConfigurationTP       as _VariantConfiguration on  $projection.VarConfigurationRootInstance  = _VariantConfiguration.VarConfigurationRootInstance
                                                                                and $projection.VarConfigurationBusObjectType = _VariantConfiguration.VarConfigurationBusObjectType
                                                                                and $projection.VarConfigurationBusObjectKey  = _VariantConfiguration.VarConfigurationBusObjectKey
  composition [0..*] of R_VarConfignCharacteristicTP   as _Characteristic
  composition [0..*] of R_VarConfignVariantConditionTP as _VariantCondition
  composition [0..*] of R_VarConfignInstceCharcGroupTP as _CharacteristicGroup
{
  key cast ('' as ib_root)                                         as VarConfigurationRootInstance,
  key cast ('' as ibobjkey )                                       as VarConfigurationBusObjectKey,
  key cast ('' as ibobjtyp )                                       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 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
}