I_FrcElmntOrgStrucRelshpTP

DDL: I_FRCELMNTORGSTRUCRELSHPTP SQL: IFEORGSTRURELTP Type: view TRANSACTIONAL
29 Fields 1 Data Sources 1 Associations

Transactional View of Org Struc Relshp of Force Element

I_FrcElmntOrgStrucRelshpTP is a Transactional CDS View that provides data about "Transactional View of Org Struc Relshp of Force Element" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntOrgRelshpWithDrft) and exposes 29 fields with key fields FrcElmntOrgRelatedOrgID, FrcElmntOrgValdtyStartDate, FrcElmntOrgValdtyEndDate, FrcElmntOrgPlngStatus, FrcElmntOrgDraftUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntOrgRelshpWithDrft FrcElmntOrgStrucRelshpTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_DFS_FrcElmntPlndOpTP _FrcElmntPlndOpTP $projection.ForceElementOrgID = _FrcElmntPlndOpTP.ForceElementOrgID and $projection.FrcElmntOrgRelatedOrgID = _FrcElmntPlndOpTP.FrcElmntOrgRelatedOrgID and $projection.FrcElmntOrgValdtyStartDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefStartDate and $projection.FrcElmntOrgValdtyEndDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefEndDate and $projection.FrcElmntOrgSubType = _FrcElmntPlndOpTP.FrcElmntOrgRefSubtype and _FrcElmntPlndOpTP.FrcElmntOrgRefInfoType = '1001' and _FrcElmntPlndOpTP.FrcElmntOrgType = 'O'

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName IFEORGSTRURELTP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Transactional View of Org Struc Relshp of Force Element view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.preserveKey true 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_STRUC_D view

Fields (29)

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

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_FrcElmntOrgStrucRelshpTP.
-- 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: IFEORGSTRURELTP

CREATE VIEW I_FrcElmntOrgStrucRelshpTP AS
SELECT
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgRelatedOrgID AS FrcElmntOrgRelatedOrgID,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgDraftUUID AS FrcElmntOrgDraftUUID,
  FrcElmntOrgStrucRelshpTP.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgName AS FrcElmntOrgName,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgRelshpSpec AS FrcElmntOrgRelshpSpec,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgRelshpBtwnObj AS FrcElmntOrgRelshpBtwnObj,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgRelshpPriority AS FrcElmntOrgRelshpPriority,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntOrgStrucRelshpTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgRelatedOrgType AS FrcElmntOrgRelatedOrgType,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgRelshpDesc AS FrcElmntOrgRelshpDesc,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgCnctntdRelshpText AS FrcElmntOrgCnctntdRelshpText,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgLastChgdByUserName AS FrcElmntOrgLastChgdByUserName,
  FrcElmntOrgStrucRelshpTP.ForceElementOrgID AS ForceElementOrgIDForEdit,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgRelatedOrgID AS FrcElmntOrgRelatedOrgIDForEdit,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatusForEdit,
  FrcElmntOrgStrucRelshpTP.FrcElmntOrgTechnicalStatusName AS FrcElmntOrgTechnicalStatusName,
  cast( _FrcElmntPlndOpTP.FrcElmntOrgPlngStatus as abap.char(22) ) AS DfsAssgmtPlanStatusObject,
  _FrcElmntPlndOpTP.FrcElmntOrgPlanDelimitDate AS FrcElmntOrgPlanDelimitDate,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _FrcElmntPlndOpTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty
FROM I_FrcElmntOrgRelshpWithDrft AS FrcElmntOrgStrucRelshpTP
LEFT OUTER JOIN I_DFS_FrcElmntPlndOpTP AS _FrcElmntPlndOpTP ON ForceElementOrgID = _FrcElmntPlndOpTP.ForceElementOrgID AND FrcElmntOrgRelatedOrgID = _FrcElmntPlndOpTP.FrcElmntOrgRelatedOrgID AND FrcElmntOrgValdtyStartDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefStartDate AND FrcElmntOrgValdtyEndDate = _FrcElmntPlndOpTP.FrcElmntOrgValdtyRefEndDate AND FrcElmntOrgSubType = _FrcElmntPlndOpTP.FrcElmntOrgRefSubtype AND _FrcElmntPlndOpTP.FrcElmntOrgRefInfoType = '1001' AND _FrcElmntPlndOpTP.FrcElmntOrgType = 'O'  -- association [1..1]
;

Learn More