FINSCDS_REPR_RLDNR

DDL: FINSVD_REPR_RLDNR SQL: FINSV_REPR_RLDNR Type: view
5 Fields 3 Data Sources

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.

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 Editing Client
KEY ldgrp ldgrp Target Ledger Group
mandtasmandt
KEY ldgrp Target Ledger Group
repr_rldnr rldnr Ledger (Compat.)

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FINSCDS_REPR_RLDNR.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: FINSV_REPR_RLDNR

CREATE VIEW FINSCDS_REPR_RLDNR AS
SELECT
  mandt,
  ldgrp,
  rldnr as repr_rldnr AS mandtasmandt,
  rldnr AS repr_rldnr
FROM fagl_tldgrp_map
INNER JOIN finsc_actve_appl ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): finsc_ledger
;

Learn More