I_CHGRECDFUNCLOCTSKLISTBSC

CDS View

Chg Recd Functional Location Task List

I_CHGRECDFUNCLOCTSKLISTBSC is a CDS View in S/4HANA. Chg Recd Functional Location Task List. It contains 24 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 24 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ChgRecdFuncLocTskListTP view from TRANSACTIONAL Chg Red Ref Obj Func Loc Task List - TP
I_ChgRecdFuncLocTskListTP_2 view from TRANSACTIONAL Chg Record Functional Location Task List
N_ChgRecdFuncLocTskList view from Auxillary view Func Loc Tsk List
R_ChgRecdFuncLocTskListTP view_entity from TRANSACTIONAL Chg Recd Obj FuncLoc Task List

Fields (24)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 3
ChangeNumber ChangeNumber 2
ChangeRecord ChangeRecord 1
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 3
ChangeRecordItemRelevance ChangeRecordItemRelevance 3
ChangeRecordReference ChangeRecordReference 3
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 3
ChangeRecordReferenceType ChangeRecordReferenceType 3
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 3
ChangeRecordUUID ChangeRecordUUID 3
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 3
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus 2
ChgRecdItmDSgntr ChgRecdItmDSgntr 2
ChgRecdItmTgtSts ChgRecdItmTgtSts 2
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
CreatedByUser CreatedByUser 3
CreationDateTime CreationDateTime 3
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 3
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 3
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 3 
@AbapCatalog.sqlViewName: 'ICRREFFTLTLBSC'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Chg Recd Functional Location Task List'

@VDM.viewType: #BASIC
@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory:#L,
  dataClass: #TRANSACTIONAL
}
define view I_ChgRecdFuncLocTskListBsc
  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,
      cast(root.issue_id as /plmb/cr_id preserving type) 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.internal_id2                             as ChgRecRefInternalKey2,
      reference.internal_id3                             as ChgRecRefInternalKey3,
      reference.internal_id4                             as ChgRecRefInternalKey4,
      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,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _ChangeRecordBsc

}
where
  reference.type_cd = 'FTL'

Learn More