I_MDChangeProcessModelFieldVH

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 I_MDChangeProcessModelFieldVH.
-- 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: IMDCHGPRMDLFLDVH

CREATE VIEW I_MDChangeProcessModelFieldVH AS
SELECT
  cast ( concat(concat(Table.MDChgProcessModelTableName, '-'), Field.field_name) as mdc_wl_attribute ) AS MDChgProcessSrchQueryAttribute,
  Table.MDChgProcessSrceObjectTypeCode AS MDChgProcessSrceObjectTypeCode,
  Table.MDChgProcessModelTableName AS MDChgProcessModelTableName,
  Table.MDChangeProcModelTableDesc AS MDChangeProcModelTableDesc,
  Field.field_name AS MDChangeProcessModelFieldName,
  dd04t.ddtext AS MDChangeProcessModelFieldDesc,
  dd03l.keyflag AS IsKeyField,
  case when CustomField.selective is not null then CustomField.selective else Field.selective end AS MDChgProcQryAttribIsSelective,
  case when CustomField.obscured is not null then CustomField.obscured else Field.obscured end AS MDChgProcQryAttribIsObscured,
  case when CustomField.technical is not null then CustomField.technical else Field.technical end AS MDChgProcQryAttribIsTechnical
FROM I_MDChangeProcessModelTable AS Table
INNER JOIN mdc_model_fields AS Field ON /* join condition not captured in parsed metadata */
INNER JOIN dd03l ON /* join condition not captured in parsed metadata */
;