Fisvd_Docnr_Gap_Rangeto

DDL: FISVD_DOCNR_GAP_RANGETO SQL: FISV_RANGETO Type: view Package: FINS_FIS_GL
8 Fields 1 Data Sources

Range To

Fisvd_Docnr_Gap_Rangeto is a CDS View that provides data about "Range To" in SAP S/4HANA. It reads from 1 data source (nriv) and exposes 8 fields. Part of development package FINS_FIS_GL.

Data Sources (1)

SourceAliasJoin Type
nriv to_year inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FISV_RANGETO view
EndUserText.label Range To view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (8)

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 nriv toyear To Year
yearto
externind nriv 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_Rangeto.
-- 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_RANGETO

CREATE VIEW Fisvd_Docnr_Gap_Rangeto AS
SELECT
  nriv.client AS client,
  nriv.subobject AS subobject,
  nriv.nrrangenr AS nrrangenr,
  to_year.fromnumber AS fromnumber,
  to_year.tonumber AS tonumber,
  nriv.toyear AS yearfrom,
  min(to_year.toyear) AS yearto,
  nriv.externind AS externind
INNER JOIN nriv AS to_year ON /* join condition not captured in parsed metadata */
;

Learn More