fiscds_rldnr_vh

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 fiscds_rldnr_vh.
-- 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_VH

CREATE VIEW fiscds_rldnr_vh AS
SELECT
  I_LedgerCompanyCodeCrcyRoles.CompanyCode AS bukrs,
  I_LedgerCompanyCodeCrcyRoles.Ledger AS rldnr,
  $session.system_language AS spras,
  cast( I_LedgerCompanyCodeCrcyRoles._CompanyCodeCurrencyRole.CurrencyRole as fis_cc_currole ) AS curtp,
  I_LedgerCompanyCodeCrcyRoles._CompanyCodeCurrencyRole._Text[1: Language = $session.system_language].CurrencyRoleName AS curtp_text,
  cast( I_LedgerCompanyCodeCrcyRoles._CoCodeCurrencyRoleCurrency.Currency as fins_currh ) AS hwaer,
  cast( I_LedgerCompanyCodeCrcyRoles._GlobalCurrencyRole.CurrencyRole as fis_gc_currole ) AS curtp2,
  cast( I_LedgerCompanyCodeCrcyRoles._GlobalCurrencyRole._Text[1: Language = $session.system_language].CurrencyRoleName as fis_gc_currole_name ) AS curtp2_text,
  cast( I_LedgerCompanyCodeCrcyRoles._GlobalCurrencyRoleCurrency.Currency as fins_currk ) AS hwae2,
  cast( '' as fins_cur_pos_k ) AS CURPOS2,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency1Role.CurrencyRole as fis_fdc1_currole ) AS curtp3,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency1Role._Text[1: Language = $session.system_language].CurrencyRoleName as fis_fdc1_currole_name ) AS curtp3_text,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDfndCrcyRole1Currency.Currency as fis_rocur ) AS hwae3,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency2Role.CurrencyRole as fis_fdc2_currole ) AS curtp4,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency2Role._Text[1: Language = $session.system_language].CurrencyRoleName as fis_fdc2_currole_name ) AS curtp4_text,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDfndCrcyRole2Currency.Currency as fis_rvcur ) AS hwae4,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency3Role.CurrencyRole as fis_fdc3_currole ) AS curtp5,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency3Role._Text[1: Language = $session.system_language].CurrencyRoleName as fis_fdc3_currole_name ) AS curtp5_text,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDfndCrcyRole3Currency.Currency as fins_curr3 ) AS hwae5,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency4Role.CurrencyRole as fis_fdc4_currole ) AS curtp6,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency4Role._Text[1: Language = $session.system_language].CurrencyRoleName as fis_fdc4_currole_name ) AS curtp6_text,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDfndCrcyRole4Currency.Currency as fins_curr4 ) AS hwae6,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency5Role.CurrencyRole as fis_fdc5_currole ) AS curtp7,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency5Role._Text[1: Language = $session.system_language].CurrencyRoleName as fis_fdc5_currole_name ) AS curtp7_text,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDfndCrcyRole5Currency.Currency as fins_curr5 ) AS hwae7,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency6Role.CurrencyRole as fis_fdc6_currole ) AS curtp8,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency6Role._Text[1: Language = $session.system_language].CurrencyRoleName as fis_fdc6_currole_name ) AS curtp8_text,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDfndCrcyRole6Currency.Currency as fins_curr6 ) AS hwae8,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency7Role.CurrencyRole as fis_fdc7_currole ) AS curtp9,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency7Role._Text[1: Language = $session.system_language].CurrencyRoleName as fis_fdc7_currole_name ) AS curtp9_text,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDfndCrcyRole7Currency.Currency as fis_rfcur ) AS hwae9,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency8Role.CurrencyRole as fis_fdc8_currole ) AS curtp10,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDefinedCurrency8Role._Text[1: Language = $session.system_language].CurrencyRoleName as fis_fdc8_currole_name ) AS curtp10_text,
  cast( I_LedgerCompanyCodeCrcyRoles._FreeDfndCrcyRole8Currency.Currency as fins_curr8 ) AS hwae10,
  cast( I_LedgerCompanyCodeCrcyRoles._FunctionalCurrencyRole.CurrencyRole as fis_functional_currole ) AS curtp11,
  cast( I_LedgerCompanyCodeCrcyRoles._FunctionalCurrencyRole._Text[1: Language = $session.system_language].CurrencyRoleName as fis_functional_currolename ) AS curtp11_text,
  cast( I_LedgerCompanyCodeCrcyRoles._FunctionalCrcyRoleCurrency.Currency as fins_currfc ) AS hwae11
FROM I_LedgerCompanyCodeCrcyRoles
;