C_FrcElmntOrgPrftCenterGroupVH

DDL: C_FRCELMNTORGPRFTCENTERGROUPVH SQL: CFEPRFTCTRGRPVH Type: view CONSUMPTION
7 Fields 1 Associations

Value Help Consumption view of Profit Center Group of FE Org

C_FrcElmntOrgPrftCenterGroupVH is a Consumption CDS View that provides data about "Value Help Consumption view of Profit Center Group of FE Org" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_SetHeaderText _SetHeaderText $projection.FrcElmntOrgGroupSetClass = _SetHeaderText.SetClass and $projection.FrcElmntOrgGroupSetSubClass = _SetHeaderText.SetSubClass and $projection.FrcElmntOrgGroupSetClassName = _SetHeaderText.SetID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CFEPRFTCTRGRPVH view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey FrcElmntOrgGroupSetClassName view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Consumption.ranked true view
ObjectModel.dataCategory #VALUE_HELP view
EndUserText.label Value Help Consumption view of Profit Center Group of FE Org view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgGroupSetClass FrcElmntOrgPrftCenterGroupVH SetClass Set Class
KEY FrcElmntOrgGroupSetSubClass FrcElmntOrgPrftCenterGroupVH SetSubClass Controlling area
KEY FrcElmntOrgGroupSetClassName FrcElmntOrgPrftCenterGroupVH SetID Profit Center Group Name
FrcElmntOrgGroupSetClassDesc Profit Center Group Description
_SetHeaderText _SetHeaderText
_SetClass _SetClass
_SetSubClass _SetSubClass

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 C_FrcElmntOrgPrftCenterGroupVH.
-- 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: CFEPRFTCTRGRPVH

CREATE VIEW C_FrcElmntOrgPrftCenterGroupVH AS
SELECT
  FrcElmntOrgPrftCenterGroupVH.SetClass AS FrcElmntOrgGroupSetClass,
  FrcElmntOrgPrftCenterGroupVH.SetSubClass AS FrcElmntOrgGroupSetSubClass,
  FrcElmntOrgPrftCenterGroupVH.SetID AS FrcElmntOrgGroupSetClassName,
  _SetHeaderText[1:Language = $session.system_language].SetDescription AS FrcElmntOrgGroupSetClassDesc
LEFT OUTER JOIN I_SetHeaderText AS _SetHeaderText ON FrcElmntOrgGroupSetClass = _SetHeaderText.SetClass AND FrcElmntOrgGroupSetSubClass = _SetHeaderText.SetSubClass AND FrcElmntOrgGroupSetClassName = _SetHeaderText.SetID  -- association [1..*]
;

Learn More