I_ChangeRecordItemCount

DDL: I_CHANGERECORDITEMCOUNT SQL: ICRITEMCOUNT Type: view BASIC
6 Fields 2 Data Sources

Change Record Item Count

I_ChangeRecordItemCount is a Basic CDS View that provides data about "Change Record Item Count" in SAP S/4HANA. It reads from 2 data sources (/iam/c_iss_refob, /iam/d_i_obj_ref) and exposes 6 fields with key fields ChangeRecordUUID, ParentChangeRecordUUID, ChangeRecordReferenceType.

Data Sources (2)

SourceAliasJoin Type
/iam/c_iss_refob /iam/c_iss_refob inner
/iam/d_i_obj_ref /iam/d_i_obj_ref from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICRITEMCOUNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Change Record Item Count view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordUUID /iam/d_i_obj_ref db_key UUID
KEY ParentChangeRecordUUID /iam/d_i_obj_ref parent_key UUID
KEY ChangeRecordReferenceType /iam/d_i_obj_ref type_cd Usage Type
ChangeRecordObjectTypeText /iam/i_type_t text User Group
ChangeRecordType /iam/c_iss_refob issue_type Issue Type
ChgRecordApplication /iam/c_iss_refob application UI Application

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_ChangeRecordItemCount.
-- 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.
-- SQL view name: ICRITEMCOUNT

CREATE VIEW I_ChangeRecordItemCount AS
SELECT
  /iam/d_i_obj_ref.db_key AS ChangeRecordUUID,
  /iam/d_i_obj_ref.parent_key AS ParentChangeRecordUUID,
  /iam/d_i_obj_ref.type_cd AS ChangeRecordReferenceType,
  /iam/i_type_t.text AS ChangeRecordObjectTypeText,
  /iam/c_iss_refob.issue_type AS ChangeRecordType,
  /iam/c_iss_refob.application AS ChgRecordApplication
FROM /iam/d_i_obj_ref
INNER JOIN /iam/c_iss_refob ON /* join condition not captured in parsed metadata */
;

Learn More