fins_cnv_rec_bseg

DDL: FINS_CNV_REC_BSEG SQL: FINSV_CNV_BSEG Type: view
12 Fields 1 Data Sources

Currency Conv.: BSEG and Ext. OI Managm.

fins_cnv_rec_bseg is a CDS View that provides data about "Currency Conv.: BSEG and Ext. OI Managm." in SAP S/4HANA. It reads from 1 data source (acdoca) and exposes 12 fields with key fields bukrs, belnr, gjahr, buzei.

Data Sources (1)

SourceAliasJoin Type
acdoca a from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINSV_CNV_BSEG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Currency Conv.: BSEG and Ext. OI Managm. view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY bukrs acdoca rbukrs Company Code
KEY belnr acdoca belnr SD Document
KEY gjahr acdoca gjahr Settlement Year
KEY buzei acdoca buzei Posting View Item
augdt acdoca augdt Clearing
augbl acdoca augbl Clrng doc.
shkzg acdoca drcrk Debit/Credit
dmbtr
ktosl acdoca ktosl Transaction
hkont acdoca racct GL Account From
ebeln acdoca ebeln Source PurchDoc
ebelp acdoca ebelp Item pur. doc.

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_bseg.
-- 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_BSEG

CREATE VIEW fins_cnv_rec_bseg AS
SELECT
  a.rbukrs AS bukrs,
  a.belnr AS belnr,
  a.gjahr AS gjahr,
  a.buzei AS buzei,
  a.augdt AS augdt,
  a.augbl AS augbl,
  a.drcrk AS shkzg,
  sum( a.hsl ) AS dmbtr,
  a.ktosl AS ktosl,
  a.racct AS hkont,
  a.ebeln AS ebeln,
  a.ebelp AS ebelp
FROM acdoca AS a
;

Learn More