FINSCDS_REPR_RLDNR

DDL: FINSVD_REPR_RLDNR SQL: FINSV_REPR_RLDNR Type: view

Representative Ledger

FINSCDS_REPR_RLDNR is a CDS View that provides data about "Representative Ledger" in SAP S/4HANA. It reads from 3 data sources (fagl_tldgrp_map, finsc_actve_appl, finsc_ledger) and exposes 5 fields with key fields mandt, ldgrp, ldgrp.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
fagl_tldgrp_map fagl_tldgrp_map from
finsc_actve_appl finsc_actve_appl inner
finsc_ledger finsc_ledger union_all

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FINSV_REPR_RLDNR view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Representative Ledger view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt
KEY ldgrp ldgrp
mandtasmandt
KEY ldgrp
repr_rldnr rldnr 
@AbapCatalog.sqlViewName: 'FINSV_REPR_RLDNR'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
@AbapCatalog.compiler.compareFilter: true
//@AccessControl.authorizationCheck: #CHECK commented out because there is no DCL and it is customizing table access only

@EndUserText.label: 'Representative Ledger'
//get representative ledger for all ledgergroups, incl. the ledgergroup <space>;

//this view can be joined to get the representative ledger for any posting

//For this, join BKPF-LDGRP with LDGRP of this view:

define view FINSCDS_REPR_RLDNR as select from fagl_tldgrp_map 

{
  key mandt,
  key ldgrp,
      rldnr  as repr_rldnr
}

where  ldgrp     <> '  '
  and  represent <> ' '
  
union all

select from finsc_ledger  

inner join finsc_actve_appl
      on   finsc_actve_appl.mandt   = finsc_ledger.mandt
      and  finsc_actve_appl.appl    = finsc_ledger.appl
      and  finsc_actve_appl.subappl = finsc_ledger.subappl
 
{
  key finsc_ledger.mandt as mandt,
  key ' '                as ldgrp,
      rldnr              as repr_rldnr
}
where xleading <> ' '  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAGL_TLDGRP_MAP",
"FINSC_ACTVE_APPL",
"FINSC_LEDGER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More