TBDLSU

DDL: TBDLSU SQL: TBDLSU_SQL Type: view

LOGICAL SYSTEM

TBDLSU is a CDS View that provides data about "LOGICAL SYSTEM" in SAP S/4HANA. It reads from 4 data sources (tbdls, tbdlsc, tbdlsct, tbdlst) and exposes 4 fields with key fields client, LOGSYS, LOGSYS.

4 data source(s) 4 fields

Data Sources (4)

SourceAliasJoin Type
tbdls tbdls from
tbdlsc tbdlsc union
tbdlsct tbdlsct left_outer
tbdlst tbdlst left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName TBDLSU_SQL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label LOGICAL SYSTEM view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY client
KEY LOGSYS tbdls logsys
KEY LOGSYS tbdlsc logsys
STEXT tbdlsct stext 
@AbapCatalog.sqlViewName: 'TBDLSU_SQL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'LOGICAL SYSTEM'
define view TBDLSU
  as select from    tbdls
    left outer join tbdlst on  tbdls.logsys = tbdlst.logsys
                           and tbdlst.langu = $session.system_language
{
  key $session.client as client,
  key tbdls.logsys    as LOGSYS,
  tbdlst.stext    as STEXT

}
union select from tbdlsc
  left outer join tbdlsct on  tbdlsct.client = tbdlsc.client
                          and tbdlsct.logsys = tbdlsc.logsys
                          and tbdlsct.langu  = $session.system_language
{
  key tbdlsc.client as client,
  key tbdlsc.logsys as LOGSYS,
  tbdlsct.stext as STEXT

} where  tbdlsc.client  = $session.client

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TBDLS",
"TBDLSC",
"TBDLSCT",
"TBDLST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More