I_EHSControlAttachment

DDL: I_EHSCONTROLATTACHMENT SQL: IEHSCTRLATT Type: view BASIC

EHS Control Attachment

I_EHSControlAttachment is a Basic CDS View that provides data about "EHS Control Attachment" in SAP S/4HANA. It reads from 1 data source (/bobf/d_atf_do) and exposes 7 fields with key fields EHSControlAttachmentUUID, EHSControlUUID.

Data Sources (1)

SourceAliasJoin Type
/bobf/d_atf_do Document from

Annotations (10)

NameValueLevelField
EndUserText.label EHS Control Attachment view
VDM.viewType #BASIC view
ObjectModel.representativeKey EHSControlAttachmentUUID view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IEHSCTRLATT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY EHSControlAttachmentUUID /bobf/d_atf_do db_key UUID
KEY EHSControlUUID EHSControlRoot db_key UUID
_EHSControl _EHSControl
MimeType /bobf/d_atf_do mimecode MIME type
EHSControlAttachmentName /bobf/d_atf_do name Zone name
EHSControlAttachmentTitle /bobf/d_atf_do description Well Code Des.
FileSize /bobf/d_atf_do filesize_content File Size

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_EHSControlAttachment.
-- 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: IEHSCTRLATT

CREATE VIEW I_EHSControlAttachment AS
SELECT
  Document.db_key AS EHSControlAttachmentUUID,
  EHSControlRoot.db_key AS EHSControlUUID,
  Document.mimecode AS MimeType,
  Document.name AS EHSControlAttachmentName,
  Document.description AS EHSControlAttachmentTitle,
  Document.filesize_content AS FileSize
FROM /bobf/d_atf_do AS Document
;