I_ILMAudObjAssgmtTP

DDL: I_ILMAUDOBJASSGMTTP Type: view_entity
16 Fields 1 Data Sources 7 Associations

Interface view entity for LRM_T_OT_PT

I_ILMAudObjAssgmtTP is a CDS View that provides data about "Interface view entity for LRM_T_OT_PT" in SAP S/4HANA. It reads from 1 data source (R_ILMAuditAreaObjAssgmtTP) and exposes 16 fields with key fields ILMObjectCategory, ILMObject, ILMPolicyCategory, ILMPolicyType. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ILMAuditAreaObjAssgmtTP R_ILMAuditAreaObjAssgmtTP from

Associations (7)

CardinalityTargetAliasCondition
[0..*] R_ILMObjTTP _ILMObjectTypeDesc $projection.ILMObjectCategory = _ILMObjectTypeDesc.ILMObjectCategory and $projection.ILMObject = _ILMObjectTypeDesc.ILMObject
[0..*] I_ILMAUDITAREATTP _ILMPolicyTypeDesc $projection.ILMPolicyCategory = _ILMPolicyTypeDesc.ILMPolicyCategory and $projection.ILMPolicyType = _ILMPolicyTypeDesc.ILMPolicyType
[0..*] R_ILMPolicyCategoryTTP _ILMPolicyCatDesc $projection.ILMPolicyCategory = _ILMPolicyCatDesc.ILMPolicyCategory
[0..*] I_ILMObjAssgmtStatusT _ILMPolTypeStatusDesc $projection.ILMAuditAreaObjAssgmtStatus = _ILMPolTypeStatusDesc.DomainValue
[0..1] R_ILMCouldIrrelevant _irrelevantObject $projection.ILMObject = _irrelevantObject.ILMObject
[0..*] I_ILMRetPolicyTP _I_ILMRetPolicyTP
[0..*] I_ILMResPolicyTP _I_ILMResPolicyTP

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Interface view entity for LRM_T_OT_PT view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ILMObjectCategory ILMObjectCategory Object Category
KEY ILMObject ILMObject Type
KEY ILMPolicyCategory ILMPolicyCategory Policy Category
KEY ILMPolicyType ILMPolicyType Audit Area
ILMAuditAreaObjAssgmtStatus ILMAuditAreaObjAssgmtStatus Workflow Status
ChangedByUserName ChangedByUserName User Name
ChangedOnDateTime ChangedOnDateTime Last Changed At
clientNULLasLastChangedAt
SingletonID 1
_ILMObjectTypeDesc _ILMObjectTypeDesc
_ILMPolTypeStatusDesc _ILMPolTypeStatusDesc
_ILMPolicyCatDesc _ILMPolicyCatDesc
_ILMPolicyTypeDesc _ILMPolicyTypeDesc
_I_ILMRetPolicyTP _I_ILMRetPolicyTP
_I_ILMResPolicyTP _I_ILMResPolicyTP
_Single _Single

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_ILMAudObjAssgmtTP.
-- 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_ILMAudObjAssgmtTP AS
SELECT
  ILMObjectCategory,
  ILMObject,
  ILMPolicyCategory,
  ILMPolicyType,
  ILMAuditAreaObjAssgmtStatus,
  ChangedByUserName,
  ChangedOnDateTime,
  tstmp_to_dats( ChangedOnDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as LastChangedAt AS clientNULLasLastChangedAt,
  1 AS SingletonID
FROM R_ILMAuditAreaObjAssgmtTP
LEFT OUTER JOIN R_ILMObjTTP AS _ILMObjectTypeDesc ON ILMObjectCategory = _ILMObjectTypeDesc.ILMObjectCategory AND ILMObject = _ILMObjectTypeDesc.ILMObject  -- association [0..*]
LEFT OUTER JOIN I_ILMAUDITAREATTP AS _ILMPolicyTypeDesc ON ILMPolicyCategory = _ILMPolicyTypeDesc.ILMPolicyCategory AND ILMPolicyType = _ILMPolicyTypeDesc.ILMPolicyType  -- association [0..*]
LEFT OUTER JOIN R_ILMPolicyCategoryTTP AS _ILMPolicyCatDesc ON ILMPolicyCategory = _ILMPolicyCatDesc.ILMPolicyCategory  -- association [0..*]
LEFT OUTER JOIN I_ILMObjAssgmtStatusT AS _ILMPolTypeStatusDesc ON ILMAuditAreaObjAssgmtStatus = _ILMPolTypeStatusDesc.DomainValue  -- association [0..*]
LEFT OUTER JOIN R_ILMCouldIrrelevant AS _irrelevantObject ON ILMObject = _irrelevantObject.ILMObject  -- association [0..1]
LEFT OUTER JOIN I_ILMRetPolicyTP AS _I_ILMRetPolicyTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ILMResPolicyTP AS _I_ILMResPolicyTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More