What is C_FrcElmntOrgNodeInfo in SAP S/4HANA?

C_FrcElmntOrgNodeInfo is a consumption CDS view in SAP S/4HANA. Force Element Organization Information It contains 42 fields.

Which tables does C_FrcElmntOrgNodeInfo read from?

C_FrcElmntOrgNodeInfo reads data from: I_FrcElmntOrgNtwkGraphNodes.

What VDM layer is C_FrcElmntOrgNodeInfo?

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

C_FrcElmntOrgNodeInfo

DDL: C_FRCELMNTORGNODEINFO SQL: CFEORGNODEINFO Type: view CONSUMPTION

42 Fields 1 Data Sources 4 Associations

Force Element Organization Information

C_FrcElmntOrgNodeInfo is a Consumption CDS View that provides data about "Force Element Organization Information" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntOrgNtwkGraphNodes) and exposes 42 fields with key field ForceElementOrgID. It has 4 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgNodeInfo	from

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	C_FrcElmntOrgNtwkGraphNodes	_FrcElmntOrgNtwkGraphNodes	`$projection.ForceElementOrgID = _FrcElmntOrgNtwkGraphNodes.ForceElementOrgID`
[1..*]	C_FrcElmntOrgNtwkGraphRelshp	_FrcElmntOrgNtwkGraphRelshp	`$projection.ForceElementOrgID = _FrcElmntOrgNtwkGraphRelshp.ForceElementOrgID`
[1..1]	C_FrcElmntOrgPlngStsVH	_FrcElmntOrgPlngStsVH	`$projection.FrcElmntOrgPlngStatus = _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus`
[1..*]	I_DFS_SenstvyClfnFrcElmnt	_SenstvyClfn	`_SenstvyClfn.ForceElementOrgID = $projection.ForceElementOrgID`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CFEORGNODEINFO	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	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.compositionRoot	true	view
Search.searchable	true	view
Consumption.ranked	true	view
EndUserText.label	Force Element Organization Information	view

Fields (42)

Key	Field	Source Table	Source Field	Description
KEY	ForceElementOrgID	I_FrcElmntOrgNtwkGraphNodes	ForceElementOrgID	Object ID Processor
	ForceElementOrgUUID	I_FrcElmntOrgNtwkGraphNodes	ForceElementOrgUUID	GUID 32
	NumberOfForceElementOrg	I_FrcElmntOrgNtwkGraphNodes	NumberOfForceElementOrg	IT record no.
	FrcElmntOrgPlanVersion	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgPlanVersion	Plan version
	FrcElmntOrgType	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgType	Object type
	FrcElmntOrgStockPlant	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgStockPlant	Plant
	FrcElmntOrgMRPStockArea	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgMRPStockArea	MRP Stock Area
	FrcElmntOrgIsAccountable	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgIsAccountable	Accountable
	FrcElmntOrgProvisionsPlant	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgProvisionsPlant	Plant
	FrcElmntOrgPrvsnMRPArea	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgPrvsnMRPArea	Provis MRP Area
	FrcElmntOrgIsStockHolding	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgIsStockHolding	Stockholding
	FrcElmntOrgInitSupSts	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgInitSupSts	Initial Supply Sts
	FrcElmntOrgPurgOrg	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgPurgOrg	Purchasing Org.
	FrcElmntOrgPurgGroup	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgPurgGroup	Purch. Group
	FrcElmntOrgStockStorageLoc	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgStockStorageLoc	Location
	FrcElmntOrgMatlRdnssPct	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgMatlRdnssPct	Readiness (Material)
	FrcElmntOrgPrsnlRdnssPct	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgPrsnlRdnssPct	Readiness (Prsnl)
	FrcElmntOrgTrngRdnssPct	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgTrngRdnssPct	Readiness (Training)
	FrcElmntOrgPriority	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgPriority	Organizational Prio.
	FrcElmntOrgLogsLevel	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgLogsLevel	Log. Level
	FrcElmntOrgInfrstrucPlant	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgInfrstrucPlant	Plant
	FrcElmOrgInfrMRPArea	I_FrcElmntOrgNtwkGraphNodes	FrcElmOrgInfrMRPArea	Infra. MRP Area
	FrcElmOrgInfrStorLoc	I_FrcElmntOrgNtwkGraphNodes	FrcElmOrgInfrStorLoc	Location
	FrcElmntOrgLastChgdByUser	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgLastChgdByUser	User Name
	FrcElmntOrgLastChgdDate	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgLastChgdDate	Changed on
	FrcElmntOrgCreatedByUser	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgCreatedByUser	Created by
	FrcElmntOrgCreationDate	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgCreationDate	Created On
	FrcElmntOrgLogicalSystem	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgLogicalSystem	Logical System
	FrcElmntOrgName	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgName	Name
	FrcElmntOrgIsRefFrcElmntOrg	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgIsRefFrcElmntOrg	RFE Indicator
	FrcElmntOrgPlngStatus	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgPlngStatus	Planning status
	FrcElmntOrgValdtyStartDate	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgValdtyStartDate	Start date
	FrcElmntOrgValdtyEndDate	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgValdtyEndDate	End Date
	FrcElmntOrgArea	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgArea	Org. Area
	FrcElmntOrgIsAgency	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgIsAgency	Boolean Variable (X = True, - = False, Space = Unknown)
	FrcElmntOrgSymbol	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgSymbol	SC
	FrcElmntOrgSubType	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgSubType	Subtype
	FrcElmntOrgUsageType	I_FrcElmntOrgNtwkGraphNodes	FrcElmntOrgUsageType	Usage Type
	FrcElmntOrgPlngStatusName	_FrcElmntOrgPlngStsVH	FrcElmntOrgPlngStatusName	Planning Status
	_FrcElmntOrgNtwkGraphNodes		_FrcElmntOrgNtwkGraphNodes
	_FrcElmntOrgNtwkGraphRelshp		_FrcElmntOrgNtwkGraphRelshp
	_SenstvyClfn		_SenstvyClfn

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_FrcElmntOrgNodeInfo.
-- 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: CFEORGNODEINFO

