C_CostCenterActivityType

DDL: C_COSTCENTERACTIVITYTYPE SQL: CFICOSTCTRACTTYP Type: view CONSUMPTION Package: FINS_FIS_FICO_APPS

Cost Center Activity Type

C_CostCenterActivityType is a Consumption CDS View that provides data about "Cost Center Activity Type" in SAP S/4HANA. It reads from 1 data source (I_CostCenterActivityType) and exposes 27 fields with key fields ControllingArea, CostCtrActivityType, ValidityEndDate. It has 3 associations to related views. Part of development package FINS_FIS_FICO_APPS.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_CostCenterActivityType I_CostCenterActivityType from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _CalendarDate $projection.ValidityEndDate = _CalendarDate.CalendarDate
[0..1] I_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.AllocationCostElement = _GLAccountInChartOfAccounts.GLAccount
[0..1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CFICOSTCTRACTTYP view
EndUserText.label Cost Center Activity Type view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey CostCtrActivityType view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea
KEY CostCtrActivityType CostCtrActivityType
KEY ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
CostCtrActivityTypeQtyUnit CostCtrActivityTypeQtyUnit
CostCtrActivityTypeCategory CostCtrActivityTypeCategory
AllocationCostElement AllocationCostElement
ActlPostgCostCenterActyTypeCat ActlPostgCostCenterActyTypeCat
CreationDate CreationDate
EnteredByUser EnteredByUser
CostCtrActivityTypeOutpQtyUnit CostCtrActivityTypeOutpQtyUnit
OutputQuantityFactor OutputQuantityFactor
ActivityTypeIsBlocked ActivityTypeIsBlocked
CostOriginGroup CostOriginGroup
FixedCostIsPredistributed FixedCostIsPredistributed
PriceAllocationMethod PriceAllocationMethod
PeriodPriceIsAverage PeriodPriceIsAverage
ActualPriceAllocationMethod ActualPriceAllocationMethod
ActualQuantityIsSetManually ActualQuantityIsSetManually
PlanQuantityIsSetManually PlanQuantityIsSetManually
ChartOfAccounts _ControllingArea ChartOfAccounts
_Text _Text
_ControllingArea _ControllingArea
_CostCtrActivityTypeCategory _CostCtrActivityTypeCategory
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_CalendarDate _CalendarDate 
@AbapCatalog.sqlViewName: 'CFICOSTCTRACTTYP'
@EndUserText.label: 'Cost Center Activity Type'
//@Analytics: {dataCategory: #DIMENSION, dataExtraction.enabled: true}

@VDM.viewType: #CONSUMPTION
@ObjectModel.representativeKey: 'CostCtrActivityType'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@Metadata.ignorePropagatedAnnotations: true

@Metadata.allowExtensions:true
define view C_CostCenterActivityType
  as select from I_CostCenterActivityType
  association [0..1] to I_CalendarDate               as _CalendarDate               on  $projection.ValidityEndDate = _CalendarDate.CalendarDate

  association [0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on  $projection.ChartOfAccounts       = _GLAccountInChartOfAccounts.ChartOfAccounts
                                                                                    and $projection.AllocationCostElement = _GLAccountInChartOfAccounts.GLAccount

  association [0..1] to I_ChartOfAccounts            as _ChartOfAccounts            on  $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts

  //association [0..1] to I_CostCenterCategory          as _CostCenterCategoryMasterData

  //   on $projection.CostCenterCategory                = _CostCenterCategoryMasterData.CostCenterCategory

{
      @ObjectModel.foreignKey.association: '_ControllingArea' //Inserted by VDM CDS Suite Plugin

  key ControllingArea,
      @ObjectModel.text.association: '_Text'
  key CostCtrActivityType,
      @ObjectModel.foreignKey.association: '_CalendarDate'
  key ValidityEndDate,
      ValidityStartDate,
      CostCtrActivityTypeQtyUnit,
      @ObjectModel.foreignKey.association: '_CostCtrActivityTypeCategory' //Inserted by VDM CDS Suite Plugin

      CostCtrActivityTypeCategory,
      @ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
      AllocationCostElement,
      ActlPostgCostCenterActyTypeCat,
      CreationDate,
      EnteredByUser,
      //    _CostCenterCategory.CostCenterCategory as CostCenterCategory,

      CostCtrActivityTypeOutpQtyUnit,
      @DefaultAggregation: #SUM
      OutputQuantityFactor,

      ActivityTypeIsBlocked,
      CostOriginGroup,
      FixedCostIsPredistributed,
      PriceAllocationMethod,
      PeriodPriceIsAverage,
      ActualPriceAllocationMethod,
      ActualQuantityIsSetManually,
      PlanQuantityIsSetManually,
      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
      _ControllingArea.ChartOfAccounts as ChartOfAccounts,

      _Text,
      _ControllingArea,
      _CostCtrActivityTypeCategory,
      _GLAccountInChartOfAccounts,
      _ChartOfAccounts,
      _CalendarDate
      //    _CostCenterCategoryMasterData


}

Learn More