P_FrcElmntToOpExerRelshp

DDL: P_FRCELMNTTOOPEXERRELSHP SQL: PFETOOPEXERREL Type: view BASIC
18 Fields 1 Data Sources 1 Associations

P_FrcElmntToOpExerRelshp is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (hrp1985) and exposes 18 fields with key fields FrcElmntOrgPlanVersion, FrcElmntOrgType, ForceElementOrgID, FrcElmntOrgSubType, FrcElmntOrgPlngStatus. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
hrp1985 FrcElmntToOpExerRelshp from

Associations (1)

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

Annotations (10)

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

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgPlanVersion hrp1985 plvar Plan version
KEY FrcElmntOrgType hrp1985 otype Type of Val.
KEY ForceElementOrgID hrp1985 objid Work Center
KEY FrcElmntOrgSubType hrp1985 subty Subtype
KEY FrcElmntOrgPlngStatus hrp1985 istat System status
KEY FrcElmntOrgValdtyStartDate hrp1985 begda Valid From
KEY FrcElmntOrgValdtyEndDate hrp1985 endda Valid To
KEY FrcElmntOrgVariationID hrp1985 varyf Variation field
KEY NumberOfForceElementOrg hrp1985 seqnr Tank ID
FrcElmntOrgInfoType hrp1985 infty Infotype
FrcElmntOrgRelatedOrgType hrp1985 sclas Rel.obj.type
FrcElmntOrgRelatedOrgID hrp1985 sobid ID rel.object
FrcElmntOrgRelshpPriority hrp1985 priox_relat Priority
FrcElmntOrgOpExerciseID hrp1985 operation_id Washout ID
FrcElmntOrgRotationKey hrp1985 con_id Contingent Key
FrcElmntOrgForceProviderID hrp1985 objid_com Object ID
FrcElmntOrgInitialMatlSuplrID hrp1985 provider_mat Supplier (Materials)
FrcElmntOrgInitialPersSuplrID hrp1985 provider_per Supplier (Personnel)

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_FrcElmntToOpExerRelshp.
-- 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: PFETOOPEXERREL

CREATE VIEW P_FrcElmntToOpExerRelshp AS
SELECT
  FrcElmntToOpExerRelshp.plvar AS FrcElmntOrgPlanVersion,
  FrcElmntToOpExerRelshp.otype AS FrcElmntOrgType,
  FrcElmntToOpExerRelshp.objid AS ForceElementOrgID,
  FrcElmntToOpExerRelshp.subty AS FrcElmntOrgSubType,
  FrcElmntToOpExerRelshp.istat AS FrcElmntOrgPlngStatus,
  FrcElmntToOpExerRelshp.begda AS FrcElmntOrgValdtyStartDate,
  FrcElmntToOpExerRelshp.endda AS FrcElmntOrgValdtyEndDate,
  FrcElmntToOpExerRelshp.varyf AS FrcElmntOrgVariationID,
  FrcElmntToOpExerRelshp.seqnr AS NumberOfForceElementOrg,
  FrcElmntToOpExerRelshp.infty AS FrcElmntOrgInfoType,
  FrcElmntToOpExerRelshp.sclas AS FrcElmntOrgRelatedOrgType,
  FrcElmntToOpExerRelshp.sobid AS FrcElmntOrgRelatedOrgID,
  FrcElmntToOpExerRelshp.priox_relat AS FrcElmntOrgRelshpPriority,
  FrcElmntToOpExerRelshp.operation_id AS FrcElmntOrgOpExerciseID,
  FrcElmntToOpExerRelshp.con_id AS FrcElmntOrgRotationKey,
  FrcElmntToOpExerRelshp.objid_com AS FrcElmntOrgForceProviderID,
  FrcElmntToOpExerRelshp.provider_mat AS FrcElmntOrgInitialMatlSuplrID,
  FrcElmntToOpExerRelshp.provider_per AS FrcElmntOrgInitialPersSuplrID
FROM hrp1985 AS FrcElmntToOpExerRelshp
LEFT OUTER JOIN I_DFS_ActivePlanVersion AS _ActivePlanVersion ON FrcElmntOrgPlanVersion = _ActivePlanVersion.DfsObjectPlanVersion  -- association [0..1]
;

Learn More