What is I_FrcElmntOrgDfsExternalRelshp in SAP S/4HANA?

I_FrcElmntOrgDfsExternalRelshp is a basic CDS view in SAP S/4HANA. Interface View of Force Element External Relshp It contains 37 fields.

Which tables does I_FrcElmntOrgDfsExternalRelshp read from?

I_FrcElmntOrgDfsExternalRelshp reads data from: I_FrcElmntOrgWithAuthorization, I_FrcElmntOrgWithAuthorization, I_FrcElmntOrgWithAuthorization, I_FrcElmntOrgWithAuthorization, P_FrcElmntOrgDfsExternalRelshp and more.

What VDM layer is I_FrcElmntOrgDfsExternalRelshp?

I_FrcElmntOrgDfsExternalRelshp is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_FrcElmntOrgDfsExternalRelshp

DDL: I_FRCELMNTORGDFSEXTERNALRELSHP SQL: IFEORGDFSEXTREL Type: view BASIC

37 Fields 6 Data Sources 1 Associations

Interface View of Force Element External Relshp

I_FrcElmntOrgDfsExternalRelshp is a Basic CDS View that provides data about "Interface View of Force Element External Relshp" in SAP S/4HANA. It reads from 6 data sources and exposes 37 fields with key fields FrcElmntOrgPlanVersion, FrcElmntOrgType, ForceElementOrgID, FrcElmntOrgSubType, FrcElmntOrgPlngStatus. It has 1 association to related views.

Data Sources (6)

Source	Alias	Join Type
I_FrcElmntOrgWithAuthorization	_auth	inner
I_FrcElmntOrgWithAuthorization	_auth	inner
I_FrcElmntOrgWithAuthorization	_auth1	inner
I_FrcElmntOrgWithAuthorization	_auth1	inner
P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgDfsExternalRelshp	from
P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgDfsExternalRelshp	union_all

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	I_FrcElmntOrgRelshpCode	_FrcElmntOrgRelshpCode	`$projection.FrcElmntOrgCnctntdRelshpName = _FrcElmntOrgRelshpCode.FrcElmntOrgSubType`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	IFEORGDFSEXTREL	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Interface View of Force Element External Relshp	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#M	view

Fields (37)

Key	Field	Source Table	Source Field	Description
KEY	FrcElmntOrgPlanVersion	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgPlanVersion	Plan version
KEY	FrcElmntOrgType	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgType	Object type
KEY	ForceElementOrgID	P_FrcElmntOrgDfsExternalRelshp	ForceElementOrgID	Object ID Processor
KEY	FrcElmntOrgSubType	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgSubType	Subtype
KEY	FrcElmntOrgPlngStatus	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgPlngStatus	Planning status
KEY	FrcElmntOrgValdtyStartDate	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgValdtyStartDate	Start date
KEY	FrcElmntOrgValdtyEndDate	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgValdtyEndDate	End Date
KEY	NumberOfForceElementOrg	P_FrcElmntOrgDfsExternalRelshp	NumberOfForceElementOrg	IT record no.
	FrcElmntOrgInfoType	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgInfoType	Infotype
	FrcElmntOrgRelatedOrgType	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgRelatedOrgType	Rel.obj.type
	FrcElmntOrgRelatedOrgID	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgRelatedOrgID	Object ID Processor
	FrcElmntOrgRelshpPriority	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgRelshpPriority	Priority
	FrcElmntOrgCnctntdRelshpName
	FrcElmntOrgLastChgdByUserName	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgLastChgdByUserName	User Name
	DfsAssgmtPlanStatusObject	P_FrcElmntOrgDfsExternalRelshp	DfsAssgmtPlanStatusObject	Planning status
	FrcElmntOrgPlanDelimitDate	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgPlanDelimitDate	Delimit date
	FrcElmntOrgPlngStatusName	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgPlngStatusName	Planning Status
	FrcElmntOrgPlngStsCritlty	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgPlngStsCritlty
	FrcElmntOrgPlanVersion			Plan version
KEY	FrcElmntOrgType	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgType	Object type
KEY	ForceElementOrgID			Object ID Processor
KEY	FrcElmntOrgSubType	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgSubType	Subtype
KEY	FrcElmntOrgPlngStatus	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgPlngStatus	Planning status
KEY	FrcElmntOrgValdtyStartDate	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgValdtyStartDate	Start date
KEY	FrcElmntOrgValdtyEndDate	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgValdtyEndDate	End Date
KEY	NumberOfForceElementOrg	P_FrcElmntOrgDfsExternalRelshp	NumberOfForceElementOrg	IT record no.
	FrcElmntOrgInfoType	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgInfoType	Infotype
	FrcElmntOrgRelatedOrgType	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgRelatedOrgType	Rel.obj.type
	FrcElmntOrgRelatedOrgID	P_FrcElmntOrgDfsExternalRelshp	ForceElementOrgID	Object ID Processor
	FrcElmntOrgRelshpPriority	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgRelshpPriority	Priority
	FrcElmntOrgCnctntdRelshpName
	FrcElmntOrgLastChgdByUserName	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgLastChgdByUserName	User Name
	DfsAssgmtPlanStatusObject	P_FrcElmntOrgDfsExternalRelshp	DfsAssgmtPlanStatusObject	Planning status
	FrcElmntOrgPlanDelimitDate	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgPlanDelimitDate	Delimit date
	FrcElmntOrgPlngStatusName	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgPlngStatusName	Planning Status
	FrcElmntOrgPlngStsCritlty	P_FrcElmntOrgDfsExternalRelshp	FrcElmntOrgPlngStsCritlty
	_FrcElmntOrgRelshpCode		_FrcElmntOrgRelshpCode

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 I_FrcElmntOrgDfsExternalRelshp.
-- 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: IFEORGDFSEXTREL

CREATE VIEW I_FrcElmntOrgDfsExternalRelshp AS
SELECT
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntOrgDfsExternalRelshp.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgDfsExternalRelshp.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelatedOrgType AS FrcElmntOrgRelatedOrgType,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelatedOrgID AS FrcElmntOrgRelatedOrgID,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelshpPriority AS FrcElmntOrgRelshpPriority,
  'A' AS FrcElmntOrgCnctntdRelshpName,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgLastChgdByUserName AS FrcElmntOrgLastChgdByUserName,
  FrcElmntOrgDfsExternalRelshp.DfsAssgmtPlanStatusObject AS DfsAssgmtPlanStatusObject,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlanDelimitDate AS FrcElmntOrgPlanDelimitDate,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty
FROM P_FrcElmntOrgDfsExternalRelshp AS FrcElmntOrgDfsExternalRelshp
INNER JOIN I_FrcElmntOrgWithAuthorization AS _auth ON /* join condition not captured in parsed metadata */
INNER JOIN I_FrcElmntOrgWithAuthorization AS _auth1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FrcElmntOrgRelshpCode AS _FrcElmntOrgRelshpCode ON FrcElmntOrgCnctntdRelshpName = _FrcElmntOrgRelshpCode.FrcElmntOrgSubType  -- association [0..*]
-- UNION ALL with additional select branch(es): P_FrcElmntOrgDfsExternalRelshp
;

Depth:

I_FrcElmntOrgDfsExternalRelshp view