I_SCMBusinessSystemGroup

DDL: I_SCMBUSINESSSYSTEMGROUP SQL: ISCMBUSSYSGRP Type: view BASIC

Business system group and corresponding logical system

I_SCMBusinessSystemGroup is a Basic CDS View that provides data about "Business system group and corresponding logical system" in SAP S/4HANA. It reads from 2 data sources (/sapapo/sysdir, t000) and exposes 2 fields with key fields BusinessSystemGroup, LogicalSystem.

Data Sources (2)

SourceAliasJoin Type
/sapapo/sysdir sysdir inner
t000 t000 from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISCMBUSSYSGRP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
EndUserText.label Business system group and corresponding logical system view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY BusinessSystemGroup /sapapo/sysdir logqs
KEY LogicalSystem /sapapo/sysdir logsys
@AbapCatalog.sqlViewName: 'ISCMBUSSYSGRP'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel:{
    usageType.serviceQuality: #A,
    usageType.sizeCategory : #M,
    usageType.dataClass: #MASTER
}
@VDM.viewType: #BASIC
@EndUserText.label: 'Business system group and corresponding logical system'
define view I_SCMBusinessSystemGroup
  as select from t000
    inner join   /sapapo/sysdir as sysdir on  sysdir.mandt  = t000.mandt
                                          and sysdir.logsys = t000.logsys
{
  key sysdir.logqs  as BusinessSystemGroup,
  key sysdir.logsys as LogicalSystem

}
where
  t000.mandt = $session.client