FISVD_GL_DOCNR_GAP_CONVERTBASE

DDL: FISVD_GL_DOCNR_GAP_CONVERTBASE SQL: FISV_GLGAPCONVBA Type: view
10 Fields 1 Data Sources

Base data from BKPF with converted belnr

FISVD_GL_DOCNR_GAP_CONVERTBASE is a CDS View that provides data about "Base data from BKPF with converted belnr" in SAP S/4HANA. It reads from 1 data source (FISVD_GL_DOCNR_GAP_BASE) and exposes 10 fields.

Data Sources (1)

SourceAliasJoin Type
FISVD_GL_DOCNR_GAP_BASE FISVD_GL_DOCNR_GAP_BASE from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FISV_GLGAPCONVBA view
EndUserText.label Base data from BKPF with converted belnr view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
mandt mandt Editing Client
bukrs bukrs Value
range range Range
gjahr gjahr Settlement Year
rldnr rldnr Ledger (Compat.)
dbelnr
yearfrom yearfrom FY from
yearto yearto
cpudt cpudt Imported On
flag flag Switch

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 FISVD_GL_DOCNR_GAP_CONVERTBASE.
-- 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_GLGAPCONVBA

CREATE VIEW FISVD_GL_DOCNR_GAP_CONVERTBASE AS
SELECT
  mandt,
  bukrs,
  range,
  gjahr,
  rldnr,
  cast(numcbelnr as abap.dec( 20, 0 )) AS dbelnr,
  yearfrom,
  yearto,
  cpudt,
  flag
FROM FISVD_GL_DOCNR_GAP_BASE
;

Learn More