CREATE VIEW C_FrcElmntOrgNodeInfo AS
SELECT
  FrcElmntOrgNodeInfo.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntOrgNodeInfo.ForceElementOrgUUID AS ForceElementOrgUUID,
  FrcElmntOrgNodeInfo.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntOrgNodeInfo.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntOrgNodeInfo.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntOrgNodeInfo.FrcElmntOrgStockPlant AS FrcElmntOrgStockPlant,
  FrcElmntOrgNodeInfo.FrcElmntOrgMRPStockArea AS FrcElmntOrgMRPStockArea,
  FrcElmntOrgNodeInfo.FrcElmntOrgIsAccountable AS FrcElmntOrgIsAccountable,
  FrcElmntOrgNodeInfo.FrcElmntOrgProvisionsPlant AS FrcElmntOrgProvisionsPlant,
  FrcElmntOrgNodeInfo.FrcElmntOrgPrvsnMRPArea AS FrcElmntOrgPrvsnMRPArea,
  FrcElmntOrgNodeInfo.FrcElmntOrgIsStockHolding AS FrcElmntOrgIsStockHolding,
  FrcElmntOrgNodeInfo.FrcElmntOrgInitSupSts AS FrcElmntOrgInitSupSts,
  FrcElmntOrgNodeInfo.FrcElmntOrgPurgOrg AS FrcElmntOrgPurgOrg,
  FrcElmntOrgNodeInfo.FrcElmntOrgPurgGroup AS FrcElmntOrgPurgGroup,
  FrcElmntOrgNodeInfo.FrcElmntOrgStockStorageLoc AS FrcElmntOrgStockStorageLoc,
  FrcElmntOrgNodeInfo.FrcElmntOrgMatlRdnssPct AS FrcElmntOrgMatlRdnssPct,
  FrcElmntOrgNodeInfo.FrcElmntOrgPrsnlRdnssPct AS FrcElmntOrgPrsnlRdnssPct,
  FrcElmntOrgNodeInfo.FrcElmntOrgTrngRdnssPct AS FrcElmntOrgTrngRdnssPct,
  FrcElmntOrgNodeInfo.FrcElmntOrgPriority AS FrcElmntOrgPriority,
  FrcElmntOrgNodeInfo.FrcElmntOrgLogsLevel AS FrcElmntOrgLogsLevel,
  FrcElmntOrgNodeInfo.FrcElmntOrgInfrstrucPlant AS FrcElmntOrgInfrstrucPlant,
  FrcElmntOrgNodeInfo.FrcElmOrgInfrMRPArea AS FrcElmOrgInfrMRPArea,
  FrcElmntOrgNodeInfo.FrcElmOrgInfrStorLoc AS FrcElmOrgInfrStorLoc,
  FrcElmntOrgNodeInfo.FrcElmntOrgLastChgdByUser AS FrcElmntOrgLastChgdByUser,
  FrcElmntOrgNodeInfo.FrcElmntOrgLastChgdDate AS FrcElmntOrgLastChgdDate,
  FrcElmntOrgNodeInfo.FrcElmntOrgCreatedByUser AS FrcElmntOrgCreatedByUser,
  FrcElmntOrgNodeInfo.FrcElmntOrgCreationDate AS FrcElmntOrgCreationDate,
  FrcElmntOrgNodeInfo.FrcElmntOrgLogicalSystem AS FrcElmntOrgLogicalSystem,
  FrcElmntOrgNodeInfo.FrcElmntOrgName AS FrcElmntOrgName,
  FrcElmntOrgNodeInfo.FrcElmntOrgIsRefFrcElmntOrg AS FrcElmntOrgIsRefFrcElmntOrg,
  FrcElmntOrgNodeInfo.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntOrgNodeInfo.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgNodeInfo.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgNodeInfo.FrcElmntOrgArea AS FrcElmntOrgArea,
  FrcElmntOrgNodeInfo.FrcElmntOrgIsAgency AS FrcElmntOrgIsAgency,
  FrcElmntOrgNodeInfo.FrcElmntOrgSymbol AS FrcElmntOrgSymbol,
  FrcElmntOrgNodeInfo.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntOrgNodeInfo.FrcElmntOrgUsageType AS FrcElmntOrgUsageType,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName
FROM I_FrcElmntOrgNtwkGraphNodes AS FrcElmntOrgNodeInfo
LEFT OUTER JOIN C_FrcElmntOrgNtwkGraphNodes AS _FrcElmntOrgNtwkGraphNodes ON ForceElementOrgID = _FrcElmntOrgNtwkGraphNodes.ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgNtwkGraphRelshp AS _FrcElmntOrgNtwkGraphRelshp ON ForceElementOrgID = _FrcElmntOrgNtwkGraphRelshp.ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON FrcElmntOrgPlngStatus = _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN I_DFS_SenstvyClfnFrcElmnt AS _SenstvyClfn ON _SenstvyClfn.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
;

Depth:

C_FrcElmntOrgNodeInfo view

I_FrcElmntOrgNtwkGraphNodes view