R_EDCElectronicDoc

DDL: R_EDCELECTRONICDOC Type: view_entity BASIC
42 Fields 1 Data Sources 4 Associations

EDC Electronic Doc

R_EDCElectronicDoc is a Basic CDS View that provides data about "EDC Electronic Doc" in SAP S/4HANA. It reads from 1 data source (I_ElectronicDoc) and exposes 42 fields with key field ElectronicDocUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ElectronicDoc I_ElectronicDoc from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_ElectronicDocTypeText _ElectronicDocTypeText $projection.ElectronicDocType = _ElectronicDocTypeText.ElectronicDocType and _ElectronicDocTypeText.Language = $session.system_language
[0..1] I_ElectronicDocSourceTypeText _ElectronicDocSourceTypeText $projection.ElectronicDocSourceType = _ElectronicDocSourceTypeText.ElectronicDocSourceType and _ElectronicDocSourceTypeText.Language = $session.system_language
[0..1] I_ElectronicDocProcessText _ElectronicDocProcessText $projection.ElectronicDocProcess = _ElectronicDocProcessText.ElectronicDocProcess and _ElectronicDocProcessText.Language = $session.system_language
[0..1] I_ElectronicDocProcStatusText _ElectronicDocProcStatusText $projection.ElectronicDocProcess = _ElectronicDocProcStatusText.ElectronicDocProcess and $projection.ElectronicDocProcessStatus = _ElectronicDocProcStatusText.ElectronicDocProcessStatus and _ElectronicDocProcStatusText.Language = $session.system_language

Annotations (7)

