I_FrcElmntWithAuthznForAssgmt

DDL: I_FRCELMNTWITHAUTHZNFORASSGMT SQL: IFEAUTHASSG Type: view COMPOSITE

Authorized FE for Assgmt

I_FrcElmntWithAuthznForAssgmt is a Composite CDS View that provides data about "Authorized FE for Assgmt" in SAP S/4HANA. It reads from 2 data sources (I_FrcElmntOrgBasic, I_FrcElmntOrgBasic) and exposes 2 fields.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_FrcElmntOrgBasic _FrcElmntOrg from
I_FrcElmntOrgBasic _FrcElmntOrg union

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFEAUTHASSG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Authorized FE for Assgmt view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
ForceElementOrgID _FrcElmntOrgWithAuthorization ForceElementOrgID
ForceElementOrgID 
@AbapCatalog.sqlViewName: 'IFEAUTHASSG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Authorized FE for Assgmt'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality:#C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_FrcElmntWithAuthznForAssgmt
  as select distinct from I_FrcElmntOrgWithAuthorization as _FrcElmntOrgWithAuthorization
  association to I_UserInfoOfAuthzdFrcElmntOrg as _UserInfoOfAuthzdFrcElmntOrg on _UserInfoOfAuthzdFrcElmntOrg.SessionUser = $session.user
{
  _FrcElmntOrgWithAuthorization.ForceElementOrgID,
  case _UserInfoOfAuthzdFrcElmntOrg.DfsIsStrucAuthznEnabled
  when 'X' then 'X'
  end as DfsIsStrucAuthznEnabled
}

union select from I_FrcElmntOrgBasic as _FrcElmntOrg
association to I_UserInfoOfAuthzdFrcElmntOrg as _UserInfoOfAuthzdFrcElmntOrg on _UserInfoOfAuthzdFrcElmntOrg.SessionUser = $session.user
{
  _FrcElmntOrg.ForceElementOrgID,
  case _UserInfoOfAuthzdFrcElmntOrg.DfsIsStrucAuthznEnabled
  when 'N' then 'X'
  end as DfsIsStrucAuthznEnabled
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FRCELMNTORGBASIC",
"I_FRCELMNTORGWITHAUTHORIZATION",
"I_USERINFOOFAUTHZDFRCELMNTORG"
],
"ASSOCIATED":
[
"I_USERINFOOFAUTHZDFRCELMNTORG"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More