FISVD_DOCNR_GAP_PARK_AA

DDL: FISVD_DOCNR_GAP_PARK_AA SQL: FISV_GAPPARKAA Type: view
13 Fields 3 Data Sources 1 Associations

Asset Park Document Data

FISVD_DOCNR_GAP_PARK_AA is a CDS View that provides data about "Asset Park Document Data" in SAP S/4HANA. It reads from 3 data sources (vbkpf, Fisvd_Docnr_Gap_Rangeblock, vbsega) and exposes 13 fields with key fields mandt, bukrs, range, gjahr, numcbelnr. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
vbkpf bkpf from
Fisvd_Docnr_Gap_Rangeblock rangeblock inner
vbsega vbsega inner

Associations (1)

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

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FISV_GAPPARKAA view
EndUserText.label Asset 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 vbkpf mandt Editing Client
KEY bukrs vbkpf bukrs Value
KEY range Fisvd_Docnr_Gap_Rangeblock nrrangenr Number Range
KEY gjahr vbkpf gjahr Settlement Year
KEY numcbelnr vbkpf 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 vbkpf 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_AA.
-- 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_GAPPARKAA

CREATE VIEW FISVD_DOCNR_GAP_PARK_AA 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,
  'A' AS gaptype
FROM vbkpf AS bkpf
INNER JOIN vbsega ON /* join condition not captured in parsed metadata */
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 = 'A' AND _GAPTYPETEXT.domname = 'FIS_GAPTYPE'  -- association [0..1]
;

Learn More