I_COSTELEMENTONCONTROLLINGAREA

CDS View

Cost element depend on controlling area

I_COSTELEMENTONCONTROLLINGAREA is a CDS View in S/4HANA. Cost element depend on controlling area. It contains 8 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
C_AllocationSenderGLAcctVH view inner CONSUMPTION Allocation Sender GL Account
C_OverheadAllocationAccountVH view inner CONSUMPTION Overhead Allocation Account Value Help
C_OvhdAllocAcctWithCtrlgAreaVH view_entity inner CONSUMPTION Overhead Alloc Account Controlling Area
I_CostElement view inner COMPOSITE Cost Element
I_CostElmntOnCtrlgAreaStdVH view from COMPOSITE Cost element depend on controlling area
I_InternalOrderCostElementVH view_entity from COMPOSITE Cost Element
I_SrvcDocBslnPlannedCost view inner COMPOSITE Baseline Planned Cost of Srv Transaction
I_SrvcDocBslnPlannedRevenue view inner COMPOSITE Baseline Planned Revenue of Srv Txn
I_SrvcDocContnsPlannedCost view_entity inner COMPOSITE Ongoing Planned Cost of Srv Transaction
I_SrvcDocContnsPlannedRevenue view_entity inner COMPOSITE Ongoing Planned Revenue of Srv Trans
I_SrvcDocItmBslnPlannedCost view inner COMPOSITE Baseline Planned Cost of Srv Txn Item
I_SrvcDocItmBslnPlannedRevenue view inner COMPOSITE Baseline Planned Revenue of Srv Txn Item
I_SrvcDocItmContnsPlannedCost view_entity inner COMPOSITE Ongoing Planned Cost Srv Trans Item
I_SrvcDocItmContnsPlndRevenue view_entity inner COMPOSITE Ongoing Planned Revenue Srv Trans Item
P_DMVCECCostElement view_entity from BASIC
P_EffctvCostElmntOnCtrlgArea view from COMPOSITE
P_GLAccountVH view inner CONSUMPTION gl account vh
P_GLOverheadAccountVH view inner CONSUMPTION gl account vh

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ControllingArea ControllingArea 3
KEY CostElement CostElement 2
ConsumptionQtyIsRecorded ConsumptionQtyIsRecorded 1
CostElementCategory CostElementCategory 2
LastChangeDateTime LastChangeDateTime 1
UnitOfMeasure UnitOfMeasure 1
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'ICECA'
@AbapCatalog.compiler.compareFilter: true
//@AccessControl.authorizationCheck: #NOT_REQUIRED

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Cost element depend on controlling area'
@ObjectModel.entityChangeStateId: 'LastChangeDateTime'
@ObjectModel.representativeKey: 'CostElement'
@ObjectModel.usageType: {
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #MIXED
}
//--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

@AccessControl.privilegedAssociations: ['_ControllingAreaText']
// ]--GENERATED


define view I_CostElementOnControllingArea
  as select from           cskb
    left outer to one join tka01 on cskb.kokrs = tka01.kokrs
  
  //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

  association [0..1] to I_ControllingArea      as _ControllingAreaText on   $projection.ControllingArea = _ControllingAreaText.ControllingArea
  // ]--GENERATED

  association [0..1] to I_ControllingArea              as _ControllingArea              on  $projection.ControllingArea = _ControllingArea.ControllingArea
  association [0..1] to I_UnitOfMeasure                as _UnitOfMeasure                on  $projection.UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure
  association [0..1] to I_CostElementOnChartOfAccounts as _CostElementOnChartOfAccounts on  $projection.ChartOfAccounts = _CostElementOnChartOfAccounts.ChartOfAccounts
                                                                                        and $projection.CostElement     = _CostElementOnChartOfAccounts.CostElement
  association [0..1] to I_CostElementCategory          as _CostElementCategory          on  $projection.CostElementCategory = _CostElementCategory.CostElementCategory
{
      //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_ControllingAreaStdVH',
                     element: 'ControllingArea' }
        }]
      @ObjectModel.text.association: '_ControllingAreaText'
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_ControllingArea'
  key cskb.kokrs           as ControllingArea,
  key cskb.kstar           as CostElement,
      @Semantics.businessDate.to: true
  key cskb.datbi           as ValidityEndDate,
      @Semantics.businessDate.from: true
      cskb.datab           as ValidityStartDate,
      @ObjectModel.foreignKey.association: '_CostElementCategory'
      cskb.katyp           as CostElementCategory,
      cskb.mgefl           as ConsumptionQtyIsRecorded,
      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      cskb.msehi           as UnitOfMeasure,
      tka01.ktopl          as ChartOfAccounts,
      cskb.last_changed_ts as LastChangeDateTime,
      _ControllingArea,
      _CostElementOnChartOfAccounts,
      _CostElementCategory,
      _UnitOfMeasure,
      //--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG

      @Consumption.hidden: true
      _ControllingAreaText
      // ]--GENERATED


}  
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CSKB",
"TKA01"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_COSTELEMENTCATEGORY",
"I_COSTELEMENTONCHARTOFACCOUNTS",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/