Fisvd_Rldnr_Appl

DDL: FISVD_RLDNR_APPL SQL: FISV_RLDNR_APPL Type: view

Ledger with Application

Fisvd_Rldnr_Appl is a CDS View that provides data about "Ledger with Application" in SAP S/4HANA. It reads from 2 data sources (finsc_actve_appl, finsc_ledger_t) and exposes 6 fields.

Data Sources (2)

SourceAliasJoin Type
finsc_actve_appl finsc_actve_appl inner
finsc_ledger_t finsc_ledger_t left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FISV_RLDNR_APPL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Ledger with Application view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view

Fields (6)

KeyFieldSource TableSource FieldDescription
rldnr Fisvd_Rldnr_Appl1 rldnr Ledger (Compat.)
name finsc_ledger_t name Zone name
xleading Fisvd_Rldnr_Appl1 xleading Leading Ledger
appl Fisvd_Rldnr_Appl1 appl Rep. Model
subappl Fisvd_Rldnr_Appl1 subappl Subapplication
spras Fisvd_Rldnr_Appl1 spras Off. Language

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 Fisvd_Rldnr_Appl.
-- 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: FISV_RLDNR_APPL

CREATE VIEW Fisvd_Rldnr_Appl AS
SELECT
  Fisvd_Rldnr_Appl1.rldnr AS rldnr,
  finsc_ledger_t.name AS name,
  Fisvd_Rldnr_Appl1.xleading AS xleading,
  Fisvd_Rldnr_Appl1.appl AS appl,
  Fisvd_Rldnr_Appl1.subappl AS subappl,
  Fisvd_Rldnr_Appl1.spras AS spras
INNER JOIN finsc_actve_appl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN finsc_ledger_t ON /* join condition not captured in parsed metadata */
;