FINOC_RULE_PRO_BASE

DDL: FINOC_RULE_PRO_BASE SQL: FINOCV_RULE_PROB Type: view Package: FINS_ORGL_CHANGE_RULE

Organizational Change: Base Rule Project

FINOC_RULE_PRO_BASE is a CDS View that provides data about "Organizational Change: Base Rule Project" in SAP S/4HANA. It reads from 2 data sources (finoc_orglchg, proj) and exposes 6 fields with key fields ps_prj_pnr, orgl_change. Part of development package FINS_ORGL_CHANGE_RULE.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
finoc_orglchg oc inner
proj prj from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FINOCV_RULE_PROB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Organizational Change: Base Rule Project view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ps_prj_pnr proj pspnr
KEY orgl_change finoc_orglchg orgl_change
kokrs proj vkokr
bukrs proj vbukr
prctr_old
prctr 
@AbapCatalog.sqlViewName: 'FINOCV_RULE_PROB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Organizational Change: Base Rule Project'


define view FINOC_RULE_PRO_BASE
  as select from           proj          as prj
    inner join             finoc_orglchg as oc     on oc.processing_status <> 'CMP' // only not yet completed org changes

    left outer to one join finoc_rt_pro  as rt_pro on  rt_pro.ps_prj_pnr      = prj.pspnr
                                                   and rt_pro.orgl_change     = oc.orgl_change
                                                   and rt_pro.reassgmt_status = 'DONE'
{
  key prj.pspnr                                                     as ps_prj_pnr,
  key oc.orgl_change,
      prj.vkokr                                                     as kokrs,
      prj.vbukr                                                     as bukrs,
      coalesce( rt_pro.prctr_old, prj.prctr )                       as prctr_old,
      cast( '          ' as finoc_prctr_new preserving type )       as prctr, // new profit center

      cast( '  ' as finoc_prctr_drvtn_source_type preserving type ) as prctr_drvtn_source_type // space = this is the root object

}

Learn More