What is C_DFS_PositionToExerciseVH in SAP S/4HANA?

C_DFS_PositionToExerciseVH is a consumption CDS view in SAP S/4HANA. Value help for Exercise to Position assignment It contains 11 fields.

What VDM layer is C_DFS_PositionToExerciseVH?

C_DFS_PositionToExerciseVH is classified as a Consumption view optimized for specific business scenarios and reporting.

C_DFS_PositionToExerciseVH

DDL: C_DFS_POSITIONTOEXERCISEVH SQL: CDFSPOSEXERVH Type: view CONSUMPTION

11 Fields 1 Associations

Value help for Exercise to Position assignment

C_DFS_PositionToExerciseVH is a Consumption CDS View that provides data about "Value help for Exercise to Position assignment" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_FrcElmntOrgSuplmntyVrtlElmnt	_FrcElmntOrgSuplmntyAttrib	`_FrcElmntOrgSuplmntyAttrib.ForceElementOrgID = $projection.ForceElementOrgID`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CDFSPOSEXERVH	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#CONSUMPTION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.dataCategory	#VALUE_HELP	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 Exercise to Position assignment	view

Fields (11)

Key	Field	Source Table	Source Field	Description
KEY	ForceElementOrgID		ForceElementOrgID	Target Force Element ID
	FrcElmntOrgName	_FrcElmntOrgSuplmntyAttrib	FrcElmntOrgName	Name
	FrcElmntOrgShortName	_FrcElmntOrgSuplmntyAttrib	FrcElmntOrgShortName	Object abbr.
	FrcElmntOrgLanguage	_FrcElmntOrgSuplmntyAttrib	FrcElmntOrgLanguage	Language
	FrcElmntOrgSubType			Sub Type
	FrcElmntOrgPlanVersion		FrcElmntOrgPlanVersion	Plan version
	FrcElmntOrgType		FrcElmntOrgType	Object type
	ClfnObjectID		ClfnObjectID
	_SenstvyClfn		_SenstvyClfn
	_FrcElmntOrgSuplmntyAttrib		_FrcElmntOrgSuplmntyAttrib
	_StrucAuth		_StrucAuth

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_DFS_PositionToExerciseVH.
-- 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: CDFSPOSEXERVH

CREATE VIEW C_DFS_PositionToExerciseVH AS
SELECT
  ForceElementOrgID,
  _FrcElmntOrgSuplmntyAttrib.FrcElmntOrgName AS FrcElmntOrgName,
  _FrcElmntOrgSuplmntyAttrib.FrcElmntOrgShortName AS FrcElmntOrgShortName,
  _FrcElmntOrgSuplmntyAttrib.FrcElmntOrgLanguage AS FrcElmntOrgLanguage,
  cast (' ' as subtyp) AS FrcElmntOrgSubType,
  FrcElmntOrgPlanVersion,
  FrcElmntOrgType,
  ClfnObjectID
LEFT OUTER JOIN I_FrcElmntOrgSuplmntyVrtlElmnt AS _FrcElmntOrgSuplmntyAttrib ON _FrcElmntOrgSuplmntyAttrib.ForceElementOrgID = ForceElementOrgID  -- association [1..1]
;

Depth:

C_DFS_PositionToExerciseVH view