I_ServiceDocumentDurationEnhcd

DDL: I_SERVICEDOCUMENTDURATIONENHCD Type: view_entity COMPOSITE Package: CRMS4_REPORT

Service Transaction Duration Enhanced

I_ServiceDocumentDurationEnhcd is a Composite CDS View that provides data about "Service Transaction Duration Enhanced" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentDuration) and exposes 9 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem, SrvcDocDurationType. It has 1 association to related views. Part of development package CRMS4_REPORT.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentDuration _ServiceDocumentDuration from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UnitOfMeasure _UoM _UoM.IsPrimaryUnitForISOCode = 'X' and _UoM.UnitOfMeasureISOCode = $projection.SrvcDocDurationUnitISOCode

Annotations (8)

NameValueLevelField
EndUserText.label Service Transaction Duration Enhanced view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType I_ServiceDocumentDuration ServiceObjectType
KEY ServiceDocument I_ServiceDocumentDuration ServiceDocument
KEY ServiceDocumentItem I_ServiceDocumentDuration ServiceDocumentItem
KEY SrvcDocDurationType I_ServiceDocumentDuration SrvcDocDurationType
SrvcDocDurationValue I_ServiceDocumentDuration SrvcDocDurationValue
SrvcDocDurationUnit I_ServiceDocumentDuration SrvcDocDurationUnit
SrvcDocDurationUnitISOCode _SrvcDocDurationUnitMapping DurationUnitISOCode
SrvcDocDurationUnitSAPCode
_ServiceObjType I_ServiceDocumentDuration _ServiceObjType 
@EndUserText.label: 'Service Transaction Duration Enhanced'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ObjectModel: {
  usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
}
@Metadata.ignorePropagatedAnnotations: true
define view entity I_ServiceDocumentDurationEnhcd
  as select from    I_ServiceDocumentDuration as _ServiceDocumentDuration
    left outer many to one join I_SrvcDocDurationUnitMapping as _SrvcDocDurationUnitMapping on _ServiceDocumentDuration.SrvcDocDurationUnit = _SrvcDocDurationUnitMapping.SrvcDocDurationUnit
  association [1..1] to I_UnitOfMeasure as _UoM on  _UoM.IsPrimaryUnitForISOCode = 'X'
                                                and _UoM.UnitOfMeasureISOCode    = $projection.SrvcDocDurationUnitISOCode
{
      @ObjectModel.foreignKey.association: '_ServiceObjType'
  key _ServiceDocumentDuration.ServiceObjectType,
  key _ServiceDocumentDuration.ServiceDocument,
  key _ServiceDocumentDuration.ServiceDocumentItem,
  key _ServiceDocumentDuration.SrvcDocDurationType,
      _ServiceDocumentDuration.SrvcDocDurationValue,
      _ServiceDocumentDuration.SrvcDocDurationUnit,
      _SrvcDocDurationUnitMapping.DurationUnitISOCode as SrvcDocDurationUnitISOCode,
      cast(_UoM.UnitOfMeasureSAPCode as meins) as SrvcDocDurationUnitSAPCode,

      //Associations

      _ServiceDocumentDuration._ServiceObjType

}

Learn More