Which tables does C_SrvcOrderDateTimeline use?

C_SrvcOrderDateTimeline reads from 1 data source(s): I_ServiceDocumentEnhcd.

How many fields does C_SrvcOrderDateTimeline have?

C_SrvcOrderDateTimeline has 8 fields. Key fields: ServiceDocument.

C_SrvcOrderDateTimeline

DDL: C_SRVCORDERDATETIMELINE SQL: CSRVCORDDATE Type: view CONSUMPTION

Date timeline for Service Order

C_SrvcOrderDateTimeline is a Consumption CDS View that provides data about "Date timeline for Service Order" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentEnhcd) and exposes 8 fields with key field ServiceDocument. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ServiceDocumentEnhcd	I_ServiceDocumentEnhcd	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	P_SelectConfItemDates	_SelectConfItemDates	`$projection.ServiceDocument = _SelectConfItemDates.ServiceDocumentPredecessorID`
[1..1]	P_SrvcOrdItemDates	_SrvcOrdItemDates	`$projection.ServiceDocument = _SrvcOrdItemDates.ServiceDocument`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	CSRVCORDDATE	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Date timeline for Service Order	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view

Fields (8)

Key	Field	Source Table	Source Field
KEY	ServiceDocument		ServiceDocument
	ServiceDocumentType		ServiceDocumentType
	ServiceObjectType		ServiceObjectType
	PlannedServiceStartDateTime	_SrvcOrdItemDates	PlannedServiceStartDateTime
	ActualServiceStartDateTime	_SelectConfItemDates	ActualServiceStartDateTime
	PlannedServiceEndDateTime	_SrvcOrdItemDates	PlannedServiceEndDateTime
	ServiceFirstResponseByDateTime	_SrvcOrdItemDates	ServiceFirstResponseByDateTime
	SrvcDocItemSLADueByDateTime	_SrvcOrdItemDates	SrvcDocItemSLADueByDateTime

