What is C_FrcElmntToWBSElmntTP in SAP S/4HANA?

C_FrcElmntToWBSElmntTP is a consumption CDS view in SAP S/4HANA. Manage Force Element to WBS Element Assignment It contains 40 fields.

Which tables does C_FrcElmntToWBSElmntTP read from?

C_FrcElmntToWBSElmntTP reads data from: I_FrcElmntToWBSElmntTP.

What VDM layer is C_FrcElmntToWBSElmntTP?

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

C_FrcElmntToWBSElmntTP

DDL: C_FRCELMNTTOWBSELMNTTP SQL: CFEWBSELMNTASMT Type: view CONSUMPTION

40 Fields 1 Data Sources 7 Associations

Manage Force Element to WBS Element Assignment

C_FrcElmntToWBSElmntTP is a Consumption CDS View that provides data about "Manage Force Element to WBS Element Assignment" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntToWBSElmntTP) and exposes 40 fields with key fields ForceElementOrgID, FrcElmntOrgRelatedOrgID, FrcElmntOrgPlngStatus, FrcElmntOrgValdtyStartDate, FrcElmntOrgValdtyEndDate. It has 7 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_FrcElmntToWBSElmntTP	FrcElmntToWBSElmntTP	from

Associations (7)

Cardinality	Target	Alias	Condition
[1..*]	C_FrcElmntOrgVH	_FrcElmntOrgVH	`_FrcElmntOrgVH.ForceElementOrgIDForEdit = $projection.ForceElementOrgID`
[1..1]	C_FrcElmntOrgProjectVH	_FrcElmntOrgProjectVH	`$projection.Project = _FrcElmntOrgProjectVH.Project`
[1..1]	C_WBSElementVH	_WBSElementVH	`$projection.WBSElementExternalID = _WBSElementVH.WBSElement`
[1..1]	C_FrcElmntOrgPlngStsVH	_FrcElmntOrgPlngStsVH	`_FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.FrcElmntOrgPlngStatus`
[0..*]	I_FrcElmntOrgSubType	_FrcElmntOrgSubType	`_FrcElmntOrgSubType.FrcElmntOrgSubType = $projection.FrcElmntOrgSubType and _FrcElmntOrgSubType.FrcElmntOrgInfoType = '1001'`
[1..1]	C_DFS_FrcElmntPlndOpTP	_FrcElmntPlndOpTP	`$projection.ForceElementOrgID = _FrcElmntPlndOpTP.ForceElementOrgID and $projection.FrcElmntOrgValdtyStartDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefStartDate and $projection.FrcElmntOrgValdtyEndDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefEndDate and $projection.FrcElmntOrgSubType = _FrcElmntPlndOpTP.FrcElmntOrgRefSubtype and _FrcElmntPlndOpTP.FrcElmntOrgRefInfoType = '1001'`
[1..1]	C_FrcElmntOrgPlngStsVH	_FrcElmntOrgPlnnOpStatusVH	`_FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = $projection.DfsAssgmtPlanStatusObject`

Annotations (17)

Name	Value	Level
AbapCatalog.sqlViewName	CFEWBSELMNTASMT	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	#M	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 WBS Element Assignment	view

Fields (40)

