C_FrcElmntToPosStrucRelshpTP

DDL: C_FRCELMNTTOPOSSTRUCRELSHPTP SQL: CFEPOSSTRUCRLSHP Type: view CONSUMPTION
32 Fields 1 Data Sources 4 Associations

C_FrcElmntToPosStrucRelshpTP is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_FrcElmntToPosStrucRelshpTP) and exposes 32 fields with key fields DfsObjectID, DfsPositionID, DfsObjectPlngStatus, DfsPositionValdtyStartDate, DfsPositionValdtyEndDate. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntToPosStrucRelshpTP FrcElmntToPosStrucRelshpTP from

Associations (4)

CardinalityTargetAliasCondition
[1..*] C_FrcElmntOrgVH _FrcElmntOrgVH _FrcElmntOrgVH.ForceElementOrgIDForEdit = $projection.DfsObjectID
[1..1] C_DFS_PositionNameVH _PositionNameVH _PositionNameVH.DfsPositionID = $projection.DfsPositionRelatedObjectIDFoEd
[1..1] C_DFS_PositionPlngStatusVH _PositionPlngStatusVH _PositionPlngStatusVH.DfsObjectPlngStatus = $projection.DfsObjectPlngStatus
[1..*] C_DFS_PosOrgStrucSubTypeVH _PosOrgStrucSubTypeVH $projection.DfsObjectSubType = _PosOrgStrucSubTypeVH.DfsObjectSubType

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CFEPOSSTRUCRLSHP 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 #L 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 (32)

KeyFieldSource TableSource FieldDescription
KEY DfsObjectID I_FrcElmntToPosStrucRelshpTP DfsObjectID Object ID
KEY DfsPositionID I_FrcElmntToPosStrucRelshpTP DfsPositionRelatedObjectID ID rel.object
KEY DfsObjectPlngStatus I_FrcElmntToPosStrucRelshpTP DfsObjectPlngStatus Planning status
KEY DfsPositionValdtyStartDate I_FrcElmntToPosStrucRelshpTP DfsPositionValdtyStartDate Start date
KEY DfsPositionValdtyEndDate I_FrcElmntToPosStrucRelshpTP DfsPositionValdtyEndDate End Date
KEY DfsObjectSubType I_FrcElmntToPosStrucRelshpTP DfsObjectSubType Subtype
DfsObjectIDForEdit I_FrcElmntToPosStrucRelshpTP DfsObjectIDForEdit Object ID
FrcElmntOrgPlngStsCritlty I_FrcElmntToPosStrucRelshpTP FrcElmntOrgPlngStsCritlty
DfsPositionRelatedObjectIDFoEd I_FrcElmntToPosStrucRelshpTP DfsPositionRelatedObjectIDFoEd ID rel.object
DfsObjectType I_FrcElmntToPosStrucRelshpTP DfsObjectType Object type
FrcElmntOrgName _FrcElmntOrgVH FrcElmntOrgName Name
DfsPositionName _PositionNameVH DfsPositionName
DfsObjectPlngStatusName _PositionPlngStatusVH DfsObjectPlngStatusName
DfsObjectPlanVersion I_FrcElmntToPosStrucRelshpTP DfsObjectPlanVersion Plan version
DfsObjectRelshpSpec I_FrcElmntToPosStrucRelshpTP DfsObjectRelshpSpec Relationship
DfsObjectRelshpBtwnObj I_FrcElmntToPosStrucRelshpTP DfsObjectRelshpBtwnObj Relnship
DfsObjectRelshpPriority I_FrcElmntToPosStrucRelshpTP DfsObjectRelshpPriority Priority
DfsPositionDescRefSqncNmbr I_FrcElmntToPosStrucRelshpTP DfsPositionDescRefSqncNmbr IT record no.
DfsObjectInfoType I_FrcElmntToPosStrucRelshpTP DfsObjectInfoType Infotype
DfsPositionRelatedObjectType I_FrcElmntToPosStrucRelshpTP DfsPositionRelatedObjectType Rel.obj.type
DfsObjRelshpLastChgdByUserName I_FrcElmntToPosStrucRelshpTP DfsObjRelshpLastChgdByUserName Percentage
DfsObjRelshpLastChgdByUser I_FrcElmntToPosStrucRelshpTP DfsObjRelshpLastChgdByUser User Name
DfsObjRelshpLastChgdDate I_FrcElmntToPosStrucRelshpTP DfsObjRelshpLastChgdDate Changed on
DfsPositionValdtyStartDateFoEd I_FrcElmntToPosStrucRelshpTP DfsPositionValdtyStartDateFoEd Start date
DfsPositionValdtyEndDateFoEd I_FrcElmntToPosStrucRelshpTP DfsPositionValdtyEndDateFoEd End Date
FrcElmntOrgPlanDelimitDate FrcElmntOrgPlanDelimitDate Delimit date
FrcElmntOrgPlngStatusName FrcElmntOrgPlngStatusName Planning Status
DfsObjectSubTypeName _PosOrgStrucSubTypeVH DfsObjectSubTypeName
_PosOrgStrucSubTypeVH _PosOrgStrucSubTypeVH
_FrcElmntOrgVH _FrcElmntOrgVH
_PositionNameVH _PositionNameVH
_PositionPlngStatusVH _PositionPlngStatusVH

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_FrcElmntToPosStrucRelshpTP.
-- 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: CFEPOSSTRUCRLSHP

