I_CHANGERECORDITEMCOUNT

CDS View

Change Record Item Count

I_CHANGERECORDITEMCOUNT is a CDS View in S/4HANA. Change Record Item Count. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ChangeRecordItemCount view from CONSUMPTION Change Record Item Count 
@AbapCatalog.sqlViewName: 'ICRITEMCOUNT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #L}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Change Record Item Count'
define view I_ChangeRecordItemCount
  as select from           /iam/d_i_obj_ref
    left outer to one join /iam/d_i_root    on /iam/d_i_root.db_key = /iam/d_i_obj_ref.parent_key
    inner join             /iam/c_iss_refob on  /iam/c_iss_refob.application  = /iam/d_i_root.application
                                            and /iam/c_iss_refob.issue_type   = /iam/d_i_root.issue_type
                                            and /iam/c_iss_refob.ref_obj_type = /iam/d_i_obj_ref.type_cd
    left outer to one join /iam/i_type_t    on  /iam/d_i_obj_ref.type_cd = /iam/i_type_t.type
                                            and /iam/i_type_t.langu      = $session.system_language
{
  key   /iam/d_i_obj_ref.db_key      as ChangeRecordUUID,
  key   /iam/d_i_obj_ref.parent_key  as ParentChangeRecordUUID,
  key   /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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/IAM/C_ISS_REFOB",
"/IAM/D_I_OBJ_REF",
"/IAM/D_I_ROOT",
"/IAM/I_TYPE_T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More