C_DFS_PosToFrcElmntStrucTP

DDL: C_DFS_POSTOFRCELMNTSTRUCTP SQL: CDFSFESTRUCTP Type: view CONSUMPTION
39 Fields 1 Data Sources 7 Associations

C_DFS_PosToFrcElmntStrucTP is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_DFS_PosToFrcElmntStrucTP) and exposes 39 fields with key fields DfsObjectID, ForceElementOrgID, DfsObjectPlanVersion, DfsObjectPlngStatus, DfsPositionValdtyStartDate. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DFS_PosToFrcElmntStrucTP PosToFrcElmntStrucTP from

Associations (7)

CardinalityTargetAliasCondition
[1..1] C_DFS_PositionHeaderTP _PositionHeaderTP $projection.DfsObjectID = _PositionHeaderTP.DfsPositionID
[1..1] C_DFS_PositionPlngStatusVH _PositionPlngStatusVH _PositionPlngStatusVH.DfsObjectPlngStatus = $projection.DfsObjectPlngStatus
[1..1] C_DFS_PosOrgStrucSubTypeVH _PositionRelationVH _PositionRelationVH.DfsObjectSubType = $projection.DfsObjectSubType and _PositionRelationVH.DfsObjectInfoType = $projection.DfsObjectInfoType
[1..1] C_DFS_PositionFrcElmntOrgVH _PositionFrcElmntOrgVH _PositionFrcElmntOrgVH.DfsPositionID = $projection.ForceElementOrgIDFoEd and _PositionFrcElmntOrgVH.FrcElmntOrgLanguage = $session.system_language
[0..1] C_FrcElmntOrgSuplmntyVrtlElmnt _FrcElmntSuplmntyAttrib $projection.ForceElementOrgIDFoEd = _FrcElmntSuplmntyAttrib.ForceElementOrgID
[1..1] C_FrcElmntOrgTP _SrceFrcElmntOrgTP $projection.ForceElementOrgID = _SrceFrcElmntOrgTP.ForceElementOrgID
[0..*] C_FrcElmntOrgVH _FrcElmntOrgVH _FrcElmntOrgVH.ForceElementOrgIDForEdit = $projection.ForceElementOrgIDFoEd

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CDFSFESTRUCTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
Metadata.allowExtensions true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY DfsObjectID I_DFS_PosToFrcElmntStrucTP DfsObjectID Position ID
KEY ForceElementOrgID ForceElementOrgID Object ID
KEY DfsObjectPlanVersion I_DFS_PosToFrcElmntStrucTP DfsObjectPlanVersion Plan version
KEY DfsObjectPlngStatus I_DFS_PosToFrcElmntStrucTP DfsObjectPlngStatus Planning status
KEY DfsPositionValdtyStartDate I_DFS_PosToFrcElmntStrucTP DfsPositionValdtyStartDate Start date
KEY DfsPositionValdtyEndDate I_DFS_PosToFrcElmntStrucTP DfsPositionValdtyEndDate End Date
KEY DfsObjectType I_DFS_PosToFrcElmntStrucTP DfsObjectType Object type
KEY DfsObjectSubType I_DFS_PosToFrcElmntStrucTP DfsObjectSubType Subtype
DfsPositionRelatedObjectID I_DFS_PosToFrcElmntStrucTP DfsPositionRelatedObjectID Related Object ID
DfsObjectSubTypeFoEd I_DFS_PosToFrcElmntStrucTP DfsObjectSubTypeFoEd Subtype
DfsObjectSubTypeName _PositionRelationVH DfsObjectSubTypeName
DfsObjectRelshpPriority I_DFS_PosToFrcElmntStrucTP DfsObjectRelshpPriority Priority
DfsPositionDescRefSqncNmbr I_DFS_PosToFrcElmntStrucTP DfsPositionDescRefSqncNmbr IT record no.
DfsObjectInfoType I_DFS_PosToFrcElmntStrucTP DfsObjectInfoType Infotype
DfsObjectRelshpSpec I_DFS_PosToFrcElmntStrucTP DfsObjectRelshpSpec Relationship
FrcElmntOrgPlngStsCritlty I_DFS_PosToFrcElmntStrucTP FrcElmntOrgPlngStsCritlty
DfsObjectRelshpBtwnObj I_DFS_PosToFrcElmntStrucTP DfsObjectRelshpBtwnObj Related Object ID
DfsPositionRelatedObjectType I_DFS_PosToFrcElmntStrucTP DfsPositionRelatedObjectType Rel.obj.type
DfsObjRelshpLastChgdByUserName I_DFS_PosToFrcElmntStrucTP DfsObjRelshpLastChgdByUserName Percentage
DfsObjRelshpLastChgdByUser I_DFS_PosToFrcElmntStrucTP DfsObjRelshpLastChgdByUser User Name
DfsObjRelshpLastChgdDate I_DFS_PosToFrcElmntStrucTP DfsObjRelshpLastChgdDate Changed on
FrcElmntOrgName _FrcElmntSuplmntyAttrib FrcElmntOrgName Object Name
ForceElementOrgIDFoEd I_DFS_PosToFrcElmntStrucTP ForceElementOrgIDFoEd Related Org ID
DfsPositionRelatedObjectIDFoEd I_DFS_PosToFrcElmntStrucTP DfsPositionRelatedObjectIDFoEd Related Org ID
DfsPositionValdtyStartDateFoEd I_DFS_PosToFrcElmntStrucTP DfsPositionValdtyStartDateFoEd Start date
DfsPositionValdtyEndDateFoEd I_DFS_PosToFrcElmntStrucTP DfsPositionValdtyEndDateFoEd End Date
FrcElmntOrgIsRefFrcElmntOrg I_DFS_PosToFrcElmntStrucTP FrcElmntOrgIsRefFrcElmntOrg RFE Indicator
DfsObjectPlngStatusName _PositionPlngStatusVH DfsObjectPlngStatusName
ForceElementSemanticObject I_DFS_PosToFrcElmntStrucTP ForceElementSemanticObject
FrcElmntOrgPlanDelimitDate FrcElmntOrgPlanDelimitDate Delimit date
FrcElmntOrgPlngStatusName FrcElmntOrgPlngStatusName Planned Delimitation status
DfsAssgmtPlanOpStsCriticality DfsAssgmtPlanOpStsCriticality
_PositionHeaderTP _PositionHeaderTP
_PositionPlngStatusVH _PositionPlngStatusVH
_PositionRelationVH _PositionRelationVH
_PositionFrcElmntOrgVH _PositionFrcElmntOrgVH
_SrceFrcElmntOrgTP _SrceFrcElmntOrgTP
_FrcElmntSuplmntyAttrib _FrcElmntSuplmntyAttrib
_FrcElmntOrgVH _FrcElmntOrgVH

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_DFS_PosToFrcElmntStrucTP.
-- 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: CDFSFESTRUCTP

