FCCX_V_VARHD_P

DDL: FCCX_V_VARHD_P Type: view_entity
15 Fields 2 Data Sources

Report Variants (SM37)

FCCX_V_VARHD_P is a CDS View that provides data about "Report Variants (SM37)" in SAP S/4HANA. It reads from 2 data sources (varid, varit) and exposes 15 fields with key fields Report, Variant.

Data Sources (2)

SourceAliasJoin Type
varid h from
varit t left_outer

Parameters (1)

NameTypeDefault
p_lang abap.lang

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Report Variants (SM37) view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Report varid report Report Name
KEY Variant varid variant Variant Saved
Transport varid transport Transportable
Environmnt varid environmnt Environment
Protected varid protected Protected
Secu varid secu Authorization Group
Version varid version XML Vers.
Ename varid ename User Name
Edat varid edat (8-character) Date for SYST
Etime varid etime TIME Data Element for SYST
Aename varid aename User Name
Aedat varid aedat Obsolete
Aetime varid aetime TIME Data Element for SYST
Mlangu varid mlangu Language
vtext varit 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_VARHD_P.
-- 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_VARHD_P AS
SELECT
  h.report AS Report,
  h.variant AS Variant,
  h.transport AS Transport,
  h.environmnt AS Environmnt,
  h.protected AS Protected,
  h.secu AS Secu,
  h.version AS Version,
  h.ename AS Ename,
  h.edat AS Edat,
  h.etime AS Etime,
  h.aename AS Aename,
  h.aedat AS Aedat,
  h.aetime AS Aetime,
  h.mlangu AS Mlangu,
  t.vtext AS vtext
FROM varid AS h
LEFT OUTER JOIN varit AS t ON /* join condition not captured in parsed metadata */
;

Learn More