I_ILMAUDITAREATP

DDL: I_ILMAUDITAREATP Type: view_entity Package: S_ILM_AA_ODATA
10 Fields 1 Data Sources 3 Associations

Interface view entity for LRM_T_PT

I_ILMAUDITAREATP is a CDS View that provides data about "Interface view entity for LRM_T_PT" in SAP S/4HANA. It reads from 1 data source (R_ILMAuditAreaTP) and exposes 10 fields with key fields ILMPolicyCategory, ILMPolicyType. It has 3 associations to related views. Part of development package S_ILM_AA_ODATA.

Data Sources (1)

SourceAliasJoin Type
R_ILMAuditAreaTP R_ILMAuditAreaTP from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_ILMAUDITAREATTP _policyTypeDesc $projection.ILMPolicyType = _policyTypeDesc.ILMPolicyType and $projection.ILMPolicyCategory = _policyTypeDesc.ILMPolicyCategory
[0..*] I_ILMPOLICYCATEGORYTP _policyCatDesc $projection.ILMPolicyCategory = _policyCatDesc.ILMPolicyCategory
[0..*] I_ILMAUDITAREATTP _text

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Interface view entity for LRM_T_PT view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ILMPolicyCategory ILMPolicyCategory Policy Category
KEY ILMPolicyType ILMPolicyType Audit Area
ChangedByUserName ChangedByUserName User Name
clientNULLasLastChangedDate
ChangedOnDateTime ChangedOnDateTime Last Changed At
SingletonID 1
_single _single
_policyTypeDesc _policyTypeDesc
_policyCatDesc _policyCatDesc
_text _text

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_ILMAUDITAREATP.
-- 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_ILMAUDITAREATP AS
SELECT
  ILMPolicyCategory,
  ILMPolicyType,
  ChangedByUserName,
  tstmp_to_dats( ChangedOnDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as LastChangedDate AS clientNULLasLastChangedDate,
  ChangedOnDateTime,
  1 AS SingletonID
FROM R_ILMAuditAreaTP
LEFT OUTER JOIN I_ILMAUDITAREATTP AS _policyTypeDesc ON ILMPolicyType = _policyTypeDesc.ILMPolicyType AND ILMPolicyCategory = _policyTypeDesc.ILMPolicyCategory  -- association [0..*]
LEFT OUTER JOIN I_ILMPOLICYCATEGORYTP AS _policyCatDesc ON ILMPolicyCategory = _policyCatDesc.ILMPolicyCategory  -- association [0..*]
LEFT OUTER JOIN I_ILMAUDITAREATTP AS _text ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More