I_SrvcOrdRefMaintenancePlan

DDL: I_SRVCORDREFMAINTENANCEPLAN Type: view BASIC

Ref. maintenance plan of a service order

I_SrvcOrdRefMaintenancePlan is a Basic CDS View that provides data about "Ref. maintenance plan of a service order" in SAP S/4HANA. It reads from 1 data source (crmd_brelvonae) and exposes 7 fields with key fields ServiceDocumentRelationUUID, ServiceDocRltnSequenceNumber.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
crmd_brelvonae crmd_brelvonae from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName ISRVCORDREFMPLAN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Ref. maintenance plan of a service order view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentRelationUUID relationid
KEY ServiceDocRltnSequenceNumber posno
ServiceDocumentRelationType breltyp
MaintenancePlan
MaintenancePlanDesc mpla wptxt
ServiceDocumentUUID objguid_b_sel
ServiceObjectType objtype_b_sel 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #BASIC
}
@AbapCatalog: {
  sqlViewName: 'ISRVCORDREFMPLAN',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #NOT_REQUIRED
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   }
}
@EndUserText.label: 'Ref. maintenance plan of a service order'
define view I_SrvcOrdRefMaintenancePlan
  as select from           crmd_brelvonae
    left outer to one join mpla on warpl = objkey_a_sel
{
  key relationid                  as ServiceDocumentRelationUUID,
  key posno                       as ServiceDocRltnSequenceNumber,
      breltyp                     as ServiceDocumentRelationType,

      cast(objkey_a_sel as warpl) as MaintenancePlan,
      mpla.wptxt                  as MaintenancePlanDesc,

      objguid_b_sel               as ServiceDocumentUUID,
      objtype_b_sel               as ServiceObjectType
}
where
      objtype_a_sel = 'BUS1020' //Maintenance Plan object type

  and objtype_b_sel = 'BUS2000116'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CRMD_BRELVONAE",
"MPLA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More