NameValueLevelField
EndUserText.label EDC Electronic Doc view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID ElectronicDocUUID eDocument GUID
ElectronicDocSequenceNmbr ElectronicDocSequenceNmbr Value Number
ElectronicDocCompanyCode ElectronicDocCompanyCode Value
ElectronicDocCountry ElectronicDocCountry CtryReg ISO Cd
ElectronicDocSourceType ElectronicDocSourceType SRVC Source Type
ElectronicDocSourceKey ElectronicDocSourceKey Source System Key
ElectronicDocType ElectronicDocType eDoc Type
ElectronicDocProcessStatus ElectronicDocProcessStatus Work Item ID
ElectronicDocLogicalSystem ElectronicDocLogicalSystem Source system
ElectronicDocLastChangedByUser ElectronicDocLastChangedByUser User Name
ElectronicDocLastChangeDate ElectronicDocLastChangeDate Time Stamp
ElectronicDocLastChangeTime ElectronicDocLastChangeTime Time Stamp
ElectronicDocCreatedByUser ElectronicDocCreatedByUser Version Created By
ElectronicDocCreationDate ElectronicDocCreationDate Time Stamp
ElectronicDocCreationTime ElectronicDocCreationTime Time
ElectronicDocSrceCreatedByUser ElectronicDocSrceCreatedByUser Source Crted By
ElectronicDocProcess ElectronicDocProcess Trans.
ElectronicDocLastProcStep ElectronicDocLastProcStep Last ProcStep
ElectronicDocLastProcStepVar ElectronicDocLastProcStepVar Last Variant
ElectronicDocHasError ElectronicDocHasError Error Flag
ElectronicDocProcessVersion ElectronicDocProcessVersion Process Version
ElectronicDocRefSqncNmbr ElectronicDocRefSqncNmbr Doc.Ref. SeqNr
ElectronicDocStatus ElectronicDocStatus Workflow Status
ElectronicDocPostingDate ElectronicDocPostingDate Posting Date
ElectronicDocIsContingency ElectronicDocIsContingency Contingency
ElectronicDocReferenceProcess ElectronicDocReferenceProcess Reference Proc.
ElectronicDocClassName ElectronicDocClassName eDoc.Class Name
ElectronicDocIsArchPrprocgDone ElectronicDocIsArchPrprocgDone Arch. Preproc.
ElectronicDocInterfaceType ElectronicDocInterfaceType Plug-In Interface Tp
ElectronicDocApprovalIDValue ElectronicDocApprovalIDValue Approval ID
ElectronicDocInterfaceUUID ElectronicDocInterfaceUUID Interface GUID
ElectronicDocFileUUID ElectronicDocFileUUID File GUID
ElectronicDocResponseCodeValue ElectronicDocResponseCodeValue Response Code
ElectronicDocInterfaceID ElectronicDocInterfaceID Interface ID
ElectronicDocInterfaceVersion ElectronicDocInterfaceVersion Version
ElectronicDocIsCntdInArchive ElectronicDocIsCntdInArchive Arch. Counter
ElectronicDocMetaStatus ElectronicDocMetaStatus Status
ElectronicDocProcessForStatus ElectronicDocProcessForStatus
ElectronicDocTypeText _ElectronicDocTypeText ElectronicDocTypeText
ElectronicDocSourceTypeText _ElectronicDocSourceTypeText ElectronicDocSourceTypeText
ElectronicDocProcessText _ElectronicDocProcessText ElectronicDocProcessText
ElectronicDocProcStatusText _ElectronicDocProcStatusText ElectronicDocProcStatusText

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 R_EDCElectronicDoc.
-- 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 R_EDCElectronicDoc AS
SELECT
  ElectronicDocUUID,
  ElectronicDocSequenceNmbr,
  ElectronicDocCompanyCode,
  ElectronicDocCountry,
  ElectronicDocSourceType,
  ElectronicDocSourceKey,
  ElectronicDocType,
  ElectronicDocProcessStatus,
  ElectronicDocLogicalSystem,
  ElectronicDocLastChangedByUser,
  ElectronicDocLastChangeDate,
  ElectronicDocLastChangeTime,
  ElectronicDocCreatedByUser,
  ElectronicDocCreationDate,
  ElectronicDocCreationTime,
  ElectronicDocSrceCreatedByUser,
  ElectronicDocProcess,
  ElectronicDocLastProcStep,
  ElectronicDocLastProcStepVar,
  ElectronicDocHasError,
  ElectronicDocProcessVersion,
  ElectronicDocRefSqncNmbr,
  ElectronicDocStatus,
  ElectronicDocPostingDate,
  ElectronicDocIsContingency,
  ElectronicDocReferenceProcess,
  ElectronicDocClassName,
  ElectronicDocIsArchPrprocgDone,
  ElectronicDocInterfaceType,
  ElectronicDocApprovalIDValue,
  ElectronicDocInterfaceUUID,
  ElectronicDocFileUUID,
  ElectronicDocResponseCodeValue,
  ElectronicDocInterfaceID,
  ElectronicDocInterfaceVersion,
  ElectronicDocIsCntdInArchive,
  ElectronicDocMetaStatus,
  ElectronicDocProcessForStatus,
  _ElectronicDocTypeText.ElectronicDocTypeText AS ElectronicDocTypeText,
  _ElectronicDocSourceTypeText.ElectronicDocSourceTypeText AS ElectronicDocSourceTypeText,
  _ElectronicDocProcessText.ElectronicDocProcessText AS ElectronicDocProcessText,
  _ElectronicDocProcStatusText.ElectronicDocProcStatusText AS ElectronicDocProcStatusText
FROM I_ElectronicDoc
LEFT OUTER JOIN I_ElectronicDocTypeText AS _ElectronicDocTypeText ON ElectronicDocType = _ElectronicDocTypeText.ElectronicDocType AND _ElectronicDocTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ElectronicDocSourceTypeText AS _ElectronicDocSourceTypeText ON ElectronicDocSourceType = _ElectronicDocSourceTypeText.ElectronicDocSourceType AND _ElectronicDocSourceTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ElectronicDocProcessText AS _ElectronicDocProcessText ON ElectronicDocProcess = _ElectronicDocProcessText.ElectronicDocProcess AND _ElectronicDocProcessText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ElectronicDocProcStatusText AS _ElectronicDocProcStatusText ON ElectronicDocProcess = _ElectronicDocProcStatusText.ElectronicDocProcess AND ElectronicDocProcessStatus = _ElectronicDocProcStatusText.ElectronicDocProcessStatus AND _ElectronicDocProcStatusText.Language = $session.system_language  -- association [0..1]
;

Learn More