C_FrcElmntToCostCtrRelshpTP

DDL: C_FRCELMNTTOCOSTCTRRELSHPTP SQL: CFECOSTCTRRLSHP Type: view CONSUMPTION
39 Fields 1 Data Sources 7 Associations

C_FrcElmntToCostCtrRelshpTP is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_FrcElmntToPrftCostCtrRltnTP) and exposes 39 fields with key fields DfsObjectID, DfsObjectRelatedObjectID, DfsObjectPlngStatus, DfsObjectValdtyStartDate, DfsObjectValdtyEndDate. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntToPrftCostCtrRltnTP FrcElmntToPrftCostCtrRltnTP from

Associations (7)

CardinalityTargetAliasCondition
[1..*] C_FrcElmntOrgVH _FrcElmntOrgVH _FrcElmntOrgVH.ForceElementOrgIDForEdit = $projection.DfsObjectID
[0..1] C_ControllingAreaVH _ControllingAreaVH $projection.FrcElmntOrgControllingArea = _ControllingAreaVH.ControllingArea
[0..*] I_CostCenterStdVH _CostCtrValueHelp $projection.FrcElmntOrgCostCenter = _CostCtrValueHelp.CostCenter and $projection.FrcElmntOrgControllingArea = _CostCtrValueHelp.ControllingArea
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.DfsObjectPlngStatus
[1..*] C_DFS_PosOrgStrucSubTypeVH _PosOrgStrucSubTypeVH $projection.DfsObjectSubType = _PosOrgStrucSubTypeVH.DfsObjectSubType
[1..1] C_DFS_FrcElmntPlndOpTP _FrcElmntPlndOpTP $projection.DfsObjectID = _FrcElmntPlndOpTP.ForceElementOrgID and $projection.DfsObjectConcatenatedID = _FrcElmntPlndOpTP.FrcElmntOrgConcatenatedID and $projection.FrcElmntOrgCostCenter = _FrcElmntPlndOpTP.FrcElmntOrgRelatedOrgID and $projection.DfsObjectValdtyStartDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefStartDate and $projection.DfsObjectValdtyEndDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefEndDate
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlnnOpStatusVH _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = $projection.DfsAssgmtPlanStatusObject

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CFECOSTCTRRLSHP 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 #XL 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 (39)

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
DfsObjectRelatedObjectType I_FrcElmntToPrftCostCtrRltnTP DfsObjectRelatedObjectType Rel.obj.type
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 Planning Status Criticality
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
FrcElmntOrgCostCenter I_FrcElmntToPrftCostCtrRltnTP FrcElmntOrgCostCenter
FrcElmntOrgName _FrcElmntOrgVH FrcElmntOrgName Name
ControllingAreaName _ControllingAreaVH ControllingAreaName Long Text
FrcElmntOrgPlngStatusName _FrcElmntOrgPlngStsVH FrcElmntOrgPlngStatusName Planning Status
DfsObjectSubTypeName _PosOrgStrucSubTypeVH DfsObjectSubTypeName
CostCenterName
ForceElementOrgID I_FrcElmntToPrftCostCtrRltnTP DfsObjectID Object ID
FrcElmntOrgPlanDelimitDate FrcElmntOrgPlanDelimitDate Delimit date
DfsAssgmtPlanStatusObject I_FrcElmntToPrftCostCtrRltnTP DfsAssgmtPlanStatusObject Planning status
DfsAssgmtPlanOperationStatus _FrcElmntOrgPlnnOpStatusVH FrcElmntOrgPlngStatusName Delimitation status
DfsAssgmtPlanOpStsCriticality DfsAssgmtPlanOpStsCriticality
_FrcElmntOrgVH _FrcElmntOrgVH
_CostCtrValueHelp _CostCtrValueHelp
_ControllingAreaVH _ControllingAreaVH
_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH
_PosOrgStrucSubTypeVH _PosOrgStrucSubTypeVH
_FrcElmntPlndOpTP _FrcElmntPlndOpTP
_FrcElmntOrgPlnnOpStatusVH _FrcElmntOrgPlnnOpStatusVH

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_FrcElmntToCostCtrRelshpTP.
-- 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: CFECOSTCTRRLSHP

CREATE VIEW C_FrcElmntToCostCtrRelshpTP AS
SELECT
  FrcElmntToPrftCostCtrRltnTP.DfsObjectID AS DfsObjectID,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectRelatedObjectID AS DfsObjectRelatedObjectID,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectPlngStatus AS DfsObjectPlngStatus,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectValdtyStartDate AS DfsObjectValdtyStartDate,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectValdtyEndDate AS DfsObjectValdtyEndDate,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectRelatedObjectType AS DfsObjectRelatedObjectType,
  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.DfsObjRelshpLastChgdByUserName AS DfsObjRelshpLastChgdByUserName,
  FrcElmntToPrftCostCtrRltnTP.DfsObjRelshpLastChgdByUser AS DfsObjRelshpLastChgdByUser,
  FrcElmntToPrftCostCtrRltnTP.DfsObjRelshpLastChgdDate AS DfsObjRelshpLastChgdDate,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectValdtyStartDateFoEd AS DfsObjectValdtyStartDateFoEd,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectValdtyEndDateFoEd AS DfsObjectValdtyEndDateFoEd,
  FrcElmntToPrftCostCtrRltnTP.FrcElmntOrgControllingArea AS FrcElmntOrgControllingArea,
  FrcElmntToPrftCostCtrRltnTP.FrcElmntOrgCostCenter AS FrcElmntOrgCostCenter,
  _FrcElmntOrgVH.FrcElmntOrgName AS FrcElmntOrgName,
  _ControllingAreaVH.ControllingAreaName AS ControllingAreaName,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _PosOrgStrucSubTypeVH.DfsObjectSubTypeName AS DfsObjectSubTypeName,
  _CostCtrValueHelp._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  FrcElmntToPrftCostCtrRltnTP.DfsObjectID AS ForceElementOrgID,
  FrcElmntOrgPlanDelimitDate,
  FrcElmntToPrftCostCtrRltnTP.DfsAssgmtPlanStatusObject AS DfsAssgmtPlanStatusObject,
  _FrcElmntOrgPlnnOpStatusVH.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 FrcElmntOrgControllingArea = _ControllingAreaVH.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenterStdVH AS _CostCtrValueHelp ON FrcElmntOrgCostCenter = _CostCtrValueHelp.CostCenter AND FrcElmntOrgControllingArea = _CostCtrValueHelp.ControllingArea  -- association [0..*]
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_DFS_FrcElmntPlndOpTP AS _FrcElmntPlndOpTP ON DfsObjectID = _FrcElmntPlndOpTP.ForceElementOrgID AND DfsObjectConcatenatedID = _FrcElmntPlndOpTP.FrcElmntOrgConcatenatedID AND FrcElmntOrgCostCenter = _FrcElmntPlndOpTP.FrcElmntOrgRelatedOrgID AND DfsObjectValdtyStartDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefStartDate AND DfsObjectValdtyEndDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefEndDate  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlnnOpStatusVH ON _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = DfsAssgmtPlanStatusObject  -- association [1..1]
;

Learn More