fins_cnv_rec_bcbs_ri

DDL: FINS_CNV_REC_BCBS_RI Type: view_entity
9 Fields 3 Data Sources

LCC: Select all relevant cleared items

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

Data Sources (3)

SourceAliasJoin Type
bse_clr bc from
fins_cnv_lcc_je lcc_je inner
fins_cnv_rec_bcbs_nri nr left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label LCC: Select all relevant cleared items view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY context_guid fins_cnv_lcc_je context_guid Context GUID
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 index_clr bse_clr index_clr Clrg Info Seq. No.
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

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_bcbs_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.

CREATE VIEW fins_cnv_rec_bcbs_ri AS
SELECT
  lcc_je.context_guid AS context_guid,
  bc.bukrs_clr AS bukrs_clr,
  bc.belnr_clr AS belnr_clr,
  bc.gjahr_clr AS gjahr_clr,
  bc.index_clr AS index_clr,
  bc.bukrs AS bukrs,
  bc.belnr AS belnr,
  bc.gjahr AS gjahr,
  bc.buzei AS buzei
FROM bse_clr AS bc
INNER JOIN fins_cnv_lcc_je AS lcc_je ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fins_cnv_rec_bcbs_nri AS nr ON /* join condition not captured in parsed metadata */
;

Learn More