CREATE VIEW C_DFS_PosToFrcElmntStrucTP AS
SELECT
  PosToFrcElmntStrucTP.DfsObjectID AS DfsObjectID,
  ForceElementOrgID,
  PosToFrcElmntStrucTP.DfsObjectPlanVersion AS DfsObjectPlanVersion,
  PosToFrcElmntStrucTP.DfsObjectPlngStatus AS DfsObjectPlngStatus,
  PosToFrcElmntStrucTP.DfsPositionValdtyStartDate AS DfsPositionValdtyStartDate,
  PosToFrcElmntStrucTP.DfsPositionValdtyEndDate AS DfsPositionValdtyEndDate,
  PosToFrcElmntStrucTP.DfsObjectType AS DfsObjectType,
  PosToFrcElmntStrucTP.DfsObjectSubType AS DfsObjectSubType,
  PosToFrcElmntStrucTP.DfsPositionRelatedObjectID AS DfsPositionRelatedObjectID,
  PosToFrcElmntStrucTP.DfsObjectSubTypeFoEd AS DfsObjectSubTypeFoEd,
  _PositionRelationVH.DfsObjectSubTypeName AS DfsObjectSubTypeName,
  PosToFrcElmntStrucTP.DfsObjectRelshpPriority AS DfsObjectRelshpPriority,
  PosToFrcElmntStrucTP.DfsPositionDescRefSqncNmbr AS DfsPositionDescRefSqncNmbr,
  PosToFrcElmntStrucTP.DfsObjectInfoType AS DfsObjectInfoType,
  PosToFrcElmntStrucTP.DfsObjectRelshpSpec AS DfsObjectRelshpSpec,
  PosToFrcElmntStrucTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  PosToFrcElmntStrucTP.DfsObjectRelshpBtwnObj AS DfsObjectRelshpBtwnObj,
  PosToFrcElmntStrucTP.DfsPositionRelatedObjectType AS DfsPositionRelatedObjectType,
  PosToFrcElmntStrucTP.DfsObjRelshpLastChgdByUserName AS DfsObjRelshpLastChgdByUserName,
  PosToFrcElmntStrucTP.DfsObjRelshpLastChgdByUser AS DfsObjRelshpLastChgdByUser,
  PosToFrcElmntStrucTP.DfsObjRelshpLastChgdDate AS DfsObjRelshpLastChgdDate,
  _FrcElmntSuplmntyAttrib.FrcElmntOrgName AS FrcElmntOrgName,
  PosToFrcElmntStrucTP.ForceElementOrgIDFoEd AS ForceElementOrgIDFoEd,
  PosToFrcElmntStrucTP.DfsPositionRelatedObjectIDFoEd AS DfsPositionRelatedObjectIDFoEd,
  PosToFrcElmntStrucTP.DfsPositionValdtyStartDateFoEd AS DfsPositionValdtyStartDateFoEd,
  PosToFrcElmntStrucTP.DfsPositionValdtyEndDateFoEd AS DfsPositionValdtyEndDateFoEd,
  PosToFrcElmntStrucTP.FrcElmntOrgIsRefFrcElmntOrg AS FrcElmntOrgIsRefFrcElmntOrg,
  _PositionPlngStatusVH.DfsObjectPlngStatusName AS DfsObjectPlngStatusName,
  PosToFrcElmntStrucTP.ForceElementSemanticObject AS ForceElementSemanticObject,
  FrcElmntOrgPlanDelimitDate,
  FrcElmntOrgPlngStatusName,
  DfsAssgmtPlanOpStsCriticality
FROM I_DFS_PosToFrcElmntStrucTP AS PosToFrcElmntStrucTP
LEFT OUTER JOIN C_DFS_PositionHeaderTP AS _PositionHeaderTP ON DfsObjectID = _PositionHeaderTP.DfsPositionID  -- 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 _PositionRelationVH ON _PositionRelationVH.DfsObjectSubType = DfsObjectSubType AND _PositionRelationVH.DfsObjectInfoType = DfsObjectInfoType  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionFrcElmntOrgVH AS _PositionFrcElmntOrgVH ON _PositionFrcElmntOrgVH.DfsPositionID = ForceElementOrgIDFoEd AND _PositionFrcElmntOrgVH.FrcElmntOrgLanguage = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgSuplmntyVrtlElmnt AS _FrcElmntSuplmntyAttrib ON ForceElementOrgIDFoEd = _FrcElmntSuplmntyAttrib.ForceElementOrgID  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgTP AS _SrceFrcElmntOrgTP ON ForceElementOrgID = _SrceFrcElmntOrgTP.ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgVH ON _FrcElmntOrgVH.ForceElementOrgIDForEdit = ForceElementOrgIDFoEd  -- association [0..*]
;

Learn More