C_FrcElmntOrgVH

DDL: C_FRCELMNTORGVH SQL: CFEORGVH Type: view CONSUMPTION
11 Fields 2 Associations 1 OData Services

Value Help for Force Element Organization Names

C_FrcElmntOrgVH is a Consumption CDS View that provides data about "Value Help for Force Element Organization Names" in SAP S/4HANA. It has 2 associations to related views. It is exposed through 1 OData service (UI_C_FRCELMNTOPEXERPOSROTATION).

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FrcElmntOrgSuplmntyNoSrch _FrcElmntOrgName _FrcElmntOrgName.ForceElementOrgID = $projection.ForceElementOrgID and _FrcElmntOrgName.FrcElmntOrgLanguage = $session.system_language
[0..*] I_DFS_ObjectName _ObjectName _ObjectName.DfsObjectID = $projection.ForceElementOrgID and _ObjectName.DfsObjectType = 'O' and _ObjectName.LanguageCode = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CFEORGVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
AbapCatalog.preserveKey true view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Value Help for Force Element Organization Names view

OData Services (1)

ServiceBindingVersionContractRelease
UI_C_FRCELMNTOPEXERPOSROTATION UI_C_FRCELMNTOPEXERPOSROT V2 C1 NOT_RELEASED

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ForceElementOrgID ForceElementOrgID Object ID Processor
KEY FrcElmntOrgWarTimeParentID ForceElementOrgID Object ID Processor
KEY FrcElmntOrgPeaceTimeParentID ForceElementOrgID Object ID Processor
KEY FrcElmntOrgStrucParentID ForceElementOrgID Object ID Processor
ForceElementOrgIDForEdit ForceElementOrgID Object ID Processor
FrcElmntOrgShortName _FrcElmntOrgName FrcElmntOrgShortName Object abbr.
_ObjectName _ObjectName
FrcElmntOrgName _FrcElmntOrgName FrcElmntOrgName Name
FrcElmntOrgPlanVersion FrcElmntOrgPlanVersion Plan version
FrcElmntOrgType FrcElmntOrgType Object type
_SenstvyClfn _SenstvyClfn

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_FrcElmntOrgVH.
-- 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: CFEORGVH

CREATE VIEW C_FrcElmntOrgVH AS
SELECT
  ForceElementOrgID,
  ForceElementOrgID AS FrcElmntOrgWarTimeParentID,
  ForceElementOrgID AS FrcElmntOrgPeaceTimeParentID,
  ForceElementOrgID AS FrcElmntOrgStrucParentID,
  ForceElementOrgID AS ForceElementOrgIDForEdit,
  _FrcElmntOrgName.FrcElmntOrgShortName AS FrcElmntOrgShortName,
  _FrcElmntOrgName.FrcElmntOrgName AS FrcElmntOrgName,
  FrcElmntOrgPlanVersion,
  FrcElmntOrgType
LEFT OUTER JOIN I_FrcElmntOrgSuplmntyNoSrch AS _FrcElmntOrgName ON _FrcElmntOrgName.ForceElementOrgID = ForceElementOrgID AND _FrcElmntOrgName.FrcElmntOrgLanguage = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_DFS_ObjectName AS _ObjectName ON _ObjectName.DfsObjectID = ForceElementOrgID AND _ObjectName.DfsObjectType = 'O' AND _ObjectName.LanguageCode = $session.system_language  -- association [0..*]
;

Learn More