I_ElectronicDocFile

DDL: I_ELECTRONICDOCFILE Type: view COMPOSITE Package: GLO-EDO

eDocument File

I_ElectronicDocFile is a Composite CDS View that provides data about "eDocument File" in SAP S/4HANA. It reads from 4 data sources (I_ElectronicDocCommFile, I_ElectronicDoc, I_ElectronicDoc, I_ElectronicDocSourceFile) and exposes 47 fields with key field ElectronicDocFileUUID. It has 5 associations to related views. Part of development package GLO-EDO.

4 data source(s) 47 fields

Data Sources (4)

SourceAliasJoin Type
I_ElectronicDocCommFile File inner
I_ElectronicDoc Header from
I_ElectronicDoc Header union_all
I_ElectronicDocSourceFile SourceFile inner

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_CountryText _CountryText $projection.ElectronicDocCountry = _CountryText.Country
[0..*] I_ElectronicDocTypeText _ElectronicDocTypeText $projection.ElectronicDocType = _ElectronicDocTypeText.ElectronicDocType
[0..*] I_ElectronicDocSourceTypeText _ElectronicDocSourceTypeText $projection.ElectronicDocSourceType = _ElectronicDocSourceTypeText.ElectronicDocSourceType
[0..*] I_ElectronicDocProcStatusText _ElectronicDocProcStatusText $projection.ElectronicDocProcessForStatus = _ElectronicDocProcStatusText.ElectronicDocProcess and $projection.ElectronicDocProcessStatus = _ElectronicDocProcStatusText.ElectronicDocProcessStatus
[0..*] I_ElectronicDocProcessText _ElectronicDocProcessText $projection.ElectronicDocProcess = _ElectronicDocProcessText.ElectronicDocProcess

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IEDOFILE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label eDocument File view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocFileUUID I_ElectronicDocCommFile ElectronicDocFileUUID
ElectronicDocFileType ElectronicDocFileType
ElectronicDocFileName ElectronicDocFileName
ElectronicDocFileCreationTime ElectronicDocFileCreationTime
ElectronicDocFileCreationDate ElectronicDocFileCreationDate
ElectronicDocFileContent ElectronicDocFileContent
ElectronicDocUUID I_ElectronicDoc ElectronicDocUUID
ElectronicDocCompanyCode I_ElectronicDoc ElectronicDocCompanyCode
ElectronicDocCountry ElectronicDocCountry
ElectronicDocSourceType ElectronicDocSourceType
ElectronicDocSourceKey ElectronicDocSourceKey
ElectronicDocType ElectronicDocType
ElectronicDocProcess ElectronicDocProcess
ElectronicDocProcessStatus ElectronicDocProcessStatus
ElectronicDocLastChangeDate ElectronicDocLastChangeDate
ElectronicDocLastChangeTime ElectronicDocLastChangeTime
ElectronicDocCreationDate ElectronicDocCreationDate
ElectronicDocCreationTime ElectronicDocCreationTime
ElectronicDocProcessForStatus ElectronicDocProcessForStatus
_CountryText _CountryText
_ElectronicDocTypeText _ElectronicDocTypeText
_ElectronicDocSourceTypeText _ElectronicDocSourceTypeText
_ElectronicDocProcStatusText _ElectronicDocProcStatusText
ElectronicDocFileUUID
ElectronicDocFileType ElectronicDocFileType
ElectronicDocFileName ElectronicDocFileName
ElectronicDocFileCreationTime ElectronicDocFileCreationTime
ElectronicDocFileCreationDate ElectronicDocFileCreationDate
ElectronicDocFileContent ElectronicDocFileContent
ElectronicDocUUID I_ElectronicDoc ElectronicDocUUID
ElectronicDocCompanyCode I_ElectronicDoc ElectronicDocCompanyCode
ElectronicDocCountry ElectronicDocCountry
ElectronicDocSourceType ElectronicDocSourceType
ElectronicDocSourceKey ElectronicDocSourceKey
ElectronicDocType ElectronicDocType
ElectronicDocProcess ElectronicDocProcess
ElectronicDocProcessStatus ElectronicDocProcessStatus
ElectronicDocLastChangeDate ElectronicDocLastChangeDate
ElectronicDocLastChangeTime ElectronicDocLastChangeTime
ElectronicDocCreationDate ElectronicDocCreationDate
ElectronicDocCreationTime ElectronicDocCreationTime
ElectronicDocProcessForStatus ElectronicDocProcessForStatus
_CountryText _CountryText
_ElectronicDocTypeText _ElectronicDocTypeText
_ElectronicDocSourceTypeText _ElectronicDocSourceTypeText
_ElectronicDocProcStatusText _ElectronicDocProcStatusText
_ElectronicDocProcessText _ElectronicDocProcessText 
@AbapCatalog: {
  sqlViewName: 'IEDOFILE',
  compiler.compareFilter: true,
  preserveKey: true
  }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'eDocument File'

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

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #X,
  sizeCategory: #M
  }
