I_AuthzdActlPosPersStrucRelshp

DDL: I_AUTHZDACTLPOSPERSSTRUCRELSHP Type: view_entity COMPOSITE
17 Fields 1 Data Sources 1 Associations

Position to Person Relationship

I_AuthzdActlPosPersStrucRelshp is a Composite CDS View that provides data about "Position to Person Relationship" in SAP S/4HANA. It reads from 1 data source (I_DFS_ObjStructureRelationship) and exposes 17 fields with key fields DfsObjectID, DfsObjectType, DfsObjectPlanVersion, DfsObjectRelshpSpec, DfsObjectRelshpBtwnObj. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_DFS_ObjStructureRelationship PosToPersonStrucRelshp from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_DFS_MaintPersonResponsible _MaintPersonResponsibleVH _MaintPersonResponsibleVH.PersonnelNumber = $projection.DfsPositionRelatedObjectID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Position to Person Relationship view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY DfsObjectID I_DFS_ObjStructureRelationship DfsObjectID Object ID
KEY DfsObjectType I_DFS_ObjStructureRelationship DfsObjectType Object type
KEY DfsObjectPlanVersion I_DFS_ObjStructureRelationship DfsObjectPlanVersion Plan version
KEY DfsObjectRelshpSpec I_DFS_ObjStructureRelationship DfsObjectRelshpSpec Relationship
KEY DfsObjectRelshpBtwnObj I_DFS_ObjStructureRelationship DfsObjectRelshpBtwnObj Relnship
KEY DfsObjectPlngStatus I_DFS_ObjStructureRelationship DfsObjectPlngStatus Planning status
KEY DfsPositionValdtyStartDate I_DFS_ObjStructureRelationship DfsObjectValdtyStartDate Start date
KEY DfsPositionValdtyEndDate I_DFS_ObjStructureRelationship DfsObjectValdtyEndDate End Date
KEY FrcElmntOrgVariationID I_DFS_ObjStructureRelationship FrcElmntOrgVariationID Variation field
DfsObjectInfoType I_DFS_ObjStructureRelationship DfsObjectInfoType Infotype
DfsObjectSubType I_DFS_ObjStructureRelationship DfsObjectSubType Subtype
FrcElmntOrgPlngStsCritlty I_DFS_ObjStructureRelationship FrcElmntOrgPlngStsCritlty
DfsPositionRelatedObjectType I_DFS_ObjStructureRelationship DfsPositionRelatedObjectType Rel.obj.type
DfsPositionRelatedObjectID I_DFS_ObjStructureRelationship DfsPositionRelatedObjectID ID rel.object
DfsObjRelshpLastChgdByUser I_DFS_ObjStructureRelationship DfsObjRelshpLastChgdByUser User Name
DfsObjRelshpLastChgdDate I_DFS_ObjStructureRelationship DfsObjRelshpLastChgdDate Changed on
EmployeeName _MaintPersonResponsibleVH EmployeeName

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_AuthzdActlPosPersStrucRelshp.
-- 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.

CREATE VIEW I_AuthzdActlPosPersStrucRelshp AS
SELECT
  PosToPersonStrucRelshp.DfsObjectID AS DfsObjectID,
  PosToPersonStrucRelshp.DfsObjectType AS DfsObjectType,
  PosToPersonStrucRelshp.DfsObjectPlanVersion AS DfsObjectPlanVersion,
  PosToPersonStrucRelshp.DfsObjectRelshpSpec AS DfsObjectRelshpSpec,
  PosToPersonStrucRelshp.DfsObjectRelshpBtwnObj AS DfsObjectRelshpBtwnObj,
  PosToPersonStrucRelshp.DfsObjectPlngStatus AS DfsObjectPlngStatus,
  PosToPersonStrucRelshp.DfsObjectValdtyStartDate AS DfsPositionValdtyStartDate,
  PosToPersonStrucRelshp.DfsObjectValdtyEndDate AS DfsPositionValdtyEndDate,
  PosToPersonStrucRelshp.FrcElmntOrgVariationID AS FrcElmntOrgVariationID,
  PosToPersonStrucRelshp.DfsObjectInfoType AS DfsObjectInfoType,
  PosToPersonStrucRelshp.DfsObjectSubType AS DfsObjectSubType,
  PosToPersonStrucRelshp.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  PosToPersonStrucRelshp.DfsPositionRelatedObjectType AS DfsPositionRelatedObjectType,
  PosToPersonStrucRelshp.DfsPositionRelatedObjectID AS DfsPositionRelatedObjectID,
  PosToPersonStrucRelshp.DfsObjRelshpLastChgdByUser AS DfsObjRelshpLastChgdByUser,
  PosToPersonStrucRelshp.DfsObjRelshpLastChgdDate AS DfsObjRelshpLastChgdDate,
  _MaintPersonResponsibleVH.EmployeeName AS EmployeeName
FROM I_DFS_ObjStructureRelationship AS PosToPersonStrucRelshp
LEFT OUTER JOIN I_DFS_MaintPersonResponsible AS _MaintPersonResponsibleVH ON _MaintPersonResponsibleVH.PersonnelNumber = DfsPositionRelatedObjectID  -- association [1..1]
;

Learn More