R_SrvcContrItemRefObjectTP

DDL: R_SRVCCONTRITEMREFOBJECTTP Type: view_entity TRANSACTIONAL

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 10 fields with key fields ServiceContract, ServiceContractItem, ServiceRefObjectSequenceNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentRefObject I_ServiceDocumentRefObject from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FunctionalLocationLabel _FunctionalLocationLabel $projection.ServiceRefFunctionalLocation = _FunctionalLocationLabel.FunctionalLocation

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 (10)

KeyFieldSource TableSource FieldDescription
KEY ServiceContract ServiceDocument
KEY ServiceContractItem ServiceDocumentItem
KEY ServiceRefObjectSequenceNumber ServiceRefObjectSequenceNumber
SerialNumber SerialNumber
ServiceReferenceEquipment Equipment
ServiceRefFunctionalLocation
SrvcRefFuncLocLabelName _FunctionalLocationLabel FunctionalLocationLabelName
ServiceReferenceProduct ProductID
_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

{
   
  key ServiceDocument                                                   as ServiceContract,
  key ServiceDocumentItem                                               as ServiceContractItem,
  key ServiceRefObjectSequenceNumber                                    as ServiceRefObjectSequenceNumber,
      SerialNumber                                                      as SerialNumber,
      Equipment                                                         as ServiceReferenceEquipment,
      cast( FunctionalLocation as functionallocation preserving type )  as ServiceRefFunctionalLocation,
      _FunctionalLocationLabel.FunctionalLocationLabelName              as SrvcRefFuncLocLabelName,
      ProductID                                                         as ServiceReferenceProduct,

      //Associations

      _ServiceContractItemTP,
      _ServiceContractTP //added for strict

}

where
      ServiceObjectType   = 'BUS2000112' // Service Contract

and   ServiceDocumentItem is not initial                                                       
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FUNCTIONALLOCATIONLABEL",
"I_SERVICEDOCUMENTREFOBJECT"
],
"ASSOCIATED":
[
"R_SERVICECONTRACTITEMTP",
"R_SERVICECONTRACTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/