I_FrcElmntToWBSElmnt

DDL: I_FRCELMNTTOWBSELMNT SQL: IFETOWBSELMNT Type: view BASIC
26 Fields 1 Data Sources

Interface View of FE to additional WBS Element

I_FrcElmntToWBSElmnt is a Basic CDS View that provides data about "Interface View of FE to additional WBS Element" in SAP S/4HANA. It reads from 1 data source (I_DFS_ObjStructureRelationship) and exposes 26 fields with key fields ForceElementOrgID, FrcElmntOrgRelatedOrgID, FrcElmntOrgPlngStatus, FrcElmntOrgValdtyStartDate, FrcElmntOrgValdtyEndDate.

Data Sources (1)

SourceAliasJoin Type
I_DFS_ObjStructureRelationship ObjStructureRelationship from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFETOWBSELMNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Interface View of FE to additional WBS Element view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ForceElementOrgID I_DFS_ObjStructureRelationship DfsObjectID Object ID
KEY FrcElmntOrgRelatedOrgID I_DFS_ObjStructureRelationship DfsPositionRelatedObjectID ID rel.object
KEY FrcElmntOrgPlngStatus I_DFS_ObjStructureRelationship DfsObjectPlngStatus Planning status
KEY FrcElmntOrgValdtyStartDate I_DFS_ObjStructureRelationship DfsObjectValdtyStartDate Start date
KEY FrcElmntOrgValdtyEndDate I_DFS_ObjStructureRelationship DfsObjectValdtyEndDate End Date
FrcElmntOrgType I_DFS_ObjStructureRelationship DfsObjectType Object type
FrcElmntOrgPlanVersion I_DFS_ObjStructureRelationship DfsObjectPlanVersion Plan version
FrcElmntOrgRelshpSpec I_DFS_ObjStructureRelationship DfsObjectRelshpSpec Relationship
FrcElmntOrgRelshpBtwnObj I_DFS_ObjStructureRelationship DfsObjectRelshpBtwnObj Relnship
FrcElmntOrgRelshpPriority I_DFS_ObjStructureRelationship DfsObjectRelshpPriority Priority
NumberOfForceElementOrg I_DFS_ObjStructureRelationship DfsPositionDescRefSqncNmbr IT record no.
FrcElmntOrgInfoType I_DFS_ObjStructureRelationship DfsObjectInfoType Infotype
FrcElmntOrgSubType I_DFS_ObjStructureRelationship DfsObjectSubType Subtype
FrcElmntOrgPlngStsCritlty I_DFS_ObjStructureRelationship FrcElmntOrgPlngStsCritlty
FrcElmntOrgRelatedOrgType I_DFS_ObjStructureRelationship DfsPositionRelatedObjectType Rel.obj.type
FrcElmntOrgLastChgdByUser I_DFS_ObjStructureRelationship DfsObjRelshpLastChgdByUser User Name
WBSElementInternalID _WBSElementBasicData WBSElementInternalID WBS Internal ID
WBSElementExternalID _WBSElementBasicData WBSElementExternalID WBS Element External ID
WBSElement _WBSElementBasicData WBSElement WBS Internal ID
WBSDescription _WBSElementBasicData WBSDescription WBS Element Name
ProjectProfileCode _ProjectBasicData ProjectProfileCode Project Profile
ProjectInternalID _ProjectBasicData ProjectInternalID Project Def.
ProjectExternalID _ProjectBasicData ProjectExternalID Project def.
Project
ProjectDescription _ProjectBasicData ProjectDescription Project Name
ProjectProfileCodeText _FrcElmntOrgProjectProfiles ProjectProfileCodeText Description

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_FrcElmntToWBSElmnt.
-- 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: IFETOWBSELMNT

CREATE VIEW I_FrcElmntToWBSElmnt AS
SELECT
  ObjStructureRelationship.DfsObjectID AS ForceElementOrgID,
  ObjStructureRelationship.DfsPositionRelatedObjectID AS FrcElmntOrgRelatedOrgID,
  ObjStructureRelationship.DfsObjectPlngStatus AS FrcElmntOrgPlngStatus,
  ObjStructureRelationship.DfsObjectValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  ObjStructureRelationship.DfsObjectValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  ObjStructureRelationship.DfsObjectType AS FrcElmntOrgType,
  ObjStructureRelationship.DfsObjectPlanVersion AS FrcElmntOrgPlanVersion,
  ObjStructureRelationship.DfsObjectRelshpSpec AS FrcElmntOrgRelshpSpec,
  ObjStructureRelationship.DfsObjectRelshpBtwnObj AS FrcElmntOrgRelshpBtwnObj,
  ObjStructureRelationship.DfsObjectRelshpPriority AS FrcElmntOrgRelshpPriority,
  ObjStructureRelationship.DfsPositionDescRefSqncNmbr AS NumberOfForceElementOrg,
  ObjStructureRelationship.DfsObjectInfoType AS FrcElmntOrgInfoType,
  ObjStructureRelationship.DfsObjectSubType AS FrcElmntOrgSubType,
  ObjStructureRelationship.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  ObjStructureRelationship.DfsPositionRelatedObjectType AS FrcElmntOrgRelatedOrgType,
  ObjStructureRelationship.DfsObjRelshpLastChgdByUser AS FrcElmntOrgLastChgdByUser,
  _WBSElementBasicData.WBSElementInternalID AS WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  _WBSElementBasicData.WBSElement AS WBSElement,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  _ProjectBasicData.ProjectProfileCode AS ProjectProfileCode,
  _ProjectBasicData.ProjectInternalID AS ProjectInternalID,
  _ProjectBasicData.ProjectExternalID AS ProjectExternalID,
  cast ( _ProjectBasicData.Project as ps_pspid_edit preserving type ) AS Project,
  _ProjectBasicData.ProjectDescription AS ProjectDescription,
  _FrcElmntOrgProjectProfiles.ProjectProfileCodeText AS ProjectProfileCodeText
FROM I_DFS_ObjStructureRelationship AS ObjStructureRelationship
;

Learn More