C_DFS_PositionHeaderTP

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_PositionHeaderTP.
-- 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: CDFSPOSHEADERTP

CREATE VIEW C_DFS_PositionHeaderTP AS
SELECT
  PositionHeaderTP.DfsPositionID AS DfsPositionID,
  PositionHeaderTP.DfsPositionID AS DfsPositionIDForEdit,
  PositionHeaderTP.DfsPositionUUID AS DfsPositionUUID,
  PositionHeaderTP.DfsObjectSequenceNumber AS DfsObjectSequenceNumber,
  PositionHeaderTP.DfsPositionPlanVersion AS DfsPositionPlanVersion,
  PositionHeaderTP.DfsPositionObjectType AS DfsPositionObjectType,
  PositionHeaderTP.DfsPositionLastChgdDteTme AS DfsPositionLastChgdDteTme,
  PositionHeaderTP.DfsPositionCreationDate AS DfsPositionCreationDate,
  PositionHeaderTP.DfsPositionCreatedByUser AS DfsPositionCreatedByUser,
  PositionHeaderTP.DfsPositionLastChgdDate AS DfsPositionLastChgdDate,
  PositionHeaderTP.DfsPositionLastChgdByUser AS DfsPositionLastChgdByUser,
  PositionHeaderTP.DfsPositionLogicalSystem AS DfsPositionLogicalSystem,
  _PositionSuplmntyAttrib.DfsPositionPlngStsCritlty AS DfsPositionPlngStsCritlty,
  _FrcElmntOrgAreaVH.FrcElmntOrgAreaDesc AS FrcElmntOrgAreaDesc,
  _PositionCountryVH.CountryName AS CountryName,
  PositionHeaderTP.DfsPositionBlockedReason AS DfsPositionBlockedReason,
  PositionHeaderTP.DfsPositionType AS DfsPositionType,
  _PositionTypeVH.DfsPositionTypeDesc AS DfsPositionTypeDesc,
  _PositionSuplmntyAttrib.DfsPositionValdtyStartDate AS DfsPositionValdtyStartDate,
  _PositionSuplmntyAttrib.DfsPositionValdtyEndDate AS DfsPositionValdtyEndDate,
  _PositionSuplmntyAttrib.DfsPositionIsChiefPositionFoEd AS DfsPositionIsChiefPositionFoEd,
  _PositionSuplmntyAttrib.DfsPositionPlngStatus AS DfsPositionPlngStatus,
  _PositionSuplmntyAttrib._PositionPlngStatusVH.DfsObjectPlngStatusName AS DfsObjectPlngStatusName,
  _PositionSuplmntyAttrib.DfsPositionName AS DfsPositionName,
  _PositionSuplmntyAttrib.DfsPositionShortName AS DfsPositionShortName,
  PositionHeaderTP.DfsJobIDForEdit AS DfsJobIDForEdit,
  DfsPositionNameForEdit,
  DfsPositionShortNameForEdit,
  DfsPositionValdtyStartDateFoEd,
  DfsPositionValdtyEndDateFoEd,
  DfsPositionPlngStatusForEdit,
  CountryCodeForEdit,
  DfsPositionOrgAreaForEdit,
  DfsPositionIsChiefPosition,
  DfsPositionIsDeputyPos,
  DfsPositionStrucFrcElmntOrgID,
  DfsPosWarTmeFrcElmntOrgID,
  DfsPosPeaceTmeFrcElmntOrgID,
  DfsPositionStrucValdtyStrtDte,
  DfsPosPeaceTmeValdtyStrtDte,
  DfsPosWarTmeValdtyStrtDte,
  DfsPositionStrucValdtyEndDte,
  DfsPosPeaceTmeValdtyEndDte,
  DfsPosWarTmeValdtyEndDte,
  DfsPositionStrucFrcElmntOrgID AS ForceElementOrgID,
  DfsPosEmployeeTypeForEdit,
  _PositionEmployeeTypeVH.DfsPositionEmployeeGroupDesc AS DfsPositionEmployeeGroupDesc,
  DfsPosHiringPriorityForEdit,
  DfsPositionSubTypeForEdit,
  ForceElementOrgIDForEdit,
  FrcElmntOrgMeasureUUID,
  FrcElmntOrgMeasureType,
  FrcElmntOrgMeasureDesc,
  _FrcElmntOrgMeasuresettings.DfsOrglMeasureDescription AS DfsOrglMeasureDescription,
  _PositionHiringPriorityVH.DfsPositionHiringPriorityText AS DfsPositionHiringPriorityText,
  _FrcElmntOrgVH.FrcElmntOrgName AS FrcElmntOrgName,
  PositionHeaderTP._PositionSenstvyClfn AS _PositionSenstvyClfn
