FINOC_RULE_NWA_BASE

CDS View

O/C Rule: Network Activity Base

FINOC_RULE_NWA_BASE is a CDS View in S/4HANA. O/C Rule: Network Activity Base. It contains 12 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 12 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FINOC_RULE_NWA_DEFAULT view from O/C Rule: Network Activity Base Default
FINOC_RULE_NWA_EXAMPLE view union_all Organizational Change: Customer Rule NWA

Fields (12)

KeyField CDS FieldsUsed in Views
KEY aufnr aufnr 1
KEY orgl_change orgl_change 1
KEY vornr vornr 2
aplzl aplzl 2
aufpl aufpl 2
bukrs bukrs 2
kokrs kokrs 2
prctr_drvtn_source_type prctr_drvtn_source_type 1
prctr_old prctr_old 1
srce_aufnr srce_aufnr 1
srce_ps_prj_pnr srce_ps_prj_pnr 1
srce_ps_psp_pnr srce_ps_psp_pnr 1 
@AbapCatalog.sqlViewName: 'FINOC_RULE_NWAB'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'O/C Rule: Network Activity Base'
// This view returns all network activities. A cross-join with all non-completed organizational changes is used to determine

// the profit center old, i.e. the profit center the network activity had before organizational change processing.

// Nevertheless, the organizational change runtime engine will always call the view with a restiction to organizational change,

// so that it won't return more than one org change per network activity.

define view FINOC_RULE_NWA_BASE
  as select from           afvc          as afvc
    inner join             afko          as afko    on afko.aufpl = afvc.aufpl
    inner join             aufk          as aufk    on aufk.aufnr = afko.aufnr
    inner join             finoc_orglchg as orglchg on orglchg.processing_status <> 'CMP'
    left outer to one join finoc_rt_nwa  as rt_nwa  on  rt_nwa.aufnr           = afko.aufnr
                                                    and rt_nwa.vornr           = afvc.vornr
                                                    and rt_nwa.orgl_change     = orglchg.orgl_change
                                                    and rt_nwa.reassgmt_status = 'DONE'
{
  key  afko.aufnr,
  key  afvc.vornr,
  key  orglchg.orgl_change,
       aufk.kokrs,
       afvc.bukrs,
       coalesce(rt_nwa.prctr_old, afvc.prctr)                      as prctr_old,
       cast( '          ' as finoc_prctr_new preserving type )     as prctr,
       cast('  ' as finoc_prctr_drvtn_source_type preserving type) as prctr_drvtn_source_type, // space = this is the root object

       cast('00000000' as finoc_srce_ps_psp_pnr preserving type)   as srce_ps_psp_pnr,
       cast('00000000' as finoc_srce_ps_prj_pnr preserving type)   as srce_ps_prj_pnr,
       cast('            ' as finoc_srce_aufnr preserving type)    as srce_aufnr,
       afvc.aufpl,
       afvc.aplzl,
       afvc.projn                                                  as ps_psp_pnr,
       afko.pronr                                                  as ps_prj_pnr
}
where
      aufk.autyp = '20' // Network activtiy

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AFKO",
"AFVC",
"AUFK",
"FINOC_ORGLCHG",
"FINOC_RT_NWA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More