fac_ad_cds_account_buv

DDL: FAC_AD_CDS_ACCOUNT_BUV SQL: FACADV_ACC_BUV Type: view

Help View for Account in Trans-Key BUV

fac_ad_cds_account_buv is a CDS View that provides data about "Help View for Account in Trans-Key BUV" in SAP S/4HANA. It reads from 6 data sources and exposes 8 fields with key fields company_code, account, account_type, account, account_type.

6 data source(s) 8 fields

Data Sources (6)

SourceAliasJoin Type
kna1 kna1 left_outer
knb1 knb1 union
lfa1 lfa1 left_outer
lfb1 lfb1 union
skb1 skb1 from
t001 t001 left_outer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_ACC_BUV view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Help View for Account in Trans-Key BUV view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.dataCategory #VALUE_HELP view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY company_code skb1 bukrs
KEY account skb1 saknr
KEY account_type
KEY account lfb1 lifnr
KEY account_type
KEY account knb1 kunnr
KEY account_type
description 
@AbapCatalog.sqlViewName: 'FACADV_ACC_BUV'
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Help View for Account in Trans-Key BUV'

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.dataCategory: #VALUE_HELP

define view fac_ad_cds_account_buv
  as select from    skb1
    left outer join t001 on skb1.bukrs = t001.bukrs
  association [0..1] to skat  on  skb1.saknr = skat.saknr
                              and t001.ktopl = skat.ktopl
                              and skat.spras = $session.system_language
  association [1..1] to dd07t on  dd07t.domname    = 'KOART'
                              and dd07t.domvalue_l = 'S'
                              and dd07t.ddlanguage = $session.system_language
{
  key  skb1.bukrs   as company_code,
  key  skb1.saknr   as account,
  key  'S'          as account_type, //S for G/L Account

       dd07t.ddtext as accnt_type_des,
       skat.txt50   as description
}

union select from lfb1
  left outer join lfa1 on lfb1.lifnr = lfa1.lifnr
association [1..1] to dd07t on  dd07t.domname    = 'KOART'
                            and dd07t.domvalue_l = 'K'
                            and dd07t.ddlanguage = $session.system_language
{
  key bukrs                             as company_code,
  key lfb1.lifnr                        as account,
  key 'K'                               as account_type, //K for Vendor

      dd07t.ddtext                      as accnt_type_des,
      cast(name1 as abap.char(50))      as description
}

union select from knb1
  left outer join kna1 on knb1.kunnr = kna1.kunnr
association [1..1] to dd07t on  dd07t.domname    = 'KOART'
                            and dd07t.domvalue_l = 'D'
                            and dd07t.ddlanguage = $session.system_language
{
  key bukrs                             as company_code,
  key knb1.kunnr                        as account,
  key 'D'                               as account_type, //D for customer

      dd07t.ddtext                      as accnt_type_des,
      cast(name1 as abap.char(50))      as description
}

Learn More