C_FrcElmntToOpExerCommandsTP

DDL: C_FRCELMNTTOOPEXERCOMMANDSTP SQL: CFEOPEXERCOMTP Type: view CONSUMPTION
32 Fields 1 Data Sources 3 Associations

Manage Force Element To Command Assignment

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

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntToOpExerRelshpTP FrcElmntToOpExerRelshpTP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_FrcElmntOpExerCommandsVH _FrcElmntOpExerCommandsVH _FrcElmntOpExerCommandsVH.ForceElementOrgID = $projection.FrcElmntOrgRelatedOrgIDFoEd
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.FrcElmntOrgPlngStatus
[1..*] C_FrcElmntOrgOpExerCommandsVH _FrcElmntOrgOpExerCommandsVH _FrcElmntOrgOpExerCommandsVH.FrcElmntOrgSubType = $projection.FrcElmntOrgSubType

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CFEOPEXERCOMTP 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 Command Assignment view

Fields (32)

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 _FrcElmntOpExerCommandsVH 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
DfsAssgmtPlanOperationStatus FrcElmntOrgPlngStatusName Delimitation status
DfsAssgmtPlanOpStsCriticality DfsAssgmtPlanOpStsCriticality
_FrcElmntOpExerCommandsVH _FrcElmntOpExerCommandsVH
_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH
_FrcElmntOrgOpExerCommandsVH _FrcElmntOrgOpExerCommandsVH

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_FrcElmntToOpExerCommandsTP.
-- 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: CFEOPEXERCOMTP

CREATE VIEW C_FrcElmntToOpExerCommandsTP 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,
  _FrcElmntOpExerCommandsVH.FrcElmntOrgName AS FrcElmntOrgName,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgValdtyEndDateFoEd AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  FrcElmntOrgPlanDelimitDate,
  FrcElmntOrgPlngStatusName AS DfsAssgmtPlanOperationStatus,
  DfsAssgmtPlanOpStsCriticality
FROM I_FrcElmntToOpExerRelshpTP AS FrcElmntToOpExerRelshpTP
LEFT OUTER JOIN C_FrcElmntOpExerCommandsVH AS _FrcElmntOpExerCommandsVH ON _FrcElmntOpExerCommandsVH.ForceElementOrgID = FrcElmntOrgRelatedOrgIDFoEd  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgOpExerCommandsVH AS _FrcElmntOrgOpExerCommandsVH ON _FrcElmntOrgOpExerCommandsVH.FrcElmntOrgSubType = FrcElmntOrgSubType  -- association [1..*]
;

Learn More