C_UI5NetworkGraphGroup

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 C_UI5NetworkGraphGroup.
-- 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: CUI5NGGROUP

CREATE VIEW C_UI5NetworkGraphGroup AS
SELECT
  UI5NetworkGraphGroup,
  UI5NetworkGraphDescription,
  UI5NetworkGraphGroupIcon,
  cast('' as swo_objtyp) AS ReferenceDocumentType,
  cast( '' as fac_ddf_anchor_document ) AS AnchorDocument,
  cast('' as vbeln_va) AS SalesDocument,
  cast('' as vbeln_vl) AS DeliveryDocument,
  cast('' as crmt_object_id_db) AS ServiceContract,
  cast('' as crms4_number_int) AS ServiceContractItem,
  cast('' as crmt_object_id_db) AS ServiceOrder,
  cast('' as crmt_object_id_db) AS ServiceConfirmation,
  cast('' as crmt_object_id_db) AS BusinessSolutionOrder,
  cast('' as vbeln_bdr) AS BillingDocumentRequest,
  cast('' as fac_ddf_billing) AS BillingDocument,
  cast('' as bukrs) AS CompanyCode,
  cast('' as fac_ddf_accounting_document ) AS AccountingDocument,
  cast('' as fis_gjahr) AS FiscalYear,
  cast('' as ebeln) AS PurchasingDocument,
  cast('' as ebelp) AS PurchasingDocumentItem,
  cast('' as fmis_earmarkedfundsdoc) AS EarmarkedFundsDocument,
  cast('' as vdm_purchaserequisition) AS PurchaseRequisition,
  cast('' as re_belnr) AS AccountMaintenanceDocument,
  cast('' as fac_ddf_supplier_invoice) AS SupplierInvoice,
  cast('' as fac_ddf_manufacturing_order) AS ManufacturingOrder,
  cast('' as cte_fin_post_doc_id) AS ConcurDocumentID,
  cast(0 as cte_system_key_number) AS ConcurSystemKey,
  cast('' as cte_fin_post_doc_type) AS ConcurDocumentType,
  cast('' as cte_fnd_post_doc_rev_id) AS ConcurDocumentRevisionNumber,
  cast('' as mblnr) AS MaterialDocument,
  cast('' as nsdm_mjahr) AS MaterialDocumentYear,
  cast('' as /pf1/dte_po_pi_secondary_key) AS PaymentItemNumber,
  cast('' as /pf1/dte_bpe_clearing_area ) AS ClearingArea,
  cast('00000000' as /pf1/dte_po_pi_key_date) AS PaymentItemDate,
  cast('' as /ui2/semantic_object_name) AS SemanticObjectName
FROM I_UI5NetworkGraphGroup
LEFT OUTER JOIN C_UI5NetworkGraphNode AS _Node ON UI5NetworkGraphGroup = _Node.UI5NetworkGraphGroup  -- association [1..*]
;