I_DFS_PositionVacancy

DDL: I_DFS_POSITIONVACANCY SQL: IDFSPOSVACANCY Type: view BASIC
10 Fields 1 Data Sources

Interface view for position vacancy

I_DFS_PositionVacancy is a Basic CDS View that provides data about "Interface view for position vacancy" in SAP S/4HANA. It reads from 1 data source (P_DFS_PositionVacancy) and exposes 10 fields with key fields DfsPositionPlanVersion, DfsPositionObjectType, DfsPositionID, DfsPositionSubType, DfsPositionPlngStatus.

Data Sources (1)

SourceAliasJoin Type
P_DFS_PositionVacancy PositionVacancy from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDFSPOSVACANCY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Interface view for position vacancy 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 (10)

KeyFieldSource TableSource FieldDescription
KEY DfsPositionPlanVersion P_DFS_PositionVacancy DfsPositionPlanVersion Plan version
KEY DfsPositionObjectType P_DFS_PositionVacancy DfsPositionObjectType Type of Val.
KEY DfsPositionID P_DFS_PositionVacancy DfsPositionID Work Center
KEY DfsPositionSubType P_DFS_PositionVacancy DfsPositionSubType Subtype
KEY DfsPositionPlngStatus P_DFS_PositionVacancy DfsPositionPlngStatus System status
KEY DfsPositionValdtyStartDate P_DFS_PositionVacancy DfsPositionValdtyStartDate Start date
KEY DfsPositionValdtyEndDate P_DFS_PositionVacancy DfsPositionValdtyEndDate End Date
DfsPositionInfoType P_DFS_PositionVacancy DfsPositionInfoType Infotype
DfsPositionIsVacant P_DFS_PositionVacancy DfsPositionIsVacant Historical rec.
DfsPositionVacancyStatus P_DFS_PositionVacancy DfsPositionVacancyStatus 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 I_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: IDFSPOSVACANCY

CREATE VIEW I_DFS_PositionVacancy AS
SELECT
  PositionVacancy.DfsPositionPlanVersion AS DfsPositionPlanVersion,
  PositionVacancy.DfsPositionObjectType AS DfsPositionObjectType,
  PositionVacancy.DfsPositionID AS DfsPositionID,
  PositionVacancy.DfsPositionSubType AS DfsPositionSubType,
  PositionVacancy.DfsPositionPlngStatus AS DfsPositionPlngStatus,
  PositionVacancy.DfsPositionValdtyStartDate AS DfsPositionValdtyStartDate,
  PositionVacancy.DfsPositionValdtyEndDate AS DfsPositionValdtyEndDate,
  PositionVacancy.DfsPositionInfoType AS DfsPositionInfoType,
  PositionVacancy.DfsPositionIsVacant AS DfsPositionIsVacant,
  PositionVacancy.DfsPositionVacancyStatus AS DfsPositionVacancyStatus
FROM P_DFS_PositionVacancy AS PositionVacancy
;

Learn More