C_DFS_PositionToJobTP

DDL: C_DFS_POSITIONTOJOBTP SQL: CDFSPOSTOJOBTP Type: view CONSUMPTION
26 Fields 1 Data Sources 5 Associations

C_DFS_PositionToJobTP is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_DFS_PositionToJobTP) and exposes 26 fields with key fields DfsPositionID, DfsPositionRelatedObjectID, DfsPositionPlngStatus, DfsPositionValdtyStartDate, DfsPositionValdtyEndDate. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DFS_PositionToJobTP PositionToJobTP from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_DFS_PositionHeaderTP _PositionHeaderTP $projection.DfsPositionID = _PositionHeaderTP.DfsPositionID
[1..1] C_DFS_PositionPlngStatusVH _PositionPlngStatusVH _PositionPlngStatusVH.DfsObjectPlngStatus = $projection.DfsPositionPlngStatus
[1..1] C_DFS_PositionJobVH _PositionJobVH _PositionJobVH.DfsJobID = $projection.DfsPositionRelatedObjectIDFoEd and _PositionJobVH.DfsJobType = $projection.DfsPositionRelatedObjectType and _PositionJobVH.LanguageCode = $session.system_language
[1..*] I_DFS_ObjectSubTypeText _ObjectSubTypeText $projection.DfsPositionSubType = _ObjectSubTypeText.DfsObjectSubType and $projection.DfsPositionInfoType = _ObjectSubTypeText.DfsObjectInfoType and _ObjectSubTypeText.LanguageCode = $session.system_language
[1..*] C_DFS_PosToJobRelationshipVH _PosToJobRelshpVH $projection.DfsPositionObjectType = _PosToJobRelshpVH.DfsPositionObjectType and $projection.DfsPositionRelatedObjectType = _PosToJobRelshpVH.DfsPositionRelatedObjectType

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CDFSPOSTOJOBTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
Metadata.allowExtensions true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY DfsPositionID I_DFS_PositionToJobTP DfsPositionID Object ID
KEY DfsPositionRelatedObjectID I_DFS_PositionToJobTP DfsPositionRelatedObjectID ID rel.object
KEY DfsPositionPlngStatus I_DFS_PositionToJobTP DfsPositionPlngStatus Planning status
KEY DfsPositionValdtyStartDate I_DFS_PositionToJobTP DfsPositionValdtyStartDate Start date
KEY DfsPositionValdtyEndDate I_DFS_PositionToJobTP DfsPositionValdtyEndDate End Date
KEY DfsPositionObjectType I_DFS_PositionToJobTP DfsPositionObjectType Object type
KEY DfsPositionPlanVersion I_DFS_PositionToJobTP DfsPositionPlanVersion Plan version
DfsPositionRelshpSpec I_DFS_PositionToJobTP DfsPositionRelshpSpec Relationship
DfsPositionRelshpBtwnObj I_DFS_PositionToJobTP DfsPositionRelshpBtwnObj Relnship
FrcElmntOrgPlngStsCritlty I_DFS_PositionToJobTP FrcElmntOrgPlngStsCritlty
DfsPositionInfoType I_DFS_PositionToJobTP DfsPositionInfoType Infotype
DfsPositionSubType I_DFS_PositionToJobTP DfsPositionSubType Subtype
DfsObjectSubTypeName _ObjectSubTypeText DfsObjectSubTypeName
DfsPositionRelatedObjectType I_DFS_PositionToJobTP DfsPositionRelatedObjectType Rel.obj.type
DfsPositionRelatedObjectIDFoEd I_DFS_PositionToJobTP DfsPositionRelatedObjectIDFoEd ID rel.object
DfsJobName _PositionJobVH DfsJobName
DfsPositionValdtyStartDateFoEd I_DFS_PositionToJobTP DfsPositionValdtyStartDateFoEd Start date
DfsPositionValdtyEndDateFoEd I_DFS_PositionToJobTP DfsPositionValdtyEndDateFoEd End Date
DfsObjectPlngStatusName _PositionPlngStatusVH DfsObjectPlngStatusName
FrcElmntOrgPlanDelimitDate FrcElmntOrgPlanDelimitDate Delimit date
FrcElmntOrgPlngStatusName FrcElmntOrgPlngStatusName Delimitation status
DfsAssgmtPlanOpStsCriticality DfsAssgmtPlanOpStsCriticality
_PositionHeaderTP _PositionHeaderTP
_PositionPlngStatusVH _PositionPlngStatusVH
_PositionJobVH _PositionJobVH
_PosToJobRelshpVH _PosToJobRelshpVH

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_PositionToJobTP.
-- 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: CDFSPOSTOJOBTP

