C_EHSFindingTP

DDL: C_EHSFINDINGTP Type: view_entity CONSUMPTION Package: EHAIM_CNS_FINDING
33 Fields 1 Data Sources 1 Associations 4 OData Services

EHS Finding

C_EHSFindingTP is a Consumption CDS View that provides data about "EHS Finding" in SAP S/4HANA. It reads from 1 data source (R_EHSFindingTP) and exposes 33 fields with key field EHSFindingUUID. It has 1 association to related views. It is exposed through 4 OData services (ASQL_F9071, ASQL_F9073, UI_EHSFINDING_MANAGE, ...). Part of development package EHAIM_CNS_FINDING.

Data Sources (1)

SourceAliasJoin Type
R_EHSFindingTP R_EHSFindingTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_EHSFindingTask _FindingTask $projection.EHSFindingUUID = _FindingTask.EHSTaskHostObjectInstanceUUID

Annotations (7)

NameValueLevelField
EndUserText.label EHS Finding view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view

OData Services (4)

ServiceBindingVersionContractRelease
ASQL_F9071 ASQL_F9071 C2 NOT_RELEASED
ASQL_F9073 ASQL_F9073 C2 NOT_RELEASED
UI_EHSFINDING_MANAGE UI_EHSFINDING_MANAGE V4 C1 NOT_RELEASED
UI_EHSINSPECTION_MANAGE UI_EHSINSPECTION_MANAGE V4 C1 NOT_RELEASED

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY EHSFindingUUID EHSFindingUUID
EHSInspectionUUID EHSInspectionUUID
EHSInspectionSectionUUID EHSInspectionSectionUUID
EHSInspectionQuestionUUID EHSInspectionQuestionUUID
EHSFindingID EHSFindingID
EHSFindingText EHSFindingText
EHSFindingCategoryCode EHSFindingCategoryCode
EHSFindingStatusCode EHSFindingStatusCode
EHSFindingPriorityCode EHSFindingPriorityCode
StatusCriticality StatusCriticality
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
HeaderAttachmentKey HeaderAttachmentKey Object Key
SAPObjectNodeType SAPObjectNodeType SONT Name
EHSFindingTitle EHSFindingTitle
RelatedTaskIsHidden RelatedTaskIsHidden
EHSQuestionnaireQuestionName EHSQuestionnaireQuestionName
EHSInspQuestionAnswerCode EHSInspQuestionAnswerCode
EHSInspSectionSequenceText EHSInspSectionSequenceText
virtualDeleteActionIsHiddenabap_boolean
EHSFindingCategoryTextlocalized
EHSFindingPriorityTextlocalized
EHSFindingStatusTextlocalized
EHSInspQuestionAnswerTextlocalized
CreatedByUserDescription _CreatedByUserText UserDescription Full Name
LastChangedByUserDescription _LastChangedByUserText UserDescription Full Name
EHSQuestionnaireName _Inspection EHSQuestionnaireName
EHSInspectionLocation _Inspection EHSInspectionLocation
EHSInspectionName _Inspection EHSInspectionName
EHSInspectionStatus _Inspection EHSInspectionStatus
_FindingTask _FindingTask

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_EHSFindingTP.
-- 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_EHSFindingTP AS
SELECT
  EHSFindingUUID,
  EHSInspectionUUID,
  EHSInspectionSectionUUID,
  EHSInspectionQuestionUUID,
  EHSFindingID,
  EHSFindingText,
  EHSFindingCategoryCode,
  EHSFindingStatusCode,
  EHSFindingPriorityCode,
  StatusCriticality,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  HeaderAttachmentKey,
  SAPObjectNodeType,
  EHSFindingTitle,
  RelatedTaskIsHidden,
  EHSQuestionnaireQuestionName,
  EHSInspQuestionAnswerCode,
  EHSInspSectionSequenceText,
  virtual DeleteActionIsHidden : abap_boolean AS virtualDeleteActionIsHiddenabap_boolean,
  _FindingCategory._Text.EHSFindingCategoryText : localized AS EHSFindingCategoryTextlocalized,
  _FindingPriority._Text.EHSFindingPriorityText : localized AS EHSFindingPriorityTextlocalized,
  _FindingStatus._Text.EHSFindingStatusText : localized AS EHSFindingStatusTextlocalized,
  _InspectionResponseText.EHSInspQuestionAnswerText : localized AS EHSInspQuestionAnswerTextlocalized,
  _CreatedByUserText.UserDescription AS CreatedByUserDescription,
  _LastChangedByUserText.UserDescription AS LastChangedByUserDescription,
  _Inspection.EHSQuestionnaireName AS EHSQuestionnaireName,
  _Inspection.EHSInspectionLocation AS EHSInspectionLocation,
  _Inspection.EHSInspectionName AS EHSInspectionName,
  _Inspection.EHSInspectionStatus AS EHSInspectionStatus
FROM R_EHSFindingTP
LEFT OUTER JOIN C_EHSFindingTask AS _FindingTask ON EHSFindingUUID = _FindingTask.EHSTaskHostObjectInstanceUUID  -- association [0..*]
;

Learn More