I_FrcElmntToOpExerRelshpDEX

DDL: I_FRCELMNTTOOPEXERRELSHPDEX Type: view_entity BASIC
18 Fields 1 Data Sources 1 Associations

Force Element Op Ex Rel Extractor

I_FrcElmntToOpExerRelshpDEX (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Force Element Organization · Cross Applications

I_FrcElmntToOpExerRelshpDEX is a Basic CDS View (Fact) that provides data about "Force Element Op Ex Rel Extractor" 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.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentIS-DFS-OF-FE
CapabilitiesData Source for Data Extraction, Association Target for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
hrp1985 FrcElmntToOpExerRelshp from

Associations (1)

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

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Force Element Op Ex Rel Extractor view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
VDM.viewType #BASIC view
ObjectModel.sapObjectNodeType.name ForceElementOrganization 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 Planning Status
KEY FrcElmntOrgValdtyStartDate hrp1985 begda Valid From
KEY FrcElmntOrgValdtyEndDate hrp1985 endda Valid To
KEY FrcElmntOrgVariationID hrp1985 varyf Variation Field for File PLOG
KEY NumberOfForceElementOrg hrp1985 seqnr Number of Infotype Record With Same Key
FrcElmntOrgInfoType hrp1985 infty Infotype
FrcElmntOrgRelatedOrgType hrp1985 sclas Type of Related Object
FrcElmntOrgRelatedOrgID hrp1985 sobid ID of Related Object
FrcElmntOrgRelshpPriority hrp1985 priox_relat Priority
FrcElmntOrgOpExerciseID hrp1985 operation_id Operation/Exercise 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 I_FrcElmntToOpExerRelshpDEX.
-- 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.

CREATE VIEW I_FrcElmntToOpExerRelshpDEX 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