P_FrcElmntOrgDfsExternalRelshp

DDL: P_FRCELMNTORGDFSEXTERNALRELSHP SQL: PFEORGDFSEXT Type: view BASIC
17 Fields 1 Data Sources 2 Associations

P_FrcElmntOrgDfsExternalRelshp is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (hrp1955) and exposes 17 fields with key fields FrcElmntOrgPlanVersion, FrcElmntOrgType, ForceElementOrgID, FrcElmntOrgSubType, FrcElmntOrgPlngStatus. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
hrp1955 FrcElmntOrgDfsExternalRelshp from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_DFS_FrcElmntPlndOp FrcElmntPlndOp FrcElmntOrgDfsExternalRelshp.objid = FrcElmntPlndOp.ForceElementOrgID and FrcElmntOrgDfsExternalRelshp.begda = FrcElmntPlndOp.FrcElmntOrgValdtyRefStartDate and FrcElmntOrgDfsExternalRelshp.endda = FrcElmntPlndOp.FrcElmntOrgValdtyRefEndDate and FrcElmntOrgDfsExternalRelshp.subty = FrcElmntPlndOp.FrcElmntOrgRefSubtype and FrcElmntPlndOp.FrcElmntOrgRefInfoType = '1955'
[0..1] I_DFS_ActivePlanVersion _ActivePlanVersion $projection.FrcElmntOrgPlanVersion = _ActivePlanVersion.DfsObjectPlanVersion

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFEORGDFSEXT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE 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 #M view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgPlanVersion
KEY FrcElmntOrgType
KEY ForceElementOrgID
KEY FrcElmntOrgSubType
KEY FrcElmntOrgPlngStatus
KEY FrcElmntOrgValdtyStartDate
KEY FrcElmntOrgValdtyEndDate
KEY NumberOfForceElementOrg
FrcElmntOrgInfoType
FrcElmntOrgRelatedOrgType
FrcElmntOrgRelatedOrgID
FrcElmntOrgRelshpPriority
FrcElmntOrgLastChgdByUserName
DfsAssgmtPlanStatusObject FrcElmntPlndOp FrcElmntOrgPlngStatus Planning status
FrcElmntOrgPlanDelimitDate FrcElmntPlndOp FrcElmntOrgPlanDelimitDate Delimit date
FrcElmntOrgPlngStatusName FrcElmntPlndOp FrcElmntOrgPlngStatusName Planning Status
FrcElmntOrgPlngStsCritlty FrcElmntPlndOp FrcElmntOrgPlngStsCritlty

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_FrcElmntOrgDfsExternalRelshp.
-- 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: PFEORGDFSEXT

CREATE VIEW P_FrcElmntOrgDfsExternalRelshp AS
SELECT
  FrcElmntOrgDfsExternalRelshp .plvar AS FrcElmntOrgPlanVersion,
  FrcElmntOrgDfsExternalRelshp .otype AS FrcElmntOrgType,
  FrcElmntOrgDfsExternalRelshp .objid AS ForceElementOrgID,
  FrcElmntOrgDfsExternalRelshp .subty AS FrcElmntOrgSubType,
  FrcElmntOrgDfsExternalRelshp .istat AS FrcElmntOrgPlngStatus,
  FrcElmntOrgDfsExternalRelshp .begda AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgDfsExternalRelshp .endda AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgDfsExternalRelshp .seqnr AS NumberOfForceElementOrg,
  FrcElmntOrgDfsExternalRelshp .infty AS FrcElmntOrgInfoType,
  FrcElmntOrgDfsExternalRelshp .sclas AS FrcElmntOrgRelatedOrgType,
  FrcElmntOrgDfsExternalRelshp .sobid AS FrcElmntOrgRelatedOrgID,
  FrcElmntOrgDfsExternalRelshp .priox_relat AS FrcElmntOrgRelshpPriority,
  FrcElmntOrgDfsExternalRelshp .uname AS FrcElmntOrgLastChgdByUserName,
  FrcElmntPlndOp.FrcElmntOrgPlngStatus AS DfsAssgmtPlanStatusObject,
  FrcElmntPlndOp.FrcElmntOrgPlanDelimitDate AS FrcElmntOrgPlanDelimitDate,
  FrcElmntPlndOp.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  FrcElmntPlndOp.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty
FROM hrp1955 AS FrcElmntOrgDfsExternalRelshp
LEFT OUTER JOIN I_DFS_FrcElmntPlndOp AS FrcElmntPlndOp ON FrcElmntOrgDfsExternalRelshp.objid = FrcElmntPlndOp.ForceElementOrgID AND FrcElmntOrgDfsExternalRelshp.begda = FrcElmntPlndOp.FrcElmntOrgValdtyRefStartDate AND FrcElmntOrgDfsExternalRelshp.endda = FrcElmntPlndOp.FrcElmntOrgValdtyRefEndDate AND FrcElmntOrgDfsExternalRelshp.subty = FrcElmntPlndOp.FrcElmntOrgRefSubtype AND FrcElmntPlndOp.FrcElmntOrgRefInfoType = '1955'  -- association [0..*]
LEFT OUTER JOIN I_DFS_ActivePlanVersion AS _ActivePlanVersion ON FrcElmntOrgPlanVersion = _ActivePlanVersion.DfsObjectPlanVersion  -- association [0..1]
;

Learn More