C_ElectronicDocCockpitHistory

DDL: C_ELECTRONICDOCCOCKPITHISTORY SQL: CEDODCCHISTORY Type: view CONSUMPTION Package: GLO-EDO-DCC

Mng Electronic Documents: History

C_ElectronicDocCockpitHistory is a Consumption CDS View that provides data about "Mng Electronic Documents: History" in SAP S/4HANA. It reads from 2 data sources (I_ElectronicDoc, I_ElectronicDocHistory) and exposes 70 fields with key fields ElectronicDocUUID, ElectronicDocSequenceNmbr, ElectronicDocSequenceNmbr. Part of development package GLO-EDO-DCC.

Data Sources (2)

SourceAliasJoin Type
I_ElectronicDoc I_ElectronicDoc union
I_ElectronicDocHistory I_ElectronicDocHistory from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CEDODCCHISTORY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Mng Electronic Documents: History view

Fields (70)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID ElectronicDocUUID eDocument GUID
KEY 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
ElectronicDocProcStatusText _ElectronicDocCockpitProcSts ElectronicDocProcStatusText
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
ElectronicDocProcess ElectronicDocProcess Trans.
ElectronicDocLastProcStep ElectronicDocLastProcStep Last ProcStep
ElectronicDocProcessStepText _ElectronicDocProcessStepText ElectronicDocProcessStepText
ElectronicDocLastProcStepVar ElectronicDocLastProcStepVar Last Variant
ElectronicDocHasError ElectronicDocHasError Error Flag
ElectronicDocProcessVersion ElectronicDocProcessVersion Process Version
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
ElectronicDocInterfaceUUID Interface GUID
ElectronicDocFileUUID ElectronicDocFileUUID File GUID
ElectronicDocInterfaceID ElectronicDocInterfaceID Interface ID
ElectronicDocInterfaceVersion ElectronicDocInterfaceVersion Version
ElectronicDocCkptArchiveMode
ElectronicDocArchiveFileID
KEY 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
ElectronicDocProcStatusText _ElectronicDocCockpitProcSts ElectronicDocProcStatusText
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
ElectronicDocProcess ElectronicDocProcess Trans.
ElectronicDocLastProcStep ElectronicDocLastProcStep Last ProcStep
ElectronicDocProcessStepText _ElectronicDocProcessStepText ElectronicDocProcessStepText
ElectronicDocLastProcStepVar ElectronicDocLastProcStepVar Last Variant
ElectronicDocHasError ElectronicDocHasError Error Flag
ElectronicDocProcessVersion ElectronicDocProcessVersion Process Version
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
ElectronicDocInterfaceUUID Interface GUID
ElectronicDocFileUUID ElectronicDocFileUUID File GUID
ElectronicDocInterfaceID ElectronicDocInterfaceID Interface ID
ElectronicDocInterfaceVersion ElectronicDocInterfaceVersion Version
ElectronicDocCkptArchiveMode
ElectronicDocArchiveFileID
ElectronicDocMetaStatus ElectronicDocMetaStatus Status

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 C_ElectronicDocCockpitHistory.
-- 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.
-- SQL view name: CEDODCCHISTORY

CREATE VIEW C_ElectronicDocCockpitHistory AS
SELECT
  ElectronicDocUUID,
  ElectronicDocSequenceNmbr,
  ElectronicDocCompanyCode,
  ElectronicDocCountry,
  ElectronicDocSourceType,
  ElectronicDocSourceKey,
  ElectronicDocType,
  ElectronicDocProcessStatus,
  _ElectronicDocCockpitProcSts.ElectronicDocProcStatusText AS ElectronicDocProcStatusText,
  ElectronicDocLogicalSystem,
  ElectronicDocLastChangedByUser,
  ElectronicDocLastChangeDate,
  ElectronicDocLastChangeTime,
  ElectronicDocCreatedByUser,
  ElectronicDocCreationDate,
  ElectronicDocCreationTime,
  ElectronicDocProcess,
  ElectronicDocLastProcStep,
  _ElectronicDocProcessStepText.ElectronicDocProcessStepText AS ElectronicDocProcessStepText,
  ElectronicDocLastProcStepVar,
  ElectronicDocHasError,
  ElectronicDocProcessVersion,
  ElectronicDocStatus,
  ElectronicDocPostingDate,
  ElectronicDocIsContingency,
  ElectronicDocReferenceProcess,
  ElectronicDocClassName,
  ElectronicDocIsArchPrprocgDone,
  ElectronicDocInterfaceType,
  cast( ElectronicDocInterfaceUUID as abap.char( 32 ) ) AS ElectronicDocInterfaceUUID,
  ElectronicDocFileUUID,
  ElectronicDocInterfaceID,
  ElectronicDocInterfaceVersion,
  cast( '' as edoc_dcc_archivemode ) AS ElectronicDocCkptArchiveMode,
  cast( '' as arkey ) AS ElectronicDocArchiveFileID,
  ElectronicDocMetaStatus
FROM I_ElectronicDocHistory
-- UNION with additional select branch(es): I_ElectronicDoc
;