FCCX_TP_HD_P

DDL: FCCX_TP_HD_P Type: view_entity Package: FCCO_PROXY
25 Fields 6 Data Sources

HD view with lanaguage param

FCCX_TP_HD_P is a CDS View that provides data about "HD view with lanaguage param" in SAP S/4HANA. It reads from 6 data sources and exposes 25 fields with key fields VariantId, ProgramName. Part of development package FCCO_PROXY.

Data Sources (6)

SourceAliasJoin Type
FCCX_V_VARHD_P FCCX_V_VARHD_P left_outer
fccx_tskpar_hd hd from
fccx_tskpar_hdt hdt left_outer
fccx_rep_met_hd met_hd inner
trdirt trdirt left_outer
FCCXC_V_TP_USED_TM2 utm left_outer

Parameters (1)

NameTypeDefault
p_lang abap.lang

Annotations (6)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label HD view with lanaguage param view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY VariantId fccx_tskpar_hd variant_id Variant Id
KEY ProgramName fccx_tskpar_hd program_name Program Name
JobVariantKey
Text fccx_tskpar_hdt text User Group
JobTemplateName fccx_tskpar_hd application_job_template Job Template Name
SourceVariant fccx_tskpar_hd source_variant Variant
JobCatalogEntryName jt JobCatalogEntryName
ApplJobTemplateText jt text User Group
log_intent jt log_intent Log Intent
report_title trdirt text User Group
IsUsedInTaskModel
scoped
Transport v37 Transport Transportable
Environmnt v37 Environmnt Environment
Protected v37 Protected Protected
Secu v37 Secu Authorization Group
Version v37 Version XML Vers.
Ename v37 Ename User Name
Edat v37 Edat (8-character) Date for SYST
Etime v37 Etime TIME Data Element for SYST
Aename v37 Aename User Name
Aedat v37 Aedat Obsolete
Aetime v37 Aetime TIME Data Element for SYST
Mlangu v37 Mlangu Language
vtext v37 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_TP_HD_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_TP_HD_P AS
SELECT
  hd.variant_id AS VariantId,
  hd.program_name AS ProgramName,
  concat(hd.program_name, concat('&&', hd.variant_id) ) AS JobVariantKey,
  hdt.text AS Text,
  hd.application_job_template AS JobTemplateName,
  hd.source_variant AS SourceVariant,
  jt.JobCatalogEntryName AS JobCatalogEntryName,
  jt.text AS ApplJobTemplateText,
  jt.log_intent AS log_intent,
  trdirt.text AS report_title,
  case when utm.variant_id is null then '' else 'X' end AS IsUsedInTaskModel,
  case when jt.JobCatalogEntryName is null then 'A' else jt.scoped end AS scoped,
  v37.Transport AS Transport,
  v37.Environmnt AS Environmnt,
  v37.Protected AS Protected,
  v37.Secu AS Secu,
  v37.Version AS Version,
  v37.Ename AS Ename,
  v37.Edat AS Edat,
  v37.Etime AS Etime,
  v37.Aename AS Aename,
  v37.Aedat AS Aedat,
  v37.Aetime AS Aetime,
  v37.Mlangu AS Mlangu,
  v37.vtext AS vtext
FROM fccx_tskpar_hd AS hd
INNER JOIN fccx_rep_met_hd AS met_hd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fccx_tskpar_hdt AS hdt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN trdirt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FCCXC_V_TP_USED_TM2 AS utm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FCCX_V_VARHD_P ON /* join condition not captured in parsed metadata */
;

Learn More