I_FRCELMNTORGDFSEXTERNALRELSHP

CDS View

Interface View of Force Element External Relshp

I_FRCELMNTORGDFSEXTERNALRELSHP is a CDS View in S/4HANA. Interface View of Force Element External Relshp. It contains 15 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 15 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_FrcElmntOrgAddrParentAddress view union CONSUMPTION Consumption view for Address Parent list
I_AuthzdRelshpPeaceTmeFrcElmnt view from COMPOSITE Basic View For FE Relations Peace Time
I_AuthzdRelshpWarTmeFrcElmnt view from COMPOSITE Basic View For FE Relations War Time
I_FrcElmntOrgExtRelshpWithDrft view from COMPOSITE Interface view for the External Relationship with Draft

Fields (15)

KeyField CDS FieldsUsed in Views
KEY ForceElementOrgID ForceElementOrgID 2
KEY FrcElmntOrgPlanVersion FrcElmntOrgPlanVersion 2
KEY FrcElmntOrgSubType FrcElmntOrgSubType,FrcElmntOrgUsageType 2
KEY FrcElmntOrgType FrcElmntOrgType 2
FrcElmntOrgCnctntdRelshpName FrcElmntOrgCnctntdRelshpName 1
FrcElmntOrgConcatenatedID FrcElmntOrgConcatenatedID 1
FrcElmntOrgInfoType FrcElmntOrgInfoType 1
FrcElmntOrgLastChgdByUserName FrcElmntOrgLastChgdByUserName 1
FrcElmntOrgPlngStatus FrcElmntOrgPlngStatus 1
FrcElmntOrgRelatedOrgID FrcElmntOrgRelatedOrgID 1
FrcElmntOrgRelatedOrgType FrcElmntOrgRelatedOrgType 2
FrcElmntOrgRelshpPriority FrcElmntOrgRelshpPriority 1
FrcElmntOrgValdtyEndDate FrcElmntOrgValdtyEndDate 1
FrcElmntOrgValdtyStartDate FrcElmntOrgValdtyStartDate 1
NumberOfForceElementOrg NumberOfForceElementOrg 1 
@AbapCatalog.sqlViewName: 'IFEORGDFSEXTREL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Interface View of Force Element External Relshp'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #M 

define view I_FrcElmntOrgDfsExternalRelshp 
  as select from P_FrcElmntOrgDfsExternalRelshp as FrcElmntOrgDfsExternalRelshp
  //  inner join I_FrcElmntOrgStrucAuthzn as _auth on  FrcElmntOrgDfsExternalRelshp.ForceElementOrgID = _auth.ForceElementOrgID

  //  inner join I_FrcElmntOrgStrucAuthzn as _auth1 on  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelatedOrgID = _auth1.ForceElementOrgID

    inner join   I_FrcElmntOrgWithAuthorization as _auth  on FrcElmntOrgDfsExternalRelshp.ForceElementOrgID = _auth.ForceElementOrgID
    inner join   I_FrcElmntOrgWithAuthorization as _auth1 on FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelatedOrgID = _auth1.ForceElementOrgID
  association [0..*] to I_FrcElmntOrgRelshpCode as _FrcElmntOrgRelshpCode on $projection.FrcElmntOrgCnctntdRelshpName = _FrcElmntOrgRelshpCode.FrcElmntOrgSubType
{
  key FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlanVersion,
  key FrcElmntOrgDfsExternalRelshp.FrcElmntOrgType,
  key FrcElmntOrgDfsExternalRelshp.ForceElementOrgID,
  key FrcElmntOrgDfsExternalRelshp.FrcElmntOrgSubType,
  key FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlngStatus,
  key FrcElmntOrgDfsExternalRelshp.FrcElmntOrgValdtyStartDate,
  key FrcElmntOrgDfsExternalRelshp.FrcElmntOrgValdtyEndDate,
  key FrcElmntOrgDfsExternalRelshp.NumberOfForceElementOrg,
      FrcElmntOrgDfsExternalRelshp.FrcElmntOrgInfoType,
      FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelatedOrgType,
      FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelatedOrgID,
      FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelshpPriority,
//      case FrcElmntOrgDfsExternalRelshp.FrcElmntOrgSubType

//      when 'V002' then 'A800'

//      when 'T002' then 'A803'

//      end as FrcElmntOrgCnctntdRelshpName,

      'A' as FrcElmntOrgCnctntdRelshpName,
      //Added field

      FrcElmntOrgDfsExternalRelshp.FrcElmntOrgLastChgdByUserName,
      FrcElmntOrgDfsExternalRelshp.FrcElmntOrgConcatenatedID,
      _FrcElmntOrgRelshpCode
}
union all select from P_FrcElmntOrgDfsExternalRelshp as FrcElmntOrgDfsExternalRelshp
//inner join I_FrcElmntOrgStrucAuthzn as _auth on  FrcElmntOrgDfsExternalRelshp.ForceElementOrgID = _auth.ForceElementOrgID

//inner join I_FrcElmntOrgStrucAuthzn as _auth1 on  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelatedOrgID = _auth1.ForceElementOrgID

  inner join          I_FrcElmntOrgWithAuthorization as _auth  on FrcElmntOrgDfsExternalRelshp.ForceElementOrgID = _auth.ForceElementOrgID
  inner join          I_FrcElmntOrgWithAuthorization as _auth1 on FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelatedOrgID = _auth1.ForceElementOrgID

association [0..*] to I_FrcElmntOrgRelshpCode as _FrcElmntOrgRelshpCode on $projection.FrcElmntOrgCnctntdRelshpName = _FrcElmntOrgRelshpCode.FrcElmntOrgSubType
{
  key FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlanVersion,
  key FrcElmntOrgDfsExternalRelshp.FrcElmntOrgType,
  key FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelatedOrgID                                                                     as ForceElementOrgID,
  key FrcElmntOrgDfsExternalRelshp.FrcElmntOrgSubType,
  key FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlngStatus,
  key FrcElmntOrgDfsExternalRelshp.FrcElmntOrgValdtyStartDate,
  key FrcElmntOrgDfsExternalRelshp.FrcElmntOrgValdtyEndDate,
  key FrcElmntOrgDfsExternalRelshp.NumberOfForceElementOrg,
      FrcElmntOrgDfsExternalRelshp.FrcElmntOrgInfoType,
      FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelatedOrgType,
      FrcElmntOrgDfsExternalRelshp.ForceElementOrgID                                                                           as FrcElmntOrgRelatedOrgID,
      FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelshpPriority,
//      case FrcElmntOrgDfsExternalRelshp.FrcElmntOrgSubType

//      when 'V002' then 'B800'

//      when 'T002' then 'B803' 

//      end as FrcElmntOrgCnctntdRelshpName,

      'B' as FrcElmntOrgCnctntdRelshpName, 
      //Added field

      FrcElmntOrgDfsExternalRelshp.FrcElmntOrgLastChgdByUserName,
      //      con    FrcElmntOrgDfsExternalRelshp.FrcElmntOrgConcatenatedID,

      concat_with_space( FrcElmntOrgDfsExternalRelshp.FrcElmntOrgType,FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelatedOrgID,1 ) as FrcElmntOrgConcatenatedID,
      _FrcElmntOrgRelshpCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FRCELMNTORGWITHAUTHORIZATION",
"P_FRCELMNTORGDFSEXTERNALRELSHP"
],
"ASSOCIATED":
[
"I_FRCELMNTORGRELSHPCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More