I_CHANGERECORDITEMREL

CDS View

Change Record Item Relevance

I_CHANGERECORDITEMREL is a CDS View in S/4HANA. Change Record Item Relevance. It contains 1 fields. 46 CDS views read from this table.

Used by 46 CDS view(s) 1 fields

CDS Views using this table (46)

ViewTypeJoinVDMDescription
C_ChangeRecordItemRelBitVH view from CONSUMPTION Item Relevance Value Help for BOM item
C_ChangeRecordItemRelBOMVH view from CONSUMPTION Item Relevance Value Help for BOM
C_ChangeRecordItemRelDocVH view from CONSUMPTION Item Relevance Value Help for Document
C_ChangeRecordItemRelEbmVH view from CONSUMPTION Item Relevance Value Help for Engineering BOM
C_ChangeRecordItemRelInspPlnVH view from CONSUMPTION Item Relevance Value Help for Inspection Plan
C_ChangeRecordItemRelLabelVH view from CONSUMPTION Item Relevance Value help for Label
C_ChangeRecordItemRelMatVH view from CONSUMPTION Item Relevance Value Help for Material
C_ChangeRecordItemRelMbmVH view from CONSUMPTION Item Relevance Value Help for Manufacturing BOM
C_ChangeRecordItemRelMstrRcpVH view from CONSUMPTION Item Relevance Value Help for Master
C_ChangeRecordItemRelPlngRtgVH view from CONSUMPTION Item Rlvnce Value Help for Plng Routing
C_ChangeRecordItemRelPlsVH view from CONSUMPTION Item Relevance Value Help for Planning Scope
C_ChangeRecordItemRelProVH view from CONSUMPTION Item Relevance Value Help for Production Order
C_ChangeRecordItemRelPurVH view from CONSUMPTION Item Relevance Value Help for Pur Order
C_ChangeRecordItemRelRecipeVH view from CONSUMPTION Item Relevance Value help for Recipe
C_ChangeRecordItemRelRouVH view from CONSUMPTION Item Relevance Value Help for Routing
C_ChangeRecordItemRelSnpshtVH view from CONSUMPTION Item Rlvnce Value Help for Snapshot
C_ChangeRecordItemRelSpecVH view from CONSUMPTION Item Relevance Value help for Specification
C_ChangeRecordItemRelTmplRtgVH view from CONSUMPTION Item Rlvnce for Template Routing
C_ChangeRecordItemRelVH view from CONSUMPTION Obsolete: Change Record Item Relevance Value Help
C_ChgImpactChgRecdRlvnce view from CONSUMPTION Change Record Item Relevance
C_ChgRecdItemRelProdnRoutingVH view from CONSUMPTION Item Relevance Value Help for Production Routing
C_ChgRecdItemRelProdStrucVarVH view from CONSUMPTION Item Relevance Value Help for Product Structure Variant
C_ChgRecdItemRlvnceOrderBOMVH view from CONSUMPTION Item Relevance for Order BOM
C_ChgRecdItemRlvnceStdBOMVH view from CONSUMPTION Item Relevance for Std BOM
C_ChgRecdItmRelEquipTskListVH view from CONSUMPTION Item Rel for Equip Task List
C_ChgRecdItmRelMaintTskListVH view from CONSUMPTION Item Rel for Maint Task List
C_ChgRecdItmRlvnceCharcVH view from CONSUMPTION Item Relevance for Characteristic
C_ChgRecdItmRlvnceClassVH view from CONSUMPTION Item Relevance for Class
C_ChgRecdItmRlvnceDefectVH view from CONSUMPTION Item Relevance for Defect
C_ChgRecdItmRlvnceETOVersBOMVH view from CONSUMPTION Item Relevance for ETO Vers BOM
C_ChgRecdItmRlvnceRateRtgVH view from CONSUMPTION Item Relevance for Rate Rtg Task List
C_ChgRecdRlvnceEquipBOMVH view from CONSUMPTION Item Relevance Equipment BOM
C_ChgRecdRlvnceFuncLocVH view from CONSUMPTION Item Relevance for Func Loc Task List
C_ChgRecdRlvnceFunLocBOMVH view from CONSUMPTION Con for Itm Relv FL BOM
C_ChgRecdRlvnceRefOpSetVH view from CONSUMPTION Item Relevance for Ref Op Set Task List
C_ChgRecdRlvnceWBSElmntBOMVH view from CONSUMPTION Item Relevance for WBS BOM
C_ItmRelRefCutPlngPrflVH view from CONSUMPTION Item Rel for Cut Plng Profile
C_ItmRelRefRateRtgTskListVH view from CONSUMPTION Item Rel Ref Rate Routing Task List
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_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

Fields (1)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordItemRelevance ChangeRecordItemRelevance,ProdnOrdItemRelevance,RoutingItemRelevance 4 
@AbapCatalog.sqlViewName: 'IITMREL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record Item Relevance'
//@ObjectModel.compositionRoot: true

//@AbapCatalog.preserveKey:true

@VDM.viewType:#BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #S}

define view I_ChangeRecordItemRel
  as select distinct from /plmi/cr_rel_app
  association [0..1] to I_ChangeRecordItemRelText as _ChangeRecordItemRelText on $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelText.ChangeRecordItemRelevance
                                                                            and _ChangeRecordItemRelText.Language = 'E'

{
  key item_rel     as ChangeRecordItemRelevance,
  key cast(issue_type as  /plmb/cr_type preserving type) as ChangeRecordType,  
  key ref_obj_type as ChangeRecordReferenceType,
      //Associations

      _ChangeRecordItemRelText.Language as Language,
      _ChangeRecordItemRelText
      
      
}
where
      application = 'CR'
      
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGERECORDITEMRELTEXT",
"/PLMI/CR_REL_APP"
],
"ASSOCIATED":
[
"I_CHANGERECORDITEMRELTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More