I_ControllingObject

DDL: I_CONTROLLINGOBJECT SQL: IFICOOBJECT Type: view BASIC

Controlling Object

I_ControllingObject is a Basic CDS View (Dimension) that provides data about "Controlling Object" in SAP S/4HANA. It reads from 8 data sources and exposes 14 fields with key field ControllingObject. It has 1 association to related views.

8 data source(s) 14 fields

Data Sources (8)

SourceAliasJoin Type
onr00 onr00 from
onrbp onrbp left_outer
onrkl onrkl left_outer
onrks onrks left_outer
onror onror left_outer
onrpd onrpd left_outer
onrpr onrpr left_outer
onrvb onrvb left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CostCenter _CostCenter $projection.CostCenter = _CostCenter.CostCenter and $projection.ControllingArea = _CostCenter.ControllingArea association[0..*] to I_CostCenterActivityType as _CostCtrActivityType on $projection.CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType and $projection.ControllingArea = _CostCtrActivityType.ControllingArea

Annotations (14)

NameValueLevelField
EndUserText.label Controlling Object view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFICOOBJECT view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey ControllingObject view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject onr00 objnr
OrderID onror aufnr
BusinessProcess onrbp prznr
CostCtrActivityType onrkl lstar
SalesDocument onrvb vbeln
SalesDocumentItem onrvb posnr
ControllingArea
CostCenter
WBSElementInternalID
ProjectInternalID
ControllingObjectType
_ControllingArea _ControllingArea
_CostCenter _CostCenter
_CostCtrActivityType _CostCtrActivityType 
@EndUserText.label: 'Controlling Object'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IFICOOBJECT'
@AccessControl.authorizationCheck: #CHECK //NOT_REQUIRED

@ObjectModel.representativeKey: 'ControllingObject'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.supportedCapabilities: [ #EXTRACTION_DATA_SOURCE, #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION 

@ObjectModel.usageType: {
  dataClass: #TRANSACTIONAL,
  serviceQuality: #C,
  sizeCategory: #L
}
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true

define view I_ControllingObject
// Corresponds to calculation view 'sap.hba.ecc.ControllingObject'

as select from onr00

left outer join onrks on  onr00.objnr = onrks.objnr
left outer join onrbp on  onr00.objnr = onrbp.objnr
left outer join onrkl on  onr00.objnr = onrkl.objnr
left outer join onror on  onr00.objnr = onror.objnr
//left outer join onrov on  Join_4.objnr = onrov.objnr

left outer join onrpd on  onr00.objnr = onrpd.objnr
left outer join onrpr on  onr00.objnr = onrpr.objnr
left outer join onrvb on  onr00.objnr = onrvb.objnr

association[1]          to I_ControllingArea              as _ControllingArea         
    on  $projection.ControllingArea         = _ControllingArea.ControllingArea
association [0..*]      to I_CostCenter                   as _CostCenter             
    on  $projection.CostCenter              = _CostCenter.CostCenter
    and $projection.ControllingArea         = _CostCenter.ControllingArea
association[0..*]       to I_CostCenterActivityType       as _CostCtrActivityType     
    on  $projection.CostCtrActivityType     = _CostCtrActivityType.CostCtrActivityType
    and $projection.ControllingArea         = _CostCtrActivityType.ControllingArea    
{

  
  
  key   onr00.objnr as ControllingObject,

        onror.aufnr as OrderID,

        onrbp.prznr as BusinessProcess,

        onrkl.lstar as CostCtrActivityType,

        onrvb.vbeln as SalesDocument,

        onrvb.posnr as SalesDocumentItem,
 
        cast ( COALESCE ( COALESCE( COALESCE(onrks.kokrs, onrbp.kokrs ),   onrkl.kokrs), '')  as fis_kokrs ) as ControllingArea,

        cast( COALESCE(onrks.kostl, onrkl.kostl) as fis_kostl ) as CostCenter,

        cast( onrpr.pspnr as fis_wbsint_no_conv preserving type ) as WBSElementInternalID,
        cast( onrpd.pspnr as fis_projectint_no_conv preserving type) as ProjectInternalID,
        cast ( SUBSTRING( onr00.objnr, 1, 2) as j_obart) as ControllingObjectType,
        _ControllingArea ,
        _CostCenter ,
        _CostCtrActivityType  
        
};
               
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ONR00",
"ONRBP",
"ONRKL",
"ONRKS",
"ONROR",
"ONRPD",
"ONRPR",
"ONRVB"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_COSTCENTERACTIVITYTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More