C_ElectronicDocAttachment

DDL: C_ELECTRONICDOCATTACHMENT Type: view_entity CONSUMPTION Package: GLO-EDO-DCC
14 Fields 1 Data Sources 1 Associations

Electronic Document: Attachment

C_ElectronicDocAttachment is a Consumption CDS View that provides data about "Electronic Document: Attachment" in SAP S/4HANA. It reads from 1 data source (I_ElectronicDocFile) and exposes 14 fields with key fields ElectronicDocUUID, ElectronicDocFileUUID. It has 1 association to related views. Part of development package GLO-EDO-DCC.

Data Sources (1)

SourceAliasJoin Type
I_ElectronicDocFile I_ElectronicDocFile from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_ElectronicDoc _ElectronicDoc $projection.ElectronicDocUUID = _ElectronicDoc.ElectronicDocUUID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Electronic Document: Attachment view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID I_ElectronicDocFile ElectronicDocUUID
KEY ElectronicDocFileUUID ElectronicDocFileUUID
ElectronicDocCompanyCode ElectronicDocCompanyCode
ElectronicDocProcess ElectronicDocProcess
ElectronicDocFileType ElectronicDocFileType
ElectronicDocFileName ElectronicDocFileName
ElectronicDocFileCreationTime ElectronicDocFileCreationTime
ElectronicDocFileCreationDate ElectronicDocFileCreationDate
ElectronicDocCockpitFileType
ElectronicDocProcessStatus _ElectronicDoc ElectronicDocProcessStatus
ElectronicDocCkptArchiveMode
ElectronicDocArchiveFileID
ElectronicDocCreatedByUser
ElectronicDocLastChangedByUser

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_ElectronicDocAttachment.
-- 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 C_ElectronicDocAttachment AS
SELECT
  I_ElectronicDocFile.ElectronicDocUUID AS ElectronicDocUUID,
  ElectronicDocFileUUID,
  ElectronicDocCompanyCode,
  ElectronicDocProcess,
  ElectronicDocFileType,
  ElectronicDocFileName,
  ElectronicDocFileCreationTime,
  ElectronicDocFileCreationDate,
  cast( '' as edoc_file_type ) AS ElectronicDocCockpitFileType,
  _ElectronicDoc.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  cast( '' as edoc_dcc_archivemode ) AS ElectronicDocCkptArchiveMode,
  cast( '' as arkey ) AS ElectronicDocArchiveFileID,
  cast('' as so_cro_nam) AS ElectronicDocCreatedByUser,
  cast('' as so_cho_nam) AS ElectronicDocLastChangedByUser
FROM I_ElectronicDocFile
LEFT OUTER JOIN I_ElectronicDoc AS _ElectronicDoc ON ElectronicDocUUID = _ElectronicDoc.ElectronicDocUUID  -- association [1..*]
;

Learn More