R_BusSolnOrdItmConfigurationTP

DDL: R_BUSSOLNORDITMCONFIGURATIONTP Type: view_entity TRANSACTIONAL

Solution Order Item Configuration - TP

R_BusSolnOrdItmConfigurationTP is a Transactional CDS View that provides data about "Solution Order Item Configuration - TP" in SAP S/4HANA. It reads from 1 data source (I_VarConfignProdInstanceValue2) and exposes 15 fields with key fields BusinessSolutionOrder, BusinessSolutionOrderItem, VarConfignInstceBusObjectKey, VarConfignInstceBusObjectType, VariantConfigurationInstance. It has 1 association to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_VarConfignProdInstanceValue2 _ItemConfiguration from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_BusinessSolutionOrderTP _BusinessSolutionOrderTP $projection.BusinessSolutionOrder = _BusinessSolutionOrderTP.BusinessSolutionOrder

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Solution Order Item Configuration - TP view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder
KEY BusinessSolutionOrderItem
KEY VarConfignInstceBusObjectKey I_VarConfignProdInstanceValue2 VarConfignInstceBusObjectKey
KEY VarConfignInstceBusObjectType I_VarConfignProdInstanceValue2 VarConfignInstceBusObjectType
KEY VariantConfigurationInstance I_VarConfignProdInstanceValue2 VariantConfigurationInstance
KEY CharcInternalID I_VarConfignProdInstanceValue2 CharcInternalID
KEY CharcValue I_VarConfignProdInstanceValue2 CharcValue
KEY CharcFromNumericValue I_VarConfignProdInstanceValue2 CharcFromNumericValue
KEY CharcToNumericValue I_VarConfignProdInstanceValue2 CharcToNumericValue
CharcReferenceTable
CharcReferenceTableField
Characteristic I_VarConfignProdInstanceValue2 Characteristic
VariantConfigurationDate I_VarConfignProdInstanceValue2 VariantConfigurationDate
_BusinessSolutionOrderItemTP _BusinessSolutionOrderItemTP
_BusinessSolutionOrderTP _BusinessSolutionOrderTP 
@AccessControl: {
  authorizationCheck:    #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: {
  usageType:{
    dataClass:      #TRANSACTIONAL,
    serviceQuality: #C,
    sizeCategory:   #L
  }
}

@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}

@EndUserText.label: 'Solution Order Item Configuration - TP'

define view entity R_BusSolnOrdItmConfigurationTP
  as select from I_VarConfignProdInstanceValue2 as _ItemConfiguration

  association        to parent R_BusinessSolutionOrderItemTP as _BusinessSolutionOrderItemTP on  $projection.BusinessSolutionOrder     = _BusinessSolutionOrderItemTP.BusinessSolutionOrder
                                                                                             and $projection.BusinessSolutionOrderItem = _BusinessSolutionOrderItemTP.BusinessSolutionOrderItem

  association [0..1] to R_BusinessSolutionOrderTP            as _BusinessSolutionOrderTP     on  $projection.BusinessSolutionOrder = _BusinessSolutionOrderTP.BusinessSolutionOrder
{
  key cast (substring(cast(VarConfignInstceBusObjectKey as abap.char( 1000 )), 11,10) as crmt_object_id_db ) as BusinessSolutionOrder,
  key cast (substring(cast(VarConfignInstceBusObjectKey as abap.char( 1000 )), 21,6) as crms4_number_int )   as BusinessSolutionOrderItem,
  key _ItemConfiguration.VarConfignInstceBusObjectKey,
  key _ItemConfiguration.VarConfignInstceBusObjectType,
  key _ItemConfiguration.VariantConfigurationInstance,
  key _ItemConfiguration.CharcInternalID,
  key _ItemConfiguration.CharcValue,
  key _ItemConfiguration.CharcFromNumericValue,
  key _ItemConfiguration.CharcToNumericValue,

      _ItemConfiguration._Characteristic.CharcReferenceTable,
      _ItemConfiguration._Characteristic.CharcReferenceTableField,
      _ItemConfiguration.Characteristic,
      _ItemConfiguration.VariantConfigurationDate,


      // Associations

      _BusinessSolutionOrderItemTP,
      _BusinessSolutionOrderTP
}
where
  substring(cast(VarConfignInstceBusObjectKey as abap.char( 1000 )), 1,10) = 'BUS2000172'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARACTERISTIC",
"I_VARCONFIGNPRODINSTANCEVALUE2"
],
"ASSOCIATED":
[
"R_BUSINESSSOLUTIONORDERITEMTP",
"R_BUSINESSSOLUTIONORDERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More