P_CONFITEMDATES

CDS View

P_CONFITEMDATES is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SelectConfItemDates view from COMPOSITE 
@AbapCatalog.sqlViewName: 'PCONFITMDATE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
define view P_ConfItemDates as select from I_ServiceDocumentItemEnhcd 
association [1..1] to I_SrvcOrderFUPSrvcConfirmation         as _SrvcOrderFUPSrvcConfirmation        on  $projection.ServiceDocumentUUID = _SrvcOrderFUPSrvcConfirmation.ServiceDocumentUUID
{
  //I_ServiceDocumentItemEnhcd 

  key ServiceDocument, 
 key ServiceDocumentItem, 
  ServiceDocumentUUID,
  _SrvcOrderFUPSrvcConfirmation.ServiceOrder as ServiceDocumentPredecessorID,
  ActualServiceStartDateTime
  //min (ActualServiceStartDateTime) as ActualServiceStartDateTime

}
where
  ServiceObjectType = 'BUS2000117'
//  and ServiceDocumentItemStatus != 'C' //! TODO: Replace with IsOpen and IsReleased check

  and ServiceDocumentItemObjectType = 'BUS2000143'
  and ServiceDocumentItemIsRejected != 'X'
 // and ( ServiceDocItemCategory = 'SCP1' or ServiceDocItemCategory = 'SCP2' or ServiceDocItemCategory = 'SCP3' ) //! TODO: Replace with BUS2000143 - Service Item

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTITEMENHCD",
"I_SRVCORDERFUPSRVCCONFIRMATION"
],
"ASSOCIATED":
[
"I_SRVCORDERFUPSRVCCONFIRMATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More