esh_tau_v_classification

DDL: ESH_TAU_V_CLASSIFICATION SQL: ESH_TAU_V_CLF Type: view

ES Tests: Classification Search Core View

esh_tau_v_classification is a CDS View that provides data about "ES Tests: Classification Search Core View" in SAP S/4HANA. It reads from 4 data sources (esh_tau_cl_pvpd, esh_tau_cl_pdt, esh_tau_cl_p, esh_tau_cl_pn) and exposes 7 fields with key field object_id.

Data Sources (4)

SourceAliasJoin Type
esh_tau_cl_pvpd assign from
esh_tau_cl_pdt dtype left_outer
esh_tau_cl_p prop left_outer
esh_tau_cl_pn propname left_outer

Parameters (1)

NameTypeDefault
p_language syst_langu

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ESH_TAU_V_CLF view
Metadata.allowExtensions true view
Semantics.interval.lowerBoundaryElement VALUE_NUM_LOW view
Semantics.interval.upperBoundaryElement VALUE_NUM_HIGH view
Semantics.interval.boundaryCodeElement INTERVAL_BOUNDARY_CODE view
EndUserText.label ES Tests: Classification Search Core View view
Search.searchable true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY object_id esh_tau_cl_pvpd object_id Transaction ID
property_id esh_tau_cl_p property_id Property
currency esh_tau_cl_pdt currency Valuation Crcy
exp_disp esh_tau_cl_pdt exp_disp Exponent
template esh_tau_cl_pdt template TRUE
value_uuid esh_tau_cl_pvpd value_uuid Value UUID
value_string esh_tau_cl_pvpd value_string String Value

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 esh_tau_v_classification.
-- 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: ESH_TAU_V_CLF
-- Parameters: p_language : syst_langu

CREATE VIEW esh_tau_v_classification AS
SELECT
  assign.object_id AS object_id,
  prop.property_id AS property_id,
  dtype.currency AS currency,
  dtype.exp_disp AS exp_disp,
  dtype.template AS template,
  assign.value_uuid AS value_uuid,
  assign.value_string AS value_string
FROM esh_tau_cl_pvpd AS assign
LEFT OUTER JOIN esh_tau_cl_p AS prop ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN esh_tau_cl_pn AS propname ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN esh_tau_cl_pdt AS dtype ON /* join condition not captured in parsed metadata */
;