Fac_AD_Cds_Tbsl_Debit

@AbapCatalog.sqlViewName: 'FACADV_TBSL_D'
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Help View for Debit Posting Key'

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MIXED 
@ObjectModel.usageType.serviceQuality: #C
define view Fac_AD_Cds_Tbsl_Debit
  as select from    tbsl
    left outer join dd07t on  dd07t.domname    = 'KOART'
                          and dd07t.domvalue_l = tbsl.koart
    left outer join tbslt on  tbsl.bschl  = tbslt.bschl
                          and tbslt.umskz = ''
{
  key tbsl.bschl,
  key tbslt.spras,
  key tbslt.umskz,
  key dd07t.domname,
  key dd07t.ddlanguage,
  key dd07t.as4local,
  key dd07t.valpos,
  key dd07t.as4vers,
      tbslt.ltext,
      tbsl.koart,
      dd07t.ddtext,
      tbsl.xumsw,
      tbsl.xzahl,
      tbsl.xsonu,
      tbsl.shkzg,
      tbsl.stbsl,
      tbsl.faus1,
      tbsl.faus2
}
where
  tbsl.shkzg = 'S' //S for Debit, H for Credit            

 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T",
"TBSL",
"TBSLT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/