I_CHANGERECORDREFOBJ
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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'