FAC_POST_ALTER_GLACCT_BASIC

DDL: FAC_POST_ALTER_GLACCT_BASIS SQL: FACPAGLB Type: view

FAC_POST_ALTER_GLACCT_BASIC is a CDS View in SAP S/4HANA. It reads from 4 data sources (skb1, skb1, t001, t001) and exposes 9 fields with key fields CountryChartOfAccounts, AlternativeGLAccountExternal, GLAccount, CompanyCode, AlternativeGLAccountExternal. It has 1 association to related views.

4 data source(s) 9 fields

Data Sources (4)

SourceAliasJoin Type
skb1 skb1 from
skb1 skb1 union_all
t001 t001 inner
t001 t001 inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts $projection.CountryChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.AlternativeGLAccount = _GLAccountInChartOfAccounts.GLAccount

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FACPAGLB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
AbapCatalog.preserveKey true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CountryChartOfAccounts t001 ktop2
KEY AlternativeGLAccountExternal _GLAccountInChartOfAccounts GLAccountExternal
KEY GLAccount skb1 saknr
KEY CompanyCode skb1 bukrs
ktoplasCountryChartOfAccounts
KEY AlternativeGLAccountExternal _GLAccountInChartOfAccounts GLAccountExternal
KEY GLAccount skb1 saknr
KEY CompanyCode skb1 bukrs
AlternativeGLAccount skb1 saknr 
@AbapCatalog.sqlViewName: 'FACPAGLB'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #MASTER
}
@AbapCatalog.preserveKey:true
define view FAC_POST_ALTER_GLACCT_BASIC
  as select from           skb1
    inner join             t001 on skb1.bukrs = t001.bukrs
  association [0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on  $projection.CountryChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts
                                                                                    and $projection.AlternativeGLAccount   = _GLAccountInChartOfAccounts.GLAccount
{
  key t001.ktop2                                    as CountryChartOfAccounts,
  key _GLAccountInChartOfAccounts.GLAccountExternal as AlternativeGLAccountExternal,
  key skb1.saknr                                    as GLAccount,
  key skb1.bukrs                                    as CompanyCode,
      skb1.altkt                                    as AlternativeGLAccount

}
where
      skb1.xintb = ''
  and skb1.mitkz =  ''
  and skb1.altkt <> ''
  and _GLAccountInChartOfAccounts.GLAccountExternal <> ''
  
union all
  select from           skb1
    inner join          t001 on skb1.bukrs = t001.bukrs
  association [0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on  $projection.CountryChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts
                                                                                    and $projection.AlternativeGLAccount   = _GLAccountInChartOfAccounts.GLAccount
{
  key t001.ktopl                                    as CountryChartOfAccounts,
  key _GLAccountInChartOfAccounts.GLAccountExternal as AlternativeGLAccountExternal,
  key skb1.saknr                                    as GLAccount,
  key skb1.bukrs                                    as CompanyCode,
      skb1.saknr                                    as AlternativeGLAccount

}
where
      skb1.xintb = ''
  and skb1.mitkz =  ''
  and t001.ktop2 = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTINCHARTOFACCOUNTS",
"SKB1",
"T001"
],
"ASSOCIATED":
[
"I_GLACCOUNTINCHARTOFACCOUNTS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More