R_SrvcQtanReferenceObjectTP

DDL: R_SRVCQTANREFERENCEOBJECTTP Type: view_entity TRANSACTIONAL Package: CRMS4_SERVICE_QUOTATION_RAP

Service Quotation Reference Object - TP

R_SrvcQtanReferenceObjectTP is a Transactional CDS View that provides data about "Service Quotation Reference Object - TP" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocumentRefObject, I_ServiceDocumentEnhcd) and exposes 8 fields with key fields ServiceQuotation, ServiceRefObjectSequenceNumber. Part of development package CRMS4_SERVICE_QUOTATION_RAP.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_ServiceDocumentRefObject I_ServiceDocumentRefObject from
I_ServiceDocumentEnhcd ServiceQuotation inner

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 Quotation Reference Object - TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ServiceQuotation I_ServiceDocumentRefObject ServiceDocument
KEY ServiceRefObjectSequenceNumber I_ServiceDocumentRefObject ServiceRefObjectSequenceNumber
SerialNumber I_ServiceDocumentRefObject SerialNumber
ServiceReferenceEquipment I_ServiceDocumentRefObject Equipment
ServiceRefFunctionalLocation
ServiceReferenceProduct I_ServiceDocumentRefObject ProductID
SrvcRefObjIsMainObject I_ServiceDocumentRefObject SrvcRefObjIsMainObject
_ServiceQuotationTP _ServiceQuotationTP 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}
@EndUserText.label: 'Service Quotation Reference Object - TP'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #B,
                sizeCategory:   #L}
}
define view entity R_SrvcQtanReferenceObjectTP

  as select from I_ServiceDocumentRefObject
  inner join   I_ServiceDocumentEnhcd as ServiceQuotation on  ServiceQuotation.ServiceDocument   = I_ServiceDocumentRefObject.ServiceDocument
                                                            and ServiceQuotation.ServiceObjectType = 'BUS2000116'
                                                            and ServiceQuotation.ServiceDocumentIsQuotation is not initial

  association to parent R_ServiceQuotationTP as _ServiceQuotationTP  on  $projection.ServiceQuotation = _ServiceQuotationTP.ServiceQuotation

{

      @ObjectModel.foreignKey.association: '_ServiceQuotationTP'
  key I_ServiceDocumentRefObject.ServiceDocument                       as ServiceQuotation,

  key I_ServiceDocumentRefObject.ServiceRefObjectSequenceNumber                                   as ServiceRefObjectSequenceNumber,

      I_ServiceDocumentRefObject.SerialNumber                                                     as SerialNumber,

      I_ServiceDocumentRefObject.Equipment                                                        as ServiceReferenceEquipment,

      cast( I_ServiceDocumentRefObject.FunctionalLocation as functionallocation preserving type ) as ServiceRefFunctionalLocation,

      I_ServiceDocumentRefObject.ProductID                                                        as ServiceReferenceProduct,

      I_ServiceDocumentRefObject.SrvcRefObjIsMainObject,

      // Associations

      _ServiceQuotationTP

}

where
      I_ServiceDocumentRefObject.ServiceObjectType   = 'BUS2000116' // Service Process

  and I_ServiceDocumentRefObject.ServiceDocumentItem is initial

Learn More