P_DFS_ObjStructureRelationship

DDL: P_DFS_OBJSTRUCTURERELATIONSHIP SQL: PDFSSTRUCRESHP Type: view BASIC
18 Fields 1 Data Sources 1 Associations

P_DFS_ObjStructureRelationship is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (hrp1001) and exposes 18 fields with key fields DfsObjectType, DfsObjectID, DfsObjectPlanVersion, DfsObjectRelshpSpec, DfsObjectRelshpBtwnObj. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
hrp1001 ObjStructureRelationship from

Associations (1)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PDFSSTRUCRESHP view
AbapCatalog.compiler.compareFilter true 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
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY DfsObjectType hrp1001 otype Type of Val.
KEY DfsObjectID hrp1001 objid Work Center
KEY DfsObjectPlanVersion hrp1001 plvar Plan version
KEY DfsObjectRelshpSpec hrp1001 rsign Relationship
KEY DfsObjectRelshpBtwnObj hrp1001 relat Relnship
KEY DfsObjectPlngStatus hrp1001 istat System status
KEY DfsObjectRelshpPriority hrp1001 priox Priority
KEY DfsObjectValdtyStartDate hrp1001 begda Valid From
KEY DfsObjectValdtyEndDate hrp1001 endda Valid To
KEY FrcElmntOrgVariationID hrp1001 varyf Variation field
KEY DfsPositionDescRefSqncNmbr hrp1001 seqnr Tank ID
DfsObjectInfoType hrp1001 infty Infotype
DfsObjectSubType hrp1001 subty Subtype
DfsPositionRelatedObjectType hrp1001 sclas Rel.obj.type
DfsPositionRelatedObjectID hrp1001 sobid ID rel.object
DfsObjRelshpLastChgdByUserName hrp1001 prozt Share
DfsObjRelshpLastChgdByUser hrp1001 uname User Name
DfsObjRelshpLastChgdDate hrp1001 aedtm Changed On

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_ObjStructureRelationship.
-- 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: PDFSSTRUCRESHP

CREATE VIEW P_DFS_ObjStructureRelationship AS
SELECT
  ObjStructureRelationship.otype AS DfsObjectType,
  ObjStructureRelationship.objid AS DfsObjectID,
  ObjStructureRelationship.plvar AS DfsObjectPlanVersion,
  ObjStructureRelationship.rsign AS DfsObjectRelshpSpec,
  ObjStructureRelationship.relat AS DfsObjectRelshpBtwnObj,
  ObjStructureRelationship.istat AS DfsObjectPlngStatus,
  ObjStructureRelationship.priox AS DfsObjectRelshpPriority,
  ObjStructureRelationship.begda AS DfsObjectValdtyStartDate,
  ObjStructureRelationship.endda AS DfsObjectValdtyEndDate,
  ObjStructureRelationship.varyf AS FrcElmntOrgVariationID,
  ObjStructureRelationship.seqnr AS DfsPositionDescRefSqncNmbr,
  ObjStructureRelationship.infty AS DfsObjectInfoType,
  ObjStructureRelationship.subty AS DfsObjectSubType,
  ObjStructureRelationship.sclas AS DfsPositionRelatedObjectType,
  ObjStructureRelationship.sobid AS DfsPositionRelatedObjectID,
  ObjStructureRelationship.prozt AS DfsObjRelshpLastChgdByUserName,
  ObjStructureRelationship.uname AS DfsObjRelshpLastChgdByUser,
  ObjStructureRelationship.aedtm AS DfsObjRelshpLastChgdDate
FROM hrp1001 AS ObjStructureRelationship
LEFT OUTER JOIN I_DFS_ActivePlanVersion AS _ActivePlanVersion ON DfsObjectPlanVersion = _ActivePlanVersion.DfsObjectPlanVersion  -- association [0..1]
;

Learn More