CREATE VIEW C_FrcElmntToPosStrucRelshpTP AS
SELECT
  FrcElmntToPosStrucRelshpTP.DfsObjectID AS DfsObjectID,
  FrcElmntToPosStrucRelshpTP.DfsPositionRelatedObjectID AS DfsPositionID,
  FrcElmntToPosStrucRelshpTP.DfsObjectPlngStatus AS DfsObjectPlngStatus,
  FrcElmntToPosStrucRelshpTP.DfsPositionValdtyStartDate AS DfsPositionValdtyStartDate,
  FrcElmntToPosStrucRelshpTP.DfsPositionValdtyEndDate AS DfsPositionValdtyEndDate,
  FrcElmntToPosStrucRelshpTP.DfsObjectSubType AS DfsObjectSubType,
  FrcElmntToPosStrucRelshpTP.DfsObjectIDForEdit AS DfsObjectIDForEdit,
  FrcElmntToPosStrucRelshpTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  FrcElmntToPosStrucRelshpTP.DfsPositionRelatedObjectIDFoEd AS DfsPositionRelatedObjectIDFoEd,
  FrcElmntToPosStrucRelshpTP.DfsObjectType AS DfsObjectType,
  _FrcElmntOrgVH.FrcElmntOrgName AS FrcElmntOrgName,
  _PositionNameVH.DfsPositionName AS DfsPositionName,
  _PositionPlngStatusVH.DfsObjectPlngStatusName AS DfsObjectPlngStatusName,
  FrcElmntToPosStrucRelshpTP.DfsObjectPlanVersion AS DfsObjectPlanVersion,
  FrcElmntToPosStrucRelshpTP.DfsObjectRelshpSpec AS DfsObjectRelshpSpec,
  FrcElmntToPosStrucRelshpTP.DfsObjectRelshpBtwnObj AS DfsObjectRelshpBtwnObj,
  FrcElmntToPosStrucRelshpTP.DfsObjectRelshpPriority AS DfsObjectRelshpPriority,
  FrcElmntToPosStrucRelshpTP.DfsPositionDescRefSqncNmbr AS DfsPositionDescRefSqncNmbr,
  FrcElmntToPosStrucRelshpTP.DfsObjectInfoType AS DfsObjectInfoType,
  FrcElmntToPosStrucRelshpTP.DfsPositionRelatedObjectType AS DfsPositionRelatedObjectType,
  FrcElmntToPosStrucRelshpTP.DfsObjRelshpLastChgdByUserName AS DfsObjRelshpLastChgdByUserName,
  FrcElmntToPosStrucRelshpTP.DfsObjRelshpLastChgdByUser AS DfsObjRelshpLastChgdByUser,
  FrcElmntToPosStrucRelshpTP.DfsObjRelshpLastChgdDate AS DfsObjRelshpLastChgdDate,
  FrcElmntToPosStrucRelshpTP.DfsPositionValdtyStartDateFoEd AS DfsPositionValdtyStartDateFoEd,
  FrcElmntToPosStrucRelshpTP.DfsPositionValdtyEndDateFoEd AS DfsPositionValdtyEndDateFoEd,
  FrcElmntOrgPlanDelimitDate,
  FrcElmntOrgPlngStatusName,
  _PosOrgStrucSubTypeVH.DfsObjectSubTypeName AS DfsObjectSubTypeName
FROM I_FrcElmntToPosStrucRelshpTP AS FrcElmntToPosStrucRelshpTP
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgVH ON _FrcElmntOrgVH.ForceElementOrgIDForEdit = DfsObjectID  -- association [1..*]
LEFT OUTER JOIN C_DFS_PositionNameVH AS _PositionNameVH ON _PositionNameVH.DfsPositionID = DfsPositionRelatedObjectIDFoEd  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionPlngStatusVH AS _PositionPlngStatusVH ON _PositionPlngStatusVH.DfsObjectPlngStatus = DfsObjectPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_DFS_PosOrgStrucSubTypeVH AS _PosOrgStrucSubTypeVH ON DfsObjectSubType = _PosOrgStrucSubTypeVH.DfsObjectSubType  -- association [1..*]
;

Learn More