I_CostCenterActivityTypeVH

DDL: I_COSTCENTERACTIVITYTYPEVH SQL: IFICCACTTYPVH Type: view BASIC
7 Fields 1 Data Sources

Cost Center Activity Type Value Help

I_CostCenterActivityTypeVH is a Basic CDS View that provides data about "Cost Center Activity Type Value Help" in SAP S/4HANA. It reads from 1 data source (I_CostCenterActivityType) and exposes 7 fields with key fields ControllingArea, CostCtrActivityType, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_CostCenterActivityType I_CostCenterActivityType from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IFICCACTTYPVH view
ObjectModel.representativeKey CostCtrActivityType view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Cost Center Activity Type Value Help view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
Consumption.ranked true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea Controlling Area
KEY CostCtrActivityType CostCtrActivityType Activity Type
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
CostCtrActivityTypeCategory ATyp category
CostCtrActivityTypeQtyUnit CostCtrActivityTypeQtyUnit Unit
CostCtrActivityTypeName

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CostCenterActivityTypeVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFICCACTTYPVH

CREATE VIEW I_CostCenterActivityTypeVH AS
SELECT
  ControllingArea,
  CostCtrActivityType,
  ValidityEndDate,
  ValidityStartDate,
  cast( CostCtrActivityTypeCategory as fis_latyp preserving type ) AS CostCtrActivityTypeCategory,
  CostCtrActivityTypeQtyUnit,
  _Text[1:Language = $session.system_language].CostCtrActivityTypeName AS CostCtrActivityTypeName
FROM I_CostCenterActivityType
;

Learn More