C_ServiceDocObjPgErrorLog

@AbapCatalog.sqlViewName: 'CSRVCDOCERRORLOG'
@AbapCatalog.compiler.compareFilter: true
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
  }
@EndUserText.label: 'View for Service document error messages'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #CONSUMPTION
}

@ObjectModel: {
   representativeKey: 'ServiceDocument',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   }
}
define view C_ServiceDocObjPgErrorLog
  as select from I_ServiceDocumentEnhcd
  //this join should never satisfy the join condition. intention is to fetch an empty row with left outer join

  association [0..1] to I_SrvcDocErrorMessageDetail as _SrvcDocErrorMessageDetail on _SrvcDocErrorMessageDetail.ServiceDocument = '????'
{

      @UI.hidden: true
  key ServiceDocument,

      @UI.hidden: true
  key ServiceDocumentUUID,

      @UI.hidden: true
  key ServiceObjectType,

      @UI.hidden: true
  key ServiceDocumentType,

      @UI.hidden: true
      @UI.lineItem: [
      {
           position:20 ,
           label: 'Message'
      }]
      @EndUserText.label: 'Message'
  key cast( '' as abap.char(20))                        as ServiceDocErrorMsg,

      @UI.hidden: true
      @UI.lineItem.position:30
      @EndUserText.label: 'Message No'
  key cast( '' as abap.char(10))                        as ServiceDocErrorMsgNo,

      @UI.hidden: true
  key cast( '' as balmnr)                               as ApplicationMessageSerialNumber,
  
    
   /*   @UI.lineItem: [
        {
            position:10 ,
            criticality: 'SrvcDocMsgCriticality',
            criticalityRepresentation: #WITHOUT_ICON
         }]
      @ObjectModel.filter.enabled : false
      //  @ObjectModel.sort.enabled : false

      @EndUserText.label: 'Message Type'  */
  
     @UI.hidden: true
     cast( '' as abap.char(1))                         as ServiceDocErrorMsgType,
   
      @UI.lineItem: [
        {
            position:10 ,
            criticality: 'SrvcDocMsgCriticality',
            criticalityRepresentation: #WITHOUT_ICON
         }]
      @ObjectModel.filter.enabled : false
      //  @ObjectModel.sort.enabled : false

      @EndUserText.label: 'Message Type'
      cast( '' as abap.char(12))                         as ServiceDocErrorMsgTypeText,    

      @UI.hidden: true
      cast( 1 as abap.int1)                             as SrvcDocMsgCriticality,

      @UI.lineItem.position:50
      @ObjectModel.filter.enabled : false
      //   @ObjectModel.sort.enabled : false

      @EndUserText.label: 'Message Description'
      _SrvcDocErrorMessageDetail.ServiceDocErrorMsgDesc as ServiceDocErrorMsgDesc,
      // cast( '' as SYSTRING)                  as ServiceDocErrorMsgDesc,


      @UI.lineItem.position:40
      @ObjectModel.filter.enabled : false
      //   @ObjectModel.sort.enabled : false

      @EndUserText.label: 'Reference Object'
      cast( '' as crmt_ref_obj_text)                    as ServiceDocErrorRefText,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      ResponsibleEmployee,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      SalesOrganization,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DistributionChannel,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      Division,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      SalesOffice,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      SalesGroup,

      // On-Premise Sales Org., Sales Office, Sales Group, Service Org.

      @UI.hidden: true
      @Consumption.filter.hidden: true
      SalesOrganizationOrgUnitID,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      SalesOfficeOrgUnitID,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      SalesGroupOrgUnitID,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      ServiceOrganization
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTENHCD",
"I_SRVCDOCERRORMESSAGEDETAIL"
],
"ASSOCIATED":
[
"I_SRVCDOCERRORMESSAGEDETAIL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/