FAA_CFG_LEDGER

DDL: FAA_CFG_LEDGER SQL: FAAV_CFG_LEDGER Type: view

Configuration of Ledger, Account. Principle and Ledgergroup

FAA_CFG_LEDGER is a CDS View that provides data about "Configuration of Ledger, Account. Principle and Ledgergroup" in SAP S/4HANA. It reads from 2 data sources (finsc_ld_cmp, fins_tech_ledger) and exposes 3 fields with key fields comp_code, ledger.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
finsc_ld_cmp ld_cmp from
fins_tech_ledger ledger inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_CFG_LEDGER view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 2 view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Configuration of Ledger, Account. Principle and Ledgergroup view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY comp_code finsc_ld_cmp bukrs
KEY ledger fins_tech_ledger rldnr
tech_ledger fins_tech_ledger tech_ledger 
@AbapCatalog.sqlViewName: 'FAAV_CFG_LEDGER'
@ClientHandling.algorithm: #SESSION_VARIABLE
--@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@AbapCatalog.buffering.status: #ACTIVE
--@AbapCatalog.buffering.type: #FULL
@AbapCatalog.buffering.type: #GENERIC
@AbapCatalog.buffering.numberOfKeyFields: 2
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Configuration of Ledger, Account. Principle and Ledgergroup'

define view FAA_CFG_LEDGER as

  select from       finsc_ld_cmp    as ld_cmp

    inner join      fins_tech_ledger    as ledger      on ledger.rldnr               = ld_cmp.rldnr
    
   {
   key ld_cmp.bukrs               as comp_code,
   key ledger.rldnr               as ledger,           
       ledger.tech_ledger         as tech_ledger,
       ld_cmp.acc_principle       as acc_principle
}

Learn More