I_SERVICEDOCUMENTDURATION

CDS View

Service Transaction Duration

I_SERVICEDOCUMENTDURATION is a CDS View in S/4HANA. Service Transaction Duration. It contains 11 fields. 19 CDS views read from this table.

Used by 19 CDS view(s) 11 fields

CDS Views using this table (19)

ViewTypeJoinVDMDescription
A_SrvcConfDuration view_entity from COMPOSITE Service Confirmation Duration
A_SrvcConfItemDuration view_entity from COMPOSITE Service Confirmation Item Duration
A_SrvcOrdDuration view_entity from COMPOSITE Service Order Duration
A_SrvcOrdItemDuration view_entity from COMPOSITE Service Order Item Duration
A_SrvcOrdTmplDuration view_entity from COMPOSITE Service Order Template Duration
A_SrvcOrdTmplItemDuration view_entity from COMPOSITE Service Order Template Item Duration
I_ServiceDocumentDurationEnhcd view_entity from COMPOSITE Service Transaction Duration Enhanced
I_SrvcDocDateInformation view union_all COMPOSITE Date Information for Service Transaction
I_SubscrpnOrdItemDuration view_entity from COMPOSITE Item Duration
P_SrvcDocItemDurationTP view_entity inner COMPOSITE Service Transaction Item Duration
R_BusSolnOrdItmDurationTP view_entity from TRANSACTIONAL Business Solution Order Item Duration - TP
R_SrvcConfDurationTP view_entity from TRANSACTIONAL Service Confirmation Duration - TP
R_SrvcContrDurationTP view_entity from TRANSACTIONAL Service Contract Duration - TP
R_SrvcContrItemDurationTP view_entity from TRANSACTIONAL Service Contract Item Duration - TP
R_SrvcContrTmplDurationTP view_entity from TRANSACTIONAL Service Contract Template Duration - TP
R_SrvcContrTmplItemDurationTP view_entity from TRANSACTIONAL Duration of SrvcContr Template Item - TP
R_SrvcOrdDurationTP view_entity from TRANSACTIONAL Service Order Duration - TP
R_SrvcOrdTmplDurationTP view_entity from TRANSACTIONAL Service Order Template Duration - TP
R_SrvcQtanDurationTP view_entity from TRANSACTIONAL Service Quotation Duration - TP

Fields (11)

KeyField CDS FieldsUsed in Views
KEY ServiceDocument BusinessSolutionOrder,ServiceConfirmation,ServiceContract,ServiceContractTemplate,ServiceDocument,ServiceOrder,ServiceOrderTemplate,ServiceQuotation,SubscriptionOrder 17
KEY ServiceDocumentItem BusinessSolutionOrderItem,ServiceConfirmationItem,ServiceContractTemplateItem,ServiceDocumentItem,ServiceOrderItem,ServiceOrderTemplateItem,SubscriptionOrderItem 8
KEY ServiceObjectType ServiceObjectType 2
KEY SrvcDocAppointmentType SrvcDocAppointmentType 1
KEY SrvcDocDurationType SrvcDocDurationType,SubscrpnOrdDurationType 18
KEY SrvcMgmtObjectUUID SrvcMgmtObjectUUID 1
_ServiceObjType _ServiceObjType 1
SrvcDocApptEndDateTime SrvcDocApptEndDateTime 1
SrvcDocApptStartDateTime SrvcDocApptStartDateTime 1
SrvcDocDurationUnit SrvcDocDurationUnit,SubscrpnOrdDurationUnit 19
SrvcDocDurationValue SrvcDocDurationValue,SubscrpnOrdDurationValue 18 
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Service Transaction Duration'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AbapCatalog: {
  sqlViewName: 'ISERVDOCDURA',
  compiler.compareFilter: true
}
@ObjectModel: {
  usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
}
@Metadata.ignorePropagatedAnnotations: true
define view I_ServiceDocumentDuration
  as select from crms4d_duration

  association [1..1] to I_CustMgmtBusObjType      as _ServiceObjType on  $projection.ServiceObjectType = _ServiceObjType.BusinessObjectType

  association [0..1] to I_SrvcDocDurationTypeText as _DurationText   on  $projection.SrvcDocDurationType = _DurationText.SrvcDocDurationType
                                                                     and _DurationText.Language          = $session.system_language
{

      @ObjectModel.foreignKey.association: '_ServiceObjType'
  key objtype_h          as ServiceObjectType,
  key object_id          as ServiceDocument,
  key number_int         as ServiceDocumentItem,
  key name_dura          as SrvcDocDurationType,
      duration           as SrvcDocDurationValue,
      time_unit          as SrvcDocDurationUnit,
      @Semantics.text: true
      _DurationText.SrvcDocDurationTypeText as SrvcDocDurationTypeText,

      //Associations

      _ServiceObjType,
      _DurationText

}

Learn More