Fisvd_Docnr_Gap_Rangeblock

DDL: FISVD_DOCNR_GAP_RANGEBLOCK SQL: FISV_RANGEBLK Type: view Package: FINS_FIS_GL
14 Fields 3 Data Sources

Range Block

Fisvd_Docnr_Gap_Rangeblock is a CDS View that provides data about "Range Block" in SAP S/4HANA. It reads from 3 data sources (Fisvd_Docnr_Gap_Rangeto, nriv, Fisvd_Docnr_Gap_Rangefrom) and exposes 14 fields. Part of development package FINS_FIS_GL.

Data Sources (3)

SourceAliasJoin Type
Fisvd_Docnr_Gap_Rangeto Fisvd_Docnr_Gap_Rangeto union_all
nriv nriv from
Fisvd_Docnr_Gap_Rangefrom rangefrom inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FISV_RANGEBLK view
EndUserText.label Range Block view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
client nriv client Workflow definition: Client
subobject nriv subobject Triggering obj.
nrrangenr nriv nrrangenr Number Range
fromnumber nriv fromnumber From number
tonumber nriv tonumber To number
yearfrom Fisvd_Docnr_Gap_Rangefrom yearfrom FY from
yearto Fisvd_Docnr_Gap_Rangefrom yearto
subobject subobject Triggering obj.
nrrangenr nrrangenr Number Range
fromnumber fromnumber From number
tonumber tonumber To number
yearfrom yearfrom FY from
yearto yearto
externind externind External NR

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_Rangeblock.
-- 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_RANGEBLK

CREATE VIEW Fisvd_Docnr_Gap_Rangeblock AS
SELECT
  nriv.client AS client,
  nriv.subobject AS subobject,
  nriv.nrrangenr AS nrrangenr,
  nriv.fromnumber AS fromnumber,
  nriv.tonumber AS tonumber,
  rangefrom.yearfrom AS yearfrom,
  rangefrom.yearto AS yearto,
  externind
FROM nriv
INNER JOIN Fisvd_Docnr_Gap_Rangefrom AS rangefrom ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): Fisvd_Docnr_Gap_Rangeto
;

Learn More