R_ILMPolicyTP

DDL: R_ILMPOLICYTP Type: view_entity
9 Fields 1 Data Sources

Basic view for LRM_T_OT_POL_ORI

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

Data Sources (1)

SourceAliasJoin Type
lrm_t_ot_pol_ori lrm_t_ot_pol_ori from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Basic view for LRM_T_OT_POL_ORI view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

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
KEY ILMPolicyOrigin policy_origin Policy Name
ILMPolicyStatus policy_status Policy Status
ChangedOnDateTime timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
ChangedByUserName user_name User Name
ILMPolicyComment comments User Notes

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_ILMPolicyTP.
-- 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_ILMPolicyTP AS
SELECT
  object_category AS ILMObjectCategory,
  object_type AS ILMObject,
  policy_category AS ILMPolicyCategory,
  policy_type AS ILMPolicyType,
  policy_origin AS ILMPolicyOrigin,
  policy_status AS ILMPolicyStatus,
  timestamp AS ChangedOnDateTime,
  user_name AS ChangedByUserName,
  comments AS ILMPolicyComment
FROM lrm_t_ot_pol_ori
;

Learn More