Fisvd_Docnr_Gap_Unionbase

DDL: FISVD_DOCNR_GAP_UNIONBASE SQL: FISV_GAPUB Type: view Package: FINS_FIS_GL
19 Fields 2 Data Sources

Base BKPF union BKPF plus 1

Fisvd_Docnr_Gap_Unionbase is a CDS View that provides data about "Base BKPF union BKPF plus 1" in SAP S/4HANA. It reads from 2 data sources (Fisvd_Docnr_Gap_Mergestart, Fisvd_Docnr_Gap_Mergestart) and exposes 19 fields. Part of development package FINS_FIS_GL.

Data Sources (2)

SourceAliasJoin Type
Fisvd_Docnr_Gap_Mergestart Fisvd_Docnr_Gap_Mergestart from
Fisvd_Docnr_Gap_Mergestart Fisvd_Docnr_Gap_Mergestart union_all

Parameters (2)

NameTypeDefault
P_bukrs abap.char( 4 )
P_gjahr abap.numc( 4 )

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FISV_GAPUB view
EndUserText.label Base BKPF union BKPF plus 1 view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (19)

KeyFieldSource TableSource FieldDescription
mandt mandt Editing Client
bukrs bukrs Value
range range Range
dbelnr dbelnr
yearfrom yearfrom FY from
yearto yearto
P_gjahrP_gjahrmandt
bukrs bukrs Value
range range Range
dbelnr
yearfrom yearfrom FY from
yearto yearto
P_gjahrP_gjahrmandt
bukrs bukrs Value
range range Range
dbelnr dbelnr
yearfrom yearfrom FY from
yearto yearto
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_Docnr_Gap_Unionbase.
-- 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_GAPUB
-- Parameters: P_bukrs : abap.char( 4 ), P_gjahr : abap.numc( 4 )

CREATE VIEW Fisvd_Docnr_Gap_Unionbase AS
SELECT
  mandt,
  bukrs,
  range,
  dbelnr,
  yearfrom,
  yearto,
  flag
FROM Fisvd_Docnr_Gap_Mergestart
-- UNION ALL with additional select branch(es): Fisvd_Docnr_Gap_Mergestart
;

Learn More