I_CHGRECDREFPLNGSCPBSC

CDS View

Change Record Reference Object PLS

I_CHGRECDREFPLNGSCPBSC is a CDS View in S/4HANA. Change Record Reference Object PLS. It contains 25 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 25 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
A_ChgRecdRefPlngScope view_entity from COMPOSITE Change Record ref Planning Scope
I_ChgRecdRefPlngScpTP view from TRANSACTIONAL Change Record Reference Object PLS TP
I_PlngScopeDetsAssgdToChgRecd view left_outer COMPOSITE Details of Planning Scopes Assigned to Change Record
N_ChangeRecordObjPgPlngScp view from Change Record Reference Object Page Planning Scope
P_ChgRecdPlngScpProdnPlant view from COMPOSITE
P_EngBOMAndPlngScpAssgd view inner COMPOSITE
P_EngSnpshtChgRecdPlngScp view from COMPOSITE
P_PlngScpAssgdToChgRecd view from COMPOSITE

Fields (25)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID,ChangeRecordRefPlngScpUUID 7
KEY ChangeRecordUUID ChangeRecordUUID 6
ChangeNumber ChangeNumber 1
ChangeRecord ChangeRecord 4
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 1
ChangeRecordItemRelevance ChangeRecordItemRelevance 2
ChangeRecordReference ChangeRecordReference 1
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 2
ChangeRecordReferenceType ChangeRecordReferenceType 3
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 1
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 2
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus 1
ChgRecdItmTgtSts ChgRecdItmTgtSts 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
ChgRecRefInternalKey1 ChgRecRefInternalKey1PlngScp 1
ChgRecRefInternalKey2 ChgRecRefInternalKey2PlngScp 1
CreatedByUser CreatedByUser 3
CreationDateTime CreationDateTime 2
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 1
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 3 
@AbapCatalog.sqlViewName: 'ICHGRECREFPLSBSC'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #L}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record Reference Object PLS'
define view I_ChgRecdRefPlngScpBsc
  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,
        reference.parent_key                           as     ChangeRecordUUID,
        root.issue_id                                  as     ChangeRecord,
        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.internal_id2                         as     ChgRecRefInternalKey2,
        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 = 'PLS'
/*+[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