UPOV_NETOBJS_NETWORK

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 UPOV_NETOBJS_NETWORK.
-- 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: UPOS_NETOBJS_NW

CREATE VIEW UPOV_NETOBJS_NETWORK AS
SELECT
  floc.tplnr AS pn_floc,
  inet.tpvon AS from_floc,
  inet.tpnach AS to_floc,
  pn_label.strno AS pn_label,
  from_label.strno AS from_label,
  to_label.strno AS to_label,
  inet.datva AS datva,
  inet.zeitva AS zeita,
  inet.datvb AS datvb,
  inet.zeitvb AS zeitb
FROM inet
INNER JOIN gho_iflot_ext AS floc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN UPOV_NETOBJS AS pn_label ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN UPOV_NETOBJS AS from_label ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN UPOV_NETOBJS AS to_label ON /* join condition not captured in parsed metadata */
;