I_CHGRECDREFPRODNORDBSC

CDS View

Change Record Reference Object Prodn Ord

I_CHGRECDREFPRODNORDBSC is a CDS View in S/4HANA. Change Record Reference Object Prodn Ord. It contains 22 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 22 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChgRecdRefProdnOrdTP view from TRANSACTIONAL Change Record Reference Object Prodn Ord
N_ChangeRecordObjPgProdnOrd view from Change Record Reference Object Page Prodn Ord

Fields (22)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 1
ChangeNumber ChangeNumber 1
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 1
ChangeRecordItemRelevance ChangeRecordItemRelevance 1
ChangeRecordReference ChangeRecordReference 1
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 1
ChangeRecordReferenceType ChangeRecordReferenceType 1
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 1
ChangeRecordUUID ChangeRecordUUID 1
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 1
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus 1
ChgRecdItmDSgntr ChgRecdItmDSgntr 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 1
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 2
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 1 
@AbapCatalog.sqlViewName: 'ICHGRECREFPPOBSC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record Reference Object Prodn Ord'
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #XL}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_ChgRecdRefProdnOrdBsc
  as select from           /iam/d_i_root    as root
    inner join             /iam/d_i_obj_ref as reference     on  root.db_key         = reference.parent_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,

      root.issue_id                              as ChangeRecord,
      reference.parent_key                       as ChangeRecordUUID,
      reference.type_cd                          as ChangeRecordReferenceType,
      reference.subtype_cd                       as ChangeRecordReferenceSubtype,
      reference.internal_guid                    as ChangeRecordRefObjectUUID,
      reference.par_objref_uuid                  as ParentChangeRecordRefUUID,
      reference.main_ref_ind                     as IsMainReference,
      reference.id                               as ChangeRecordReference,

      @Semantics.user.createdBy: true
      reference.created_by                       as CreatedByUser,
      cast( reference.created_on  as tzntstmps ) as CreationDateTime,
      @Semantics.user.lastChangedBy: true
      reference.changed_by                       as LastChangedByUser,
      cast( reference.changed_on  as tzntstmps ) as LastChangeDateTime,
      reference.virtual_ref_ind                  as ChangeRecordVirtualRefInd,
      reference.item_rel                         as ChangeRecordItemRelevance,
      reference.internal_id1                     as ChgRecRefInternalKey1,
      reference_ext.itm_status                   as ChangeRecordItemProcgStatus,
      reference_ext.tgt_proc_status              as ChgRecdItmTgtSts,
      reference_ext.dig_sign                     as ChgRecdItmDSgntr,
      reference_ext.itm_status                   as ChgRecdCurrentItemProcgStatus,
      reference_ext.reasonforchange              as ChgRecdReasonForChange,
      reference_ext.expected_comp_dat            as ExpdCompltnDte,
      reference_ext.auth_group                   as ChgRecdAuthznGrpText,
      reference_ext.chgstatus                    as ChgRecdNmbrChgSts,
      reference_ext.changenumber                 as ChangeNumber,
      
      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _ChangeRecordBsc

}
where
      reference.type_cd     = 'PRN'
  and reference.category_cd = 'PRN_ERP'

Learn More