Finsvd_F4_Rldnr_For_Simulation

DDL: FINSVD_F4_RLDNR_FOR_SIMULATION SQL: FINSV_F4_LDSIM Type: view

Value help view: extension ledger for simulation

Finsvd_F4_Rldnr_For_Simulation is a CDS View that provides data about "Value help view: extension ledger for simulation" in SAP S/4HANA. It reads from 3 data sources (finsc_actve_appl, finsc_ledger, finsc_ledger_t) and exposes 6 fields with key fields mandt, rldnr. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
finsc_actve_appl finsc_actve_appl inner
finsc_ledger finsc_ledger from
finsc_ledger_t finsc_ledger_t left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_LedgerExtTypeText _extledger_type_name $projection.ExtensionLedgerType = _extledger_type_name.ExtensionLedgerType

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FINSV_F4_LDSIM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Value help view: extension ledger for simulation view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY mandt finsc_ledger mandt Editing Client
KEY rldnr finsc_ledger rldnr Ledger (Compat.)
name finsc_ledger_t name Zone name
ExtensionLedgerType finsc_ledger ext_ledger_type Extn. Ledger Type
ExtensionLedgerTypeName
core finsc_ledger core Underlying Ledger

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 Finsvd_F4_Rldnr_For_Simulation.
-- 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_F4_LDSIM

CREATE VIEW Finsvd_F4_Rldnr_For_Simulation AS
SELECT
  finsc_ledger.mandt AS mandt,
  finsc_ledger.rldnr AS rldnr,
  finsc_ledger_t.name AS name,
  finsc_ledger.ext_ledger_type AS ExtensionLedgerType,
  cast( _extledger_type_name[1:Language=$session.system_language].ExtensionLedgerTypeName as fins_ext_ledger_type_name ) AS ExtensionLedgerTypeName,
  finsc_ledger.core AS core
FROM finsc_ledger
LEFT OUTER JOIN finsc_ledger_t ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_actve_appl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_LedgerExtTypeText AS _extledger_type_name ON ExtensionLedgerType = _extledger_type_name.ExtensionLedgerType  -- association [0..*]
;