C_FrcElmntOrgLogisticsLevelVH

DDL: C_FRCELMNTORGLOGISTICSLEVELVH SQL: CFEORGLOGLEVTXVH Type: view CONSUMPTION
3 Fields 1 Data Sources 1 Associations

Value Help View for FE Logistics Level

C_FrcElmntOrgLogisticsLevelVH is a Consumption CDS View that provides data about "Value Help View for FE Logistics Level" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntOrgLogisticsLevel) and exposes 3 fields with key fields FrcElmntOrgLogsLevel, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntOrgLogisticsLevel FrcElmntOrgLogisticsLevel from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_FrcElmntOrgLogisticsLvlText _FrcElmntOrgLogisticsLvlText FrcElmntOrgLogisticsLevel.FrcElmntOrgLogsLevel = _FrcElmntOrgLogisticsLvlText.FrcElmntOrgLogsLevel and _FrcElmntOrgLogisticsLvlText.Language = $session.system_language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CFEORGLOGLEVTXVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
EndUserText.label Value Help View for FE Logistics Level view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgLogsLevel I_FrcElmntOrgLogisticsLevel FrcElmntOrgLogsLevel Logistics Level
KEY Language _FrcElmntOrgLogisticsLvlText Language Report Text Language
FrcElmntOrgLogsLevelName _FrcElmntOrgLogisticsLvlText FrcElmntOrgLogsLevelName Logistics Level Name

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_FrcElmntOrgLogisticsLevelVH.
-- 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: CFEORGLOGLEVTXVH

CREATE VIEW C_FrcElmntOrgLogisticsLevelVH AS
SELECT
  FrcElmntOrgLogisticsLevel.FrcElmntOrgLogsLevel AS FrcElmntOrgLogsLevel,
  _FrcElmntOrgLogisticsLvlText.Language AS Language,
  _FrcElmntOrgLogisticsLvlText.FrcElmntOrgLogsLevelName AS FrcElmntOrgLogsLevelName
FROM I_FrcElmntOrgLogisticsLevel AS FrcElmntOrgLogisticsLevel
LEFT OUTER JOIN I_FrcElmntOrgLogisticsLvlText AS _FrcElmntOrgLogisticsLvlText ON FrcElmntOrgLogisticsLevel.FrcElmntOrgLogsLevel = _FrcElmntOrgLogisticsLvlText.FrcElmntOrgLogsLevel AND _FrcElmntOrgLogisticsLvlText.Language = $session.system_language  -- association [1..1]
;

Learn More