I_CostCenterVH

DDL: I_COSTCENTERVH SQL: IFICOSTCENTERVH Type: view BASIC
17 Fields 1 Data Sources 1 Associations 3 OData Services 1 Fiori Apps

Cost Center

I_CostCenterVH is a Basic CDS View that provides data about "Cost Center" in SAP S/4HANA. It reads from 1 data source (I_CostCenter) and exposes 17 fields with key fields CostCenter, ControllingArea, ValidityEndDate. It has 1 association to related views. It is exposed through 3 OData services (UI_MANUALACCRS_MNG, UI_REVNINCRBDGTRULE_MANAGE, UI_RIBRULEGRANTS_MANAGE). It is used in 1 Fiori application: Manage Manual Accruals.

Data Sources (1)

SourceAliasJoin Type
I_CostCenter CostCenter from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ControllingArea _ControllingAreaText $projection.ControllingArea = _ControllingAreaText.ControllingArea association[0..*] to I_CostCenterText as _Text on $projection.ControllingArea = _Text.ControllingArea and $projection.CostCenter = _Text.CostCenter and $projection.ValidityEndDate = _Text.ValidityEndDate

Annotations (14)

NameValueLevelField
VDM.viewType #BASIC view
EndUserText.label Cost Center view
AbapCatalog.sqlViewName IFICOSTCENTERVH view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey CostCenter view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
Search.searchable true view
Consumption.ranked true view
AccessControl.authorizationCheck #CHECK view

OData Services (3)

ServiceBindingVersionContractRelease
UI_MANUALACCRS_MNG UI_MANUALACCRS_MNG V2 C1 NOT_RELEASED
UI_REVNINCRBDGTRULE_MANAGE UI_REVNINCRBDGTRULE_MANAGE V2 C1 NOT_RELEASED
UI_RIBRULEGRANTS_MANAGE UI_RIBRULEGRANTS_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5423 Manage Manual Accruals Transactional With this app, you can create, import, edit, and copy accrual objects as well as change their status. You can use this app to: - Display and edit accrual objects. - Create new accrual objects. - Copy accrual objects. - Import accrual objects from a spreadsheet file. - Change the status of an accrual object by pausing, suspending, or resuming its accrual subobjects. - Prematurely finish accrual subobjects by terminating them or undo premature termination. - View the parameters assigned to an accrual object. - View a detailed summary of changes made to the accrual object, comparing the old and new values of the accrual object fields.

Manage Manual Accruals

Business Role: General Ledger Accountant

With this app, you can create, import, edit, and copy accrual objects as well as change their status.

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CostCenter I_CostCenter CostCenter Cost Center
KEY ControllingArea I_CostCenter ControllingArea Controlling Area
KEY ValidityEndDate I_CostCenter ValidityEndDate ValidTo
CostCenterName
CompanyCode I_CostCenter CompanyCode Receiver Company Code
CostCenterCategory I_CostCenter CostCenterCategory CCtr Category
CostCtrResponsiblePersonName I_CostCenter CostCtrResponsiblePersonName Person Resp.
CostCtrResponsibleUser I_CostCenter CostCtrResponsibleUser User Responsible
ValidityStartDate I_CostCenter ValidityStartDate Validity Start Date
ProfitCenter I_CostCenter ProfitCenter Profit Center
CostCenterResponsibilityArea
_ControllingArea _ControllingArea
_CompanyCode _CompanyCode
_CostCenterCategory _CostCenterCategory
_ProfitCenter _ProfitCenter
_Text _Text
_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_CostCenterVH.
-- 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: IFICOSTCENTERVH

CREATE VIEW I_CostCenterVH AS
SELECT
  CostCenter.CostCenter AS CostCenter,
  CostCenter.ControllingArea AS ControllingArea,
  CostCenter.ValidityEndDate AS ValidityEndDate,
  _Text[1:Language=$session.system_language].CostCenterName AS CostCenterName,
  CostCenter.CompanyCode AS CompanyCode,
  CostCenter.CostCenterCategory AS CostCenterCategory,
  CostCenter.CostCtrResponsiblePersonName AS CostCtrResponsiblePersonName,
  CostCenter.CostCtrResponsibleUser AS CostCtrResponsibleUser,
  CostCenter.ValidityStartDate AS ValidityStartDate,
  CostCenter.ProfitCenter AS ProfitCenter,
  concat('KS', concat(ControllingArea, CostCenter)) AS CostCenterResponsibilityArea
FROM I_CostCenter AS CostCenter
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea association[0..*] to I_CostCenterText as _Text on ControllingArea = _Text.ControllingArea AND CostCenter = _Text.CostCenter AND ValidityEndDate = _Text.ValidityEndDate  -- association [0..1]
;

Learn More