I_DFS_QualifnMgmt

DDL: I_DFS_QUALIFNMGMT SQL: IDFSQUALIFNMGMT Type: view BASIC
16 Fields 1 Data Sources

Details for qualification management

I_DFS_QualifnMgmt is a Basic CDS View that provides data about "Details for qualification management" in SAP S/4HANA. It reads from 1 data source (P_DFS_QualifnMgmt) and exposes 16 fields with key fields DfsObjectPlanVersion, DfsObjectType, DfsObjectID, DfsObjectPlngStatus, DfsObjectValdtyStartDate.

Data Sources (1)

SourceAliasJoin Type
P_DFS_QualifnMgmt _QualifnMgmt from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDFSQUALIFNMGMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Details for qualification management view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY DfsObjectPlanVersion DfsObjectPlanVersion Plan version
KEY DfsObjectType DfsObjectType Object type
KEY DfsObjectID DfsObjectID Object ID
KEY DfsObjectPlngStatus DfsObjectPlngStatus Planning status
KEY DfsObjectValdtyStartDate DfsObjectValdtyStartDate Start date
KEY DfsObjectValdtyEndDate DfsObjectValdtyEndDate End Date
KEY DfsObjectSubType DfsObjectSubType Subtype
KEY FrcElmntOrgVariationID FrcElmntOrgVariationID Variation field
KEY DfsPositionDescRefSqncNmbr DfsPositionDescRefSqncNmbr IT record no.
DfsObjectInfoType DfsObjectInfoType Infotype
DfsObjectRelatedObjectType DfsObjectRelatedObjectType Rel.obj.type
DfsObjectRelatedObjectID DfsObjectRelatedObjectID ID rel.object
DfsObjRelshpLastChgdByUser DfsObjRelshpLastChgdByUser User Name
DfsObjRelshpLastChgdDate DfsObjRelshpLastChgdDate Changed on
DfsQualificationLevel DfsQualificationLevel Proficiency Q/R
DfsObjectRelshpPriority DfsObjectRelshpPriority Priority

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_QualifnMgmt.
-- 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: IDFSQUALIFNMGMT

CREATE VIEW I_DFS_QualifnMgmt AS
SELECT
  DfsObjectPlanVersion,
  DfsObjectType,
  DfsObjectID,
  DfsObjectPlngStatus,
  DfsObjectValdtyStartDate,
  DfsObjectValdtyEndDate,
  DfsObjectSubType,
  FrcElmntOrgVariationID,
  DfsPositionDescRefSqncNmbr,
  DfsObjectInfoType,
  DfsObjectRelatedObjectType,
  DfsObjectRelatedObjectID,
  DfsObjRelshpLastChgdByUser,
  DfsObjRelshpLastChgdDate,
  DfsQualificationLevel,
  DfsObjectRelshpPriority
FROM P_DFS_QualifnMgmt AS _QualifnMgmt
;

Learn More