I_FrcElmntOrgExternalRelshpTP

DDL: I_FRCELMNTORGEXTERNALRELSHPTP SQL: IFEORGDFSEXTTP Type: view TRANSACTIONAL
31 Fields 1 Data Sources 1 Associations

Transactional View of Force Element External Relshp

I_FrcElmntOrgExternalRelshpTP is a Transactional CDS View that provides data about "Transactional View of Force Element External Relshp" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntOrgExtRelshpWithDrft) and exposes 31 fields with key fields FrcElmntOrgRelatedOrgID, FrcElmntOrgValdtyStartDate, FrcElmntOrgValdtyEndDate, FrcElmntOrgSubType, FrcElmntOrgPlngStatus. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgExternalRelshpTP from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_FrcElmntOrgNameTP _FrcElmntOrgNameTP _FrcElmntOrgNameTP.ForceElementOrgID = $projection.ForceElementOrgID and _FrcElmntOrgNameTP.FrcElmntOrgLanguage = $session.system_language and ( _FrcElmntOrgNameTP.FrcElmntOrgValdtyStartDate <= $session.system_date and _FrcElmntOrgNameTP.FrcElmntOrgValdtyEndDate >= $session.system_date and _FrcElmntOrgNameTP.FrcElmntOrgPlngStatus = '1' )

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName IFEORGDFSEXTTP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transactional View of Force Element External Relshp view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name ForceElementOrganization view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence DFS_FE_RELSHP_D view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgRelatedOrgID I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgRelatedOrgID ID rel.object
KEY FrcElmntOrgValdtyStartDate I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgValdtyStartDate Start date
KEY FrcElmntOrgValdtyEndDate I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgValdtyEndDate End Date
KEY FrcElmntOrgSubType I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgSubType Subtype
KEY FrcElmntOrgPlngStatus I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgPlngStatus Planning status
KEY FrcElmntOrgDraftUUID I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgDraftUUID UUID
ForceElementOrgID I_FrcElmntOrgExtRelshpWithDrft ForceElementOrgID Object ID Processor
FrcElmntOrgPlngStatusFoEd I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgPlngStatusFoEd
FrcElmntOrgPlanVersion I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgPlanVersion Plan version
FrcElmntOrgType I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgType Object type
NumberOfForceElementOrg I_FrcElmntOrgExtRelshpWithDrft NumberOfForceElementOrg IT record no.
FrcElmntOrgInfoType I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgInfoType Infotype
FrcElmntOrgRelatedOrgType I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgRelatedOrgType Rel.obj.type
FrcElmntOrgRelshpPriority I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgRelshpPriority Priority
FrcElmntOrgCnctntdRelshpName I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgCnctntdRelshpName
FrcElmntOrgRelshpDesc I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgRelshpDesc Relationship
FrcElmntOrgLastChgdByUserName I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgLastChgdByUserName User Name
ForceElementOrgIDForEdit I_FrcElmntOrgExtRelshpWithDrft ForceElementOrgID Object ID Processor
FrcElmntOrgRelatedOrgIDForEdit I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgRelatedOrgID ID rel.object
FrcElmntOrgValdtyStartDateFoEd I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgValdtyStartDate Start date
FrcElmntOrgValdtyEndDateFoEd I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgValdtyEndDate End Date
FrcElmntOrgPlngStatusForEdit I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgPlngStatus Planning status
FrcElmntOrgSubTypeForEdit I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgSubType Subtype
FrcElmntOrgTechnicalStatusName I_FrcElmntOrgExtRelshpWithDrft FrcElmntOrgTechnicalStatusName
DfsAssgmtPlanStatusObject DfsAssgmtPlanStatusObject Planning status
FrcElmntOrgPlanDelimitDate FrcElmntOrgPlanDelimitDate Delimit date
FrcElmntOrgPlngStatusName FrcElmntOrgPlngStatusName Planning Status
FrcElmntOrgPlngStsCritlty FrcElmntOrgPlngStsCritlty
FrcElmntOrgName _FrcElmntOrgNameTP FrcElmntOrgName Name
FrcElmntOrgLanguage _FrcElmntOrgNameTP FrcElmntOrgLanguage Language
_StrucAuth _StrucAuth

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_FrcElmntOrgExternalRelshpTP.
-- 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: IFEORGDFSEXTTP

CREATE VIEW I_FrcElmntOrgExternalRelshpTP AS
SELECT
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgRelatedOrgID AS FrcElmntOrgRelatedOrgID,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgDraftUUID AS FrcElmntOrgDraftUUID,
  FrcElmntOrgExternalRelshpTP.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgPlngStatusFoEd AS FrcElmntOrgPlngStatusFoEd,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntOrgExternalRelshpTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgRelatedOrgType AS FrcElmntOrgRelatedOrgType,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgRelshpPriority AS FrcElmntOrgRelshpPriority,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgCnctntdRelshpName AS FrcElmntOrgCnctntdRelshpName,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgRelshpDesc AS FrcElmntOrgRelshpDesc,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgLastChgdByUserName AS FrcElmntOrgLastChgdByUserName,
  FrcElmntOrgExternalRelshpTP.ForceElementOrgID AS ForceElementOrgIDForEdit,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgRelatedOrgID AS FrcElmntOrgRelatedOrgIDForEdit,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatusForEdit,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgSubType AS FrcElmntOrgSubTypeForEdit,
  FrcElmntOrgExternalRelshpTP.FrcElmntOrgTechnicalStatusName AS FrcElmntOrgTechnicalStatusName,
  DfsAssgmtPlanStatusObject,
  FrcElmntOrgPlanDelimitDate,
  FrcElmntOrgPlngStatusName,
  FrcElmntOrgPlngStsCritlty,
  _FrcElmntOrgNameTP.FrcElmntOrgName AS FrcElmntOrgName,
  _FrcElmntOrgNameTP.FrcElmntOrgLanguage AS FrcElmntOrgLanguage
FROM I_FrcElmntOrgExtRelshpWithDrft AS FrcElmntOrgExternalRelshpTP
LEFT OUTER JOIN I_FrcElmntOrgNameTP AS _FrcElmntOrgNameTP ON _FrcElmntOrgNameTP.ForceElementOrgID = ForceElementOrgID AND _FrcElmntOrgNameTP.FrcElmntOrgLanguage = $session.system_language AND ( _FrcElmntOrgNameTP.FrcElmntOrgValdtyStartDate <= $session.system_date AND _FrcElmntOrgNameTP.FrcElmntOrgValdtyEndDate >= $session.system_date AND _FrcElmntOrgNameTP.FrcElmntOrgPlngStatus = '1' )  -- association [1..*]
;

Learn More