I_ORGLCHANGEWBSELEMENT

CDS View

WBS Elements in an Orgl Change

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

Used by 5 CDS view(s) 4 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
FINOC_RT_WBS_FILL view from Orgl Change: Fill Runtime for WBS Elmnt
FINOC_RT_WBS_FILL view left_outer Orgl Change: Fill Runtime for WBS Elmnt
FINOC_RT_WBS_FILL view union_all Orgl Change: Fill Runtime for WBS Elmnt
P_OrglChgWBSElmntUploadCheck view_entity inner COMPOSITE
R_OrglChangeWBSElementTP view_entity from TRANSACTIONAL Organizational Change WBS Element

Fields (4)

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

define view I_OrglChangeWBSElement
  as select from finoc_orglchgwbs
  association [1]    to I_OrganizationalChange as _OrglChange                    on  $projection.OrganizationalChange = _OrglChange.OrganizationalChange
  association [1]    to I_WBSElementBasicData  as _WBSElement                    on  $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
  association [0..1] to I_WBSElement           as _WBSElementExternalID          on  $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementWithCodingMask

  //  association [0..1] to  I_WBSElementBasicData  as _WBSElementExternalID        on  $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID    //TEST

  //  association [0..*] to I_WBSElement            as _WBSElementExternalID        on  $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementWithCodingMask  //TEST


  association [1..*] to I_ProfitCenter         as _ProfitCtr                     on  $projection.ControllingArea = _ProfitCtr.ControllingArea
                                                                                 and $projection.ProfitCenter    = _ProfitCtr.ProfitCenter
  association [1..*] to I_ProfitCenter         as _ProfitCtrNew                  on  $projection.ControllingArea          = _ProfitCtrNew.ControllingArea
                                                                                 and $projection.ProfitCenterByOrglChange = _ProfitCtrNew.ProfitCenter
  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_psp_pnr as fis_wbsint_no_conv preserving type) as WBSElementInternalID,

       //      _WBSElementExternalID.WBSElementWithCodingMask         as WBSElementExternalID,                       //Changed for Test


       //     _WBSElementExternalID.WBSElementExternalID              as WBSElementExternalID,                       //Test - does not work!

       //       cast ( 'ABCD12345123451234512345' as ps_posid_edit preserving type )   as WBSElementExternalID,        //Test

       _WBSElement.WBSElementExternalID                        as WBSElementExternalID,
       kokrs                                                   as ControllingArea,
       prctr                                                   as ProfitCenter,
       prctr_new                                               as ProfitCenterByOrglChange,
       last_changed_on                                         as LastChangeDateTime,
       last_changed_by                                         as LastChangedByUser,
        // not used

       _WBSElement._Project.ProjectProfileCode                 as ProjectProfileCode,
       _OrglChange,
       _WBSElement,
       _WBSElementExternalID,
       @Semantics.text: true
       _ProfitCtr,
       @Semantics.text: true
       _ProfitCtrNew,
       _ProfitCenterBfrOrglChangeText,
       _ProfitCenterByOrglChangeText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTBASICDATA",
"I_WBSELEMENTBASICDATA",
"FINOC_ORGLCHGWBS"
],
"ASSOCIATED":
[
"I_ORGANIZATIONALCHANGE",
"I_PROFITCENTER",
"I_PROFITCENTERTEXT",
"I_WBSELEMENT",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More