/AIF/C_InterfaceStatistics

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 /AIF/C_InterfaceStatistics.
-- 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: /AIF/CIFSTA

CREATE VIEW /AIF/C_InterfaceStatistics AS
SELECT
  IFSta.ns AS Namespace,
  IFSta.ifname AS InterfaceName,
  IFSta.ifver AS InterfaceVersion,
  case when IFDisp.ifdisplay is null then IFSta.ifkey when IFDisp.ifdisplay is initial then IFSta.ifkey else IFDisp.ifdisplay end as InterfaceKey AS ifdisplayendasInterfaceKey,
  IFSta.idxtbl AS IndexTable,
  IFSta.count_all AS NumberAllMessages,
  IFSta.count_w AS NumberWarningMessages,
  IFSta.count_e AS NumberErrorMessages,
  IFSta.count_a AS NumberAbortMessages,
  IFSta.count_i AS NumberInProcessMessages,
  IFSta.count_s AS NumberSuccessMessages,
  IFSta.count_c AS NumberCanceledMessages,
  IFSta.is_tech_interface AS IsTechnicalInterface
FROM /AIF/I_InterfaceStatistics
LEFT OUTER JOIN /AIF/I_Interface_Display AS IFDisp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /AIF/I_Namespace_T AS _NSDes ON Namespace = _NSDes.ns  -- association [0..*]
LEFT OUTER JOIN /AIF/I_Namespace_VH AS _NSValueHelp ON Namespace = _NSValueHelp.ns  -- association [0..1]
LEFT OUTER JOIN /AIF/I_Interface_T AS _IFDes ON Namespace = _IFDes.ns AND InterfaceName = _IFDes.ifname AND InterfaceVersion = _IFDes.ifversion  -- association [0..*]
;