I_CHGRECDREFOBJVISIBILITY

CDS View

Change Record Reference Object Visible

I_CHGRECDREFOBJVISIBILITY is a CDS View in S/4HANA. Change Record Reference Object Visible. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_ChgRecdRefObjVisibility view from CONSUMPTION Change Record Reference Object Visible
I_ChangeRecordItemVisibility view_entity from COMPOSITE CR Reference Object Type Visibility

Fields (1)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordType ChangeRecordType 2 
@AbapCatalog.sqlViewName: 'ICRTRFOBJVIB'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record Reference Object Visible'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #A,
                         dataClass: #CUSTOMIZING,
                         sizeCategory: #S}
define view I_ChgRecdRefObjVisibility
    as select from  /iam/c_issuetyp  as issue_type
    association [0..*] to /iam/c_iss_refob as issue_ref_ob on  issue_type.application = issue_ref_ob.application 
                                                           and issue_type.issue_type  = issue_ref_ob.issue_type
{
    key issue_type.issue_type      as ChangeRecordType,
    key issue_type.application     as ChgRecordApplication,      
    key issue_ref_ob.int_number    as ChangeRecordReferenceObject,       
    issue_ref_ob.ref_obj_type      as ChangeRecordReferenceType,
    count(*)            as ChgRecdRefObjVisible
}
where issue_type.application = 'CR'
group by issue_type.issue_type, issue_ref_ob.ref_obj_type, issue_type.application, issue_ref_ob.int_number

Learn More