C_ReExAssignCostCenter

DDL: C_REEXASSIGNCOSTCENTER SQL: CREEXASSCOSTCNTR Type: view CONSUMPTION
19 Fields 1 Data Sources 1 Associations

Cost Center

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

Data Sources (1)

SourceAliasJoin Type
I_CostCenter CostCenter from

Parameters (1)

NameTypeDefault
P_Language sylangu

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 (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CREEXASSCOSTCNTR view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Cost Center view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea I_CostCenter ControllingArea Controlling Area
KEY CostCenter I_CostCenter CostCenter Cost Center
KEY ValidityEndDate I_CostCenter ValidityEndDate ValidTo
ValidityStartDate I_CostCenter ValidityStartDate Validity Start Date
CompanyCode I_CostCenter CompanyCode Receiver Company Code
BusinessArea I_CostCenter BusinessArea Business Area
CostCenterCategory I_CostCenter CostCenterCategory CCtr Category
CostCtrResponsiblePersonName I_CostCenter CostCtrResponsiblePersonName Person Resp.
CostCtrResponsibleUser I_CostCenter CostCtrResponsibleUser User Responsible
CostCenterCurrency I_CostCenter CostCenterCurrency Currency
ProfitCenter I_CostCenter ProfitCenter Profit Center
Department I_CostCenter Department Department
Country I_CostCenter Country Venue: Ctry/Reg
CityName I_CostCenter CityName Name
Region I_CostCenter Region Venue Region
Language I_CostCenter Language Report Text Language
FunctionalArea I_CostCenter FunctionalArea Sendr Fctl Area
CostCenterName
CostCenterDescription

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_ReExAssignCostCenter.
-- 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: CREEXASSCOSTCNTR
-- Parameters: P_Language : sylangu

CREATE VIEW C_ReExAssignCostCenter AS
SELECT
  CostCenter.ControllingArea AS ControllingArea,
  CostCenter.CostCenter AS CostCenter,
  CostCenter.ValidityEndDate AS ValidityEndDate,
  CostCenter.ValidityStartDate AS ValidityStartDate,
  CostCenter.CompanyCode AS CompanyCode,
  CostCenter.BusinessArea AS BusinessArea,
  CostCenter.CostCenterCategory AS CostCenterCategory,
  CostCenter.CostCtrResponsiblePersonName AS CostCtrResponsiblePersonName,
  CostCenter.CostCtrResponsibleUser AS CostCtrResponsibleUser,
  CostCenter.CostCenterCurrency AS CostCenterCurrency,
  CostCenter.ProfitCenter AS ProfitCenter,
  CostCenter.Department AS Department,
  CostCenter.Country AS Country,
  CostCenter.CityName AS CityName,
  CostCenter.Region AS Region,
  CostCenter.Language AS Language,
  CostCenter.FunctionalArea AS FunctionalArea,
  _Text[1: Language = $parameters.P_Language].CostCenterName AS CostCenterName,
  _Text[1: Language = $parameters.P_Language].CostCenterDescription AS CostCenterDescription
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