I_DFS_PositionQualifnLevel

DDL: I_DFS_POSITIONQUALIFNLEVEL SQL: IDFSQUALNLVL Type: view BASIC
9 Fields 1 Data Sources 2 Associations

DFS Position Qualification Level

I_DFS_PositionQualifnLevel is a Basic CDS View that provides data about "DFS Position Qualification Level" in SAP S/4HANA. It reads from 1 data source (hrp1033) and exposes 9 fields with key fields DfsObjectType, DfsObjectID, DfsQualificationScale. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
hrp1033 PositionQualifnLevel from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_DFS_PositionQualifnLevelText _PositionQualifnLevelText $projection.DfsQualificationScale = _PositionQualifnLevelText.DfsQualificationScale
[1..*] I_DFS_ObjStructureRelationship _ObjStructureRelationship $projection.DfsObjectID = _ObjStructureRelationship.DfsPositionRelatedObjectID and _ObjStructureRelationship.DfsObjectValdtyStartDate <= $session.system_date and _ObjStructureRelationship.DfsObjectValdtyEndDate >= $session.system_date

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDFSQUALNLVL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label DFS Position Qualification Level view
VDM.viewType #BASIC view
ObjectModel.representativeKey DfsQualificationScale view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DfsObjectType hrp1033 otype Type of Val.
KEY DfsObjectID hrp1033 objid Work Center
KEY DfsQualificationScale hrp1033 scale Scale
DfsQualificationRating _PositionQualifnLevelText DfsQualificationRating
DfsQualificationLevelDesc _PositionQualifnLevelText DfsQualificationLevelDesc
DfsPositionRelatedObjectID _ObjStructureRelationship DfsPositionRelatedObjectID ID rel.object
DfsPositionRelatedObjectType _ObjStructureRelationship DfsPositionRelatedObjectType Rel.obj.type
DfsQualificationID _ObjStructureRelationship DfsObjectID Object ID
_ObjStructureRelationship _ObjStructureRelationship

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 I_DFS_PositionQualifnLevel.
-- 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: IDFSQUALNLVL

CREATE VIEW I_DFS_PositionQualifnLevel AS
SELECT
  PositionQualifnLevel.otype AS DfsObjectType,
  PositionQualifnLevel.objid AS DfsObjectID,
  PositionQualifnLevel.scale AS DfsQualificationScale,
  _PositionQualifnLevelText.DfsQualificationRating AS DfsQualificationRating,
  _PositionQualifnLevelText.DfsQualificationLevelDesc AS DfsQualificationLevelDesc,
  _ObjStructureRelationship.DfsPositionRelatedObjectID AS DfsPositionRelatedObjectID,
  _ObjStructureRelationship.DfsPositionRelatedObjectType AS DfsPositionRelatedObjectType,
  _ObjStructureRelationship.DfsObjectID AS DfsQualificationID
FROM hrp1033 AS PositionQualifnLevel
LEFT OUTER JOIN I_DFS_PositionQualifnLevelText AS _PositionQualifnLevelText ON DfsQualificationScale = _PositionQualifnLevelText.DfsQualificationScale  -- association [1..*]
LEFT OUTER JOIN I_DFS_ObjStructureRelationship AS _ObjStructureRelationship ON DfsObjectID = _ObjStructureRelationship.DfsPositionRelatedObjectID AND _ObjStructureRelationship.DfsObjectValdtyStartDate <= $session.system_date AND _ObjStructureRelationship.DfsObjectValdtyEndDate >= $session.system_date  -- association [1..*]
;

Learn More