R_BusSolnOrdItmConfigurationTP

DDL: R_BUSSOLNORDITMCONFIGURATIONTP Type: view_entity TRANSACTIONAL Package: CRMS4_SOLUTION_ORDER_RAP

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. Part of development package CRMS4_SOLUTION_ORDER_RAP.

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 VarConfignInstceBusObjectKey
KEY VarConfignInstceBusObjectType VarConfignInstceBusObjectType
KEY VariantConfigurationInstance VariantConfigurationInstance
KEY CharcInternalID CharcInternalID
KEY CharcValue CharcValue
KEY CharcFromNumericValue CharcFromNumericValue
KEY CharcToNumericValue CharcToNumericValue
CharcReferenceTable _Characteristic CharcReferenceTable
CharcReferenceTableField _Characteristic CharcReferenceTableField
Characteristic Characteristic
VariantConfigurationDate 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 VarConfignInstceBusObjectKey,
  key VarConfignInstceBusObjectType,
  key VariantConfigurationInstance,
  key CharcInternalID,
  key CharcValue,
  key CharcFromNumericValue,
  key CharcToNumericValue,

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


      // Associations

      _BusinessSolutionOrderItemTP,
      _BusinessSolutionOrderTP
}
where
       substring(cast(VarConfignInstceBusObjectKey as abap.char( 1000 )), 1,10) = 'BUS2000172'
  and(
       CharcInternalID                                                          is not null
    or CharcValue                                                               is not null
    or CharcFromNumericValue                                                    is not null
    or CharcToNumericValue                                                      is not null
  )

Learn More