C_FrcElmntToExerciseRelshpTP

DDL: C_FRCELMNTTOEXERCISERELSHPTP SQL: CFEEXERRELTP Type: view CONSUMPTION
33 Fields 1 Data Sources 4 Associations

Manage Force Element to Exercise Relationship Assignment

C_FrcElmntToExerciseRelshpTP is a Consumption CDS View that provides data about "Manage Force Element to Exercise 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_FrcElmntOrgExerciseVH _FrcElmntOrgExerciseVH _FrcElmntOrgExerciseVH.ForceElementOrgID = $projection.FrcElmntOrgRelatedOrgIDFoEd
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.FrcElmntOrgPlngStatus
[1..*] C_FrcElmntOrgExerciseRelshpVH _FrcElmntOrgExerciseRelshpVH _FrcElmntOrgExerciseRelshpVH.FrcElmntOrgSubType = $projection.FrcElmntOrgSubType
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlnnOpStatusVH _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = $projection.DfsAssgmtPlanStatusObject

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CFEEXERRELTP 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 Exercise 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 _FrcElmntOrgExerciseVH 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 _FrcElmntOrgPlnnOpStatusVH FrcElmntOrgPlngStatusName Planned Delimitation status
DfsAssgmtPlanOpStsCriticality DfsAssgmtPlanOpStsCriticality
_FrcElmntOrgExerciseVH _FrcElmntOrgExerciseVH
_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH
_FrcElmntOrgExerciseRelshpVH _FrcElmntOrgExerciseRelshpVH

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_FrcElmntToExerciseRelshpTP.
-- 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: CFEEXERRELTP

CREATE VIEW C_FrcElmntToExerciseRelshpTP 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,
  _FrcElmntOrgExerciseVH.FrcElmntOrgName AS FrcElmntOrgName,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgValdtyEndDateFoEd AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  FrcElmntOrgPlanDelimitDate,
  DfsAssgmtPlanStatusObject,
  _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatusName AS DfsAssgmtPlanOperationStatus,
  DfsAssgmtPlanOpStsCriticality
FROM I_FrcElmntToOpExerRelshpTP AS FrcElmntToOpExerRelshpTP
LEFT OUTER JOIN C_FrcElmntOrgExerciseVH AS _FrcElmntOrgExerciseVH ON _FrcElmntOrgExerciseVH.ForceElementOrgID = FrcElmntOrgRelatedOrgIDFoEd  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgExerciseRelshpVH AS _FrcElmntOrgExerciseRelshpVH ON _FrcElmntOrgExerciseRelshpVH.FrcElmntOrgSubType = FrcElmntOrgSubType  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlnnOpStatusVH ON _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = DfsAssgmtPlanStatusObject  -- association [1..1]
;

Learn More