C_FrcElmntToExercisePosTP

DDL: C_FRCELMNTTOEXERCISEPOSTP SQL: CFEEXERPOSTP Type: view CONSUMPTION
35 Fields 1 Data Sources 5 Associations

Position Assignment for Organizational Structure

C_FrcElmntToExercisePosTP is a Consumption CDS View that provides data about "Position Assignment for Organizational Structure" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntToOpExerRelshpTP) and exposes 35 fields with key fields ForceElementOrgID, FrcElmntOrgRelatedOrgID, FrcElmntOrgPlngStatus, FrcElmntOrgValdtyStartDate, FrcElmntOrgValdtyEndDate. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntToOpExerRelshpTP FrcElmntToOpExerRelshpTP from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_DFS_PositionNameVH _PositionNameVH _PositionNameVH.DfsPositionID = $projection.FrcElmntOrgRelatedOrgIDFoEd
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.FrcElmntOrgPlngStatus
[1..*] C_FrcElmntToExercisePosVH _FrcElmntToExercisePosVH _FrcElmntToExercisePosVH.FrcElmntOrgSubType = $projection.FrcElmntOrgCnctntdRelshpName
[1..*] C_FrcElmntOrgVH _FrcElmntOrgVH _FrcElmntOrgVH.ForceElementOrgID = $projection.ForceElementOrgID
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlnnOpStatusVH _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = $projection.DfsAssgmtPlanStatusObject

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CFEEXERPOSTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED 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 Position Assignment for Organizational Structure view

Fields (35)

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
DfsPositionName
FrcElmntOrgValdtyStartDateFoEd I_FrcElmntToOpExerRelshpTP FrcElmntOrgValdtyStartDateFoEd Start date
FrcElmntOrgValdtyEndDateFoEd I_FrcElmntToOpExerRelshpTP FrcElmntOrgValdtyEndDateFoEd End Date
FrcElmntOrgPlngStsCritlty I_FrcElmntToOpExerRelshpTP FrcElmntOrgPlngStsCritlty
FrcElmntOrgPlngStatusName _FrcElmntOrgPlngStsVH FrcElmntOrgPlngStatusName Planning Status
FrcElmntOrgName _FrcElmntOrgVH FrcElmntOrgName Name
FrcElmntOrgPlanDelimitDate FrcElmntOrgPlanDelimitDate Delimit date
DfsAssgmtPlanStatusObject DfsAssgmtPlanStatusObject Planning status
DfsAssgmtPlanOperationStatus _FrcElmntOrgPlnnOpStatusVH FrcElmntOrgPlngStatusName Planned Delimitation status
DfsAssgmtPlanOpStsCriticality DfsAssgmtPlanOpStsCriticality
_FrcElmntOrgVH _FrcElmntOrgVH
_PositionNameVH _PositionNameVH
_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH
_FrcElmntToExercisePosVH _FrcElmntToExercisePosVH

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_FrcElmntToExercisePosTP.
-- 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: CFEEXERPOSTP

CREATE VIEW C_FrcElmntToExercisePosTP 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,
  _PositionNameVH .DfsPositionName AS DfsPositionName,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgValdtyEndDateFoEd AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _FrcElmntOrgVH.FrcElmntOrgName AS FrcElmntOrgName,
  FrcElmntOrgPlanDelimitDate,
  DfsAssgmtPlanStatusObject,
  _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatusName AS DfsAssgmtPlanOperationStatus,
  DfsAssgmtPlanOpStsCriticality
FROM I_FrcElmntToOpExerRelshpTP AS FrcElmntToOpExerRelshpTP
LEFT OUTER JOIN C_DFS_PositionNameVH AS _PositionNameVH ON _PositionNameVH.DfsPositionID = FrcElmntOrgRelatedOrgIDFoEd  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntToExercisePosVH AS _FrcElmntToExercisePosVH ON _FrcElmntToExercisePosVH.FrcElmntOrgSubType = FrcElmntOrgCnctntdRelshpName  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgVH ON _FrcElmntOrgVH.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlnnOpStatusVH ON _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = DfsAssgmtPlanStatusObject  -- association [1..1]
;

Learn More