R_SrvcConfAppointmentTP

DDL: R_SRVCCONFAPPOINTMENTTP Type: view_entity TRANSACTIONAL

Service Confirmation Appointment - TP

R_SrvcConfAppointmentTP is a Transactional CDS View that provides data about "Service Confirmation Appointment - TP" in SAP S/4HANA. It reads from 2 data sources (I_SrvcDocAppointment, I_ServiceDocument) and exposes 5 fields with key fields ServiceConfirmation, SrvcDocAppointmentType.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_SrvcDocAppointment ServiceAppointment from
I_ServiceDocument ServiceConfirmation 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 Confirmation Appointment - TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ServiceConfirmation I_ServiceDocument ServiceDocument
KEY SrvcDocAppointmentType I_SrvcDocAppointment SrvcDocAppointmentType
SrvcDocApptStartDateTime I_SrvcDocAppointment SrvcDocApptStartDateTime
SrvcDocApptEndDateTime I_SrvcDocAppointment SrvcDocApptEndDateTime
_ServiceConfirmationTP _ServiceConfirmationTP 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}
@EndUserText.label: 'Service Confirmation Appointment - TP'
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #L
   }
}
define view entity R_SrvcConfAppointmentTP
  as select from I_SrvcDocAppointment  as ServiceAppointment
 // inner join   R_ServiceConfirmationTP  as ServiceConfirmation on  ServiceAppointment.SrvcMgmtObjectUUID = ServiceConfirmation.ServiceConfirmationUUID

    inner join   I_ServiceDocument  as ServiceConfirmation on  ServiceAppointment.SrvcMgmtObjectUUID = ServiceConfirmation.ServiceDocumentUUID
                                                           and ServiceConfirmation.ServiceObjectType  = 'BUS2000117'
  association to parent R_ServiceConfirmationTP as _ServiceConfirmationTP on $projection.ServiceConfirmation = _ServiceConfirmationTP.ServiceConfirmation
{

//key ServiceConfirmation.ServiceConfirmation                 as ServiceConfirmation,

key ServiceConfirmation.ServiceDocument                     as ServiceConfirmation,   
key ServiceAppointment.SrvcDocAppointmentType               as SrvcDocAppointmentType, 
    ServiceAppointment.SrvcDocApptStartDateTime             as SrvcDocApptStartDateTime,
    ServiceAppointment.SrvcDocApptEndDateTime               as SrvcDocApptEndDateTime,
    _ServiceConfirmationTP
}
where  ServiceAppointment.SrvcDocApptStartDateTime is not initial 
or     ServiceAppointment.SrvcDocApptEndDateTime   is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENT",
"I_SRVCDOCAPPOINTMENT"
],
"ASSOCIATED":
[
"R_SERVICECONFIRMATIONTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More