P_LocationAuthGroupEval

DDL: P_LOCATIONAUTHGROUPEVAL SQL: PLOCAUTHGRPEVAL Type: view BASIC

P_LocationAuthGroupEval is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_LocationMap) and exposes 1 field with key field LocationUUID. It has 2 associations to related views.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_LocationMap _LocationMap from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_LocationAuthorizationGroup _LocAuthGrpDet _LocationMap.LocationType = _LocAuthGrpDet.LocationType and _LocationMap.BusinessSystemGroup = _LocAuthGrpDet.BusinessSystemGroup and _LocationMap.CompanyCode = _LocAuthGrpDet.CompanyCode
[0..1] I_LocationAuthorizationGroup _LocAuthGrpGen _LocationMap.LocationType = _LocAuthGrpGen.LocationType and _LocAuthGrpGen.BusinessSystemGroup = '' and _LocAuthGrpGen.CompanyCode = ''

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PLOCAUTHGRPEVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #NONE view
VDM.private true view
VDM.viewType #BASIC view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY LocationUUID LocationUUID 
@AbapCatalog.sqlViewName: 'PLOCAUTHGRPEVAL'

@AbapCatalog.compiler.compareFilter:    true
@AbapCatalog.preserveKey:               true
@AccessControl.authorizationCheck:      #NOT_REQUIRED
@AccessControl.personalData.blocking:   #NOT_REQUIRED
@ClientHandling.algorithm:              #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory:    #M
@ObjectModel.usageType.dataClass:       #MASTER
@VDM.lifecycle.contract.type:           #NONE
@VDM.private:                           true
@VDM.viewType:                          #BASIC

define view P_LocationAuthGroupEval 
  as select from I_LocationMap as _LocationMap
  association [0..1] to I_LocationAuthorizationGroup as _LocAuthGrpDet on  _LocationMap.LocationType        = _LocAuthGrpDet.LocationType
                                                                       and _LocationMap.BusinessSystemGroup = _LocAuthGrpDet.BusinessSystemGroup
                                                                       and _LocationMap.CompanyCode         = _LocAuthGrpDet.CompanyCode
  association [0..1] to I_LocationAuthorizationGroup as _LocAuthGrpGen on  _LocationMap.LocationType        = _LocAuthGrpGen.LocationType
                                                                       and _LocAuthGrpGen.BusinessSystemGroup = ''
                                                                       and _LocAuthGrpGen.CompanyCode = ''
{
  key LocationUUID,
  
      case 
        when _LocAuthGrpDet.AuthorizationGroup <> ''
          then _LocAuthGrpDet.AuthorizationGroup
          else _LocAuthGrpGen.AuthorizationGroup
        end                                       as AuthorizationGroup
}   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOCATIONAUTHORIZATIONGROUP",
"I_LOCATIONMAP"
],
"ASSOCIATED":
[
"I_LOCATIONAUTHORIZATIONGROUP"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More