Key	Field	Source Table	Source Field	Description
KEY	ForceElementOrgID	I_FrcElmntToWBSElmntTP	ForceElementOrgID	Object ID Processor
KEY	FrcElmntOrgRelatedOrgID	I_FrcElmntToWBSElmntTP	FrcElmntOrgRelatedOrgID	ID rel.object
KEY	FrcElmntOrgPlngStatus	I_FrcElmntToWBSElmntTP	FrcElmntOrgPlngStatus	Planning status
KEY	FrcElmntOrgValdtyStartDate	I_FrcElmntToWBSElmntTP	FrcElmntOrgValdtyStartDate	Start date
KEY	FrcElmntOrgValdtyEndDate	I_FrcElmntToWBSElmntTP	FrcElmntOrgValdtyEndDate	End Date
	FrcElmntOrgType	I_FrcElmntToWBSElmntTP	FrcElmntOrgType	Object type
	FrcElmntOrgPlanVersion	I_FrcElmntToWBSElmntTP	FrcElmntOrgPlanVersion	Plan version
	FrcElmntOrgRelshpSpec	I_FrcElmntToWBSElmntTP	FrcElmntOrgRelshpSpec	Relationship
	FrcElmntOrgRelshpBtwnObj	I_FrcElmntToWBSElmntTP	FrcElmntOrgRelshpBtwnObj	Relnship
	FrcElmntOrgRelshpPriority	I_FrcElmntToWBSElmntTP	FrcElmntOrgRelshpPriority	Priority
	NumberOfForceElementOrg	I_FrcElmntToWBSElmntTP	NumberOfForceElementOrg	IT record no.
	FrcElmntOrgInfoType	I_FrcElmntToWBSElmntTP	FrcElmntOrgInfoType	Infotype
	FrcElmntOrgSubType	I_FrcElmntToWBSElmntTP	FrcElmntOrgSubType	Subtype
	FrcElmntOrgSubTypeName
	FrcElmntOrgPlngStsCritlty	I_FrcElmntToWBSElmntTP	FrcElmntOrgPlngStsCritlty
	FrcElmntOrgRelatedOrgType	I_FrcElmntToWBSElmntTP	FrcElmntOrgRelatedOrgType	Rel.obj.type
	FrcElmntOrgLastChgdByUser	I_FrcElmntToWBSElmntTP	FrcElmntOrgLastChgdByUser	User Name
	WBSElementInternalID	I_FrcElmntToWBSElmntTP	WBSElementInternalID	WBS Internal ID
	WBSElementExternalID	I_FrcElmntToWBSElmntTP	WBSElementExternalID	WBS Element External ID
	WBSElement	I_FrcElmntToWBSElmntTP	WBSElement	WBS Internal ID
	ProjectProfileCode	I_FrcElmntToWBSElmntTP	ProjectProfileCode	Project Profile
	ProjectInternalID	I_FrcElmntToWBSElmntTP	ProjectInternalID	Project Def.
	ProjectExternalID	I_FrcElmntToWBSElmntTP	ProjectExternalID	Project def.
	Project	I_FrcElmntToWBSElmntTP	Project	WBS Element
	ProjectProfileCodeText	I_FrcElmntToWBSElmntTP	ProjectProfileCodeText	Description
	FrcElmntOrgValdtyStartDateFoEd	I_FrcElmntToWBSElmntTP	FrcElmntOrgValdtyStartDateFoEd	Start date
	FrcElmntOrgValdtyEndDateFoEd	I_FrcElmntToWBSElmntTP	FrcElmntOrgValdtyEndDateFoEd	End Date
	FrcElmntOrgName	_FrcElmntOrgVH	FrcElmntOrgName	Name
	ProjectDescription	_FrcElmntOrgProjectVH	ProjectDescription	Project Name
	WBSDescription	_WBSElementVH	WBSDescription	WBS Element Name
	FrcElmntOrgPlngStatusName	_FrcElmntOrgPlngStsVH	FrcElmntOrgPlngStatusName	Planning Status
	FrcElmntOrgPlanDelimitDate		FrcElmntOrgPlanDelimitDate	Delimit date
	DfsAssgmtPlanStatusObject		DfsAssgmtPlanStatusObject	Planning status
	DfsAssgmtPlanOperationStatus	_FrcElmntOrgPlnnOpStatusVH	FrcElmntOrgPlngStatusName	Planned Delimitation status
	DfsAssgmtPlanOpStsCriticality		DfsAssgmtPlanOpStsCriticality
	_FrcElmntOrgVH		_FrcElmntOrgVH
	_FrcElmntOrgProjectVH		_FrcElmntOrgProjectVH
	_WBSElementVH		_WBSElementVH
	_FrcElmntOrgPlngStsVH		_FrcElmntOrgPlngStsVH
	_FrcElmntOrgSubType		_FrcElmntOrgSubType

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_FrcElmntToWBSElmntTP.
-- 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: CFEWBSELMNTASMT

