I_CostCenterText

DDL: I_COSTCENTERTEXT SQL: IFICOSTCENTERT Type: view BASIC Package: FINS_COST_CENTER_VDM
10 Fields 1 Data Sources 3 Associations 20 OData Services 1 Fiori Apps

Cost Center - Text

I_CostCenterText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Public 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. It is exposed through 20 OData services (ASQL_F1421, ASQL_F2421, ASQL_F2876, ...). It is used in 1 Fiori application: Review Service Entry Sheet Accruals. Part of development package FINS_COST_CENTER_VDM.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentCO-OM-2CL
CapabilitiesData Source for Data Extraction,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Language-Dependent Text
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public 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

OData Services (20)

ServiceBindingVersionContractRelease
ASQL_F1421 ASQL_F1421 C2 NOT_RELEASED
ASQL_F2421 ASQL_F2421 C2 NOT_RELEASED
ASQL_F2876 ASQL_F2876 C2 NOT_RELEASED
ASQL_F3096 ASQL_F3096 C2 NOT_RELEASED
ASQL_F3680 ASQL_F3680 C2 NOT_RELEASED
ASQL_F3681 ASQL_F3681 C2 NOT_RELEASED
ASQL_F3966 ASQL_F3966 C2 NOT_RELEASED
ASQL_F4011 ASQL_F4011 C2 NOT_RELEASED
ASQL_F4021 ASQL_F4021 C2 NOT_RELEASED
ASQL_F4095 ASQL_F4095 C2 NOT_RELEASED
ASQL_F4173 ASQL_F4173 C2 NOT_RELEASED
ASQL_F4307 ASQL_F4307 C2 NOT_RELEASED
ASQL_F4424 ASQL_F4424 C2 NOT_RELEASED
ASQL_F4562 ASQL_F4562 C2 NOT_RELEASED
ASQL_F5342 ASQL_F5342 C2 NOT_RELEASED
ASQL_F6108 ASQL_F6108 C2 NOT_RELEASED
ASQL_F6785 ASQL_F6785 C2 NOT_RELEASED
ASQL_F7343 ASQL_F7343 C2 NOT_RELEASED
ASQL_F7344 ASQL_F7344 C2 NOT_RELEASED
UI_SSACPERDCAMOUNTS_REVIEW UI_SSACPERDCAMOUNTS_REVIEW V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6108 Review Service Entry Sheet Accruals Transactional Review service entry sheet accrual amount for each period.

Review Service Entry Sheet Accruals

Business Role: Cost Accountant - Overhead

For service purchasing, you need to post accruals for costs that come from unapproved service entry sheets. A purchase order item could have multiple service entry sheets with different account assignments. The Service Entry Sheet Accruals application enables you to calculate and post accruals in General Ledger Accounting automatically. The relevant data can be transferred from Service Purchasing and Recording of the Materials Management component to the Accrual Engine and automatically converted from purchase order items into accrual subobjects. The system calculates the accruals for each account assignment specified in the items of service entry sheets. In each period, you can start an accrual run, which posts all accruals for the service transactions.

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