Ehfnd_Chm_Wpcp_Lisu_with_Sub

DDL: EHFND_CHM_WPCP_LISU_WITH_SUB SQL: EHFNDV_CHM_WLSWS Type: view

Chemical Workplace Control Parameter

Ehfnd_Chm_Wpcp_Lisu_with_Sub is a CDS View that provides data about "Chemical Workplace Control Parameter" in SAP S/4HANA. It reads from 4 data sources (ehfndd_chm_wcp, ehfndi_lisu_rt, ehfndi_lisu_rt, ehfndd_chm_wcp) and exposes 2 fields with key fields parent_key, parent_key.

Data Sources (4)

SourceAliasJoin Type
ehfndd_chm_wcp ehfndd_chm_wcp from
ehfndi_lisu_rt root_lisu inner
ehfndi_lisu_rt sub_lisu inner
ehfndd_chm_wcp wcp union_all

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName EHFNDV_CHM_WLSWS view
EndUserText.label Chemical Workplace Control Parameter view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY parent_key ehfndd_chm_wcp parent_key UUID
KEY parent_key UUID

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 Ehfnd_Chm_Wpcp_Lisu_with_Sub.
-- 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: EHFNDV_CHM_WLSWS

CREATE VIEW Ehfnd_Chm_Wpcp_Lisu_with_Sub AS
SELECT
  ehfndd_chm_wcp.parent_key AS parent_key
FROM ehfndd_chm_wcp
INNER JOIN ehfndi_lisu_rt AS root_lisu ON /* join condition not captured in parsed metadata */
INNER JOIN ehfndi_lisu_rt AS sub_lisu ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): ehfndd_chm_wcp
;