CREATE VIEW C_FrcElmntToWBSElmntTP AS
SELECT
  FrcElmntToWBSElmntTP.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntToWBSElmntTP.FrcElmntOrgRelatedOrgID AS FrcElmntOrgRelatedOrgID,
  FrcElmntToWBSElmntTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntToWBSElmntTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntToWBSElmntTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntToWBSElmntTP.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntToWBSElmntTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntToWBSElmntTP.FrcElmntOrgRelshpSpec AS FrcElmntOrgRelshpSpec,
  FrcElmntToWBSElmntTP.FrcElmntOrgRelshpBtwnObj AS FrcElmntOrgRelshpBtwnObj,
  FrcElmntToWBSElmntTP.FrcElmntOrgRelshpPriority AS FrcElmntOrgRelshpPriority,
  FrcElmntToWBSElmntTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntToWBSElmntTP.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntToWBSElmntTP.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  _FrcElmntOrgSubType._FrcElmntOrgSubTypeText[1:FrcElmntOrgLanguage=$session.system_language].FrcElmntOrgSubTypeName AS FrcElmntOrgSubTypeName,
  FrcElmntToWBSElmntTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  FrcElmntToWBSElmntTP.FrcElmntOrgRelatedOrgType AS FrcElmntOrgRelatedOrgType,
  FrcElmntToWBSElmntTP.FrcElmntOrgLastChgdByUser AS FrcElmntOrgLastChgdByUser,
  FrcElmntToWBSElmntTP.WBSElementInternalID AS WBSElementInternalID,
  FrcElmntToWBSElmntTP.WBSElementExternalID AS WBSElementExternalID,
  FrcElmntToWBSElmntTP.WBSElement AS WBSElement,
  FrcElmntToWBSElmntTP.ProjectProfileCode AS ProjectProfileCode,
  FrcElmntToWBSElmntTP.ProjectInternalID AS ProjectInternalID,
  FrcElmntToWBSElmntTP.ProjectExternalID AS ProjectExternalID,
  FrcElmntToWBSElmntTP.Project AS Project,
  FrcElmntToWBSElmntTP.ProjectProfileCodeText AS ProjectProfileCodeText,
  FrcElmntToWBSElmntTP.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntToWBSElmntTP.FrcElmntOrgValdtyEndDateFoEd AS FrcElmntOrgValdtyEndDateFoEd,
  _FrcElmntOrgVH.FrcElmntOrgName AS FrcElmntOrgName,
  _FrcElmntOrgProjectVH.ProjectDescription AS ProjectDescription,
  _WBSElementVH.WBSDescription AS WBSDescription,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  FrcElmntOrgPlanDelimitDate,
  DfsAssgmtPlanStatusObject,
  _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatusName AS DfsAssgmtPlanOperationStatus,
  DfsAssgmtPlanOpStsCriticality
FROM I_FrcElmntToWBSElmntTP AS FrcElmntToWBSElmntTP
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgVH ON _FrcElmntOrgVH.ForceElementOrgIDForEdit = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgProjectVH AS _FrcElmntOrgProjectVH ON Project = _FrcElmntOrgProjectVH.Project  -- association [1..1]
LEFT OUTER JOIN C_WBSElementVH AS _WBSElementVH ON WBSElementExternalID = _WBSElementVH.WBSElement  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN I_FrcElmntOrgSubType AS _FrcElmntOrgSubType ON _FrcElmntOrgSubType.FrcElmntOrgSubType = FrcElmntOrgSubType AND _FrcElmntOrgSubType.FrcElmntOrgInfoType = '1001'  -- association [0..*]
LEFT OUTER JOIN C_DFS_FrcElmntPlndOpTP AS _FrcElmntPlndOpTP ON ForceElementOrgID = _FrcElmntPlndOpTP.ForceElementOrgID AND FrcElmntOrgValdtyStartDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefStartDate AND FrcElmntOrgValdtyEndDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefEndDate AND FrcElmntOrgSubType = _FrcElmntPlndOpTP.FrcElmntOrgRefSubtype AND _FrcElmntPlndOpTP.FrcElmntOrgRefInfoType = '1001'  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlnnOpStatusVH ON _FrcElmntOrgPlnnOpStatusVH.FrcElmntOrgPlngStatus = DfsAssgmtPlanStatusObject  -- association [1..1]
;

Depth:

C_FrcElmntToWBSElmntTP view

I_FrcElmntToWBSElmntTP view