I_ELECTRONICDOC

@AbapCatalog: {
  sqlViewName: 'IEDOCUMENT',
  compiler.compareFilter: true,
  preserveKey: true
  }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'eDocument'

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  dataClass: #TRANSACTIONAL,
  serviceQuality: #A,
  sizeCategory: #M
  }
define view I_ElectronicDoc
  as select from edocument
{
  key edoc_guid             as ElectronicDocUUID,
      seq_no                as ElectronicDocSequenceNmbr,
      bukrs                 as ElectronicDocCompanyCode,
      land                  as ElectronicDocCountry,
      source_type           as ElectronicDocSourceType,
      source_key            as ElectronicDocSourceKey,
      edoc_type             as ElectronicDocType,
      proc_status           as ElectronicDocProcessStatus,
      logsys                as ElectronicDocLogicalSystem,
      changed_by            as ElectronicDocLastChangedByUser,
      change_date           as ElectronicDocLastChangeDate,
      change_time           as ElectronicDocLastChangeTime,
      created_by            as ElectronicDocCreatedByUser,
      create_date           as ElectronicDocCreationDate,
      create_time           as ElectronicDocCreationTime,
      source_created_by     as ElectronicDocSrceCreatedByUser,
      process               as ElectronicDocProcess,
      last_procstep         as ElectronicDocLastProcStep,
      last_procstep_variant as ElectronicDocLastProcStepVar,    
      error_flag            as ElectronicDocHasError,
      process_version       as ElectronicDocProcessVersion,
      docref_seqnr          as ElectronicDocRefSqncNmbr,
      status                as ElectronicDocStatus,
      posting_date          as ElectronicDocPostingDate,
      contingency           as ElectronicDocIsContingency,
      ref_process           as ElectronicDocReferenceProcess,
      edocument_class       as ElectronicDocClassName,
      archive_prep          as ElectronicDocIsArchPrprocgDone,
      interface_type        as ElectronicDocInterfaceType,
      approval_id           as ElectronicDocApprovalIDValue,
      interface_guid        as ElectronicDocInterfaceUUID,
      file_guid             as ElectronicDocFileUUID,
      response_code         as ElectronicDocResponseCodeValue,
      interface_id          as ElectronicDocInterfaceID,
      int_version           as ElectronicDocInterfaceVersion,
      count_archive         as ElectronicDocIsCntdInArchive,
      metastatus            as ElectronicDocMetaStatus,

      case when edocument.ref_process is initial then edocument.process
           else edocument.ref_process
           end              as ElectronicDocProcessForStatus
}