I_ProfitCenterWhereUsed

DDL: I_PROFITCENTERWHEREUSED SQL: IFIPCTRWUOBJ Type: view BASIC
5 Fields 1 Data Sources

Where Used Object List for Profit Center

I_ProfitCenterWhereUsed is a Basic CDS View that provides data about "Where Used Object List for Profit Center" in SAP S/4HANA. It reads from 1 data source (cepc) and exposes 5 fields with key fields ControllingArea, ProfitCenter, ValidityEndDate, PrftCtrUsingObjectType.

Data Sources (1)

SourceAliasJoin Type
cepc cepc from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFIPCTRWUOBJ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Where Used Object List for Profit Center view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea kokrs Org. Value
KEY ProfitCenter prctr Profit Centers
KEY ValidityEndDate datbi Validity period
KEY PrftCtrUsingObjectType
PrftCtrUsingObjectTypeDesc

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_ProfitCenterWhereUsed.
-- 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: IFIPCTRWUOBJ

CREATE VIEW I_ProfitCenterWhereUsed AS
SELECT
  kokrs AS ControllingArea,
  prctr AS ProfitCenter,
  datbi AS ValidityEndDate,
  cast( '' as fac_wupc_type_name ) AS PrftCtrUsingObjectType,
  cast( '' as fac_wupc_type_description ) AS PrftCtrUsingObjectTypeDesc
FROM cepc
;

Learn More