fiscds_rldnr_cu2

DDL: FISVD_RLDNR_CU2 SQL: FISV_RLDNR_CU2 Type: view

Currencies for company Code and ledger

fiscds_rldnr_cu2 is a CDS View that provides data about "Currencies for company Code and ledger" in SAP S/4HANA. It reads from 2 data sources (fiscds_rldnr_cur, t002) and exposes 24 fields.

Data Sources (2)

SourceAliasJoin Type
fiscds_rldnr_cur fiscds_rldnr_cur from
t002 t002 inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FISV_RLDNR_CU2 view
EndUserText.label Currencies for company Code and ledger view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (24)

KeyFieldSource TableSource FieldDescription
bukrs fiscds_rldnr_cur bukrs Value
rldnr fiscds_rldnr_cur rldnr Ledger (Compat.)
curtp fiscds_rldnr_cur curtp Valuation Area
hwaer fiscds_rldnr_cur hwaer Local Currency
curtp2 fiscds_rldnr_cur curtp2 Curr./Val. Type
hwae2 fiscds_rldnr_cur hwae2 Local curr. 2
curpos2 fiscds_rldnr_cur curpos2 Curr Pos K
curtp3 fiscds_rldnr_cur curtp3 FreeDef Crcy 1
hwae3 fiscds_rldnr_cur hwae3 Local curr. 3
curtp4 fiscds_rldnr_cur curtp4 FreeDef Crcy 2
hwae4 fiscds_rldnr_cur hwae4 Local curr. 4
curtp5 fiscds_rldnr_cur curtp5 FreeDef Crcy 3
hwae5 fiscds_rldnr_cur hwae5 Local curr. 4
curtp6 fiscds_rldnr_cur curtp6 FreeDef Crcy 4
hwae6 fiscds_rldnr_cur hwae6 Local curr. 6
curtp7 fiscds_rldnr_cur curtp7 FreeDef Crcy 5
hwae7 fiscds_rldnr_cur hwae7 Local curr. 7
curtp8 fiscds_rldnr_cur curtp8 FreeDef Crcy 6
hwae8 fiscds_rldnr_cur hwae8 Local curr. 8
curtp9 fiscds_rldnr_cur curtp9 FreeDef Crcy 7
hwae9 fiscds_rldnr_cur hwae9 Local curr. 9
curtp10 fiscds_rldnr_cur curtp10 FreeDef Crcy 8
hwae10 fiscds_rldnr_cur hwae10 Local curr. 10
spras t002 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 fiscds_rldnr_cu2.
-- 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_CU2

CREATE VIEW fiscds_rldnr_cu2 AS
SELECT
  fiscds_rldnr_cur.bukrs AS bukrs,
  fiscds_rldnr_cur.rldnr AS rldnr,
  fiscds_rldnr_cur.curtp AS curtp,
  fiscds_rldnr_cur.hwaer AS hwaer,
  fiscds_rldnr_cur.curtp2 AS curtp2,
  fiscds_rldnr_cur.hwae2 AS hwae2,
  fiscds_rldnr_cur.curpos2 AS curpos2,
  fiscds_rldnr_cur.curtp3 AS curtp3,
  fiscds_rldnr_cur.hwae3 AS hwae3,
  fiscds_rldnr_cur.curtp4 AS curtp4,
  fiscds_rldnr_cur.hwae4 AS hwae4,
  fiscds_rldnr_cur.curtp5 AS curtp5,
  fiscds_rldnr_cur.hwae5 AS hwae5,
  fiscds_rldnr_cur.curtp6 AS curtp6,
  fiscds_rldnr_cur.hwae6 AS hwae6,
  fiscds_rldnr_cur.curtp7 AS curtp7,
  fiscds_rldnr_cur.hwae7 AS hwae7,
  fiscds_rldnr_cur.curtp8 AS curtp8,
  fiscds_rldnr_cur.hwae8 AS hwae8,
  fiscds_rldnr_cur.curtp9 AS curtp9,
  fiscds_rldnr_cur.hwae9 AS hwae9,
  fiscds_rldnr_cur.curtp10 AS curtp10,
  fiscds_rldnr_cur.hwae10 AS hwae10,
  t002.spras AS spras
FROM fiscds_rldnr_cur
INNER JOIN t002 ON /* join condition not captured in parsed metadata */
;