@AbapCatalog.sqlViewName: 'CSRVCORDDATE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Date timeline for Service Order'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #CONSUMPTION
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
define view C_SrvcOrderDateTimeline
  as select from I_ServiceDocumentEnhcd
  association [1..1] to P_SelectConfItemDates as _SelectConfItemDates on $projection.ServiceDocument = _SelectConfItemDates.ServiceDocumentPredecessorID
  association [1..1] to P_SrvcOrdItemDates    as _SrvcOrdItemDates    on $projection.ServiceDocument = _SrvcOrdItemDates.ServiceDocument
{
  key ServiceDocument,
      ServiceDocumentType,
      ServiceObjectType,
      _SrvcOrdItemDates.PlannedServiceStartDateTime as PlannedServiceStartDateTime,
      _SelectConfItemDates.ActualServiceStartDateTime as ActualServiceStartDateTime,
      _SrvcOrdItemDates.PlannedServiceEndDateTime as PlannedServiceEndDateTime,
      _SrvcOrdItemDates.ServiceFirstResponseByDateTime as ServiceFirstResponseByDateTime,
      _SrvcOrdItemDates.SrvcDocItemSLADueByDateTime as SrvcDocItemSLADueByDateTime
      //      tstmp_to_dats(_SelectConfItemDates.ActualServiceStartDateTime,

      //                    abap_user_timezone($session.user, $session.client,'NULL' ),

      //                    $session.client,

      //                    'NULL' ) as ActualServiceStartDateTime,

      //

//      dats_tims_to_tstmp(tstmp_to_dats(_SelectConfItemDates.ActualServiceStartDateTime,

//                    abap_user_timezone($session.user, $session.client,'NULL' ),

//                    $session.client,

//                    'NULL'),tstmp_to_tims(_SelectConfItemDates.ActualServiceStartDateTime,

//                    abap_user_timezone($session.user, $session.client,'NULL' ),

//                    $session.client,

//                    'NULL') , abap_user_timezone($session.user, $session.client,'NULL' ),

//                    $session.client,

//                    'NULL')       as ActualServiceStartDateTime,



    /*  dats_tims_to_tstmp(tstmp_to_dats(_SrvcOrdItemDates.PlannedServiceStartDateTime,
                   abap_user_timezone($session.user, $session.client,'NULL' ),
                   $session.client,
                   'NULL'),tstmp_to_tims(_SrvcOrdItemDates.PlannedServiceStartDateTime,
                   abap_user_timezone($session.user, $session.client,'NULL' ),
                   $session.client,
                   'NULL') , abap_user_timezone($session.user, $session.client,'NULL' ),
                   $session.client,
//                   'NULL')        as  PlannedServiceStartDateTime,*/

        

      //      tstmp_to_dats(_SrvcOrdItemDates.PlannedServiceStartDateTime,

      //                abap_user_timezone($session.user, $session.client,'NULL' ),

      //                $session.client,

      //                'NULL' )     as PlannedServiceStartDateTime,


//      dats_tims_to_tstmp(tstmp_to_dats(_SrvcOrdItemDates.PlannedServiceEndDateTime,

//                         abap_user_timezone($session.user, $session.client,'NULL' ),

//                         $session.client,

//                         'NULL'),tstmp_to_tims(_SrvcOrdItemDates.PlannedServiceEndDateTime,

//                         abap_user_timezone($session.user, $session.client,'NULL' ),

//                         $session.client,

//                         'NULL') , abap_user_timezone($session.user, $session.client,'NULL' ),

//                         $session.client,

//                         'NULL')  as PlannedServiceEndDateTime,


      //      tstmp_to_dats( _SrvcOrdItemDates.PlannedServiceEndDateTime,

      //                 abap_user_timezone($session.user, $session.client,'NULL' ),

      //                 $session.client,

      //                 'NULL' )    as PlannedServiceEndDateTime,


//      dats_tims_to_tstmp(tstmp_to_dats(_SrvcOrdItemDates.ServiceFirstResponseByDateTime,

//                          abap_user_timezone($session.user, $session.client,'NULL' ),

//                          $session.client,

//                          'NULL'),tstmp_to_tims(_SrvcOrdItemDates.ServiceFirstResponseByDateTime,

//                          abap_user_timezone($session.user, $session.client,'NULL' ),

//                          $session.client,

//                          'NULL') , abap_user_timezone($session.user, $session.client,'NULL' ),

//                          $session.client,

//                          'NULL') as ServiceFirstResponseByDateTime,


      //      tstmp_to_dats(_SrvcOrdItemDates.ServiceFirstResponseByDateTime,

      //                  abap_user_timezone($session.user, $session.client,'NULL' ),

      //                   $session.client,

      //                  'NULL' )   as ServiceFirstResponseByDateTime,


//      dats_tims_to_tstmp(tstmp_to_dats(_SrvcOrdItemDates.SrvcDocItemSLADueByDateTime,

//                          abap_user_timezone($session.user, $session.client,'NULL' ),

//                          $session.client,

//                          'NULL'),tstmp_to_tims(_SrvcOrdItemDates.SrvcDocItemSLADueByDateTime,

//                          abap_user_timezone($session.user, $session.client,'NULL' ),

//                          $session.client,

//                          'NULL') , abap_user_timezone($session.user, $session.client,'NULL' ),

//                          $session.client,

//                          'NULL') as SrvcDocItemSLADueByDateTime

      //      tstmp_to_dats(_SrvcOrdItemDates.SrvcDocItemSLADueByDateTime,

      //                  abap_user_timezone($session.user, $session.client,'NULL' ),

      //                  $session.client,

      //                 'NULL' )    as SrvcDocItemSLADueByDateTime



      //  _SRVCORDITEMDATES,

      // _SelectConfItemDates


}
where
  ServiceObjectType = 'BUS2000116'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTENHCD",
"P_SELECTCONFITEMDATES",
"P_SRVCORDITEMDATES"
],
"ASSOCIATED":
[
"P_SELECTCONFITEMDATES",
"P_SRVCORDITEMDATES"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_SrvcOrderDateTimeline view

I_ServiceDocumentEnhcd view