C_FrcElmntOrgCostCenterGroupVH

DDL: C_FRCELMNTORGCOSTCENTERGROUPVH SQL: CCOSTCTRGRPVH Type: view CONSUMPTION
7 Fields 1 Associations

Value Help of FE CostCtrGrp

C_FrcElmntOrgCostCenterGroupVH is a Consumption CDS View that provides data about "Value Help of FE CostCtrGrp" 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 CCOSTCTRGRPVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Value Help of FE CostCtrGrp view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
Consumption.ranked true view
ObjectModel.representativeKey FrcElmntOrgGroupSetClassName view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.dataCategory #VALUE_HELP view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgGroupSetClass FrcElmntOrgCostCenterGroupVH SetClass Set Class
KEY FrcElmntOrgGroupSetSubClass FrcElmntOrgCostCenterGroupVH SetSubClass Controlling area
KEY FrcElmntOrgGroupSetClassName FrcElmntOrgCostCenterGroupVH SetID Cost Center Group Name
FrcElmntOrgGroupSetClassDesc Cost 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_FrcElmntOrgCostCenterGroupVH.
-- 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: CCOSTCTRGRPVH

CREATE VIEW C_FrcElmntOrgCostCenterGroupVH AS
SELECT
  FrcElmntOrgCostCenterGroupVH.SetClass AS FrcElmntOrgGroupSetClass,
  FrcElmntOrgCostCenterGroupVH.SetSubClass AS FrcElmntOrgGroupSetSubClass,
  FrcElmntOrgCostCenterGroupVH.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