P_CostCenterActivityTypeTP

DDL: P_COSTCENTERACTIVITYTYPETP Type: view COMPOSITE

P_CostCenterActivityTypeTP is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CostCenterActivityType) and exposes 28 fields with key fields ControllingArea, CostCtrActivityType, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_CostCenterActivityType I_CostCenterActivityType from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCCACTTYPTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea
KEY CostCtrActivityType CostCtrActivityType
KEY ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
CostCtrActivityTypeQtyUnit CostCtrActivityTypeQtyUnit
CostCtrActivityTypeCategory
AllocationCostElement
CostCtrActivityTypeOutpQtyUnit CostCtrActivityTypeOutpQtyUnit
CreationDate
EnteredByUser
ActlPostgCostCenterActyTypeCat
OutputQuantityFactor
ActivityTypeIsBlocked
FixedCostIsPredistributed
PriceAllocationMethod
PeriodPriceIsAverage
ActualPriceAllocationMethod
ActualQuantityIsSetManually
PlanQuantityIsSetManually
CostCtrActivityTypeValidCat
CostCtrActivityTypeName
CostCtrActivityTypeDesc
ChartOfAccounts _ControllingArea ChartOfAccounts
_Text _Text
_ControllingArea _ControllingArea
_CostCenterCategory _CostCenterCategory
_CostCtrActivityTypeCategory _CostCtrActivityTypeCategory
_UnitOfMeasure _UnitOfMeasure
@AbapCatalog: {
  sqlViewName: 'PCCACTTYPTP',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM: {
  private: true,
  viewType: #COMPOSITE
}

@ObjectModel.usageType: {
  dataClass: #ORGANIZATIONAL,
  serviceQuality: #A,
  sizeCategory: #M
}

@Metadata.ignorePropagatedAnnotations: true

define view P_CostCenterActivityTypeTP
  as select from I_CostCenterActivityType

{
  key ControllingArea,
  key CostCtrActivityType,
  key ValidityEndDate,
      ValidityStartDate,
      CostCtrActivityTypeQtyUnit,
      cast (CostCtrActivityTypeCategory as fis_mat_latyp preserving type )      as CostCtrActivityTypeCategory,
      cast (AllocationCostElement as fis_mat_vksta preserving type )            as AllocationCostElement,
      CostCtrActivityTypeOutpQtyUnit,
      cast (CreationDate as fis_cc_erfdt preserving type )                      as CreationDate,
      cast (EnteredByUser as fis_cc_erfnm preserving type )                     as EnteredByUser,
      cast (ActlPostgCostCenterActyTypeCat as fis_mat_latypi preserving type )  as ActlPostgCostCenterActyTypeCat,
      cast (OutputQuantityFactor as fis_ausfk preserving type )                 as OutputQuantityFactor,
      cast (ActivityTypeIsBlocked as fco_activity_type_lock preserving type )   as ActivityTypeIsBlocked,
      cast (FixedCostIsPredistributed as fis_mat_co_fixvo preserving type )     as FixedCostIsPredistributed,
      cast (PriceAllocationMethod as fis_tarkz preserving type )                as PriceAllocationMethod,
      cast (PeriodPriceIsAverage as fis_co_yrate preserving type )              as PeriodPriceIsAverage,
      cast (ActualPriceAllocationMethod as fis_mat_co_tarkz_i preserving type ) as ActualPriceAllocationMethod,
      cast (ActualQuantityIsSetManually as fis_co_manist preserving type )      as ActualQuantityIsSetManually,
      cast (PlanQuantityIsSetManually as fis_co_manplan preserving type )       as PlanQuantityIsSetManually,
      cast ( CostCtrActivityTypeValidCat as fco_kstty preserving type )         as CostCtrActivityTypeValidCat,
      _Text[1:Language=$session.system_language].CostCtrActivityTypeName,
      _Text[1:Language=$session.system_language].CostCtrActivityTypeDesc,
      _ControllingArea.ChartOfAccounts,

      _Text,
      _ControllingArea,
      _CostCenterCategory,
      _CostCtrActivityTypeCategory,
      _UnitOfMeasure

}