I_PRACostCenterText

DDL: I_PRACOSTCENTERTEXT SQL: IPVCOSTCENTERT Type: view COMPOSITE Package: OIU_VDM_CDS
10 Fields 2 Data Sources 2 Associations

PRA Cost Center - Text

I_PRACostCenterText (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_PRACostCenterText is a Composite CDS View that provides data about "PRA Cost Center - Text" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, I_CostCenterText) and exposes 10 fields with key fields CompanyCode, CostCenter, ValidityEndDate, Language. It has 2 associations to related views. Part of development package OIU_VDM_CDS.

SAP API Hub

CategoryComposite
StateC1
Line of BusinessCross Applications
Application ComponentIS-OIL-PRA
CapabilitiesData Source for Data Extraction,Language-Dependent Text,Data Source for Defining CDS Entities,Data Source in SQL Select,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode inner
I_CostCenterText I_CostCenterText from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea

Annotations (13)

NameValueLevelField
EndUserText.label PRA Cost Center - Text view
ObjectModel.dataCategory #TEXT view
Analytics.dataExtraction.enabled true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IPVCOSTCENTERT view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey CostCenter view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode Receiver Company Code
KEY CostCenter CostCenter Cost Center
KEY ValidityEndDate ValidityEndDate Valid To Date
KEY Language I_CostCenterText Language Report Text Language
ControllingArea I_CostCenterText ControllingArea Controlling Area
CostCenterName CostCenterName Cost Center Name
CostCenterDescription CostCenterDescription Description of Cost Center
ValidityStartDate ValidityStartDate Validity Start Date
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea

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_PRACostCenterText.
-- 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: IPVCOSTCENTERT

CREATE VIEW I_PRACostCenterText AS
SELECT
  I_CompanyCode.CompanyCode AS CompanyCode,
  CostCenter,
  ValidityEndDate,
  I_CostCenterText.Language AS Language,
  I_CostCenterText.ControllingArea AS ControllingArea,
  CostCenterName,
  CostCenterDescription,
  ValidityStartDate
FROM I_CostCenterText
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
;

Learn More