I_BR_ProfitCenterText_C

DDL: I_BR_PROFITCENTERTEXT_C SQL: IBRPROFCENTERTXC Type: view COMPOSITE Package: GLO_LOG_BR
7 Fields 1 Data Sources 1 Associations

Brazil Profit Center - Text

I_BR_ProfitCenterText_C is a Composite CDS View that provides data about "Brazil Profit Center - Text" in SAP S/4HANA. It reads from 1 data source (I_ProfitCenterText) and exposes 7 fields with key fields LanguageCode, CompanyCode, ControllingArea, ProfitCenter, ValidityEndDate. It has 1 association to related views. Part of development package GLO_LOG_BR.

Data Sources (1)

SourceAliasJoin Type
I_ProfitCenterText ProfitCenterText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BR_ControllingArea _ControllingArea _ControllingArea.ControllingArea = ProfitCenterText.ControllingArea

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBRPROFCENTERTXC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Brazil Profit Center - Text view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.preserveKey true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY LanguageCode I_ProfitCenterText Language Report Text Language
KEY CompanyCode _ControllingArea CompanyCode Receiver Company Code
KEY ControllingArea I_ProfitCenterText ControllingArea Controlling Area
KEY ProfitCenter I_ProfitCenterText ProfitCenter Profit Center
KEY ValidityEndDate I_ProfitCenterText ValidityEndDate ValidTo
ProfitCenterName
ProfitCenterLongName I_ProfitCenterText ProfitCenterLongName Profit Center Description

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 I_BR_ProfitCenterText_C.
-- 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: IBRPROFCENTERTXC

CREATE VIEW I_BR_ProfitCenterText_C AS
SELECT
  ProfitCenterText.Language AS LanguageCode,
  _ControllingArea.CompanyCode AS CompanyCode,
  ProfitCenterText.ControllingArea AS ControllingArea,
  ProfitCenterText.ProfitCenter AS ProfitCenter,
  ProfitCenterText.ValidityEndDate AS ValidityEndDate,
  cast(ProfitCenterText.ProfitCenterName as logbr_profitcenter) AS ProfitCenterName,
  ProfitCenterText.ProfitCenterLongName AS ProfitCenterLongName
FROM I_ProfitCenterText AS ProfitCenterText
LEFT OUTER JOIN I_BR_ControllingArea AS _ControllingArea ON _ControllingArea.ControllingArea = ProfitCenterText.ControllingArea  -- association [1..1]
;

Learn More