A_CnsldtnProfitCenterT

DDL: A_CNSLDTNPROFITCENTERT Type: view COMPOSITE
6 Fields 1 Data Sources 2 Associations

Combined Profit Center Text

A_CnsldtnProfitCenterT is a Composite CDS View that provides data about "Combined Profit Center Text" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnProfitCenterT) and exposes 6 fields with key fields Language, ProfitCenter, ControllingArea. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnProfitCenterT I_CnsldtnProfitCenterT from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_CnsldtnProfitCenter _CnsldtnProfitCenter $projection.ProfitCenter = _CnsldtnProfitCenter.ProfitCenter and $projection.ControllingArea = _CnsldtnProfitCenter.ControllingArea
[1..1] A_CnsldtnControllingArea _CnsldtnControllingArea $projection.ControllingArea = _CnsldtnControllingArea.ControllingArea

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ACSPROFITCENTERT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ProfitCenter view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Combined Profit Center Text view
OData.entitySet.name ProfitCenterText view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Language Language Report Text Language
KEY ProfitCenter ProfitCenter Profit Center
KEY ControllingArea ControllingArea Controlling Area
ProfitCenterText Short Description
_CnsldtnControllingArea _CnsldtnControllingArea
_CnsldtnProfitCenter _CnsldtnProfitCenter

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_CnsldtnProfitCenterT.
-- 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_CnsldtnProfitCenterT AS
SELECT
  Language,
  ProfitCenter,
  ControllingArea,
  cast(AdditionalMasterDataText as fincs_prctr_t preserving type) AS ProfitCenterText
FROM I_CnsldtnProfitCenterT
LEFT OUTER JOIN A_CnsldtnProfitCenter AS _CnsldtnProfitCenter ON ProfitCenter = _CnsldtnProfitCenter.ProfitCenter AND ControllingArea = _CnsldtnProfitCenter.ControllingArea  -- association [1..1]
LEFT OUTER JOIN A_CnsldtnControllingArea AS _CnsldtnControllingArea ON ControllingArea = _CnsldtnControllingArea.ControllingArea  -- association [1..1]
;

Learn More