I_CHGRECDREFMATBSC

CDS View

Change Record Reference Object Material

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

Used by 3 CDS view(s) 1 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ChangeRecordReferenceMatTP view from TRANSACTIONAL Change Record Object Reference Material
I_ChangeRecordReferenceMatTP_2 view from TRANSACTIONAL Change Record Object Reference Material
N_ChangeRecordObjPgMatl view from Change Record Reference Object Material

Fields (1)

KeyField CDS FieldsUsed in Views
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus 1 
@AbapCatalog.sqlViewName: 'ICHGRECDREFMATB'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #XXL}
@EndUserText.label: 'Change Record Reference Object Material'
@AbapCatalog.preserveKey:true
define view I_ChgRecdRefMatBsc
  as select from           /iam/d_i_obj_ref as reference
  //    left outer join      /plmb/cr_itm_ext as refext   on  reference.parent_key = refext.db_key

    inner join             /iam/d_i_root    as root          on  reference.parent_key = root.db_key
                                                             and root.application     = 'CR'
                                                             and root.issue_category  = 'CR'
    left outer to one join /plmi/cr_itm_ext as reference_ext on reference.db_key = reference_ext.parent_key

  association [1..1] to I_ChangeRecordBsc as _ChangeRecordBsc on $projection.ChangeRecordUUID = _ChangeRecordBsc.ChangeRecordUUID
{
  key reference.db_key                                                 as ChangeRecordReferenceUUID,
      reference.parent_key                                             as ChangeRecordUUID,
      root.issue_id                                                    as ChangeRecord,
      root.issue_type                                                  as ChangeRecordType,
      reference.type_cd                                                as ChangeRecordReferenceType,
      reference.subtype_cd                                             as ChangeRecordReferenceSubtype,
      reference.id                                                     as ChangeRecordReference,
      reference.par_objref_uuid                                        as ParentChangeRecordRefUUID,
      reference.main_ref_ind                                           as IsMainReference,
      @Semantics.user.createdBy: true
      reference.created_by                                             as CreatedByUser,
      cast( reference.created_on  as tzntstmps preserving type )       as CreationDateTime,
      @Semantics.user.lastChangedBy: true
      reference.changed_by                                             as LastChangedByUser,
      cast( reference.changed_on  as tzntstmps preserving type )       as LastChangeDateTime,
      reference.item_rel                                               as ChangeRecordItemRelevance,
      reference.virtual_ref_ind                                        as ChangeRecordVirtualRefInd,
      reference.internal_id1                                           as ChgRecRefInternalKey1,
      reference_ext.itm_status                                         as ChangeRecordItemProcgStatus,
      reference_ext.itm_status                                         as ChgRecdCurrentItemProcgStatus,
      reference_ext.changenumber                                       as ChangeNumber,
      reference_ext.tgt_proc_status                                    as ChgRecdItmTgtSts,
      reference_ext.dig_sign                                           as ChgRecdItmDSgntr,
      reference_ext.reasonforchange                                    as ChgRecdReasonForChange,
      reference_ext.expected_comp_dat                                  as ExpdCompltnDte,
      reference_ext.auth_group                                         as ChgRecdAuthznGrpText,
      reference_ext.chgstatus                                          as ChgRecdNmbrChgSts,
      root.lcycle_cd                                                   as ChangeRecordLifecycleStatus,
      cast(root.user_status_01 as /plmb/cr_hdr_status preserving type) as ChangeRecordStatus,
      //    refext.customer_no                         as     Customer,


      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _ChangeRecordBsc
}
where
  reference.type_cd = 'MAT'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/IAM/D_I_OBJ_REF",
"/IAM/D_I_ROOT",
"/PLMI/CR_ITM_EXT"
],
"ASSOCIATED":
[
"I_CHANGERECORDBSC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More