C_FrcElmntToOperationRelshpTP

DDL: C_FRCELMNTTOOPERATIONRELSHPTP SQL: CFEOPRELTP Type: view CONSUMPTION
33 Fields 1 Data Sources 4 Associations

Manage Force Element to Operation Relationship Assignment

C_FrcElmntToOperationRelshpTP is a Consumption CDS View that provides data about "Manage Force Element to Operation Relationship Assignment" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntToOpExerRelshpTP) and exposes 33 fields with key fields ForceElementOrgID, FrcElmntOrgRelatedOrgID, FrcElmntOrgPlngStatus, FrcElmntOrgValdtyStartDate, FrcElmntOrgValdtyEndDate. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntToOpExerRelshpTP FrcElmntToOpExerRelshpTP from

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_FrcElmntOrgOperationVH _FrcElmntOrgOperationVH _FrcElmntOrgOperationVH.ForceElementOrgID = $projection.FrcElmntOrgRelatedOrgIDFoEd
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.FrcElmntOrgPlngStatus
[1..*] C_FrcElmntOrgOperationRelshpVH _FrcElmntOrgOperationRelshpVH _FrcElmntOrgOperationRelshpVH.FrcElmntOrgSubType = $projection.FrcElmntOrgSubType
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlnnOpStatusVH _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = $projection.DfsAssgmtPlanStatusObject

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CFEOPRELTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
Metadata.allowExtensions true view
EndUserText.label Manage Force Element to Operation Relationship Assignment view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY ForceElementOrgID I_FrcElmntToOpExerRelshpTP ForceElementOrgID Object ID Processor
KEY FrcElmntOrgRelatedOrgID I_FrcElmntToOpExerRelshpTP FrcElmntOrgRelatedOrgID ID rel.object
KEY FrcElmntOrgPlngStatus I_FrcElmntToOpExerRelshpTP FrcElmntOrgPlngStatus Planning status
KEY FrcElmntOrgValdtyStartDate I_FrcElmntToOpExerRelshpTP FrcElmntOrgValdtyStartDate Start date
KEY FrcElmntOrgValdtyEndDate I_FrcElmntToOpExerRelshpTP FrcElmntOrgValdtyEndDate End Date
KEY FrcElmntOrgSubType I_FrcElmntToOpExerRelshpTP FrcElmntOrgSubType Subtype
FrcElmntOrgPlanVersion I_FrcElmntToOpExerRelshpTP FrcElmntOrgPlanVersion Plan version
FrcElmntOrgType I_FrcElmntToOpExerRelshpTP FrcElmntOrgType Object type
FrcElmntOrgVariationID I_FrcElmntToOpExerRelshpTP FrcElmntOrgVariationID Variation field
NumberOfForceElementOrg I_FrcElmntToOpExerRelshpTP NumberOfForceElementOrg IT record no.
FrcElmntOrgInfoType I_FrcElmntToOpExerRelshpTP FrcElmntOrgInfoType Infotype
FrcElmntOrgRelatedOrgType I_FrcElmntToOpExerRelshpTP FrcElmntOrgRelatedOrgType Rel.obj.type
ForceElementOrgIDFoEd I_FrcElmntToOpExerRelshpTP ForceElementOrgIDFoEd Object ID
FrcElmntOrgRelatedOrgIDFoEd I_FrcElmntToOpExerRelshpTP FrcElmntOrgRelatedOrgIDFoEd ID rel.object
FrcElmntOrgOpExerciseID I_FrcElmntToOpExerRelshpTP FrcElmntOrgOpExerciseID Op./Exercise ID
FrcElmntOrgRotationKey I_FrcElmntToOpExerRelshpTP FrcElmntOrgRotationKey Contingent Key
FrcElmntOrgForceProviderID I_FrcElmntToOpExerRelshpTP FrcElmntOrgForceProviderID Object ID
FrcElmntOrgInitialMatlSuplrID I_FrcElmntToOpExerRelshpTP FrcElmntOrgInitialMatlSuplrID Object ID
FrcElmntOrgInitialPersSuplrID I_FrcElmntToOpExerRelshpTP FrcElmntOrgInitialPersSuplrID Object ID
FrcElmntOrgCnctntdRelshpName I_FrcElmntToOpExerRelshpTP FrcElmntOrgCnctntdRelshpName
FrcElmntOrgRelshpDesc I_FrcElmntToOpExerRelshpTP FrcElmntOrgRelshpDesc Relationship
FrcElmntOrgName _FrcElmntOrgOperationVH FrcElmntOrgName Name
FrcElmntOrgValdtyStartDateFoEd I_FrcElmntToOpExerRelshpTP FrcElmntOrgValdtyStartDateFoEd Start date
FrcElmntOrgValdtyEndDateFoEd I_FrcElmntToOpExerRelshpTP FrcElmntOrgValdtyEndDateFoEd End Date
FrcElmntOrgPlngStsCritlty I_FrcElmntToOpExerRelshpTP FrcElmntOrgPlngStsCritlty
FrcElmntOrgPlngStatusName _FrcElmntOrgPlngStsVH FrcElmntOrgPlngStatusName Planning Status
FrcElmntOrgPlanDelimitDate FrcElmntOrgPlanDelimitDate Delimit date
DfsAssgmtPlanStatusObject DfsAssgmtPlanStatusObject Planning status
DfsAssgmtPlanOperationStatus FrcElmntOrgPlngStatusName Planned Delimitation status
DfsAssgmtPlanOpStsCriticality DfsAssgmtPlanOpStsCriticality
_FrcElmntOrgOperationVH _FrcElmntOrgOperationVH
_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH
_FrcElmntOrgOperationRelshpVH _FrcElmntOrgOperationRelshpVH

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 C_FrcElmntToOperationRelshpTP.
-- 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: CFEOPRELTP

