fins_cnv_rec_clr_ri

DDL: FINS_CNV_REC_CLR_RI SQL: FINSV_CNV_CLR_RI Type: view
22 Fields 4 Data Sources

LCC: Select all relevant cleared JE

fins_cnv_rec_clr_ri is a CDS View that provides data about "LCC: Select all relevant cleared JE" in SAP S/4HANA. It reads from 4 data sources (bse_clr, bse_clr, fins_cnv_lcc_je, fins_cnv_lcc_je) and exposes 22 fields with key fields context_guid, rldnr, bukrs_clr, belnr_clr, gjahr_clr.

Data Sources (4)

SourceAliasJoin Type
bse_clr bc from
bse_clr bc union_all
fins_cnv_lcc_je lcc_je inner
fins_cnv_lcc_je lcc_je inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINSV_CNV_CLR_RI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.preserveKey true view
EndUserText.label LCC: Select all relevant cleared JE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY context_guid fins_cnv_lcc_je context_guid Context GUID
KEY rldnr fins_cnv_lcc_je rldnr Ledger (Compat.)
KEY bukrs_clr bse_clr bukrs_clr Company Code
KEY belnr_clr bse_clr belnr_clr Document Number
KEY gjahr_clr bse_clr gjahr_clr Fiscal Year
KEY buzei_clr bse_clr agbuz Item
KEY bukrs bse_clr bukrs_clr Value
KEY belnr bse_clr belnr_clr SD Document
KEY gjahr bse_clr gjahr_clr Settlement Year
KEY buzei bse_clr agbuz Posting View Item
KEY agzei bse_clr agzei Clearing Item
KEY rldnr fins_cnv_lcc_je rldnr Ledger (Compat.)
KEY bukrs_clr bse_clr bukrs_clr Company Code
KEY belnr_clr bse_clr belnr_clr Document Number
KEY gjahr_clr bse_clr gjahr_clr Fiscal Year
KEY buzei_clr bse_clr agbuz Item
KEY bukrs bse_clr bukrs Value
KEY belnr bse_clr belnr SD Document
KEY gjahr bse_clr gjahr Settlement Year
KEY buzei bse_clr buzei Posting View Item
KEY agzei bse_clr agzei Clearing Item
KEY curtp fins_cnv_lcc_je curtp Valuation Area

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 fins_cnv_rec_clr_ri.
-- 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_CNV_CLR_RI

CREATE VIEW fins_cnv_rec_clr_ri AS
SELECT
  lcc_je.context_guid AS context_guid,
  lcc_je.rldnr AS rldnr,
  bc.bukrs_clr AS bukrs_clr,
  bc.belnr_clr AS belnr_clr,
  bc.gjahr_clr AS gjahr_clr,
  bc.agbuz AS buzei_clr,
  bc.bukrs_clr AS bukrs,
  bc.belnr_clr AS belnr,
  bc.gjahr_clr AS gjahr,
  bc.agbuz AS buzei,
  bc.agzei AS agzei,
  lcc_je.curtp AS curtp
FROM bse_clr AS bc
INNER JOIN fins_cnv_lcc_je AS lcc_je ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): bse_clr
;

Learn More