I_ElectronicDoc

DDL: I_ELECTRONICDOC Type: view BASIC Package: GLO-EDO

eDocument

I_ElectronicDoc is a Basic CDS View that provides data about "eDocument" in SAP S/4HANA. It reads from 1 data source (edocument) and exposes 38 fields with key field ElectronicDocUUID. Part of development package GLO-EDO.

Data Sources (1)

SourceAliasJoin Type
edocument edocument from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IEDOCUMENT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label eDocument view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID edoc_guid eDocument GUID
ElectronicDocSequenceNmbr seq_no Value Number
ElectronicDocCompanyCode bukrs Value
ElectronicDocCountry land CtryReg ISO Cd
ElectronicDocSourceType source_type SRVC Source Type
ElectronicDocSourceKey source_key Source System Key
ElectronicDocType edoc_type eDoc Type
ElectronicDocProcessStatus proc_status Work Item ID
ElectronicDocLogicalSystem logsys Source system
ElectronicDocLastChangedByUser changed_by User Name
ElectronicDocLastChangeDate change_date Time Stamp
ElectronicDocLastChangeTime change_time Time Stamp
ElectronicDocCreatedByUser created_by Version Created By
ElectronicDocCreationDate create_date Time Stamp
ElectronicDocCreationTime create_time Time
ElectronicDocSrceCreatedByUser source_created_by Source Crted By
ElectronicDocProcess process Trans.
ElectronicDocLastProcStep last_procstep Last ProcStep
ElectronicDocLastProcStepVar last_procstep_variant Last Variant
ElectronicDocHasError error_flag Error Flag
ElectronicDocProcessVersion process_version Process Version
ElectronicDocRefSqncNmbr docref_seqnr Doc.Ref. SeqNr
ElectronicDocStatus status Workflow Status
ElectronicDocPostingDate posting_date Posting Date
ElectronicDocIsContingency contingency Contingency
ElectronicDocReferenceProcess ref_process Reference Proc.
ElectronicDocClassName edocument_class eDoc.Class Name
ElectronicDocIsArchPrprocgDone archive_prep Arch. Preproc.
ElectronicDocInterfaceType interface_type Plug-In Interface Tp
ElectronicDocApprovalIDValue approval_id Approval ID
ElectronicDocInterfaceUUID interface_guid Interface GUID
ElectronicDocFileUUID file_guid File GUID
ElectronicDocResponseCodeValue response_code Response Code
ElectronicDocInterfaceID interface_id Interface ID
ElectronicDocInterfaceVersion int_version Version
ElectronicDocIsCntdInArchive count_archive Arch. Counter
ElectronicDocMetaStatus metastatus Status
ElectronicDocTaxReportingDate tax_reporting_date Tax Reporting Date

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ElectronicDoc.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ElectronicDoc AS
SELECT
  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,
  tax_reporting_date AS ElectronicDocTaxReportingDate
FROM edocument
;