C_FrcElmntToProfitCtrRelshpTP

DDL: C_FRCELMNTTOPROFITCTRRELSHPTP SQL: CFEPRFTCTRRLSHP Type: view CONSUMPTION
38 Fields 1 Data Sources 8 Associations

Manage Force Element to Profit Center Assignment

C_FrcElmntToProfitCtrRelshpTP is a Consumption CDS View that provides data about "Manage Force Element to Profit Center Assignment" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntToPrftCostCtrRltnTP) and exposes 38 fields with key fields DfsObjectID, DfsObjectRelatedObjectID, DfsObjectPlngStatus, DfsObjectValdtyStartDate, DfsObjectValdtyEndDate. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntToPrftCostCtrRltnTP FrcElmntToPrftCostCtrRltnTP from

Associations (8)

CardinalityTargetAliasCondition
[1..*] C_FrcElmntOrgVH _FrcElmntOrgVH _FrcElmntOrgVH.ForceElementOrgIDForEdit = $projection.DfsObjectID
[1..1] C_ControllingAreaVH _ControllingAreaVH _ControllingAreaVH.ControllingArea = $projection.FrcElmntOrgControllingArea
[1..1] C_PrftCtrValHelp _ProfitCtrValueHelp _ProfitCtrValueHelp.ProfitCenter = $projection.FrcElmntOrgProfitCenter and _ProfitCtrValueHelp.ControllingArea = $projection.FrcElmntOrgControllingArea
[1..1] I_ProfitCenterStdVH _ProfitCenterStdVH _ProfitCenterStdVH.ProfitCenter = $projection.FrcElmntOrgProfitCenter and _ProfitCenterStdVH.ControllingArea = $projection.FrcElmntOrgControllingArea and _ProfitCenterStdVH.ValidityEndDate >= $session.system_date and _ProfitCenterStdVH.ValidityStartDate <= $session.system_date
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.DfsObjectPlngStatus
[1..*] C_DFS_PosOrgStrucSubTypeVH _PosOrgStrucSubTypeVH $projection.DfsObjectSubType = _PosOrgStrucSubTypeVH.DfsObjectSubType
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlnnOpStatusVH _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = $projection.DfsAssgmtPlanOperationStatus
[1..1] C_DFS_FrcElmntPlndOpTP _FrcElmntPlndOpTP $projection.DfsObjectID = _FrcElmntPlndOpTP.ForceElementOrgID and $projection.DfsObjectValdtyStartDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefStartDate and $projection.DfsObjectValdtyEndDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefEndDate

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CFEPRFTCTRRLSHP 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
EndUserText.label Manage Force Element to Profit Center Assignment view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY DfsObjectID I_FrcElmntToPrftCostCtrRltnTP DfsObjectID Object ID
KEY DfsObjectRelatedObjectID I_FrcElmntToPrftCostCtrRltnTP DfsObjectRelatedObjectID ID rel.object
KEY DfsObjectPlngStatus I_FrcElmntToPrftCostCtrRltnTP DfsObjectPlngStatus Planning status
KEY DfsObjectValdtyStartDate I_FrcElmntToPrftCostCtrRltnTP DfsObjectValdtyStartDate Start date
KEY DfsObjectValdtyEndDate I_FrcElmntToPrftCostCtrRltnTP DfsObjectValdtyEndDate End Date
DfsObjectType I_FrcElmntToPrftCostCtrRltnTP DfsObjectType Object type
DfsObjectPlanVersion I_FrcElmntToPrftCostCtrRltnTP DfsObjectPlanVersion Plan version
DfsObjectRelshpSpec I_FrcElmntToPrftCostCtrRltnTP DfsObjectRelshpSpec Relationship
DfsObjectRelshpBtwnObj I_FrcElmntToPrftCostCtrRltnTP DfsObjectRelshpBtwnObj Relnship
DfsObjectRelshpPriority I_FrcElmntToPrftCostCtrRltnTP DfsObjectRelshpPriority Priority
NumberOfForceElementOrg I_FrcElmntToPrftCostCtrRltnTP NumberOfForceElementOrg IT record no.
DfsObjectInfoType I_FrcElmntToPrftCostCtrRltnTP DfsObjectInfoType Infotype
DfsObjectSubType I_FrcElmntToPrftCostCtrRltnTP DfsObjectSubType Subtype
FrcElmntOrgPlngStsCritlty I_FrcElmntToPrftCostCtrRltnTP FrcElmntOrgPlngStsCritlty
DfsObjectRelatedObjectType I_FrcElmntToPrftCostCtrRltnTP DfsObjectRelatedObjectType Rel.obj.type
DfsObjRelshpLastChgdByUserName I_FrcElmntToPrftCostCtrRltnTP DfsObjRelshpLastChgdByUserName Percentage
DfsObjRelshpLastChgdByUser I_FrcElmntToPrftCostCtrRltnTP DfsObjRelshpLastChgdByUser User Name
DfsObjRelshpLastChgdDate I_FrcElmntToPrftCostCtrRltnTP DfsObjRelshpLastChgdDate Changed on
DfsObjectValdtyStartDateFoEd I_FrcElmntToPrftCostCtrRltnTP DfsObjectValdtyStartDateFoEd Start date
DfsObjectValdtyEndDateFoEd I_FrcElmntToPrftCostCtrRltnTP DfsObjectValdtyEndDateFoEd End Date
FrcElmntOrgControllingArea I_FrcElmntToPrftCostCtrRltnTP FrcElmntOrgControllingArea CO Area
FrcElmntOrgProfitCenter I_FrcElmntToPrftCostCtrRltnTP FrcElmntOrgProfitCenter
ProfitCenterName
ControllingAreaName _ControllingAreaVH ControllingAreaName Long Text
FrcElmntOrgName _FrcElmntOrgVH FrcElmntOrgName Name
FrcElmntOrgPlngStatusName _FrcElmntOrgPlngStsVH FrcElmntOrgPlngStatusName Planning Status
DfsObjectSubTypeName _PosOrgStrucSubTypeVH DfsObjectSubTypeName
ForceElementOrgID I_FrcElmntToPrftCostCtrRltnTP DfsObjectID Object ID
DfsAssgmtPlanStatusObject DfsAssgmtPlanStatusObject Planning status
FrcElmntOrgPlanDelimitDate FrcElmntOrgPlanDelimitDate Planned Delimitation Date
DfsAssgmtPlanOperationStatus _FrcElmntPlndOpTP FrcElmntOrgPlngStatusName Planned Delimitation status
DfsAssgmtPlanOpStsCriticality DfsAssgmtPlanOpStsCriticality
_FrcElmntOrgVH _FrcElmntOrgVH
_ProfitCtrValueHelp _ProfitCtrValueHelp
_ControllingAreaVH _ControllingAreaVH
_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH
_PosOrgStrucSubTypeVH _PosOrgStrucSubTypeVH
_FrcElmntPlndOpTP _FrcElmntPlndOpTP

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_FrcElmntToProfitCtrRelshpTP.
-- 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: CFEPRFTCTRRLSHP

