I_SlsOrdFlfmtInSupplyContact

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_SlsOrdFlfmtInSupplyContact.
-- 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: ISOFINSUPCNTCT
-- Parameters: P_ManufacturingOrder : manufacturingorder, P_PurchasingDocument : ebeln

CREATE VIEW I_SlsOrdFlfmtInSupplyContact AS
SELECT
  ManufacturingOrder,
  cast('' as ebeln) AS PurchasingDocument,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  cast('' as esart) AS PurchasingDocumentType,
  ProductionPlant,
  cast('' as ekorg) AS PurchasingOrganization,
  cast('' as ekgrp) AS PurchasingGroup,
  cast('X' as internal_contact) AS ContactIsInternal,
  cast('' as external_contact) AS ContactIsExternal,
  cast('M1' as bu_pafkt) AS ContactPersonFunction,
  _MRPController.MRPControllerName AS ContactPersonName,
  _MRPController.MRPControllerPhoneNumber AS PhoneNumber,
  cast('' as ad_tlxtns) AS PhoneNumberExtension,
  cast('' as ad_telnrlg) AS InternationalPhoneNumber,
  cast('' as ad_tlnmbr) AS MobilePhoneNumber,
  cast('' as ad_telnrlg) AS InternationalMobilePhoneNumber
FROM I_MfgOrder
-- UNION ALL with additional select branch(es): I_PurchasingDocument
;