What is I_CostCenterActivityTypeText in SAP S/4HANA?

I_CostCenterActivityTypeText is a basic CDS view in SAP S/4HANA. Cost Center Activity Type - Text It contains 11 fields.

Which tables does I_CostCenterActivityTypeText read from?

I_CostCenterActivityTypeText reads data from: cslt.

What VDM layer is I_CostCenterActivityTypeText?

I_CostCenterActivityTypeText is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_CostCenterActivityTypeText

DDL: I_COSTCENTERACTIVITYTYPETEXT SQL: IFICCACTTYPT Type: view BASIC

11 Fields 1 Data Sources 2 Associations

Cost Center Activity Type - Text

I_CostCenterActivityTypeText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_CostCenterActivityTypeText is a Basic CDS View that provides data about "Cost Center Activity Type - Text" in SAP S/4HANA. It reads from 1 data source (cslt) and exposes 11 fields with key fields ValidityEndDate, ControllingArea, CostCtrActivityType, Language. It has 2 associations to related views.

SAP API Hub

State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-FIO-GL-IS
Capabilities	Data Source for Defining CDS Entities, Language-Dependent Text, Data Source for Data Extraction, Association Target for Defining CDS Entities
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
cslt	cslt	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_ControllingArea	_ControllingAreaText	`$projection.ControllingArea = _ControllingAreaText.ControllingArea`
[0..1]	I_Language	_Language	`$projection.Language = _Language.Language association[1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea`

Annotations (16)

Name	Value	Level
ObjectModel.dataCategory	#TEXT	view
ObjectModel.representativeKey	CostCtrActivityType	view
ObjectModel.modelingPattern	#LANGUAGE_DEPENDENT_TEXT	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#M	view
EndUserText.label	Cost Center Activity Type - Text	view
Analytics.dataExtraction.enabled	true	view
VDM.viewType	#BASIC	view
AbapCatalog.sqlViewName	IFICCACTTYPT	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Search.searchable	true	view
Metadata.ignorePropagatedAnnotations	true	view
Consumption.filter.businessDate.at	true	view

Fields (11)

Key	Field	Source Table	Source Field	Description
KEY	ValidityEndDate	cslt	datbi	Validity period
KEY	ControllingArea			Controlling Area
KEY	CostCtrActivityType	cslt	lstar	Activity Type
KEY	Language		spras	Off. Language
	CostCtrActivityTypeName			Cost Center Activity Type Name
	CostCtrActivityTypeDesc			Cost Center Activity Type Description
	ValidityStartDate		datab	Validity period
	CostCtrActyTypeTxtSearchTerm		mctxt	Search Term for Matchcode Use
	_Language		_Language
	_ControllingArea		_ControllingArea
	_ControllingAreaText		_ControllingAreaText

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_CostCenterActivityTypeText.
-- 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: IFICCACTTYPT

CREATE VIEW I_CostCenterActivityTypeText AS
SELECT
  cslt.datbi AS ValidityEndDate,
  cast( cslt.kokrs as fis_kokrs preserving type ) AS ControllingArea,
  cslt.lstar AS CostCtrActivityType,
  spras AS Language,
  cast( ktext as fis_costctractivitytypename preserving type ) AS CostCtrActivityTypeName,
  cast( ltext as fis_costctractivitytypedesc preserving type ) AS CostCtrActivityTypeDesc,
  datab AS ValidityStartDate,
  mctxt AS CostCtrActyTypeTxtSearchTerm
FROM cslt
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language association[1] to I_ControllingArea as _ControllingArea on ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
;

Depth:

I_CostCenterActivityTypeText view

cslt