CREATE VIEW C_FrcElmntToProfitCtrRelshpTP AS
SELECT
  FrcElmntToPrftCostCtrRltnTP.DfsObjectID AS DfsObjectID,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectRelatedObjectID AS DfsObjectRelatedObjectID,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectPlngStatus AS DfsObjectPlngStatus,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectValdtyStartDate AS DfsObjectValdtyStartDate,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectValdtyEndDate AS DfsObjectValdtyEndDate,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectType AS DfsObjectType,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectPlanVersion AS DfsObjectPlanVersion,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectRelshpSpec AS DfsObjectRelshpSpec,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectRelshpBtwnObj AS DfsObjectRelshpBtwnObj,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectRelshpPriority AS DfsObjectRelshpPriority,
  FrcElmntToPrftCostCtrRltnTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectInfoType AS DfsObjectInfoType,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectSubType AS DfsObjectSubType,
  FrcElmntToPrftCostCtrRltnTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectRelatedObjectType AS DfsObjectRelatedObjectType,
  FrcElmntToPrftCostCtrRltnTP.DfsObjRelshpLastChgdByUserName AS DfsObjRelshpLastChgdByUserName,
  FrcElmntToPrftCostCtrRltnTP.DfsObjRelshpLastChgdByUser AS DfsObjRelshpLastChgdByUser,
  FrcElmntToPrftCostCtrRltnTP.DfsObjRelshpLastChgdDate AS DfsObjRelshpLastChgdDate,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectValdtyStartDateFoEd AS DfsObjectValdtyStartDateFoEd,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectValdtyEndDateFoEd AS DfsObjectValdtyEndDateFoEd,
  FrcElmntToPrftCostCtrRltnTP.FrcElmntOrgControllingArea AS FrcElmntOrgControllingArea,
  FrcElmntToPrftCostCtrRltnTP.FrcElmntOrgProfitCenter AS FrcElmntOrgProfitCenter,
  _ProfitCenterStdVH._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  _ControllingAreaVH.ControllingAreaName AS ControllingAreaName,
  _FrcElmntOrgVH.FrcElmntOrgName AS FrcElmntOrgName,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _PosOrgStrucSubTypeVH.DfsObjectSubTypeName AS DfsObjectSubTypeName,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectID AS ForceElementOrgID,
  DfsAssgmtPlanStatusObject,
  FrcElmntOrgPlanDelimitDate,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStatusName AS DfsAssgmtPlanOperationStatus,
  DfsAssgmtPlanOpStsCriticality
FROM I_FrcElmntToPrftCostCtrRltnTP AS FrcElmntToPrftCostCtrRltnTP
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgVH ON _FrcElmntOrgVH.ForceElementOrgIDForEdit = DfsObjectID  -- association [1..*]
LEFT OUTER JOIN C_ControllingAreaVH AS _ControllingAreaVH ON _ControllingAreaVH.ControllingArea = FrcElmntOrgControllingArea  -- association [1..1]
LEFT OUTER JOIN C_PrftCtrValHelp AS _ProfitCtrValueHelp ON _ProfitCtrValueHelp.ProfitCenter = FrcElmntOrgProfitCenter AND _ProfitCtrValueHelp.ControllingArea = FrcElmntOrgControllingArea  -- association [1..1]
LEFT OUTER JOIN I_ProfitCenterStdVH AS _ProfitCenterStdVH ON _ProfitCenterStdVH.ProfitCenter = FrcElmntOrgProfitCenter AND _ProfitCenterStdVH.ControllingArea = FrcElmntOrgControllingArea AND _ProfitCenterStdVH.ValidityEndDate >= $session.system_date AND _ProfitCenterStdVH.ValidityStartDate <= $session.system_date  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = DfsObjectPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_DFS_PosOrgStrucSubTypeVH AS _PosOrgStrucSubTypeVH ON DfsObjectSubType = _PosOrgStrucSubTypeVH.DfsObjectSubType  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlnnOpStatusVH ON _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = DfsAssgmtPlanOperationStatus  -- association [1..1]
LEFT OUTER JOIN C_DFS_FrcElmntPlndOpTP AS _FrcElmntPlndOpTP ON DfsObjectID = _FrcElmntPlndOpTP.ForceElementOrgID AND DfsObjectValdtyStartDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefStartDate AND DfsObjectValdtyEndDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefEndDate  -- association [1..1]
;

Learn More