FCCX_TP_DEF

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_DEF.
-- 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.

CREATE VIEW FCCX_TP_DEF AS
SELECT
  def.variant_id AS VariantId,
  def.program_name AS ProgramName,
  def.parameter_name AS ParameterName,
  def.parameter_type AS ParameterType,
  def.hidden_indicator AS HiddenIndicator,
  hdp.JobTemplateName AS JobTemplateName,
  rul.RuleCount AS RuleCount,
  meta.kind AS Kind,
  meta.type AS Type,
  meta.dtyp AS Dtyp,
  meta.length AS Length,
  meta.intlen AS Intlen,
  meta.decimals AS Decimals,
  meta.mandatory_ind AS MandatoryInd,
  meta.che_rad AS CheRad,
  meta.group_id AS GroupId,
  meta.dbtabname AS Dbtabname,
  meta.dbfieldname AS Dbfieldname,
  meta.typing_data_type AS TypingDataType,
  meta.conv_exit AS ConvExit,
  meta.lowercase AS Lowercase,
  meta.hidden_ind AS HiddenInd,
  meta.changeable_ind AS ChangeableInd,
  meta.is_date AS IsDate,
  meta.is_fyear AS IsFyear,
  meta.is_fper AS IsFper,
  meta.is_fyearperiod AS IsFyearperiod,
  meta.is_managed_by_fcco AS IsManagedByFcco,
  meta.parameter_type AS ParameterTypeMeta,
  meta.screen_position AS ScreenPosition,
  meta.value_help_type AS ValueHelpType,
  meta.shlp_name AS ShlpName,
  meta.has_value_help AS HasValueHelp
FROM fccx_tskpar_def AS def
INNER JOIN fccx_rep_met_par AS meta ON /* join condition not captured in parsed metadata */
INNER JOIN FCCX_TP_HD AS hdp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FCCX_V_tp_rul_distinct AS rul ON /* join condition not captured in parsed metadata */
;