Fisvd_Docnr_Gap_Numbergap

DDL: FISVD_DOCNR_GAP_NUMBERGAP SQL: FISV_GAPNUMGAP Type: view
6 Fields 1 Data Sources

Gap start and end number

Fisvd_Docnr_Gap_Numbergap is a CDS View that provides data about "Gap start and end number" in SAP S/4HANA. It reads from 1 data source (Fisvd_Docnr_Gap_Sumflag) and exposes 6 fields.

Data Sources (1)

SourceAliasJoin Type
Fisvd_Docnr_Gap_Sumflag Fisvd_Docnr_Gap_Sumflag from

Parameters (2)

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

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FISV_GAPNUMGAP view
EndUserText.label Gap start and end number view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
mandt mandt Editing Client
bukrs bukrs Value
range range Range
dbelnr
yearfrom yearfrom FY from
yearto yearto

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_Numbergap.
-- 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_GAPNUMGAP
-- Parameters: P_bukrs : abap.char( 4 ), P_gjahr : abap.numc( 4 )

CREATE VIEW Fisvd_Docnr_Gap_Numbergap AS
SELECT
  mandt,
  bukrs,
  range,
  dbelnr - 1 AS dbelnr,
  yearfrom,
  yearto
FROM Fisvd_Docnr_Gap_Sumflag
;

Learn More