C_FrcElmntOrgStrucTypeVH

DDL: C_FRCELMNTORGSTRUCTYPEVH SQL: CFEORGSTRUTYPEVH Type: view CONSUMPTION
9 Fields

VH for Structure Type of FE Organization

C_FrcElmntOrgStrucTypeVH is a Consumption CDS View that provides data about "VH for Structure Type of FE Organization" in SAP S/4HANA.

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CFEORGSTRUTYPEVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
Search.searchable true view
Consumption.ranked true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey FrcElmntOrgStrucType view
EndUserText.label VH for Structure Type of FE Organization view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgCountry FRCELMNTORGSTRUCTYPE FrcElmntOrgCountry Country/Reg.
KEY FrcElmntOrgArea FRCELMNTORGSTRUCTYPE FrcElmntOrgArea Organizational Area
KEY FrcElmntOrgStrucType FRCELMNTORGSTRUCTYPE FrcElmntOrgStrucType Structure Type
KEY FrcElmntOrgStrucLevel FRCELMNTORGSTRUCTYPE FrcElmntOrgStrucLevel Strct. Level
FrcElmntOrgStrucLevelFoEd FRCELMNTORGSTRUCTYPE FrcElmntOrgStrucLevel Strct. Level
FrcElmntOrgAttributeIsHidden FRCELMNTORGSTRUCTYPE FrcElmntOrgAttributeIsHidden
FrcElmntOrgAreaType FRCELMNTORGSTRUCTYPE FrcElmntOrgAreaType Organizational Area Type
FrcElmntOrgStrucTypeDesc Structure Type Description
FrcElmntOrgStrucLevelDesc Structure Level Description

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_FrcElmntOrgStrucTypeVH.
-- 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: CFEORGSTRUTYPEVH

CREATE VIEW C_FrcElmntOrgStrucTypeVH AS
SELECT
  FRCELMNTORGSTRUCTYPE.FrcElmntOrgCountry AS FrcElmntOrgCountry,
  FRCELMNTORGSTRUCTYPE.FrcElmntOrgArea AS FrcElmntOrgArea,
  FRCELMNTORGSTRUCTYPE.FrcElmntOrgStrucType AS FrcElmntOrgStrucType,
  FRCELMNTORGSTRUCTYPE.FrcElmntOrgStrucLevel AS FrcElmntOrgStrucLevel,
  FRCELMNTORGSTRUCTYPE.FrcElmntOrgStrucLevel AS FrcElmntOrgStrucLevelFoEd,
  FRCELMNTORGSTRUCTYPE.FrcElmntOrgAttributeIsHidden AS FrcElmntOrgAttributeIsHidden,
  FRCELMNTORGSTRUCTYPE.FrcElmntOrgAreaType AS FrcElmntOrgAreaType,
  FRCELMNTORGSTRUCTYPE._FrcElmntOrgStrucTypeText[1:FrcElmntOrgLanguage=$session.system_language].FrcElmntOrgStrucTypeDesc AS FrcElmntOrgStrucTypeDesc,
  FRCELMNTORGSTRUCTYPE._FrcElmntOrgStrucLevelText[1:FrcElmntOrgLanguage=$session.system_language].FrcElmntOrgStrucLevelDesc AS FrcElmntOrgStrucLevelDesc
;

Learn More