R_SrvcContrItemRefObjectTP

DDL: R_SRVCCONTRITEMREFOBJECTTP Type: view_entity TRANSACTIONAL Package: CRMS4_SERVICE_CONTRACT_RAP

Service Contract Item Ref Object - TP

R_SrvcContrItemRefObjectTP is a Transactional CDS View that provides data about "Service Contract Item Ref Object - TP" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentRefObject) and exposes 13 fields with key fields ServiceContract, ServiceContractItem, ServiceRefObjectSequenceNumber. It has 4 associations to related views. Part of development package CRMS4_SERVICE_CONTRACT_RAP.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentRefObject I_ServiceDocumentRefObject from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_FunctionalLocationLabel _FunctionalLocationLabel $projection.ServiceRefFunctionalLocation = _FunctionalLocationLabel.FunctionalLocation
[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
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Service Contract Item Ref Object - TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ServiceContract ServiceDocument
KEY ServiceContractItem ServiceDocumentItem
KEY ServiceRefObjectSequenceNumber ServiceRefObjectSequenceNumber
SerialNumber SerialNumber
ServiceReferenceEquipment Equipment
ServiceRefFunctionalLocation
SrvcRefFuncLocLabelName _FunctionalLocationLabel FunctionalLocationLabelName
ServiceReferenceProduct ProductID
_EquipmentText _EquipmentText
_FunctionalLocationText _FunctionalLocationText
_ProductText _ProductText
_ServiceContractItemTP _ServiceContractItemTP
_ServiceContractTP _ServiceContractTP 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}
@EndUserText.label: 'Service Contract Item Ref Object - TP'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}

define view entity R_SrvcContrItemRefObjectTP
  as select from I_ServiceDocumentRefObject

  association [0..1] to I_FunctionalLocationLabel      as _FunctionalLocationLabel      on $projection.ServiceRefFunctionalLocation = _FunctionalLocationLabel.FunctionalLocation

  association to parent R_ServiceContractItemTP as _ServiceContractItemTP on  $projection.ServiceContract      = _ServiceContractItemTP.ServiceContract
                                                                          and $projection.ServiceContractItem  = _ServiceContractItemTP.ServiceContractItem
   //added for strict                            

  association to R_ServiceContractTP    as _ServiceContractTP             on $projection.ServiceContract      = _ServiceContractTP.ServiceContract

  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 ServiceContract,
  key ServiceDocumentItem                                            as ServiceContractItem,

  key ServiceRefObjectSequenceNumber                                 as ServiceRefObjectSequenceNumber,

      SerialNumber                                                   as SerialNumber,

      @ObjectModel.text.association: '_EquipmentText'
      Equipment                                                      as ServiceReferenceEquipment,

      @ObjectModel.text.association: '_FunctionalLocationText'
      cast(FunctionalLocation as functionallocation preserving type) as ServiceRefFunctionalLocation,

      _FunctionalLocationLabel.FunctionalLocationLabelName           as SrvcRefFuncLocLabelName,

      @ObjectModel.text.association: '_ProductText'
      ProductID                                                      as ServiceReferenceProduct,

      // Associations

      _EquipmentText,
      _FunctionalLocationText,
      _ProductText,
      _ServiceContractItemTP,
      _ServiceContractTP // added for strict

}

where
      ServiceObjectType   = 'BUS2000112' // Service Contract

and   ServiceDocumentItem is not initial

Learn More