P_FrcElmntOrgStrucRelshp

DDL: P_FRCELMNTORGSTRUCRELSHP SQL: PFEORGSTRURELSHP Type: view BASIC
16 Fields 1 Data Sources 1 Associations

P_FrcElmntOrgStrucRelshp is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (hrp1001) and exposes 16 fields with key fields FrcElmntOrgType, ForceElementOrgID, FrcElmntOrgPlanVersion, FrcElmntOrgRelshpSpec, FrcElmntOrgRelshpBtwnObj. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
hrp1001 FrcElmntOrgStrucRelshp from

Associations (1)

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

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFEORGSTRURELSHP view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgType hrp1001 otype Type of Val.
KEY ForceElementOrgID hrp1001 objid Work Center
KEY FrcElmntOrgPlanVersion hrp1001 plvar Plan version
KEY FrcElmntOrgRelshpSpec hrp1001 rsign Relationship
KEY FrcElmntOrgRelshpBtwnObj hrp1001 relat Relnship
KEY FrcElmntOrgPlngStatus hrp1001 istat System status
KEY FrcElmntOrgRelshpPriority hrp1001 priox Priority
KEY FrcElmntOrgValdtyStartDate hrp1001 begda Valid From
KEY FrcElmntOrgValdtyEndDate hrp1001 endda Valid To
KEY NumberOfForceElementOrg hrp1001 seqnr Tank ID
FrcElmntOrgWeightingPct hrp1001 prozt Share
FrcElmntOrgInfoType hrp1001 infty Infotype
FrcElmntOrgSubType hrp1001 subty Subtype
FrcElmntOrgRelatedOrgType hrp1001 sclas Rel.obj.type
FrcElmntOrgRelatedOrgID hrp1001 sobid ID rel.object
FrcElmntOrgLastChgdByUserName hrp1001 uname User Name

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_FrcElmntOrgStrucRelshp.
-- 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: PFEORGSTRURELSHP

CREATE VIEW P_FrcElmntOrgStrucRelshp AS
SELECT
  FrcElmntOrgStrucRelshp.otype AS FrcElmntOrgType,
  FrcElmntOrgStrucRelshp.objid AS ForceElementOrgID,
  FrcElmntOrgStrucRelshp.plvar AS FrcElmntOrgPlanVersion,
  FrcElmntOrgStrucRelshp.rsign AS FrcElmntOrgRelshpSpec,
  FrcElmntOrgStrucRelshp.relat AS FrcElmntOrgRelshpBtwnObj,
  FrcElmntOrgStrucRelshp.istat AS FrcElmntOrgPlngStatus,
  FrcElmntOrgStrucRelshp.priox AS FrcElmntOrgRelshpPriority,
  FrcElmntOrgStrucRelshp.begda AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgStrucRelshp.endda AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgStrucRelshp.seqnr AS NumberOfForceElementOrg,
  FrcElmntOrgStrucRelshp.prozt AS FrcElmntOrgWeightingPct,
  FrcElmntOrgStrucRelshp.infty AS FrcElmntOrgInfoType,
  FrcElmntOrgStrucRelshp.subty AS FrcElmntOrgSubType,
  FrcElmntOrgStrucRelshp.sclas AS FrcElmntOrgRelatedOrgType,
  FrcElmntOrgStrucRelshp.sobid AS FrcElmntOrgRelatedOrgID,
  FrcElmntOrgStrucRelshp.uname AS FrcElmntOrgLastChgdByUserName
FROM hrp1001 AS FrcElmntOrgStrucRelshp
LEFT OUTER JOIN I_DFS_ActivePlanVersion AS _ActivePlanVersion ON FrcElmntOrgPlanVersion = _ActivePlanVersion.DfsObjectPlanVersion  -- association [0..1]
;

Learn More