I_CHANGERECORDTYPE

CDS View

Change Record Type

I_CHANGERECORDTYPE is a CDS View in S/4HANA. Change Record Type. It contains 3 fields. 11 CDS views read from this table.

Used by 11 CDS view(s) 3 fields

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_ChangeRecordTypeCreateVH view from CONSUMPTION Change Record Type VH for Creation
C_ChangeRecordTypeVH view from CONSUMPTION Record Type
C_EngSnpshtChgNtcForEBOMVH view inner CONSUMPTION Eng Snapshot Change Notice Change Records for EBOM
C_EngSnpshtChgRecdTypeDocVH view from CONSUMPTION Change Record Type
C_EngSnpshtChgRecdTypeVH view from CONSUMPTION Change Record Type
I_ChangeRecordNextStatusVH view inner BASIC Value help for next status
I_ChangeRecordTypeStdVH view from COMPOSITE Change Record Type
I_CRUserStatusProField view inner BASIC User Status Field
I_PlngRoutingChangeRecordType view from BASIC Change Record Types for Planning Routing
I_ProdnModRefChangeRecord view_entity inner COMPOSITE Reference Change Records
I_TmplRoutingChangeRecordType view from BASIC Change Record Types for Template Routing

Fields (3)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordType ChangeRecordType 6
ChangeRecordCategory ChangeRecordCategory 2
ChangeRecordTypeDesc ChangeRecordTypeDesc 3 
@AbapCatalog.sqlViewName: 'ICHGRCDTYP'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'ChangeRecordType'
//@Analytics: {dataCategory: #DIMENSION, dataExtraction.enabled: true}

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Change Record Type'
@VDM.viewType:#BASIC

@ObjectModel.usageType: {serviceQuality: #B,
                         dataClass: #MIXED,
                         sizeCategory: #L}
@AbapCatalog.preserveKey:true

define view I_ChangeRecordType
  as select from /iam/c_issuetyp as Issue_type
    inner join   /plmi/cr_type   as CR_type on Issue_type.issue_type = CR_type.cr_type
  association [0..*] to I_ChangeRecordTypeText as _Text on $projection.ChangeRecordType = _Text.ChangeRecordType

{
      @ObjectModel.text.association: '_Text'
      @ObjectModel.text.element: ['ChangeRecordTypeDesc']

  key cast(Issue_type.issue_type as /plmb/cr_type preserving type)      as ChangeRecordType,
      Issue_type.party_role_code                                        as ChangeResponsible,
      Issue_type.status_profile                                         as ChangeRecordStatusProfile,
      Issue_type.nrange_interval                                        as ChangeRecordNumberRangeIntID,
      Issue_type.wfd_id                                                 as ChangeRecordScenarioID,
      @UI.hidden: true
      Issue_type.inactive                                               as ChangeRecordIsInactive,
      CR_type.cr_category                                               as ChangeRecordCategory,
      CR_type.process_route                                             as ChgRecordIsUsingProcessRoute,
      CR_type.collaboration                                             as ChgRecordIsUsingCollaboration,
      case CR_type.collaboration
            when '' then 'X'
            else ''
      end                                                               as ChgRecdCollaborationIsHidden,
      CR_type.enable_item_proc_status                                   as ChgRecdItemProcgStatusIsEnbld,
      CR_type.peo_relevant                                              as ChgRecdIsProdnEngOpsRlvt,
      _Text[1:Language = $session.system_language].ChangeRecordTypeDesc as ChangeRecordTypeDesc,
      CR_type.purpose                                                   as ChangeRecordPurposeType,
      _Text

}
where
  Issue_type.application = 'CR'

Learn More