I_CHANGERECORDREFOBJ

CDS View

Change Record Reference Object

I_CHANGERECORDREFOBJ is a CDS View in S/4HANA. Change Record Reference Object. It contains 3 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
C_ChangeRecordRefObjVH view from CONSUMPTION Change Record Reference Obj Value Help
C_MngUnassgdEBOMChgRecdTypeVH view from CONSUMPTION Change Record Type enabled with Mfg Reference Objects
C_MngUnassgdEBOMChgRecdTypeVH view inner CONSUMPTION Change Record Type enabled with Mfg Reference Objects
C_MngUnassgdMBOMChgRecdTypeVH view from CONSUMPTION Change Record Type enabled with MFG Reference Objects
I_ChangeRecordItemType view_entity union_all COMPOSITE Change Record Item Type
I_ChangeRecordReferenceItem view_entity union_all COMPOSITE ChangeRecord Item types
I_ChgRecdTypeRlvtForEngSnpsht view inner COMPOSITE Change Record Types:Snpsht,EBOM,PLS,MBOM
I_ChgRecdTypeRlvtForMfgSnpsht view inner COMPOSITE Change Record Types for Mfg Snapshot
I_ChgRecdTypeRlvtSnpshtWthDoc view inner COMPOSITE Change Record Types:Snpsht,EBOM,PLS,MBOM,DOC
I_DfctChgRecdType view inner COMPOSITE Chg Recd types for defect
I_MfgBOMRtgChgRecdType view inner COMPOSITE Chg Recd types for Mfg. BOM and Routing
I_MngUnassgdBOMChgRecdType view from COMPOSITE Change Record Type enabled with MBOM
I_MngUnassgdMBOMChgRecdType view from COMPOSITE Change Record Type enabled with MBOM
I_OrdRtgProdnOrdChgRecdType view inner COMPOSITE Chg Recd types for routing and prdn order
I_PlngRoutingChangeRecordType view inner BASIC Change Record Types for Planning Routing
I_RoutingChangeRecordType view inner BASIC Change Record Types for Routing
I_TmplRoutingChangeRecordType view inner BASIC Change Record Types for Template Routing
P_MngUnassgdEBOMChgRecdType view inner COMPOSITE Change Record Types enabled with EBOM/PLS

Fields (3)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceType ChangeRecordItemType,SAPObjectNodeTypeInUppercase 2
KEY ChangeRecordType ChangeRecordType 3
ChangeRecordReferenceTypeText ChangeRecordReferenceTypeText 2
@AbapCatalog.sqlViewName: 'ICRREFOBJ'
//@Analytics: { dataCategory: #DIMENSION }

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Change Record Reference Object'

@ObjectModel.usageType: {serviceQuality: #A,
                         dataClass: #CUSTOMIZING,
                         sizeCategory: #L}

define view I_ChangeRecordRefObj
  as select from /iam/c_iss_refob as RefOBJ
  association [0..*] to I_IssActyMgmtObjectType as _Text on $projection.ChangeRecordReferenceType = _Text.IssActyMgmtObjectType
{

  key application    as ChgRecordApplication,
  key issue_type     as ChangeRecordType,
  key int_number     as ChangeRecordReferenceObject,
      ref_obj_type   as ChangeRecordReferenceType,
      
      cast(_Text._Text[1: Language = $session.system_language].IssActyMgmtObjectTypeText as /plmb/cr_object_type_text) as ChangeRecordReferenceTypeText
}
where
  application = 'CR'