C_SlsDocFlfmtMfgOrderContacts

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_SlsDocFlfmtMfgOrderContacts.
-- 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: CSOFMFGORDERCONT

CREATE VIEW C_SlsDocFlfmtMfgOrderContacts AS
SELECT
  Header.ManufacturingOrder AS ManufacturingOrder,
  cast( '03' as parvw ) AS PartnerFunction,
  ContactCardUser.UserID AS UserID,
  cast( ContactCardUser.FullName as ad_namtext ) as FullName AS FullNameasad_namtextasFullName,
  cast ( ContactCardUser.LastName as ad_namelas ) as FamilyName AS LastNameasad_namelasasFamilyName,
  cast ( ContactCardUser.FirstName as ad_namefir ) as FirstName AS FirstNameasad_namefirasFirstName,
  cast( ContactCardUser.EmailAddress as ad_smtpadr ) as EmailAddress AS EmailAddressasad_smtpadrasEmailAddress,
  Header.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  Header.ManufacturingOrderType AS ManufacturingOrderType,
  Header.ProductionPlant AS ProductionPlant
INNER JOIN I_MRPController AS MRPController ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgOrder AS Header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MfgOrderObjPgContTypeText AS _MfgOrderObjPgContTypeText ON PartnerFunction = _MfgOrderObjPgContTypeText.InteractionContactType  -- association [0..*]
;