I_NotificationType

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_NotificationType.
-- 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: INOTIFTYPE

CREATE VIEW I_NotificationType AS
SELECT
  qmart AS NotificationType,
  qmnuk AS NumberRange,
  herkz AS NotificationOrigin,
  cast( parvw_kund as vdm_q_parvw_kund preserving type ) AS NotifPartnerFuncCustomer,
  cast( parvw_ap as vdm_q_parvw_ap preserving type ) AS NotifPartnerFuncContactPerson,
  cast( parvw_int as vdm_q_parvw_int preserving type ) AS NotifPrtnFuncImplementingDept,
  cast( parvw_lief as vdm_q_parvw_lief preserving type ) AS NotifPartnerFuncSupplier,
  cast( parvw_her as vdm_q_parvw_her preserving type ) AS NotifPartnerFuncManufacturer,
  cast( parvw_vera as vdm_q_parvw_vera preserving type ) AS NotifPartnerRoleResponsible,
  cast( parvw_auto as vdm_q_parvw_auto preserving type ) AS NotifPartnerFuncAuthor,
  cast( parvw_qmsm as vdm_q_parvw_qmsm preserving type ) AS NotifPartnerFuncTask,
  cast( parvw_geh as vdm_q_parvw_geh preserving type ) AS NotifPartnerFuncApprover
FROM tq80
;