FINS_CNV_CONVERSION_BSEG_ADD

DDL: FINS_CNV_CONVERSION_BSEG_ADD SQL: FINS_CNV_BSEGA Type: view
36 Fields 1 Data Sources

Currency Conversion: View Conv BSEG_ADD

FINS_CNV_CONVERSION_BSEG_ADD is a CDS View that provides data about "Currency Conversion: View Conv BSEG_ADD" in SAP S/4HANA. It reads from 1 data source (bseg_add) and exposes 36 fields with key fields bukrs, belnr, gjahr, buzei.

Data Sources (1)

SourceAliasJoin Type
bseg_add i from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINS_CNV_BSEGA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
EndUserText.label Currency Conversion: View Conv BSEG_ADD view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY bukrs bseg_add bukrs Value
KEY belnr bseg_add belnr SD Document
KEY gjahr bseg_add gjahr Settlement Year
KEY buzei bseg_add buzei Posting View Item
budat h budat Posting Date
bldat h bldat Journal Entry Date
hkont bseg_add hkont Transfer acct
awtyp h awtyp Reference Document Type
xopvw bseg_add xopvw OI Management
augdt bseg_add augdt Clearing
koart bseg_add koart Account type
waers h waers Transaction Currency
hwaer h hwaer Local Currency
hwae2 h hwae2 Local curr. 2
hwae3 h hwae3 Local curr. 3
rfccur bseg_add rfccur Functional Currency
pswsl bseg_add pswsl G/L Currency
wrbtr bseg_add wrbtr Gross Amount
dmbtr bseg_add dmbtr Loc. amount
dmbe2 bseg_add dmbe2 LC2 Amount
dmbe3 bseg_add dmbe3 LC3 Amount
fcsl bseg_add fcsl Amount in FunctCrcy
pswbt bseg_add pswbt G/L Amount
rdiff rdiff Rounding Diff.
rdif2 rdif2 Diff.Realized 2
rdif3 rdif3 Diff.Realized 3
bdif2 bdif2 Valuation Diff. 2
bdif3 bdif3 Valuation Diff. 3
bdiff bdiff Valuation Diff.
mwst2 mwst2 LC2 Tax
mwst3 mwst3 LC3 Tax
mwsts mwsts LC tax amount
ppdif2 ppdif2 Diff. Realized
ppdif3 ppdif3 Diff. Realized
ppdiff ppdiff Diff. Realized
wmwst wmwst Tax Amount

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_CONVERSION_BSEG_ADD.
-- 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: FINS_CNV_BSEGA

CREATE VIEW FINS_CNV_CONVERSION_BSEG_ADD AS
SELECT
  i.bukrs AS bukrs,
  i.belnr AS belnr,
  i.gjahr AS gjahr,
  i.buzei AS buzei,
  h.budat AS budat,
  h.bldat AS bldat,
  i.hkont AS hkont,
  h.awtyp AS awtyp,
  i.xopvw AS xopvw,
  i.augdt AS augdt,
  i.koart AS koart,
  h.waers AS waers,
  h.hwaer AS hwaer,
  h.hwae2 AS hwae2,
  h.hwae3 AS hwae3,
  i.rfccur AS rfccur,
  i.pswsl AS pswsl,
  i.wrbtr AS wrbtr,
  i.dmbtr AS dmbtr,
  i.dmbe2 AS dmbe2,
  i.dmbe3 AS dmbe3,
  i.fcsl AS fcsl,
  i.pswbt AS pswbt,
  rdiff,
  rdif2,
  rdif3,
  bdif2,
  bdif3,
  bdiff,
  mwst2,
  mwst3,
  mwsts,
  ppdif2,
  ppdif3,
  ppdiff,
  wmwst
FROM bseg_add AS i
;

Learn More