R_SrvcQtanItemRefObjectTP

DDL: R_SRVCQTANITEMREFOBJECTTP Type: view_entity TRANSACTIONAL

Service Quotation Item Reference Object - TP

R_SrvcQtanItemRefObjectTP is a Transactional CDS View that provides data about "Service Quotation Item Reference Object - TP" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocumentRefObject, I_ServiceDocumentEnhcd) and exposes 10 fields with key fields ServiceQuotation, ServiceQuotationItem, ServiceRefObjectSequenceNumber.

2 data source(s) 10 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 Item Reference Object - TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ServiceQuotation I_ServiceDocumentRefObject ServiceDocument
KEY ServiceQuotationItem I_ServiceDocumentRefObject ServiceDocumentItem
KEY ServiceRefObjectSequenceNumber I_ServiceDocumentRefObject ServiceRefObjectSequenceNumber
SerialNumber I_ServiceDocumentRefObject SerialNumber
ServiceReferenceEquipment I_ServiceDocumentRefObject Equipment
ServiceRefFunctionalLocation
ServiceReferenceProduct I_ServiceDocumentRefObject ProductID
SrvcRefObjIsMainObject I_ServiceDocumentRefObject SrvcRefObjIsMainObject
_ServiceQuotationItemTP _ServiceQuotationItemTP
_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 Item Reference Object - TP'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #B,
                sizeCategory:   #L}
}

define view entity R_SrvcQtanItemRefObjectTP   
  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_ServiceQuotationItemTP as _ServiceQuotationItemTP on  $projection.ServiceQuotation = _ServiceQuotationItemTP.ServiceQuotation
                                                                    and $projection.ServiceQuotationItem     = _ServiceQuotationItemTP.ServiceQuotationItem
   //added for strict                            

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

{
   
  key I_ServiceDocumentRefObject.ServiceDocument                                                   as ServiceQuotation,

  key I_ServiceDocumentRefObject.ServiceDocumentItem                                               as ServiceQuotationItem,
 
  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


      _ServiceQuotationItemTP,

      _ServiceQuotationTP  //added for strict


}

where
      I_ServiceDocumentRefObject.ServiceObjectType   = 'BUS2000116' 
and   I_ServiceDocumentRefObject.ServiceDocumentItem is not initial                                                       
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTENHCD",
"I_SERVICEDOCUMENTREFOBJECT"
],
"ASSOCIATED":
[
"R_SERVICEQUOTATIONITEMTP",
"R_SERVICEQUOTATIONTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More