CREATE VIEW C_DFS_PositionToJobTP AS
SELECT
  PositionToJobTP.DfsPositionID AS DfsPositionID,
  PositionToJobTP.DfsPositionRelatedObjectID AS DfsPositionRelatedObjectID,
  PositionToJobTP.DfsPositionPlngStatus AS DfsPositionPlngStatus,
  PositionToJobTP.DfsPositionValdtyStartDate AS DfsPositionValdtyStartDate,
  PositionToJobTP.DfsPositionValdtyEndDate AS DfsPositionValdtyEndDate,
  PositionToJobTP.DfsPositionObjectType AS DfsPositionObjectType,
  PositionToJobTP.DfsPositionPlanVersion AS DfsPositionPlanVersion,
  PositionToJobTP.DfsPositionRelshpSpec AS DfsPositionRelshpSpec,
  PositionToJobTP.DfsPositionRelshpBtwnObj AS DfsPositionRelshpBtwnObj,
  PositionToJobTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  PositionToJobTP.DfsPositionInfoType AS DfsPositionInfoType,
  PositionToJobTP.DfsPositionSubType AS DfsPositionSubType,
  _ObjectSubTypeText.DfsObjectSubTypeName AS DfsObjectSubTypeName,
  PositionToJobTP.DfsPositionRelatedObjectType AS DfsPositionRelatedObjectType,
  PositionToJobTP.DfsPositionRelatedObjectIDFoEd AS DfsPositionRelatedObjectIDFoEd,
  _PositionJobVH.DfsJobName AS DfsJobName,
  PositionToJobTP.DfsPositionValdtyStartDateFoEd AS DfsPositionValdtyStartDateFoEd,
  PositionToJobTP.DfsPositionValdtyEndDateFoEd AS DfsPositionValdtyEndDateFoEd,
  _PositionPlngStatusVH.DfsObjectPlngStatusName AS DfsObjectPlngStatusName,
  FrcElmntOrgPlanDelimitDate,
  FrcElmntOrgPlngStatusName,
  DfsAssgmtPlanOpStsCriticality
FROM I_DFS_PositionToJobTP AS PositionToJobTP
LEFT OUTER JOIN C_DFS_PositionHeaderTP AS _PositionHeaderTP ON DfsPositionID = _PositionHeaderTP.DfsPositionID  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionPlngStatusVH AS _PositionPlngStatusVH ON _PositionPlngStatusVH.DfsObjectPlngStatus = DfsPositionPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionJobVH AS _PositionJobVH ON _PositionJobVH.DfsJobID = DfsPositionRelatedObjectIDFoEd AND _PositionJobVH.DfsJobType = DfsPositionRelatedObjectType AND _PositionJobVH.LanguageCode = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_DFS_ObjectSubTypeText AS _ObjectSubTypeText ON DfsPositionSubType = _ObjectSubTypeText.DfsObjectSubType AND DfsPositionInfoType = _ObjectSubTypeText.DfsObjectInfoType AND _ObjectSubTypeText.LanguageCode = $session.system_language  -- association [1..*]
LEFT OUTER JOIN C_DFS_PosToJobRelationshipVH AS _PosToJobRelshpVH ON DfsPositionObjectType = _PosToJobRelshpVH.DfsPositionObjectType AND DfsPositionRelatedObjectType = _PosToJobRelshpVH.DfsPositionRelatedObjectType  -- association [1..*]
;

Learn More