FCCX_V_REP_VAR_CONT

DDL: FCCX_V_REP_VAR_CONT Type: view_entity Package: FCCO_PROXY

Report Variant Content

FCCX_V_REP_VAR_CONT is a CDS View that provides data about "Report Variant Content" in SAP S/4HANA. It reads from 2 data sources (FCCX_V_VARHD_P, fccx_rep_vari) and exposes 10 fields with key fields VARIANTID, PROGRAMNAME, selname, seqnr. Part of development package FCCO_PROXY.

Data Sources (2)

SourceAliasJoin Type
FCCX_V_VARHD_P FCCX_V_VARHD_P inner
fccx_rep_vari v from

Parameters (1)

NameTypeDefault
p_lang abap.lang

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Report Variant Content view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY VARIANTID fccx_rep_vari variant_id Variant Id
KEY PROGRAMNAME fccx_rep_vari program_name Program Name
KEY selname fccx_rep_vari selname Selection
KEY seqnr fccx_rep_vari seqnr Tank ID
kind fccx_rep_vari kind Usage Data Source
sign fccx_rep_vari sign Type of SIGN component in row type of a Ranges type
optioni fccx_rep_vari optioni Option
low fccx_rep_vari low Value from
high fccx_rep_vari high Value up to
vtext h vtext Wgh.Dat.Ty.Txt.

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 FCCX_V_REP_VAR_CONT.
-- 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.
-- Parameters: p_lang : abap.lang

CREATE VIEW FCCX_V_REP_VAR_CONT AS
SELECT
  v.variant_id AS VARIANTID,
  v.program_name AS PROGRAMNAME,
  v.selname AS selname,
  v.seqnr AS seqnr,
  v.kind AS kind,
  v.sign AS sign,
  v.optioni AS optioni,
  v.low AS low,
  v.high AS high,
  h.vtext AS vtext
FROM fccx_rep_vari AS v
INNER JOIN FCCX_V_VARHD_P ON /* join condition not captured in parsed metadata */
;