I_CostCenterText

DDL: I_COSTCENTERTEXT SQL: IFICOSTCENTERT Type: view BASIC
10 Fields 1 Data Sources 3 Associations

Cost Center - Text

I_CostCenterText (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_CostCenterText is a Basic CDS View that provides data about "Cost Center - Text" in SAP S/4HANA. It reads from 1 data source (cskt) and exposes 10 fields with key fields CostCenter, ControllingArea, Language, ValidityEndDate. It has 3 associations to related views.

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-FIO-GL-IS
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities, Language-Dependent Text, Data Source for Data Extraction
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
cskt cskt from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ControllingArea _ControllingAreaText $projection.ControllingArea = _ControllingAreaText.ControllingArea
[0..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (17)

NameValueLevelField
EndUserText.label Cost Center - Text view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFICOSTCENTERT view
AccessControl.authorizationCheck #CHECK view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey CostCenter view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
Search.searchable true view
Consumption.filter.businessDate.at true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CostCenter cskt kostl Substitute CC
KEY ControllingArea cskt kokrs Controlling Area
KEY Language cskt spras Off. Language
KEY ValidityEndDate cskt datbi Validity period
ValidityStartDate _md datab Validity period
CostCenterName Cost Center Name
CostCenterDescription Description of Cost Center
_ControllingArea _ControllingArea
_Language _Language
_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_CostCenterText.
-- 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: IFICOSTCENTERT

CREATE VIEW I_CostCenterText AS
SELECT
  cskt.kostl AS CostCenter,
  cskt.kokrs AS ControllingArea,
  cskt.spras AS Language,
  cskt.datbi AS ValidityEndDate,
  _md.datab AS ValidityStartDate,
  cast(cskt.ktext as fis_kostl_name preserving type) AS CostCenterName,
  cast(cskt.ltext as fis_kostl_ltext preserving type) AS CostCenterDescription
FROM cskt
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More