C_FrcElmntOrgPeaceTmeRelshpTP

DDL: C_FRCELMNTORGPEACETMERELSHPTP SQL: CFEORGPTRELSHPTP Type: view CONSUMPTION
37 Fields 1 Data Sources 8 Associations

View of Force Element Peace Time Relationships

C_FrcElmntOrgPeaceTmeRelshpTP is a Consumption CDS View that provides data about "View of Force Element Peace Time Relationships" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntOrgExternalRelshpTP) and exposes 37 fields with key fields FrcElmntOrgRelatedOrgID, FrcElmntOrgValdtyStartDate, FrcElmntOrgValdtyEndDate, FrcElmntOrgSubType, FrcElmntOrgPlngStatus. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntOrgExternalRelshpTP FrcElmntOrgPeaceTmeRelshpTP from

Associations (8)

CardinalityTargetAliasCondition
[1..*] C_FrcElmntOrgVH _FrcElmntOrgTargetVH _FrcElmntOrgTargetVH.ForceElementOrgIDForEdit = $projection.FrcElmntOrgRelatedOrgIDForEdit
[1..1] I_FrcElmntOrgSuplmntyNoSrch _FrcElmntOrgSuplmntyName $projection.FrcElmntOrgRelatedOrgIDForEdit = _FrcElmntOrgSuplmntyName.ForceElementOrgID and _FrcElmntOrgSuplmntyName.FrcElmntOrgLanguage = $session.system_language
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.FrcElmntOrgPlngStatus
[1..*] C_FrcElmntOrgPeaceTimeRelshpVH _FrcElmntOrgRelshpVH _FrcElmntOrgRelshpVH.FrcElmntOrgSubTypeForEdit = $projection.FrcElmntOrgCnctntdRelshpName
[1..*] I_DFS_SenstvyClfnFrcElmnt _SenstvyClfn _SenstvyClfn.ForceElementOrgID = $projection.ForceElementOrgID
[1..*] I_DFS_SenstvyClfnFrcElmnt _SenstvyClfnRelated _SenstvyClfnRelated.ForceElementOrgID = $projection.FrcElmntOrgRelatedOrgID
[0..*] I_DFS_TechnicalStatusText _TechnicalStatusText $projection.FrcElmntOrgTechnicalStatusName = _TechnicalStatusText.DfsAssgmtTechnicalStatus
[1..1] C_FrcElmntOrgTP _FrcElmntOrgTP _FrcElmntOrgTP.ForceElementOrgID = $projection.FrcElmntOrgRelatedOrgIDForEdit

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CFEORGPTRELSHPTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label View of Force Element Peace Time Relationships view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgRelatedOrgID I_FrcElmntOrgExternalRelshpTP FrcElmntOrgRelatedOrgID Target Object ID
KEY FrcElmntOrgValdtyStartDate I_FrcElmntOrgExternalRelshpTP FrcElmntOrgValdtyStartDate Valid From
KEY FrcElmntOrgValdtyEndDate I_FrcElmntOrgExternalRelshpTP FrcElmntOrgValdtyEndDate Valid To
KEY FrcElmntOrgSubType I_FrcElmntOrgExternalRelshpTP FrcElmntOrgSubType Subtype
KEY FrcElmntOrgPlngStatus I_FrcElmntOrgExternalRelshpTP FrcElmntOrgPlngStatus Planning Status
KEY FrcElmntOrgDraftUUID I_FrcElmntOrgExternalRelshpTP FrcElmntOrgDraftUUID UUID
ForceElementOrgID I_FrcElmntOrgExternalRelshpTP ForceElementOrgID Object ID Processor
FrcElmntOrgName I_FrcElmntOrgExternalRelshpTP FrcElmntOrgName Force Element Name
FrcElmntOrgNameFoEd _FrcElmntOrgSuplmntyName FrcElmntOrgName Target Name
NumberOfForceElementOrg I_FrcElmntOrgExternalRelshpTP NumberOfForceElementOrg IT record no.
FrcElmntOrgPlanVersion I_FrcElmntOrgExternalRelshpTP FrcElmntOrgPlanVersion Plan version
FrcElmntOrgType I_FrcElmntOrgExternalRelshpTP FrcElmntOrgType Type of Object
FrcElmntOrgInfoType I_FrcElmntOrgExternalRelshpTP FrcElmntOrgInfoType Infotype
FrcElmntOrgRelatedOrgType I_FrcElmntOrgExternalRelshpTP FrcElmntOrgRelatedOrgType Type of Related Object
FrcElmntOrgRelshpPriority I_FrcElmntOrgExternalRelshpTP FrcElmntOrgRelshpPriority Priority
FrcElmntOrgPlngStatusFoEd I_FrcElmntOrgExternalRelshpTP FrcElmntOrgPlngStatusFoEd Object Status
FrcElmntOrgRelshpDesc _FrcElmntOrgRelshpVH FrcElmntOrgRelshpDesc Subtype
FrcElmntOrgRelshpSpec _FrcElmntOrgRelshpVH FrcElmntOrgRelshpSpec Relationship
ForceElementOrgIDForEdit I_FrcElmntOrgExternalRelshpTP ForceElementOrgIDForEdit Object ID
FrcElmntOrgRelatedOrgIDForEdit I_FrcElmntOrgExternalRelshpTP FrcElmntOrgRelatedOrgIDForEdit ID rel.object
FrcElmntOrgValdtyStartDateFoEd I_FrcElmntOrgExternalRelshpTP FrcElmntOrgValdtyStartDateFoEd Start date
FrcElmntOrgValdtyEndDateFoEd I_FrcElmntOrgExternalRelshpTP FrcElmntOrgValdtyEndDateFoEd End Date
FrcElmntOrgPlngStatusForEdit I_FrcElmntOrgExternalRelshpTP FrcElmntOrgPlngStatusForEdit Planning status
FrcElmntOrgCnctntdRelshpName I_FrcElmntOrgExternalRelshpTP FrcElmntOrgCnctntdRelshpName Concatenated Relationship Name
FrcElmntOrgTechnicalStatusName I_FrcElmntOrgExternalRelshpTP FrcElmntOrgTechnicalStatusName Active/Draft Status
Criticality I_FrcElmntOrgExternalRelshpTP Criticality Status Rating
FrcElmntOrgPlngStatusName _FrcElmntOrgPlngStsVH FrcElmntOrgPlngStatusName Planning Status
FrcElmntOrgPlanDelimitDate FrcElmntOrgPlanDelimitDate Delimit date
DfsAssgmtPlanOperationStatus FrcElmntOrgPlngStatusName Delimitation status
FrcElmntOrgPlngStsCritlty FrcElmntOrgPlngStsCritlty
_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH
_FrcElmntOrgRelshpVH _FrcElmntOrgRelshpVH
_FrcElmntOrgTargetVH _FrcElmntOrgTargetVH
_SenstvyClfn _SenstvyClfn
_SenstvyClfnRelated _SenstvyClfnRelated
_FrcElmntOrgTP _FrcElmntOrgTP
_TechnicalStatusText _TechnicalStatusText

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_FrcElmntOrgPeaceTmeRelshpTP.
-- 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: CFEORGPTRELSHPTP

