C_FrcElmntToExerStaffPrpslTP

DDL: C_FRCELMNTTOEXERSTAFFPRPSLTP SQL: CFEEXSTAFFPRTP Type: view CONSUMPTION
36 Fields 1 Data Sources 8 Associations

Exercise Staff Proposal

C_FrcElmntToExerStaffPrpslTP is a Consumption CDS View that provides data about "Exercise Staff Proposal" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntToOpExerRelshpTP) and exposes 36 fields with key fields ForceElementOrgID, FrcElmntOrgRelatedOrgID, FrcElmntOrgPlngStatus, FrcElmntOrgValdtyStartDate, FrcElmntOrgValdtyEndDate. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntToOpExerRelshpTP FrcElmntToOpExerRelshpTP from

Associations (8)

CardinalityTargetAliasCondition
[1..1] C_FrcElmntOrgPersonnelVH _FrcElmntOrgPersonnelVH _FrcElmntOrgPersonnelVH.PersonnelNumber = $projection.FrcElmntOrgRelatedOrgIDFoEd
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.FrcElmntOrgPlngStatus
[1..*] C_FrcElmntOrgExerciseRelshpVH _FrcElmntOrgExerciseRelshpVH _FrcElmntOrgExerciseRelshpVH.FrcElmntOrgSubType = $projection.FrcElmntOrgSubType
[0..*] C_FrcElmntOrgExerToPersTypeVH _FrcElmntOrgExerToPersTypeVH _FrcElmntOrgExerToPersTypeVH.FrcElmntOrgSubType = $projection.FrcElmntOrgCnctntdRelshpName and _FrcElmntOrgExerToPersTypeVH.FrcElmntOrgRelatedOrgType = $projection.FrcElmntOrgType
[0..1] C_FrcElmntOrgExerciseVH _FrcElmntOrgExerciseVH _FrcElmntOrgExerciseVH.ForceElementOrgID = $projection.FrcElmntOrgOpExerciseID
[0..1] C_FrcElmntOrgOpExerRotationVH _FrcElmntOrgOpExerRotationVH $projection.FrcElmntOrgOpExerciseID = _FrcElmntOrgOpExerRotationVH.ForceElementOrgID and $projection.FrcElmntOrgRotationKey = _FrcElmntOrgOpExerRotationVH.FrcElmntOrgRotationKey
[0..*] C_FrcElmntOrgExerRotationVH _FrcElmntOrgExerRotationVH $projection.ForceElementOrgID = _FrcElmntOrgExerRotationVH.ForceElementOrgID
[0..*] C_FrcElmntOrgAssgmtExerVH _FrcElmntOrgAssgmtExerVH $projection.ForceElementOrgID = _FrcElmntOrgAssgmtExerVH.ForceElementOrgID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CFEEXSTAFFPRTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Exercise Staff Proposal 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

Fields (36)

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 _FrcElmntOrgExerToPersTypeVH FrcElmntOrgRelshpDesc Relationship
EmployeeName _FrcElmntOrgPersonnelVH EmployeeName
FrcElmntOrgValdtyStartDateFoEd I_FrcElmntToOpExerRelshpTP FrcElmntOrgValdtyStartDateFoEd Start date
FrcElmntOrgValdtyEndDateFoEd I_FrcElmntToOpExerRelshpTP FrcElmntOrgValdtyEndDateFoEd End Date
FrcElmntOrgPlngStsCritlty I_FrcElmntToOpExerRelshpTP FrcElmntOrgPlngStsCritlty
FrcElmntOrgPlngStatusName _FrcElmntOrgPlngStsVH FrcElmntOrgPlngStatusName Planning Status
FrcElmntOrgName _FrcElmntOrgExerciseVH FrcElmntOrgName Name
FrcElmntOrgRotationName _FrcElmntOrgOpExerRotationVH FrcElmntOrgRotationName
_FrcElmntOrgExerToPersTypeVH _FrcElmntOrgExerToPersTypeVH
_FrcElmntOrgPersonnelVH _FrcElmntOrgPersonnelVH
_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH
_FrcElmntOrgExerciseRelshpVH _FrcElmntOrgExerciseRelshpVH
_FrcElmntOrgExerciseVH _FrcElmntOrgExerciseVH
_FrcElmntOrgOpExerRotationVH _FrcElmntOrgOpExerRotationVH
_FrcElmntOrgExerRotationVH _FrcElmntOrgExerRotationVH
_FrcElmntOrgAssgmtExerVH _FrcElmntOrgAssgmtExerVH

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_FrcElmntToExerStaffPrpslTP.
-- 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: CFEEXSTAFFPRTP

CREATE VIEW C_FrcElmntToExerStaffPrpslTP 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,
  _FrcElmntOrgExerToPersTypeVH.FrcElmntOrgRelshpDesc AS FrcElmntOrgRelshpDesc,
  _FrcElmntOrgPersonnelVH.EmployeeName AS EmployeeName,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgValdtyEndDateFoEd AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntToOpExerRelshpTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _FrcElmntOrgExerciseVH.FrcElmntOrgName AS FrcElmntOrgName,
  _FrcElmntOrgOpExerRotationVH.FrcElmntOrgRotationName AS FrcElmntOrgRotationName
FROM I_FrcElmntToOpExerRelshpTP AS FrcElmntToOpExerRelshpTP
LEFT OUTER JOIN C_FrcElmntOrgPersonnelVH AS _FrcElmntOrgPersonnelVH ON _FrcElmntOrgPersonnelVH.PersonnelNumber = 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_FrcElmntOrgExerToPersTypeVH AS _FrcElmntOrgExerToPersTypeVH ON _FrcElmntOrgExerToPersTypeVH.FrcElmntOrgSubType = FrcElmntOrgCnctntdRelshpName AND _FrcElmntOrgExerToPersTypeVH.FrcElmntOrgRelatedOrgType = FrcElmntOrgType  -- association [0..*]
LEFT OUTER JOIN C_FrcElmntOrgExerciseVH AS _FrcElmntOrgExerciseVH ON _FrcElmntOrgExerciseVH.ForceElementOrgID = FrcElmntOrgOpExerciseID  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgOpExerRotationVH AS _FrcElmntOrgOpExerRotationVH ON FrcElmntOrgOpExerciseID = _FrcElmntOrgOpExerRotationVH.ForceElementOrgID AND FrcElmntOrgRotationKey = _FrcElmntOrgOpExerRotationVH.FrcElmntOrgRotationKey  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgExerRotationVH AS _FrcElmntOrgExerRotationVH ON ForceElementOrgID = _FrcElmntOrgExerRotationVH.ForceElementOrgID  -- association [0..*]
LEFT OUTER JOIN C_FrcElmntOrgAssgmtExerVH AS _FrcElmntOrgAssgmtExerVH ON ForceElementOrgID = _FrcElmntOrgAssgmtExerVH.ForceElementOrgID  -- association [0..*]
;

Learn More