I_SrvcDocFUPInternalOrder

DDL: I_SRVCDOCFUPINTERNALORDER Type: view BASIC Package: CRMS4_ANALYTICS_COMMON

Follow-Up Internal Order of Srvc Transac

I_SrvcDocFUPInternalOrder is a Basic CDS View (Dimension) that provides data about "Follow-Up Internal Order of Srvc Transac" in SAP S/4HANA. It reads from 4 data sources (iaom_assignments, aufk, iaom_crmsrv_exat, iaom_ext_obj_inf) and exposes 4 fields with key fields InternalOrder, ServiceDocument. Part of development package CRMS4_ANALYTICS_COMMON.

4 data source(s) 4 fields

Data Sources (4)

SourceAliasJoin Type
iaom_assignments ag inner
aufk au from
iaom_crmsrv_exat ex inner
iaom_ext_obj_inf ob inner

Annotations (14)

NameValueLevelField
EndUserText.label Follow-Up Internal Order of Srvc Transac view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISRVFUPINTORD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.allowExtensions true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY InternalOrder aufk aufnr
KEY ServiceDocument iaom_crmsrv_exat object_id
ServiceDocumentDescription iaom_crmsrv_exat process_descript
ServiceDocumentType iaom_crmsrv_exat process_type 
@EndUserText.label: 'Follow-Up Internal Order of Srvc Transac'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: {
  sqlViewName: 'ISRVFUPINTORD',
  compiler.compareFilter: true,
  preserveKey: true
}
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@Analytics: {
   dataCategory: #DIMENSION,
   internalName: #LOCAL
   }
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@ObjectModel: {
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #D,
     sizeCategory:   #XXL
   }
}
@Metadata.allowExtensions:true

define view I_SrvcDocFUPInternalOrder
  as select from aufk             as au
    inner join   iaom_assignments as ag on ag.object_no = au.objnr
    inner join   iaom_crmsrv_exat as ex on ex.ext_object_id = ag.ext_object_id
    inner join   iaom_ext_obj_inf as ob on  ob.ext_object_id   = ag.ext_object_id
                                        and ob.bus_scenario_id = ag.bus_scenario_id
{
  key    au.aufnr            as InternalOrder,
  key    ex.object_id        as ServiceDocument,
         ex.process_descript as ServiceDocumentDescription,
         ex.process_type     as ServiceDocumentType
}

Learn More