I_ORGANIZATIONALCHANGEPROJECT

CDS View

Projects in an Orgl Change

I_ORGANIZATIONALCHANGEPROJECT is a CDS View in S/4HANA. Projects in an Orgl Change. It contains 5 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 5 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
FINOC_RT_PRO_FILL view from Orgl Change: Fill Runtime for Projects
FINOC_RT_PRO_FILL view left_outer Orgl Change: Fill Runtime for Projects
FINOC_RT_WBS_FILL view union_all Orgl Change: Fill Runtime for WBS Elmnt
P_OrglChgProjectUploadCheck view_entity inner COMPOSITE
R_OrglChangeProjectTP view_entity from TRANSACTIONAL Organizational Change Projects

Fields (5)

KeyField CDS FieldsUsed in Views
KEY OrganizationalChange OrganizationalChange 2
KEY ProjectInternalID ProjectInternalID,SourceProjectInternalID 2
ControllingArea ControllingArea 1
ProfitCenter ProfitCenterBeforeOrglChange 2
ProfitCenterByOrglChange ProfitCenterByOrglChange,SystemMessageVariable2 3 
@AbapCatalog.sqlViewName: 'IFINOCORGLCHGPRO'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Projects in an Orgl Change'
@Analytics: {
  dataCategory: #DIMENSION
}
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'ProjectInternalID'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #XL
}
@Analytics.internalName:#LOCAL
@Metadata.allowExtensions:true

define view I_OrganizationalChangeProject
  as select from finoc_orglchgpro
  association [1]    to I_OrganizationalChange as _OrglChange                    on  $projection.OrganizationalChange = _OrglChange.OrganizationalChange
  association [1]    to I_ProjectBasicData     as _ProjectBasicData              on  $projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID
  association [0..1] to I_Project              as _Project                       on  $projection.ProjectExternalID = _Project.ProjectWithCodingMask

  association [0..*] to I_ProfitCenterText     as _ProfitCenterBfrOrglChangeText on  $projection.ControllingArea                    = _ProfitCenterBfrOrglChangeText.ControllingArea
                                                                                 and $projection.ProfitCenter                       = _ProfitCenterBfrOrglChangeText.ProfitCenter
                                                                                 and _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'
  association [0..*] to I_ProfitCenterText     as _ProfitCenterByOrglChangeText  on  $projection.ControllingArea                   = _ProfitCenterByOrglChangeText.ControllingArea
                                                                                 and $projection.ProfitCenterByOrglChange          = _ProfitCenterByOrglChangeText.ProfitCenter
                                                                                 and _ProfitCenterByOrglChangeText.ValidityEndDate = '99991231'

{
       @ObjectModel.foreignKey.association: '_OrglChange'
  key  orgl_change                                           as OrganizationalChange,
  key  cast (ps_prj_pnr as ps_s4_proj_pspnr preserving type) as ProjectInternalID,
       _ProjectBasicData.ProjectExternalID                   as ProjectExternalID,
       kokrs                                                 as ControllingArea,
       prctr                                                 as ProfitCenter,
       prctr_new                                             as ProfitCenterByOrglChange,
       last_changed_on                                       as LastChangeDateTime,
       last_changed_by                                       as LastChangedByUser,
       _OrglChange,
       _Project,
       _ProjectBasicData,
       _ProfitCenterBfrOrglChangeText,
       _ProfitCenterByOrglChangeText,
       //not used

       _ProjectBasicData.ProjectProfileCode                           as ProjectProfileCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTBASICDATA",
"FINOC_ORGLCHGPRO"
],
"ASSOCIATED":
[
"I_ORGANIZATIONALCHANGE",
"I_PROFITCENTERTEXT",
"I_PROJECT",
"I_PROJECTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More