What is C_FrcElmntToCostCtrRelshpList in SAP S/4HANA?

C_FrcElmntToCostCtrRelshpList is a consumption CDS view in SAP S/4HANA. Consumption View of Cost Center Rlnshp It contains 46 fields.

What VDM layer is C_FrcElmntToCostCtrRelshpList?

C_FrcElmntToCostCtrRelshpList is classified as a Consumption view optimized for specific business scenarios and reporting.

C_FrcElmntToCostCtrRelshpList

DDL: C_FRCELMNTTOCOSTCTRRELSHPLIST SQL: CFECSTCTRRLUNON Type: view CONSUMPTION

46 Fields 8 Associations

Consumption View of Cost Center Rlnshp

C_FrcElmntToCostCtrRelshpList is a Consumption CDS View that provides data about "Consumption View of Cost Center Rlnshp" in SAP S/4HANA. It has 8 associations to related views.

Associations (8)

Cardinality	Target	Alias	Condition
[1..1]	C_FrcElmntOrgTP	_FrcElmntOrgTP	`$projection.DfsObjectID = _FrcElmntOrgTP.ForceElementOrgID`
[1..1]	C_ControllingAreaVH	_ControllingAreaVH	`$projection.FrcElmntOrgControllingArea = _ControllingAreaVH.ControllingArea`
[0..1]	C_FrcElmntSuplmntyAttribAssgmt	_SrceFrcElmntOrgTP	`$projection.DfsObjectID = _SrceFrcElmntOrgTP.ForceElementOrgID`
[1..1]	C_FrcElmntOrgPlngStsVH	_FrcElmntOrgPlngStsVH	`_FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.DfsObjectPlngStatus`
[0..*]	I_DFS_TechnicalStatusText	_TechnicalStatusText	`$projection.DfsAssgmtActiveDraft = _TechnicalStatusText.DfsAssgmtTechnicalStatus`
[0..*]	I_CostCenterStdVH	_CostCntrValueHelp	`$projection.FrcElmntOrgCostCenter = _CostCntrValueHelp.CostCenter and $projection.FrcElmntOrgControllingArea = _CostCntrValueHelp.ControllingArea`
[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 and _FrcElmntPlndOpTP.FrcElmntOrgRefSubtype = 'A011'`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CFECSTCTRRLUNON	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Consumption View of Cost Center Rlnshp	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
Metadata.allowExtensions	true	view

Fields (46)

Key	Field	Source Table	Source Field	Description
KEY	DfsObjectID	FrcElmntToProfitCostCtrUnion	DfsObjectID	Object ID
KEY	DfsObjectRelatedObjectID	FrcElmntToProfitCostCtrUnion	DfsObjectRelatedObjectID	Related Object ID
KEY	DfsObjectDraftUUID	FrcElmntToProfitCostCtrUnion	DfsObjectDraftUUID
KEY	DfsObjectValdtyStartDate	FrcElmntToProfitCostCtrUnion	DfsObjectValdtyStartDate	Start date
KEY	DfsObjectValdtyEndDate	FrcElmntToProfitCostCtrUnion	DfsObjectValdtyEndDate	End Date
KEY	DfsObjectPlngStatus	FrcElmntToProfitCostCtrUnion	DfsObjectPlngStatus	Planning status
	DfsObjectPlanVersion	FrcElmntToProfitCostCtrUnion	DfsObjectPlanVersion	Plan version
	DfsAssgmtTechnicalStatusDesc
	DfsAssgmtActiveDraft	FrcElmntToProfitCostCtrUnion	DfsAssgmtActiveDraft
	DfsObjectType	FrcElmntToProfitCostCtrUnion	DfsObjectType	Object type
	DfsObjectRelshpSpec	FrcElmntToProfitCostCtrUnion	DfsObjectRelshpSpec	Relationship
	DfsObjectRelshpBtwnObj	FrcElmntToProfitCostCtrUnion	DfsObjectRelshpBtwnObj	Relnship
	FrcElmntOrgPlngStsCritlty	FrcElmntToProfitCostCtrUnion	FrcElmntOrgPlngStsCritlty	Planning Status Criticality
	DfsObjectRelshpPriority	FrcElmntToProfitCostCtrUnion	DfsObjectRelshpPriority	Priority
	NumberOfForceElementOrg	FrcElmntToProfitCostCtrUnion	NumberOfForceElementOrg	Infotype No
	DfsObjectInfoType	FrcElmntToProfitCostCtrUnion	DfsObjectInfoType	Infotype
	DfsObjectSubType	FrcElmntToProfitCostCtrUnion	DfsObjectSubType	Subtype
	DfsObjectRelatedObjectType	FrcElmntToProfitCostCtrUnion	DfsObjectRelatedObjectType	Related Type
	DfsObjRelshpLastChgdByUserName	FrcElmntToProfitCostCtrUnion	DfsObjRelshpLastChgdByUserName	Last Changed
	DfsObjRelshpLastChgdByUser	FrcElmntToProfitCostCtrUnion	DfsObjRelshpLastChgdByUser	Changed By
	DfsObjRelshpLastChgdDate	FrcElmntToProfitCostCtrUnion	DfsObjRelshpLastChgdDate	Changed On
	IsActiveEntity	FrcElmntToProfitCostCtrUnion	IsActiveEntity	Is active
	FrcElmntOrgPlngStatusName	_FrcElmntOrgPlngStsVH	FrcElmntOrgPlngStatusName	Planning Status
	HasActiveEntity	FrcElmntToProfitCostCtrUnion	HasActiveEntity	TRUE
	HasDraftEntity	FrcElmntToProfitCostCtrUnion	HasDraftEntity	Has Draft
	Criticality	FrcElmntToProfitCostCtrUnion	Criticality	Criticality
	FrcElmntOrgControllingArea	FrcElmntToProfitCostCtrUnion	FrcElmntOrgControllingArea	CO Area
	ControllingArea	FrcElmntToProfitCostCtrUnion	FrcElmntOrgControllingArea	CO Area
	FrcElmntOrgCostCenter	FrcElmntToProfitCostCtrUnion	FrcElmntOrgCostCenter
	FrcElmntOrgType			Organizational Type
	ForceElementOrgUUID	_SrceFrcElmntOrgTP	ForceElementOrgUUID	GUID 32
	FrcElmntOrgName	_SrceFrcElmntOrgTP	FrcElmntOrgName	Object Name
	FrcElmntOrgPlanVersion	_SrceFrcElmntOrgTP	FrcElmntOrgPlanVersion	Plan version
	FrcElmntOrgSymbol	_SrceFrcElmntOrgTP	FrcElmntOrgSymbol	Symbol Code
	ForceElementOrgID	_SrceFrcElmntOrgTP	ForceElementOrgID	Object ID Processor
	_SrceFrcElmntOrgTP		_SrceFrcElmntOrgTP
	CostCenterName
	DfsAssgmtPlanStatusObject		DfsAssgmtPlanStatusObject	Planning status
	FrcElmntOrgPlanDelimitDate		FrcElmntOrgPlanDelimitDate	Delimit date
	DfsAssgmtPlanOperationStatus	_FrcElmntPlndOpTP	FrcElmntOrgPlngStatusName	Planned Delimitation status
	DfsAssgmtPlanOpStsCriticality	_FrcElmntPlndOpTP	FrcElmntOrgPlngStsCritlty
	ControllingAreaName	_ControllingAreaVH	ControllingAreaName	Long Text
	_FrcElmntOrgTP		_FrcElmntOrgTP
	_FrcElmntOrgPlngStsVH		_FrcElmntOrgPlngStsVH
	_CostCntrValueHelp		_CostCntrValueHelp
	_ControllingAreaVH		_ControllingAreaVH

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_FrcElmntToCostCtrRelshpList.
-- 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: CFECSTCTRRLUNON

CREATE VIEW C_FrcElmntToCostCtrRelshpList AS
SELECT
  FrcElmntToProfitCostCtrUnion.DfsObjectID AS DfsObjectID,
  FrcElmntToProfitCostCtrUnion.DfsObjectRelatedObjectID AS DfsObjectRelatedObjectID,
  FrcElmntToProfitCostCtrUnion.DfsObjectDraftUUID AS DfsObjectDraftUUID,
  FrcElmntToProfitCostCtrUnion.DfsObjectValdtyStartDate AS DfsObjectValdtyStartDate,
  FrcElmntToProfitCostCtrUnion.DfsObjectValdtyEndDate AS DfsObjectValdtyEndDate,
  FrcElmntToProfitCostCtrUnion.DfsObjectPlngStatus AS DfsObjectPlngStatus,
  FrcElmntToProfitCostCtrUnion.DfsObjectPlanVersion AS DfsObjectPlanVersion,
  _TechnicalStatusText[1:Language=$session.system_language].DfsAssgmtTechnicalStatusDesc AS DfsAssgmtTechnicalStatusDesc,
  FrcElmntToProfitCostCtrUnion.DfsAssgmtActiveDraft AS DfsAssgmtActiveDraft,
  FrcElmntToProfitCostCtrUnion.DfsObjectType AS DfsObjectType,
  FrcElmntToProfitCostCtrUnion.DfsObjectRelshpSpec AS DfsObjectRelshpSpec,
  FrcElmntToProfitCostCtrUnion.DfsObjectRelshpBtwnObj AS DfsObjectRelshpBtwnObj,
  FrcElmntToProfitCostCtrUnion.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  FrcElmntToProfitCostCtrUnion.DfsObjectRelshpPriority AS DfsObjectRelshpPriority,
  FrcElmntToProfitCostCtrUnion.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntToProfitCostCtrUnion.DfsObjectInfoType AS DfsObjectInfoType,
  FrcElmntToProfitCostCtrUnion.DfsObjectSubType AS DfsObjectSubType,
  FrcElmntToProfitCostCtrUnion.DfsObjectRelatedObjectType AS DfsObjectRelatedObjectType,
  FrcElmntToProfitCostCtrUnion.DfsObjRelshpLastChgdByUserName AS DfsObjRelshpLastChgdByUserName,
  FrcElmntToProfitCostCtrUnion.DfsObjRelshpLastChgdByUser AS DfsObjRelshpLastChgdByUser,
  FrcElmntToProfitCostCtrUnion.DfsObjRelshpLastChgdDate AS DfsObjRelshpLastChgdDate,
  FrcElmntToProfitCostCtrUnion.IsActiveEntity AS IsActiveEntity,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  FrcElmntToProfitCostCtrUnion.HasActiveEntity AS HasActiveEntity,
  FrcElmntToProfitCostCtrUnion.HasDraftEntity AS HasDraftEntity,
  FrcElmntToProfitCostCtrUnion.Criticality AS Criticality,
  FrcElmntToProfitCostCtrUnion.FrcElmntOrgControllingArea AS FrcElmntOrgControllingArea,
  FrcElmntToProfitCostCtrUnion.FrcElmntOrgControllingArea AS ControllingArea,
  FrcElmntToProfitCostCtrUnion.FrcElmntOrgCostCenter AS FrcElmntOrgCostCenter,
  _SrceFrcElmntOrgTP. FrcElmntOrgType AS FrcElmntOrgType,
  _SrceFrcElmntOrgTP.ForceElementOrgUUID AS ForceElementOrgUUID,
  _SrceFrcElmntOrgTP.FrcElmntOrgName AS FrcElmntOrgName,
  _SrceFrcElmntOrgTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  _SrceFrcElmntOrgTP.FrcElmntOrgSymbol AS FrcElmntOrgSymbol,
  _SrceFrcElmntOrgTP.ForceElementOrgID AS ForceElementOrgID,
  _CostCntrValueHelp._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  DfsAssgmtPlanStatusObject,
  FrcElmntOrgPlanDelimitDate,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStatusName AS DfsAssgmtPlanOperationStatus,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStsCritlty AS DfsAssgmtPlanOpStsCriticality,
  _ControllingAreaVH.ControllingAreaName AS ControllingAreaName
LEFT OUTER JOIN C_FrcElmntOrgTP AS _FrcElmntOrgTP ON DfsObjectID = _FrcElmntOrgTP.ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_ControllingAreaVH AS _ControllingAreaVH ON FrcElmntOrgControllingArea = _ControllingAreaVH.ControllingArea  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntSuplmntyAttribAssgmt AS _SrceFrcElmntOrgTP ON DfsObjectID = _SrceFrcElmntOrgTP.ForceElementOrgID  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = DfsObjectPlngStatus  -- association [1..1]
LEFT OUTER JOIN I_DFS_TechnicalStatusText AS _TechnicalStatusText ON DfsAssgmtActiveDraft = _TechnicalStatusText.DfsAssgmtTechnicalStatus  -- association [0..*]
LEFT OUTER JOIN I_CostCenterStdVH AS _CostCntrValueHelp ON FrcElmntOrgCostCenter = _CostCntrValueHelp.CostCenter AND FrcElmntOrgControllingArea = _CostCntrValueHelp.ControllingArea  -- association [0..*]
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 AND _FrcElmntPlndOpTP.FrcElmntOrgRefSubtype = 'A011'  -- association [1..1]
;

Depth:

C_FrcElmntToCostCtrRelshpList view