I_ELECTRONICDOC

CDS View

eDocument

I_ELECTRONICDOC is a CDS View in S/4HANA. eDocument. It contains 38 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_EDocCockpitRelevantOvw view_entity from CONSUMPTION Entity for Create Electronic Documents
C_ElectronicDocByMetaStatus view_entity from CONSUMPTION eDocument by Metastatus
C_ElectronicDocCockpitFilter view from CONSUMPTION Mng Electronic Documents: Filter
C_ElectronicDocCockpitHistory view union CONSUMPTION Mng Electronic Documents: History
C_ElectronicDocMetaStatusSum view_entity from CONSUMPTION eDocument Metastatus Summary
I_EDCElectronicDocRelation view_entity from BASIC eDocument Consistency Relationship
I_ElectronicDocCockpitList view from COMPOSITE Electronic Document List
I_ElectronicDocCockpitList view union COMPOSITE Electronic Document List
I_ElectronicDocFile view from COMPOSITE eDocument File
I_ElectronicDocFile view union_all COMPOSITE eDocument File
I_PE_ElectronicDocument view_entity from COMPOSITE Peru eDocument
I_TR_ElectronicDocInvoice view from COMPOSITE eDocument Turkey eInvoice
R_EDCElectronicDoc view_entity from BASIC EDC Electronic Doc

Fields (38)

KeyField CDS FieldsUsed in Views
KEY ElectronicDocCompanyCode ElectronicDocCompanyCode 7
KEY ElectronicDocCountry Country,ElectronicDocCountry 6
KEY ElectronicDocInterfaceType ElectronicDocInterfaceType 3
KEY ElectronicDocProcess ElectronicDocProcess 6
KEY ElectronicDocSourceKey ElectronicDocSourceKey 4
KEY ElectronicDocSourceType ElectronicDocSourceType 4
KEY ElectronicDocType ElectronicDocType 4
KEY ElectronicDocUUID ElectronicDocUUID 6
ElectronicDocApprovalIDValue ElectronicDocApprovalIDValue 1
ElectronicDocClassName ElectronicDocClassName 1
ElectronicDocCreatedByUser ElectronicDocCreatedByUser 3
ElectronicDocCreationDate ElectronicDocCreationDate 5
ElectronicDocCreationTime ElectronicDocCreationTime 3
ElectronicDocFileUUID ElectronicDocFileUUID 2
ElectronicDocHasError ElectronicDocHasError 2
ElectronicDocInterfaceID ElectronicDocInterfaceID 2
ElectronicDocInterfaceUUID ElectronicDocInterfaceUUID 1
ElectronicDocInterfaceVersion ElectronicDocInterfaceVersion 2
ElectronicDocIsArchPrprocgDone ElectronicDocIsArchPrprocgDone 2
ElectronicDocIsCntdInArchive ElectronicDocIsCntdInArchive 2
ElectronicDocIsContingency ElectronicDocIsContingency 2
ElectronicDocLastChangeDate ElectronicDocLastChangeDate 3
ElectronicDocLastChangedByUser ElectronicDocLastChangedByUser 2
ElectronicDocLastChangeTime ElectronicDocLastChangeTime 3
ElectronicDocLastProcStep ElectronicDocLastProcStep 2
ElectronicDocLastProcStepVar ElectronicDocLastProcStepVar 2
ElectronicDocLogicalSystem ElectronicDocLogicalSystem 1
ElectronicDocMetaStatus ElectronicDocMetaStatus 3
ElectronicDocPostingDate ElectronicDocPostingDate 3
ElectronicDocProcessForStatus ElectronicDocProcessForStatus 1
ElectronicDocProcessStatus ElectronicDocProcessStatus 4
ElectronicDocProcessVersion ElectronicDocProcessVersion 2
ElectronicDocReferenceProcess ElectronicDocReferenceProcess 2
ElectronicDocRefSqncNmbr ElectronicDocRefSqncNmbr 1
ElectronicDocResponseCodeValue ElectronicDocResponseCodeValue 1
ElectronicDocSequenceNmbr ElectronicDocSequenceNmbr 2
ElectronicDocSrceCreatedByUser ElectronicDocSrceCreatedByUser 3
ElectronicDocStatus ElectronicDocStatus 2
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EDOCUMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/