I_CurrencyTypesCorrespnc

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 I_CurrencyTypesCorrespnc.
-- 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: ICURRTPCORR

CREATE VIEW I_CurrencyTypesCorrespnc AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYearVariant,
  CompanyCodeCurrencyRole,
  GlobalCurrencyRole,
  FreeDefinedCurrency1Role,
  FreeDefinedCurrency2Role,
  FreeDefinedCurrency3Role,
  FreeDefinedCurrency4Role,
  FreeDefinedCurrency5Role,
  FreeDefinedCurrency6Role,
  FreeDefinedCurrency7Role,
  FreeDefinedCurrency8Role,
  AccountingPrinciple,
  cast(curtcc_text.CurrencyRoleName as fins_curtype_h_t ) AS CompanyCodeCurrencyRoleName,
  cast(curtgc_text.CurrencyRoleName as fins_curtype_k_t ) AS GlobalCurrencyRoleName,
  cast(curtp1_text.CurrencyRoleName as fins_curtype_o_t ) AS FreeDefinedCurrency1RoleName,
  cast(curtp2_text.CurrencyRoleName as fins_curtype_v_t ) AS FreeDefinedCurrency2RoleName,
  cast(curtp3_text.CurrencyRoleName as fins_curtype_b_t ) AS FreeDefinedCurrency3RoleName,
  cast(curtp4_text.CurrencyRoleName as fins_curtype_c_t ) AS FreeDefinedCurrency4RoleName,
  cast(curtp5_text.CurrencyRoleName as fins_curtype_d_t ) AS FreeDefinedCurrency5RoleName,
  cast(curtp6_text.CurrencyRoleName as fins_curtype_e_t ) AS FreeDefinedCurrency6RoleName,
  cast(curtp7_text.CurrencyRoleName as fins_curtype_f_t ) AS FreeDefinedCurrency7RoleName,
  cast(curtp8_text.CurrencyRoleName as fins_curtype_g_t ) AS FreeDefinedCurrency8RoleName
FROM I_LedgerCompanyCodeCrcyRoles
LEFT OUTER JOIN I_CurrencyRoleText AS curtcc_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CurrencyRoleText AS curtgc_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CurrencyRoleText AS curtp1_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CurrencyRoleText AS curtp2_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CurrencyRoleText AS curtp3_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CurrencyRoleText AS curtp4_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CurrencyRoleText AS curtp5_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CurrencyRoleText AS curtp6_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CurrencyRoleText AS curtp7_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CurrencyRoleText AS curtp8_text ON /* join condition not captured in parsed metadata */
;