A_CostCenterHierarchy

DDL: A_COSTCENTERHIERARCHY Type: view_entity COMPOSITE Package: FINS_FI_UH_INBOUND
12 Fields 1 Data Sources 2 OData Services

Cost Center Hierarchy

A_CostCenterHierarchy is a Composite CDS View that provides data about "Cost Center Hierarchy" in SAP S/4HANA. It reads from 1 data source (R_CostCenterHierarchy) and exposes 12 fields with key fields CostCenterHierarchyShortID, ValidityEndDate, ValidityStartDate. It is exposed through 2 OData services (API_COSTCENTER_HIERARCHY, ASQL_F8568). Part of development package FINS_FI_UH_INBOUND.

Data Sources (1)

SourceAliasJoin Type
R_CostCenterHierarchy R_CostCenterHierarchy projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Cost Center Hierarchy view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.sapObjectNodeType.name CostCenterHierarchy view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
OData.entityType.name CostCenterHierarchy_Type view

OData Services (2)

ServiceBindingVersionContractRelease
API_COSTCENTER_HIERARCHY API_COSTCENTER_HIERARCHY V4 C2 C1
ASQL_F8568 ASQL_F8568 C2 NOT_RELEASED

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CostCenterHierarchyShortID CostCenterHierarchyShortID Hierarchy ID
KEY ValidityEndDate ValidityEndDate ValidTo
KEY ValidityStartDate ValidityStartDate Validity Start Date
ControllingArea ControllingArea Controlling Area
UniversalHierVersStatus UniversalHierVersStatus
UniversalHierVersUpdatedAt UniversalHierVersUpdatedAt Updated At
UniversalHierVersUpdatedBy UniversalHierVersUpdatedBy Updated By
UniversalHierVersCreatedAt UniversalHierVersCreatedAt Created At
UniversalHierVersCreatedBy UniversalHierVersCreatedBy Created By
UniversalHierVersLockedBy UniversalHierVersLockedBy Locked By
UniversalHierVersLockedAt UniversalHierVersLockedAt Locked At
HierarchyIsSetGroupCompatible HierarchyIsSetGroupCompatible

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 A_CostCenterHierarchy.
-- 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.

CREATE VIEW A_CostCenterHierarchy AS
SELECT
  CostCenterHierarchyShortID,
  ValidityEndDate,
  ValidityStartDate,
  ControllingArea,
  UniversalHierVersStatus,
  UniversalHierVersUpdatedAt,
  UniversalHierVersUpdatedBy,
  UniversalHierVersCreatedAt,
  UniversalHierVersCreatedBy,
  UniversalHierVersLockedBy,
  UniversalHierVersLockedAt,
  HierarchyIsSetGroupCompatible
FROM R_CostCenterHierarchy
;

Learn More