CREATE VIEW C_FrcElmntOrgPeaceTmeRelshpTP AS
SELECT
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgRelatedOrgID AS FrcElmntOrgRelatedOrgID,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgDraftUUID AS FrcElmntOrgDraftUUID,
  FrcElmntOrgPeaceTmeRelshpTP.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgName AS FrcElmntOrgName,
  _FrcElmntOrgSuplmntyName.FrcElmntOrgName AS FrcElmntOrgNameFoEd,
  FrcElmntOrgPeaceTmeRelshpTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgRelatedOrgType AS FrcElmntOrgRelatedOrgType,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgRelshpPriority AS FrcElmntOrgRelshpPriority,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgPlngStatusFoEd AS FrcElmntOrgPlngStatusFoEd,
  _FrcElmntOrgRelshpVH.FrcElmntOrgRelshpDesc AS FrcElmntOrgRelshpDesc,
  _FrcElmntOrgRelshpVH.FrcElmntOrgRelshpSpec AS FrcElmntOrgRelshpSpec,
  FrcElmntOrgPeaceTmeRelshpTP.ForceElementOrgIDForEdit AS ForceElementOrgIDForEdit,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgRelatedOrgIDForEdit AS FrcElmntOrgRelatedOrgIDForEdit,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgValdtyEndDateFoEd AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgPlngStatusForEdit AS FrcElmntOrgPlngStatusForEdit,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgCnctntdRelshpName AS FrcElmntOrgCnctntdRelshpName,
  FrcElmntOrgPeaceTmeRelshpTP.FrcElmntOrgTechnicalStatusName AS FrcElmntOrgTechnicalStatusName,
  FrcElmntOrgPeaceTmeRelshpTP.Criticality AS Criticality,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  FrcElmntOrgPlanDelimitDate,
  FrcElmntOrgPlngStatusName AS DfsAssgmtPlanOperationStatus,
  FrcElmntOrgPlngStsCritlty
FROM I_FrcElmntOrgExternalRelshpTP AS FrcElmntOrgPeaceTmeRelshpTP
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgTargetVH ON _FrcElmntOrgTargetVH.ForceElementOrgIDForEdit = FrcElmntOrgRelatedOrgIDForEdit  -- association [1..*]
LEFT OUTER JOIN I_FrcElmntOrgSuplmntyNoSrch AS _FrcElmntOrgSuplmntyName ON FrcElmntOrgRelatedOrgIDForEdit = _FrcElmntOrgSuplmntyName.ForceElementOrgID AND _FrcElmntOrgSuplmntyName.FrcElmntOrgLanguage = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPeaceTimeRelshpVH AS _FrcElmntOrgRelshpVH ON _FrcElmntOrgRelshpVH.FrcElmntOrgSubTypeForEdit = FrcElmntOrgCnctntdRelshpName  -- association [1..*]
LEFT OUTER JOIN I_DFS_SenstvyClfnFrcElmnt AS _SenstvyClfn ON _SenstvyClfn.ForceElementOrgID = ForceElementOrgID  -- association [1..*]
LEFT OUTER JOIN I_DFS_SenstvyClfnFrcElmnt AS _SenstvyClfnRelated ON _SenstvyClfnRelated.ForceElementOrgID = FrcElmntOrgRelatedOrgID  -- association [1..*]
LEFT OUTER JOIN I_DFS_TechnicalStatusText AS _TechnicalStatusText ON FrcElmntOrgTechnicalStatusName = _TechnicalStatusText.DfsAssgmtTechnicalStatus  -- association [0..*]
LEFT OUTER JOIN C_FrcElmntOrgTP AS _FrcElmntOrgTP ON _FrcElmntOrgTP.ForceElementOrgID = FrcElmntOrgRelatedOrgIDForEdit  -- association [1..1]
;

Learn More