FAC_AlternativeAccount_VH

DDL: FAC_ALTERNATIVEACCOUNT_VH SQL: FACALTVACCTVH Type: view

Alternative Account Value Help

FAC_AlternativeAccount_VH is a CDS View that provides data about "Alternative Account Value Help" in SAP S/4HANA. It reads from 4 data sources (ska1, ska1, skb1, t001) and exposes 10 fields with key fields GLAccount, CompanyCode, ChartOfAccounts. It has 1 association to related views.

4 data source(s) 10 fields

Data Sources (4)

SourceAliasJoin Type
ska1 _alternative inner
ska1 ska1 inner
skb1 skb1 from
t001 t001 inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] skat _skat $projection.CountryChartOfAccounts = _skat.ktopl and $projection.AlternativeGLAccount = _skat.saknr and _skat.spras = $session.system_language

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FACALTVACCTVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Alternative Account Value Help view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY GLAccount ska1 saknr
KEY CompanyCode t001 bukrs
KEY ChartOfAccounts ska1 ktopl
AlternativeGLAccount ska1 saknr
AlternativeGLAccountExternal ska1 sakan
CountryChartOfAccounts t001 ktop2
CompanyCodeName t001 butxt
City t001 ort01
GLAccountName _skat txt20
GLAccountLongName _skat txt50 
@AbapCatalog.sqlViewName: 'FACALTVACCTVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Alternative Account Value Help'
@ObjectModel.usageType: {
  serviceQuality: #B,
  sizeCategory: #L,
  dataClass: #MIXED
}
define view FAC_AlternativeAccount_VH
  as select from skb1
    inner join   t001 on skb1.bukrs = t001.bukrs
    inner join   ska1 on  t001.ktopl = ska1.ktopl
                      and skb1.saknr = ska1.saknr
    inner join   ska1 as _alternative on  t001.ktop2 = _alternative.ktopl
                                      and skb1.altkt = _alternative.saknr
                                    
  association [0..1] to skat as _skat on  $projection.CountryChartOfAccounts = _skat.ktopl
                                      and $projection.AlternativeGLAccount   = _skat.saknr
                                      and _skat.spras                        = $session.system_language

{
  key ska1.saknr  as GLAccount,
  key t001.bukrs  as CompanyCode,
  key ska1.ktopl  as ChartOfAccounts,
  
      _alternative.saknr  as AlternativeGLAccount,
      _alternative.sakan  as AlternativeGLAccountExternal,
      
      t001.ktop2  as CountryChartOfAccounts,
      t001.butxt  as CompanyCodeName,
      t001.ort01  as City,

      _skat.txt20 as GLAccountName,
      _skat.txt50 as GLAccountLongName
} group by ska1.saknr, t001.bukrs, ska1.ktopl, _alternative.saknr, _alternative.sakan, t001.ktop2, t001.butxt, t001.ort01, _skat.txt20, _skat.txt50
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SKA1",
"SKAT",
"SKB1",
"T001"
],
"ASSOCIATED":
[
"SKAT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More