I_ILMAuditAreaAssgmtTP

DDL: I_ILMAUDITAREAASSGMTTP Type: view_entity Package: S_ILM_AA_OBJ_ASSGMT_ODATA
10 Fields 1 Data Sources 3 Associations

Interface view entity for Audit Area Assignment

I_ILMAuditAreaAssgmtTP is a CDS View that provides data about "Interface view entity for Audit Area Assignment" 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_OBJ_ASSGMT_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_ILMAuditAreaObjAssgmtTP _assignment

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Interface view entity for Audit Area Assignment view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

Fields (10)

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

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_ILMAuditAreaAssgmtTP.
-- 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_ILMAuditAreaAssgmtTP AS
SELECT
  ILMPolicyCategory,
  ILMPolicyType,
  ChangedByUserName,
  ChangedOnDateTime,
  tstmp_to_dats( ChangedOnDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as LastChangedDate AS clientNULLasLastChangedDate,
  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_ILMAuditAreaObjAssgmtTP AS _assignment ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More