CREATE VIEW C_FrcElmntToOperationRelshpTP AS
SELECT
  FrcElmntToOpExerRelshpTP.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgRelatedOrgID AS FrcElmntOrgRelatedOrgID,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgVariationID AS FrcElmntOrgVariationID,
  FrcElmntToOpExerRelshpTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgRelatedOrgType AS FrcElmntOrgRelatedOrgType,
  FrcElmntToOpExerRelshpTP.ForceElementOrgIDFoEd AS ForceElementOrgIDFoEd,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgRelatedOrgIDFoEd AS FrcElmntOrgRelatedOrgIDFoEd,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgOpExerciseID AS FrcElmntOrgOpExerciseID,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgRotationKey AS FrcElmntOrgRotationKey,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgForceProviderID AS FrcElmntOrgForceProviderID,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgInitialMatlSuplrID AS FrcElmntOrgInitialMatlSuplrID,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgInitialPersSuplrID AS FrcElmntOrgInitialPersSuplrID,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgCnctntdRelshpName AS FrcElmntOrgCnctntdRelshpName,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgRelshpDesc AS FrcElmntOrgRelshpDesc,
  _FrcElmntOrgOperationVH.FrcElmntOrgName AS FrcElmntOrgName,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgValdtyEndDateFoEd AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  FrcElmntOrgPlanDelimitDate,
  DfsAssgmtPlanStatusObject,
  FrcElmntOrgPlngStatusName AS DfsAssgmtPlanOperationStatus,
  DfsAssgmtPlanOpStsCriticality
FROM I_FrcElmntToOpExerRelshpTP AS FrcElmntToOpExerRelshpTP
LEFT OUTER JOIN C_FrcElmntOrgOperationVH AS _FrcElmntOrgOperationVH ON _FrcElmntOrgOperationVH.ForceElementOrgID = FrcElmntOrgRelatedOrgIDFoEd  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgOperationRelshpVH AS _FrcElmntOrgOperationRelshpVH ON _FrcElmntOrgOperationRelshpVH.FrcElmntOrgSubType = FrcElmntOrgSubType  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlnnOpStatusVH ON _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = DfsAssgmtPlanStatusObject  -- association [1..1]
;

Learn More