P_AllocCostCenterVH

DDL: P_ALLOCCOSTCENTERVH SQL: PALOCOSTCENVH Type: view CONSUMPTION
11 Fields 1 Data Sources 1 Associations

Cost Center VH

P_AllocCostCenterVH is a Consumption CDS View that provides data about "Cost Center VH" in SAP S/4HANA. It reads from 1 data source (C_CostCenterVH) and exposes 11 fields with key fields CostCenter, ControllingArea, ValidityEndDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
C_CostCenterVH C_CostCenterVH from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PALOCOSTCENVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cost Center VH view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Search.searchable true view
VDM.private true view

Fields (11)

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

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 P_AllocCostCenterVH.
-- 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: PALOCOSTCENVH

CREATE VIEW P_AllocCostCenterVH AS
SELECT
  CostCenter,
  ControllingArea,
  ValidityEndDate,
  CompanyCode,
  CostCenterCategory,
  CostCtrResponsiblePersonName,
  CostCtrResponsibleUser,
  ValidityStartDate,
  ProfitCenter,
  CostCenterName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName
FROM C_CostCenterVH
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More