C_AllocationCostCenterVH

DDL: C_ALLOCATIONCOSTCENTERVH SQL: CALLOCCVH Type: view CONSUMPTION

Cost Center Value Help

C_AllocationCostCenterVH is a Consumption CDS View that provides data about "Cost Center Value Help" in SAP S/4HANA. It reads from 1 data source (I_CostCenterVH) and exposes 11 fields with key fields ControllingArea, CostCenter, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_CostCenterVH CostCenter from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CALLOCCVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey CostCenter 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
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
EndUserText.label Cost Center Value Help view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea I_CostCenterVH ControllingArea Controlling Area
KEY CostCenter I_CostCenterVH CostCenter Cost Center
KEY ValidityEndDate I_CostCenterVH ValidityEndDate ValidTo
ValidityStartDate I_CostCenterVH ValidityStartDate Validity Start Date
CostCenterName I_CostCenterVH CostCenterName Name
CompanyCode I_CostCenterVH CompanyCode Receiver Company Code
CostCenterCategory I_CostCenterVH CostCenterCategory CCtr Category
ProfitCenter I_CostCenterVH ProfitCenter Profit Center
CostCtrResponsiblePersonName I_CostCenterVH CostCtrResponsiblePersonName Person Resp.
CostCtrResponsibleUser I_CostCenterVH CostCtrResponsibleUser User Responsible
_ControllingArea I_CostCenterVH _ControllingArea

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 C_AllocationCostCenterVH.
-- 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: CALLOCCVH

CREATE VIEW C_AllocationCostCenterVH AS
SELECT
  CostCenter.ControllingArea AS ControllingArea,
  CostCenter.CostCenter AS CostCenter,
  CostCenter.ValidityEndDate AS ValidityEndDate,
  CostCenter.ValidityStartDate AS ValidityStartDate,
  CostCenter.CostCenterName AS CostCenterName,
  CostCenter.CompanyCode AS CompanyCode,
  CostCenter.CostCenterCategory AS CostCenterCategory,
  CostCenter.ProfitCenter AS ProfitCenter,
  CostCenter.CostCtrResponsiblePersonName AS CostCtrResponsiblePersonName,
  CostCenter.CostCtrResponsibleUser AS CostCtrResponsibleUser,
  CostCenter._ControllingArea AS _ControllingArea
FROM I_CostCenterVH AS CostCenter
;