I_BR_CostCenterText

DDL: I_BR_COSTCENTERTEXT SQL: IBRCOSTCENTERTXT Type: view BASIC Package: GLO_LOG_BR
6 Fields 1 Data Sources 1 Associations

Brazil Cost Center - Text

I_BR_CostCenterText is a Basic CDS View that provides data about "Brazil Cost Center - Text" in SAP S/4HANA. It reads from 1 data source (cskt) and exposes 6 fields with key fields LanguageCode, CompanyCode, CostCenter, ValidityEndDate. It has 1 association to related views. Part of development package GLO_LOG_BR.

Data Sources (1)

SourceAliasJoin Type
cskt cskt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BR_ControllingArea _ControllingArea _ControllingArea.ControllingArea = cskt.kokrs

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBRCOSTCENTERTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Brazil Cost Center - Text view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY LanguageCode cskt spras Off. Language
KEY CompanyCode _ControllingArea CompanyCode Receiver Company Code
KEY CostCenter cskt kostl Substitute CC
KEY ValidityEndDate cskt datbi Validity period
CostCenterName
CostCenterDescription cskt ltext Text exists

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_CostCenterText.
-- 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: IBRCOSTCENTERTXT

CREATE VIEW I_BR_CostCenterText AS
SELECT
  cskt.spras AS LanguageCode,
  _ControllingArea.CompanyCode AS CompanyCode,
  cskt.kostl AS CostCenter,
  cskt.datbi AS ValidityEndDate,
  cast(cskt.ktext as eams_costcenter_desc preserving type) AS CostCenterName,
  cskt.ltext AS CostCenterDescription
FROM cskt
LEFT OUTER JOIN I_BR_ControllingArea AS _ControllingArea ON _ControllingArea.ControllingArea = cskt.kokrs  -- association [1..1]
;

Learn More