FROM I_DFS_PositionHeaderTP AS PositionHeaderTP
LEFT OUTER JOIN C_DFS_PositionNameTP AS _PositionNameTP ON DfsPositionID = _PositionNameTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionDescriptionTP AS _PositionDescriptionTP ON DfsPositionID = _PositionDescriptionTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionEmployeeGroupTP AS _PositionEmployeeGroupTP ON DfsPositionID = _PositionEmployeeGroupTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionNATOTP AS _PositionNATOTP ON DfsPositionID = _PositionNATOTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionRankTP AS _PositionRankTP ON DfsPositionID = _PositionRankTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionSpcfcCharcsTP AS _PositionSpcfcCharcsTP ON DfsPositionID = _PositionSpcfcCharcsTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionVacancyTP AS _PositionVacancyTP ON DfsPositionID = _PositionVacancyTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionToQualifnTP AS _PositionToQualifnTP ON DfsPositionID = _PositionToQualifnTP.DfsObjectID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionToQualifnBlockTP AS _PositionToQualifnBlockTP ON DfsPositionID = _PositionToQualifnBlockTP.DfsObjectID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionToJobTP AS _PositionToJobTP ON DfsPositionID = _PositionToJobTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionToTaskTP AS _PositionToTaskTP ON DfsPositionID = _PositionToTaskTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionToStdWrkflwTskTP AS _PositionToStdWrkflwTskTP ON DfsPositionID = _PositionToStdWrkflwTskTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionConventionTP AS _PositionConventionTP ON DfsPositionID = _PositionConventionTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PosToFrcElmntStrucTP AS _PosToFrcElmntStrucTP ON DfsPositionID = _PosToFrcElmntStrucTP.DfsObjectID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PosToFrcElmntWartimeTP AS _PosToFrcElmntWartimeTP ON DfsPositionID = _PosToFrcElmntWartimeTP.DfsObjectID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PosToPersonStrucRelshp AS _PosToPersonStrucRelshp ON DfsPositionID = _PosToPersonStrucRelshp.DfsObjectID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PosToPersExtRelshp AS _PosToPersExtRelshp ON DfsPositionID = _PosToPersExtRelshp.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionSuplmntyAttrib AS _PositionSuplmntyAttrib ON DfsPositionID = _PositionSuplmntyAttrib.DfsPositionID AND _PositionSuplmntyAttrib.LanguageCode = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionBlockedPosTP AS _PositionBlockedPosTP ON DfsPositionID = _PositionBlockedPosTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PosAssgmtAccogPartHier AS _PosAssgmtAccogPartHier ON DfsPositionID = _PosAssgmtAccogPartHier.DfsPositionSourceID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtPosOpRotationList AS _AssgmtPosOpRotationList ON DfsPositionID = _AssgmtPosOpRotationList.DfsPositionSourceID  -- association [1..*]
LEFT OUTER JOIN C_DFS_AssgmtPosExerRotList AS _AssgmtPosExerRotList ON DfsPositionID = _AssgmtPosExerRotList.DfsPositionSourceID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionTypeVH AS _PositionTypeVH ON _PositionTypeVH.DfsPositionObjectType = DfsPositionObjectType AND _PositionTypeVH.DfsPositionType = DfsPositionType  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionEmployeeTypeVH AS _PositionEmployeeTypeVH ON _PositionEmployeeTypeVH.DfsPositionEmployeeGroup = DfsPosEmployeeTypeForEdit  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionHiringPriorityVH AS _PositionHiringPriorityVH ON _PositionHiringPriorityVH.DfsPositionHiringPriority = DfsPosHiringPriorityForEdit  -- association [1..1]
LEFT OUTER JOIN C_DFS_PosToJobRelationshipVH AS _PosToJobRelshpVH ON _PosToJobRelshpVH.DfsPositionSubType = DfsPositionSubTypeForEdit  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgAreaVH AS _FrcElmntOrgAreaVH ON _FrcElmntOrgAreaVH.FrcElmntOrgCountry = CountryCodeForEdit AND _FrcElmntOrgAreaVH.FrcElmntOrgAreaForEdit = DfsPositionOrgAreaForEdit  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionCountryVH AS _PositionCountryVH ON _PositionCountryVH.CountryCode = CountryCodeForEdit  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgVH ON _FrcElmntOrgVH.ForceElementOrgIDForEdit = DfsPositionStrucFrcElmntOrgID  -- association [0..*]
LEFT OUTER JOIN C_DFS_PositionToJobVH AS _PositionToJobVH ON _PositionToJobVH.DfsJobID = DfsJobIDForEdit AND _PositionToJobVH.DfsJobType = 'C' AND _PositionToJobVH.LanguageCode = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionBlockedReasonVH AS _BlockedReasonVH ON _BlockedReasonVH.DfsPositionBlockedReason = DfsPositionBlockedReason  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionFrcElmntOrgVH AS _PositionFrcElmntOrgVH ON _PositionFrcElmntOrgVH.DfsPositionID = DfsPositionStrucFrcElmntOrgID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionToOperationTP AS _PositionToOperationTP ON DfsPositionID = _PositionToOperationTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionToExerciseTP AS _PositionToExerciseTP ON DfsPositionID = _PositionToExerciseTP.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PosToPersonExerRelshp AS _PosToPersonExerRelshp ON DfsPositionID = _PosToPersonExerRelshp.DfsPositionRelatedObjectID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PosToPersonOpRelshp AS _PosToPersonOpRelshp ON DfsPositionID = _PosToPersonOpRelshp.DfsPositionRelatedObjectID  -- association [1..*]
LEFT OUTER JOIN I_DFS_OrglMeasureUserSettings AS _FrcElmntOrgMeasuresettings ON _FrcElmntOrgMeasuresettings.ForceElementOrgID = DfsPositionID AND _FrcElmntOrgMeasuresettings.UserID = $session.user AND _FrcElmntOrgMeasuresettings.DfsIsOrglMeasureSelected = 'X'  -- association [1..*]
LEFT OUTER JOIN C_DFS_PosStaffPrpslOpRelshp AS _PosStaffPrpslOpRelshp ON DfsPositionID = _PosStaffPrpslOpRelshp.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PosStaffPrpslExerRelshp AS _PosStaffPrpslExerRelshp ON DfsPositionID = _PosStaffPrpslExerRelshp.DfsPositionID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionJobToQualifn AS _JobQualRelshp ON DfsPositionID = _JobQualRelshp.DfsPositionID  -- association [1..*]
;