FAA_LEDGER

DDL: FAA_LEDGER SQL: FAAV_LEDGER Type: view

Ledger with FAA persistency (including tech Ledger)

FAA_LEDGER is a CDS View that provides data about "Ledger with FAA persistency (including tech Ledger)" in SAP S/4HANA. It reads from 4 data sources (FAA_CFG_LEDGER, FAA_CFG_LEDGER, faat_cmp_ledger, faat_cmp_ledger) and exposes 3 fields with key fields comp_code, ledger, ledger.

4 data source(s) 3 fields

Data Sources (4)

SourceAliasJoin Type
FAA_CFG_LEDGER cfg_ledger inner
FAA_CFG_LEDGER cfg_ledger inner
faat_cmp_ledger cmp from
faat_cmp_ledger cmp union_all

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_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 #X view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Ledger with FAA persistency (including tech Ledger) view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY comp_code faat_cmp_ledger comp_code
KEY ledger FAA_CFG_LEDGER ledger
KEY ledger FAA_CFG_LEDGER tech_ledger 
@AbapCatalog.sqlViewName: 'FAAV_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: #X
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Ledger with FAA persistency (including tech Ledger)'

--to access ACDOCA with all FAA relevant ledger we need to add the tech ledgers

define view FAA_LEDGER as

  select from     faat_cmp_ledger   as cmp  

    inner join      FAA_CFG_LEDGER  as cfg_ledger  on  cfg_ledger.ledger     = cmp.ledger
                                                   and cfg_ledger.comp_code  = cmp.comp_code
   {
   key cmp.comp_code              as comp_code,
   key cfg_ledger.ledger          as ledger,           -- to read ACDOCA.RLDNR with base ledger
   key cfg_ledger.ledger          as base_ledger,
       cfg_ledger.acc_principle   as acc_principle

}

union all

  select from       faat_cmp_ledger   as cmp  

    inner join      FAA_CFG_LEDGER  as cfg_ledger  on  cfg_ledger.ledger     = cmp.ledger
                                                   and cfg_ledger.comp_code  = cmp.comp_code
   {
   key cmp.comp_code              as comp_code,
   key cfg_ledger.tech_ledger     as ledger,           -- to read ACDOCA.RLDNR with tech ledger
   key cfg_ledger.ledger          as base_ledger,
       cfg_ledger.acc_principle   as acc_principle
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_CFG_LEDGER",
"FAAT_CMP_LEDGER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More