I_CostCenterActivityTypeDetail

DDL: I_COSTCENTERACTIVITYTYPEDETAIL SQL: IFICCACTTYPD Type: view BASIC Package: FINS_FIS_FICO

Cost Center Activity Type Detail

I_CostCenterActivityTypeDetail is a Basic CDS View (Dimension) that provides data about "Cost Center Activity Type Detail" in SAP S/4HANA. It reads from 1 data source (csla) and exposes 13 fields with key fields ControllingArea, CostCtrActivityType, ValidityEndDate. It has 1 association to related views. Part of development package FINS_FIS_FICO.

Data Sources (1)

SourceAliasJoin Type
csla csla from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CostCenterActivityTypeText _Text $projection.ControllingArea = _Text.ControllingArea and $projection.CostCtrActivityType = _Text.CostCtrActivityType and $projection.ValidityEndDate = _Text.ValidityEndDate association[1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea

Annotations (11)

NameValueLevelField
EndUserText.label Cost Center Activity Type Detail view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFICCACTTYPD view
ObjectModel.representativeKey CostCtrActivityType view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea
KEY CostCtrActivityType lstar
KEY ValidityEndDate datbi
ValidityStartDate datab
CostCtrActivityTypeQtyUnit leinh
CostCtrActivityTypeCategory latyp
AllocationCostElement vksta
CostCtrActivityTypeOutpQtyUnit auseh
CreationDate ersda
EnteredByUser usnam
CostOriginGroup hrkft
_Text _Text
_ControllingArea _ControllingArea
@EndUserText.label: 'Cost Center Activity Type Detail'
@Analytics: { dataCategory: #DIMENSION } //, dataExtraction.enabled: true}

@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IFICCACTTYPD'
@ObjectModel.representativeKey: 'CostCtrActivityType'
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:#MASTER

@Metadata.allowExtensions:true
define view I_CostCenterActivityTypeDetail as select from csla

association [0..*] to I_CostCenterActivityTypeText as _Text on  $projection.ControllingArea         = _Text.ControllingArea 
                                                            and $projection.CostCtrActivityType = _Text.CostCtrActivityType
                                                            and $projection.ValidityEndDate     = _Text.ValidityEndDate
association[1] to I_ControllingArea as _ControllingArea     on  $projection.ControllingArea = _ControllingArea.ControllingArea
{
  @ObjectModel.foreignKey.association: '_ControllingArea'
  key cast( kokrs as fis_kokrs preserving type ) as ControllingArea,
  key lstar as CostCtrActivityType,
  @Semantics.businessDate.to: true
  key datbi as ValidityEndDate,
      datab as ValidityStartDate,
      leinh as CostCtrActivityTypeQtyUnit,
      latyp as CostCtrActivityTypeCategory,
      vksta as AllocationCostElement,
      auseh as CostCtrActivityTypeOutpQtyUnit,
      ersda as CreationDate,
      usnam as EnteredByUser,
      hrkft as CostOriginGroup,
    
  _Text,
  _ControllingArea

};