P_DFS_PositionVacancy

DDL: P_DFS_POSITIONVACANCY SQL: PDFSPOSVACANCY Type: view BASIC
10 Fields 1 Data Sources 1 Associations

P_DFS_PositionVacancy is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (hrp1007) and exposes 10 fields with key fields DfsPositionPlanVersion, DfsPositionObjectType, DfsPositionID, DfsPositionSubType, DfsPositionPlngStatus. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
hrp1007 PositionVacancy from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_DFS_ActivePlanVersion _ActivePlanVersion $projection.DfsPositionPlanVersion = _ActivePlanVersion.DfsObjectPlanVersion

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PDFSPOSVACANCY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DfsPositionPlanVersion hrp1007 plvar Plan version
KEY DfsPositionObjectType hrp1007 otype Type of Val.
KEY DfsPositionID hrp1007 objid Work Center
KEY DfsPositionSubType hrp1007 subty Subtype
KEY DfsPositionPlngStatus hrp1007 istat System status
KEY DfsPositionValdtyStartDate hrp1007 begda Valid From
KEY DfsPositionValdtyEndDate hrp1007 endda Valid To
DfsPositionInfoType hrp1007 infty Infotype
DfsPositionIsVacant hrp1007 histo Historical rec.
DfsPositionVacancyStatus hrp1007 status Workflow Status

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 P_DFS_PositionVacancy.
-- 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: PDFSPOSVACANCY

CREATE VIEW P_DFS_PositionVacancy AS
SELECT
  PositionVacancy.plvar AS DfsPositionPlanVersion,
  PositionVacancy.otype AS DfsPositionObjectType,
  PositionVacancy.objid AS DfsPositionID,
  PositionVacancy.subty AS DfsPositionSubType,
  PositionVacancy.istat AS DfsPositionPlngStatus,
  PositionVacancy.begda AS DfsPositionValdtyStartDate,
  PositionVacancy.endda AS DfsPositionValdtyEndDate,
  PositionVacancy.infty AS DfsPositionInfoType,
  PositionVacancy.histo AS DfsPositionIsVacant,
  PositionVacancy.status AS DfsPositionVacancyStatus
FROM hrp1007 AS PositionVacancy
LEFT OUTER JOIN I_DFS_ActivePlanVersion AS _ActivePlanVersion ON DfsPositionPlanVersion = _ActivePlanVersion.DfsObjectPlanVersion  -- association [0..1]
;

Learn More