FAC_AD_CDS_GLACCOUNT_CC

DDL: FAC_AD_CDS_GLACCOUNT_CC SQL: FACADV_GLACCT_CC Type: view

View for GL Account based on Comp Code

FAC_AD_CDS_GLACCOUNT_CC is a CDS View that provides data about "View for GL Account based on Comp Code" in SAP S/4HANA. It reads from 2 data sources (skb1, t001) and exposes 9 fields with key fields bukrs, saknr.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
skb1 skb1 from
t001 t001 left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_GLACCT_CC view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
AbapCatalog.preserveKey true view
EndUserText.label View for GL Account based on Comp Code view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY bukrs skb1 bukrs
KEY saknr skb1 saknr
butxt t001 butxt
ktopl t001 ktopl
xbilk ska1 xbilk
txt20 skat txt20
txt50 skat txt50
mitkz skb1 mitkz
xintb skb1 xintb 
@AbapCatalog.sqlViewName: 'FACADV_GLACCT_CC'
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@AbapCatalog.preserveKey:true
@EndUserText.label: 'View for GL Account based on Comp Code'
define view FAC_AD_CDS_GLACCOUNT_CC
  as select from skb1
    left outer join t001 on skb1.bukrs = t001.bukrs
  association [0..1] to ska1 on  $projection.saknr = ska1.saknr
                             and t001.ktopl        = ska1.ktopl
  association [0..1] to skat on  $projection.saknr = skat.saknr
                             and t001.ktopl        = skat.ktopl
                             and skat.spras        = $session.system_language
{
  key  skb1.bukrs,
  key  skb1.saknr,
       
       t001.butxt,
       t001.ktopl,
       ska1.xbilk,
       skat.txt20,
       skat.txt50,
       skb1.mitkz,
       skb1.xintb
}
where
  ska1.glaccount_type <> 'S'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SKA1",
"SKAT",
"SKB1",
"T001"
],
"ASSOCIATED":
[
"SKA1",
"SKAT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More