R_ILMAuditAreaObjAssgmtTP

DDL: R_ILMAUDITAREAOBJASSGMTTP Type: view_entity
7 Fields 1 Data Sources

Basic view for LRM_T_OT_PT

R_ILMAuditAreaObjAssgmtTP is a CDS View that provides data about "Basic view for LRM_T_OT_PT" in SAP S/4HANA. It reads from 1 data source (lrm_t_ot_pt) and exposes 7 fields with key fields ILMObjectCategory, ILMObject, ILMPolicyCategory, ILMPolicyType.

Data Sources (1)

SourceAliasJoin Type
lrm_t_ot_pt lrm_t_ot_pt from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Basic view 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 (7)

KeyFieldSource TableSource FieldDescription
KEY ILMObjectCategory object_category Object Category
KEY ILMObject object_type Type
KEY ILMPolicyCategory policy_category Policy Category
KEY ILMPolicyType policy_type Audit Area
ILMAuditAreaObjAssgmtStatus status Workflow Status
ChangedByUserName user_name User Name
ChangedOnDateTime timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

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 R_ILMAuditAreaObjAssgmtTP.
-- 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 R_ILMAuditAreaObjAssgmtTP AS
SELECT
  object_category AS ILMObjectCategory,
  object_type AS ILMObject,
  policy_category AS ILMPolicyCategory,
  policy_type AS ILMPolicyType,
  status AS ILMAuditAreaObjAssgmtStatus,
  user_name AS ChangedByUserName,
  timestamp AS ChangedOnDateTime
FROM lrm_t_ot_pt
;

Learn More