I_RecrrgSuplrInvcPrftCtrVH

DDL: I_RECRRGSUPLRINVCPRFTCTRVH SQL: IRSIPRFTCTRVH Type: view COMPOSITE Package: ODATA_RECUR_SUPPLIER_INVOICES
5 Fields 1 Data Sources 1 Associations

Profit Center

I_RecrrgSuplrInvcPrftCtrVH is a Composite CDS View that provides data about "Profit Center" in SAP S/4HANA. It reads from 1 data source (I_PrftCtrCompanyCodeAssignment) and exposes 5 fields with key fields ControllingArea, ProfitCenter, CompanyCode. It has 1 association to related views. Part of development package ODATA_RECUR_SUPPLIER_INVOICES.

Data Sources (1)

SourceAliasJoin Type
I_PrftCtrCompanyCodeAssignment _Assignment from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProfitCenterText _Text _Assignment.ControllingArea = _Text.ControllingArea and _Assignment.ProfitCenter = _Text.ProfitCenter and _Text.Language = $session.system_language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IRSIPRFTCTRVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
Consumption.ranked true view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
ObjectModel.representativeKey ProfitCenter view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea Controlling Area
KEY ProfitCenter ProfitCenter Profit Center
KEY CompanyCode CompanyCode Receiver Company Code
ValidityEndDate
ProfitCenterName _Text ProfitCenterName Profit Center Name

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_RecrrgSuplrInvcPrftCtrVH.
-- 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: IRSIPRFTCTRVH

CREATE VIEW I_RecrrgSuplrInvcPrftCtrVH AS
SELECT
  ControllingArea,
  ProfitCenter,
  CompanyCode,
  _Text .ValidityEndDate AS ValidityEndDate,
  _Text.ProfitCenterName AS ProfitCenterName
FROM I_PrftCtrCompanyCodeAssignment AS _Assignment
LEFT OUTER JOIN I_ProfitCenterText AS _Text ON _Assignment.ControllingArea = _Text.ControllingArea AND _Assignment.ProfitCenter = _Text.ProfitCenter AND _Text.Language = $session.system_language  -- association [0..*]
;

Learn More