I_EHSEnvrmtReportFormList

DDL: I_EHSENVRMTREPORTFORMLIST Type: view_entity BASIC Package: EHENV_BO_ENV_REPORT
6 Fields 1 Data Sources 2 Associations 2 OData Services

Environment Emission Forms

I_EHSEnvrmtReportFormList is a Basic CDS View that provides data about "Environment Emission Forms" in SAP S/4HANA. It reads from 1 data source (ehfndc_ads_fgfa) and exposes 6 fields with key field EHSFormName. It has 2 associations to related views. It is exposed through 2 OData services (ASQL_F5638, UI_EHSSUMMARYREPORT_MANAGE). Part of development package EHENV_BO_ENV_REPORT.

Data Sources (1)

SourceAliasJoin Type
ehfndc_ads_fgfa ehfndc_ads_fgfa from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_EHSEnvrmtReportFormDesc _FormDescription $projection.EHSFormName = _FormDescription.EHSFormName
[1..1] P_EHSReportFormData _FormDetails $projection.EHSFormName = _FormDetails.EHSFormName

Annotations (11)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Environment Emission Forms view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey EHSFormName view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #META view
ObjectModel.resultSet.sizeCategory #XS view
Analytics.technicalName IEMFORM view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F5638 ASQL_F5638 C2 NOT_RELEASED
UI_EHSSUMMARYREPORT_MANAGE UI_EHSSUMMARYREPORT_MANAGE V4 C1 NOT_RELEASED

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY EHSFormName ehfndc_ads_fgfa form_name Name
EHSFormDescription
EHSFormGroupName group_name WMPC Group Name
EHSSemanticObject _FormDetails EHSSemanticObject
EHSSemanticAction _FormDetails EHSSemanticAction
_FormDescription _FormDescription

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_EHSEnvrmtReportFormList.
-- 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 I_EHSEnvrmtReportFormList AS
SELECT
  ehfndc_ads_fgfa.form_name AS EHSFormName,
  _FormDescription[1: Language = $session.system_language].EHSFormDescription AS EHSFormDescription,
  group_name AS EHSFormGroupName,
  _FormDetails.EHSSemanticObject AS EHSSemanticObject,
  _FormDetails.EHSSemanticAction AS EHSSemanticAction
FROM ehfndc_ads_fgfa
LEFT OUTER JOIN I_EHSEnvrmtReportFormDesc AS _FormDescription ON EHSFormName = _FormDescription.EHSFormName  -- association [0..*]
LEFT OUTER JOIN P_EHSReportFormData AS _FormDetails ON EHSFormName = _FormDetails.EHSFormName  -- association [1..1]
;

Learn More