Ehenv_Amns_Ex

DDL: EHENV_AMNS_EX SQL: EHENVV_AMNS_EX Type: view
12 Fields 2 Data Sources

Amounts with Value date/time extended data

Ehenv_Amns_Ex is a CDS View that provides data about "Amounts with Value date/time extended data" in SAP S/4HANA. It reads from 2 data sources (ehfndd_amns_root, t006a) and exposes 12 fields.

Data Sources (2)

SourceAliasJoin Type
ehfndd_amns_root ehfndd_amns_root from
t006a t006a left_outer

Parameters (1)

NameTypeDefault
p_langu lang

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName EHENVV_AMNS_EX view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Amounts with Value date/time extended data view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
amount_key db_key UUID
fault_ind fault_ind Faulty Value
deviation_id deviation_id ID
missing_ind missing_ind Missing Value
warning_ind warning_ind Warning
status status Workflow Status
sourcetype sourcetype Source Type
external_src external_src External Source
value value Value from table
unit_text t006a mseht Meas. Unit Text
valueunit valueunit Unit of Measurement
remark remark Status Description

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 Ehenv_Amns_Ex.
-- 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: EHENVV_AMNS_EX
-- Parameters: p_langu : lang

CREATE VIEW Ehenv_Amns_Ex AS
SELECT
  db_key AS amount_key,
  fault_ind,
  deviation_id,
  missing_ind,
  warning_ind,
  status,
  sourcetype,
  external_src,
  value,
  t006a.mseht AS unit_text,
  valueunit,
  remark
FROM ehfndd_amns_root
LEFT OUTER JOIN t006a ON /* join condition not captured in parsed metadata */
;

Learn More