TBDLSU

DDL: TBDLSU SQL: TBDLSU_SQL Type: view Package: SALE2

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. Part of development package SALE2.

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

Learn More