define view I_ElectronicDocFile

  // Part 1: eDocument Files

  as select from I_ElectronicDoc         as Header
    inner join   I_ElectronicDocCommFile as File    on File.ElectronicDocUUID = Header.ElectronicDocUUID

  association [0..*] to I_CountryText                 as _CountryText                 on  $projection.ElectronicDocCountry = _CountryText.Country
  association [0..*] to I_ElectronicDocTypeText       as _ElectronicDocTypeText       on  $projection.ElectronicDocType = _ElectronicDocTypeText.ElectronicDocType
  association [0..*] to I_ElectronicDocSourceTypeText as _ElectronicDocSourceTypeText on  $projection.ElectronicDocSourceType = _ElectronicDocSourceTypeText.ElectronicDocSourceType
  association [0..*] to I_ElectronicDocProcStatusText as _ElectronicDocProcStatusText on  $projection.ElectronicDocProcessForStatus = _ElectronicDocProcStatusText.ElectronicDocProcess
                                                                                      and $projection.ElectronicDocProcessStatus = _ElectronicDocProcStatusText.ElectronicDocProcessStatus
  association [0..*] to I_ElectronicDocProcessText    as _ElectronicDocProcessText    on  $projection.ElectronicDocProcess = _ElectronicDocProcessText.ElectronicDocProcess
{
  key File.ElectronicDocFileUUID,
      ElectronicDocFileType,
      ElectronicDocFileName,
      ElectronicDocFileCreationTime,
      ElectronicDocFileCreationDate,
      ElectronicDocFileContent,

      Header.ElectronicDocUUID,
      Header.ElectronicDocCompanyCode,
      ElectronicDocCountry,
      ElectronicDocSourceType,
      ElectronicDocSourceKey,
      ElectronicDocType,
      ElectronicDocProcess,
      ElectronicDocProcessStatus,
      ElectronicDocLastChangeDate,
      ElectronicDocLastChangeTime,
      ElectronicDocCreationDate,
      ElectronicDocCreationTime,
      ElectronicDocProcessForStatus,

      //Associations

      _CountryText,
      _ElectronicDocTypeText,
      _ElectronicDocSourceTypeText,
      _ElectronicDocProcStatusText,
      _ElectronicDocProcessText
}


// Part 2: eDocument Source Files

union all select from I_ElectronicDoc           as Header
  inner join          I_ElectronicDocSourceFile as SourceFile on SourceFile.ElectronicDocFileUUID = Header.ElectronicDocSourceKey
                                                             and Header.ElectronicDocSourceType   = 'SRC_FILE'

association [0..*] to I_CountryText                 as _CountryText                 on  $projection.ElectronicDocCountry = _CountryText.Country
association [0..*] to I_ElectronicDocTypeText       as _ElectronicDocTypeText       on  $projection.ElectronicDocType = _ElectronicDocTypeText.ElectronicDocType
association [0..*] to I_ElectronicDocSourceTypeText as _ElectronicDocSourceTypeText on  $projection.ElectronicDocSourceType = _ElectronicDocSourceTypeText.ElectronicDocSourceType
association [0..*] to I_ElectronicDocProcStatusText as _ElectronicDocProcStatusText on  $projection.ElectronicDocProcessForStatus = _ElectronicDocProcStatusText.ElectronicDocProcess
                                                                                    and $projection.ElectronicDocProcessStatus = _ElectronicDocProcStatusText.ElectronicDocProcessStatus
association [0..*] to I_ElectronicDocProcessText    as _ElectronicDocProcessText    on  $projection.ElectronicDocProcess = _ElectronicDocProcessText.ElectronicDocProcess
{
  key SourceFile.ElectronicDocFileUUID,
      ElectronicDocFileType,
      ElectronicDocFileName,
      ElectronicDocFileCreationTime,
      ElectronicDocFileCreationDate,
      ElectronicDocFileContent,

      Header.ElectronicDocUUID,
      Header.ElectronicDocCompanyCode,
      ElectronicDocCountry,
      ElectronicDocSourceType,
      ElectronicDocSourceKey,
      ElectronicDocType,
      ElectronicDocProcess,
      ElectronicDocProcessStatus,
      ElectronicDocLastChangeDate,
      ElectronicDocLastChangeTime,
      ElectronicDocCreationDate,
      ElectronicDocCreationTime,
      ElectronicDocProcessForStatus,

      //Associations

      _CountryText,
      _ElectronicDocTypeText,
      _ElectronicDocSourceTypeText,
      _ElectronicDocProcStatusText,
      _ElectronicDocProcessText
}

Learn More