FGL_BCF_LD_CMP

DDL: FGL_BCF_LD_CMP SQL: FGLV_BCF_LD_CMP Type: view

All valid item of table finsc_ld_cmp

FGL_BCF_LD_CMP is a CDS View that provides data about "All valid item of table finsc_ld_cmp" in SAP S/4HANA. It reads from 5 data sources (finsc_actve_appl, finsc_ld_cmp, finsc_ledger, finsc_ledger_t, t001) and exposes 5 fields with key fields rldnr, bukrs.

5 data source(s) 5 fields

Data Sources (5)

SourceAliasJoin Type
finsc_actve_appl finsc_actve_appl inner
finsc_ld_cmp finsc_ld_cmp from
finsc_ledger finsc_ledger inner
finsc_ledger_t finsc_ledger_t left_outer
t001 t001 inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FGLV_BCF_LD_CMP view
AbapCatalog.compiler.compareFilter true view
EndUserText.label All valid item of table finsc_ld_cmp view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY rldnr finsc_ld_cmp rldnr
KEY bukrs finsc_ld_cmp bukrs
toyear finsc_ld_cmp toyear
butxt t001 butxt
name finsc_ledger_t name 
@AbapCatalog.sqlViewName: 'FGLV_BCF_LD_CMP'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'All valid item of table finsc_ld_cmp'
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass:  #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #CHECK
define view FGL_BCF_LD_CMP as select from finsc_ld_cmp 
inner join t001 on finsc_ld_cmp.bukrs = t001.bukrs
inner join finsc_ledger on finsc_ld_cmp.rldnr = finsc_ledger.rldnr
inner join finsc_actve_appl on  finsc_ledger.appl    = finsc_actve_appl.appl
                                         and finsc_ledger.subappl = finsc_actve_appl.subappl
left outer join finsc_ledger_t on finsc_ledger_t.rldnr = finsc_ld_cmp.rldnr and langu = $session.system_language
{
  key finsc_ld_cmp.rldnr,
  key finsc_ld_cmp.bukrs,
  finsc_ld_cmp.toyear,
  t001.butxt,
  finsc_ledger_t.name
} 
where finsc_ledger.ext_ledger_type <> 'P' //Exclude predictive ledgers from BCF

  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINSC_ACTVE_APPL",
"FINSC_LD_CMP",
"FINSC_LEDGER",
"FINSC_LEDGER_T",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More