R_SrvcContrTmplItmRefObjectTP

DDL: R_SRVCCONTRTMPLITMREFOBJECTTP Type: view_entity TRANSACTIONAL

Ref Object of SrvcContr Tmpl Item - TP

R_SrvcContrTmplItmRefObjectTP is a Transactional CDS View that provides data about "Ref Object of SrvcContr Tmpl Item - TP" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentRefObject) and exposes 10 fields with key fields ServiceContractTemplate, ServiceContractTemplateItem, 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
EndUserText.label Ref Object of SrvcContr Tmpl Item - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ServiceContractTemplate ServiceDocument
KEY ServiceContractTemplateItem ServiceDocumentItem
KEY ServiceRefObjectSequenceNumber ServiceRefObjectSequenceNumber
SerialNumber SerialNumber
ServiceReferenceEquipment Equipment
ServiceRefFunctionalLocation
SrvcRefFuncLocLabelName _FunctionalLocationLabel FunctionalLocationLabelName
ServiceReferenceProduct ProductID
_Item _Item
_ServiceContractTemplate _ServiceContractTemplate
@EndUserText.label: 'Ref Object of SrvcContr Tmpl Item - TP'
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}



define view entity R_SrvcContrTmplItmRefObjectTP
  as select from I_ServiceDocumentRefObject
  
  association [0..1] to I_FunctionalLocationLabel      as _FunctionalLocationLabel      on $projection.ServiceRefFunctionalLocation = _FunctionalLocationLabel.FunctionalLocation
                        
  association to parent R_SrvcContrTmplItemTP as _Item on  $projection.ServiceContractTemplate = _Item.ServiceContractTemplate
                                                       and $projection.ServiceContractTemplateItem = _Item.ServiceContractTemplateItem
  //added for strict

  association to R_ServiceContractTemplateTP  as _ServiceContractTemplate on  $projection.ServiceContractTemplate = _ServiceContractTemplate.ServiceContractTemplate

{

      // Key

  key ServiceDocument                                                  as ServiceContractTemplate,
  key ServiceDocumentItem                                              as ServiceContractTemplateItem,
  key ServiceRefObjectSequenceNumber                                   as ServiceRefObjectSequenceNumber,

      // Object List

      SerialNumber                                                     as SerialNumber,
      Equipment                                                        as ServiceReferenceEquipment,
      cast( FunctionalLocation as functionallocation preserving type ) as ServiceRefFunctionalLocation,
      _FunctionalLocationLabel.FunctionalLocationLabelName             as SrvcRefFuncLocLabelName,
      ProductID                                                        as ServiceReferenceProduct,
      
      // Association

      _Item,
      _ServiceContractTemplate

}

where
      ServiceObjectType   = 'BUS2000112' // Service Contract

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