R_BusSolnOrdItmRefObjectTP

DDL: R_BUSSOLNORDITMREFOBJECTTP Type: view_entity TRANSACTIONAL Package: CRMS4_SOLUTION_ORDER_RAP

Business Solution Order Item Reference Object - TP

R_BusSolnOrdItmRefObjectTP is a Transactional CDS View that provides data about "Business Solution Order Item Reference Object - TP" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentRefObject) and exposes 16 fields with key fields BusinessSolutionOrder, BusinessSolutionOrderItem, ServiceRefObjectSequenceNumber. It has 4 associations to related views. Part of development package CRMS4_SOLUTION_ORDER_RAP.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentRefObject I_ServiceDocumentRefObject from

Associations (4)

CardinalityTargetAliasCondition
[1..1] R_BusinessSolutionOrderTP _BusinessSolutionOrder $projection.BusinessSolutionOrder = _BusinessSolutionOrder.BusinessSolutionOrder
[1..*] I_EquipmentText _EquipmentText $projection.ServiceReferenceEquipment = _EquipmentText.Equipment
[1..*] I_FunctionalLocationText _FunctionalLocationText $projection.ServiceRefFunctionalLocation = _FunctionalLocationText.FunctionalLocation
[1..*] I_ProductText _ProductText $projection.ServiceReferenceProduct = _ProductText.Product

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK 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 Business Solution Order Item Reference Object - TP view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder ServiceDocument
KEY BusinessSolutionOrderItem ServiceDocumentItem
KEY ServiceRefObjectSequenceNumber ServiceRefObjectSequenceNumber
SerialNumber SerialNumber
ServiceReferenceEquipment Equipment
ServiceRefFunctionalLocation
ServiceReferenceProduct ProductID
SrvcRefObjIsMainObject SrvcRefObjIsMainObject
_BusinessSolutionOrderItem _BusinessSolutionOrderItem
_BusinessSolutionOrder _BusinessSolutionOrder
_Equipment _Equipment
_Product _Product
_FunctionalLocation _FunctionalLocation
_EquipmentText _EquipmentText
_FunctionalLocationText _FunctionalLocationText
_ProductText _ProductText 
@AccessControl: {
  authorizationCheck:    #CHECK,
  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: 'Business Solution Order Item Reference Object - TP'

define view entity R_BusSolnOrdItmRefObjectTP
  as select from I_ServiceDocumentRefObject
  association        to parent R_BusinessSolutionOrderItemTP as _BusinessSolutionOrderItem on  $projection.BusinessSolutionOrder     = _BusinessSolutionOrderItem.BusinessSolutionOrder
                                                                                           and $projection.BusinessSolutionOrderItem = _BusinessSolutionOrderItem.BusinessSolutionOrderItem

  association [1..1] to R_BusinessSolutionOrderTP            as _BusinessSolutionOrder     on  $projection.BusinessSolutionOrder = _BusinessSolutionOrder.BusinessSolutionOrder
  association [1..*] to I_EquipmentText                      as _EquipmentText             on $projection.ServiceReferenceEquipment = _EquipmentText.Equipment
  association [1..*] to I_FunctionalLocationText             as _FunctionalLocationText    on $projection.ServiceRefFunctionalLocation = _FunctionalLocationText.FunctionalLocation
  association [1..*] to I_ProductText                        as _ProductText               on $projection.ServiceReferenceProduct  = _ProductText.Product
{
  key ServiceDocument     as BusinessSolutionOrder,
  key ServiceDocumentItem as BusinessSolutionOrderItem,
  key ServiceRefObjectSequenceNumber,

      SerialNumber        as SerialNumber,
      @ObjectModel.text.association: '_EquipmentText'
      Equipment           as ServiceReferenceEquipment,
      @ObjectModel.foreignKey.association: '_FunctionalLocation'
      @ObjectModel.text.association: '_FunctionalLocationText'
      cast( FunctionalLocation as functionallocation preserving type )  as ServiceRefFunctionalLocation,
      @ObjectModel.text.association: '_ProductText'
      ProductID           as ServiceReferenceProduct,
      SrvcRefObjIsMainObject,

      //Associations

      _BusinessSolutionOrderItem,
      _BusinessSolutionOrder,
      _Equipment,
      _Product,
      _FunctionalLocation,
      _EquipmentText,
      _FunctionalLocationText,
      _ProductText

}
where
      ServiceObjectType   = 'BUS2000172'
  and ServiceDocumentItem is not initial

Learn More