Finsvd_F4__Va_Simledger

DDL: FINSVD_F4__VA_SIMLEDGER SQL: FINSV_F4_VASIMLD Type: view

Value help view: simulation ledger according valuation area

Finsvd_F4__Va_Simledger is a CDS View that provides data about "Value help view: simulation ledger according valuation area" in SAP S/4HANA. It reads from 4 data sources (tacc_bwber_pr, tacc_trgt_ldgr, fagl_tldgrp_map, Finsvd_F4_Rldnr_For_Simulation) and exposes 7 fields with key fields bwber, rldnr.

Data Sources (4)

SourceAliasJoin Type
tacc_bwber_pr bpr inner
tacc_trgt_ldgr ldg inner
fagl_tldgrp_map map inner
Finsvd_F4_Rldnr_For_Simulation sld from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FINSV_F4_VASIMLD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Value help view: simulation ledger according valuation area view
ObjectModel.usageType.serviceQuality C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY bwber tacc_bwber_pr bwber Valuation Area
KEY rldnr Finsvd_F4_Rldnr_For_Simulation rldnr Ledger (Compat.)
name Finsvd_F4_Rldnr_For_Simulation name Zone name
ExtensionLedgerType Finsvd_F4_Rldnr_For_Simulation ExtensionLedgerType Extn. Ledger Type
ExtensionLedgerTypeName Finsvd_F4_Rldnr_For_Simulation ExtensionLedgerTypeName
core Finsvd_F4_Rldnr_For_Simulation core Underlying Ledger
ldgrp tacc_trgt_ldgr ldgrp_gl Target Ledger Group

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__Va_Simledger.
-- 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_VASIMLD

CREATE VIEW Finsvd_F4__Va_Simledger AS
SELECT
  bpr.bwber AS bwber,
  sld.rldnr AS rldnr,
  sld.name AS name,
  sld.ExtensionLedgerType AS ExtensionLedgerType,
  sld.ExtensionLedgerTypeName AS ExtensionLedgerTypeName,
  sld.core AS core,
  ldg.ldgrp_gl AS ldgrp
FROM Finsvd_F4_Rldnr_For_Simulation AS sld
INNER JOIN fagl_tldgrp_map AS map ON /* join condition not captured in parsed metadata */
INNER JOIN tacc_trgt_ldgr AS ldg ON /* join condition not captured in parsed metadata */
INNER JOIN tacc_bwber_pr AS bpr ON /* join condition not captured in parsed metadata */
;