FISVD_DOCNR_GAP_PARK_DEL

DDL: FISVD_DOCNR_GAP_PARK_DEL SQL: FISV_GAPPARKDEL Type: view Package: FINS_FIS_GL
13 Fields 2 Data Sources 1 Associations

Deleted Park Document Data

FISVD_DOCNR_GAP_PARK_DEL is a CDS View that provides data about "Deleted Park Document Data" in SAP S/4HANA. It reads from 2 data sources (bkpf, Fisvd_Docnr_Gap_Rangeblock) and exposes 13 fields with key fields mandt, bukrs, range, gjahr, numcbelnr. It has 1 association to related views. Part of development package FINS_FIS_GL.

Data Sources (2)

SourceAliasJoin Type
bkpf bkpf from
Fisvd_Docnr_Gap_Rangeblock rangeblock inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] dd07t _GAPTYPETEXT _GAPTYPETEXT.domvalue_l = 'Z' and _GAPTYPETEXT.domname = 'FIS_GAPTYPE'

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FISV_GAPPARKDEL view
EndUserText.label Deleted Park Document Data view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY mandt bkpf mandt Editing Client
KEY bukrs bkpf bukrs Value
KEY range Fisvd_Docnr_Gap_Rangeblock nrrangenr Number Range
KEY gjahr bkpf gjahr Settlement Year
KEY numcbelnr bkpf belnr SD Document
yearfrom Fisvd_Docnr_Gap_Rangeblock yearfrom FY from
yearto Fisvd_Docnr_Gap_Rangeblock yearto
fromnumber Fisvd_Docnr_Gap_Rangeblock fromnumber From number
tonumber Fisvd_Docnr_Gap_Rangeblock tonumber To number
cpudt bkpf cpudt Imported On
externind Fisvd_Docnr_Gap_Rangeblock externind External NR
gaptype
_GAPTYPETEXT _GAPTYPETEXT

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_PARK_DEL.
-- 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_GAPPARKDEL

CREATE VIEW FISVD_DOCNR_GAP_PARK_DEL AS
SELECT
  bkpf.mandt AS mandt,
  bkpf.bukrs AS bukrs,
  rangeblock.nrrangenr AS range,
  bkpf.gjahr AS gjahr,
  bkpf.belnr AS numcbelnr,
  rangeblock.yearfrom AS yearfrom,
  rangeblock.yearto AS yearto,
  rangeblock.fromnumber AS fromnumber,
  rangeblock.tonumber AS tonumber,
  bkpf.cpudt AS cpudt,
  rangeblock.externind AS externind,
  'Z' AS gaptype
FROM bkpf
INNER JOIN Fisvd_Docnr_Gap_Rangeblock AS rangeblock ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS _GAPTYPETEXT ON _GAPTYPETEXT.domvalue_l = 'Z' AND _GAPTYPETEXT.domname = 'FIS_GAPTYPE'  -- association [0..1]
;

Learn More