R_ProfitCenterTextTP

DDL: R_PROFITCENTERTEXTTP Type: view_entity TRANSACTIONAL Package: RAP_FIN_GL_PROFIT_CENTER
9 Fields 1 Data Sources 1 Associations

Profit Center - Text TP

R_ProfitCenterTextTP is a Transactional CDS View that provides data about "Profit Center - Text TP" in SAP S/4HANA. It reads from 1 data source (I_ProfitCenterText) and exposes 9 fields with key fields Language, ControllingArea, ProfitCenter, ValidityEndDate. It has 1 association to related views. Part of development package RAP_FIN_GL_PROFIT_CENTER.

Data Sources (1)

SourceAliasJoin Type
I_ProfitCenterText I_ProfitCenterText from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.LanguageForEdit = _Language.Language

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Profit Center - Text TP view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.sapObjectNodeType.name ProfitCenterText view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Language Language Report Text Language
KEY ControllingArea ControllingArea Controlling Area
KEY ProfitCenter ProfitCenter Profit Center
KEY ValidityEndDate ValidityEndDate ValidTo
LanguageForEdit Language Report Text Language
ProfitCenterName Profit Center Name
ProfitCenterLongName Profit Center Description
_Language _Language
_ProfitCenterTP _ProfitCenterTP

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 R_ProfitCenterTextTP.
-- 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 R_ProfitCenterTextTP AS
SELECT
  Language,
  ControllingArea,
  ProfitCenter,
  ValidityEndDate,
  Language AS LanguageForEdit,
  cast (ProfitCenterName as rap_fin_prft_ctr_name preserving type) AS ProfitCenterName,
  cast (ProfitCenterLongName as rap_fin_prft_ctr_long_name preserving type) AS ProfitCenterLongName
FROM I_ProfitCenterText
LEFT OUTER JOIN I_Language AS _Language ON LanguageForEdit = _Language.Language  -- association [0..1]
;

Learn More