I_MfgOrderOpDocInfoRecdObjLink

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_MfgOrderOpDocInfoRecdObjLink.
-- 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: IPPMFGOROPDOCOBL

CREATE VIEW I_MfgOrderOpDocInfoRecdObjLink AS
SELECT
  doc.DocumentType AS DocumentType,
  doc.DocumentInfoRecord AS DocumentInfoRecord,
  cast(doc.DocumentPart as pph_doktl preserving type) AS DocumentPart,
  cast(doc.DocumentVersion as pph_dokvr preserving type) AS DocumentVersion,
  cast(doc.CreationDateTime as hp_created_at preserving type) AS CreationDateTime,
  cast(doc.CreatedByUser as ernam preserving type) AS CreatedByUser,
  cast(doc.ChangedDateTime as hp_changed_at preserving type) AS ChangedDateTime,
  cast(doc.LastChangedByUser as aenam preserving type) AS ChangedBy,
  doc.InternalDocumentStatus AS InternalDocumentStatus,
  doc.ChangeNumber AS ChangeNumber,
  doc.AuthorizationGroup AS AuthorizationGroup,
  cast(doc.ResponsiblePersonName as pph_dwnam preserving type) AS ResponsiblePersonName,
  doc.DocInfoRecdLinkStatus AS DocInfoRecdLinkStatus,
  doc.DocInfoRecdObjectLinkStatus AS DocInfoRecdObjectLinkStatus,
  doc.ObjectTypeDatabaseTable AS ObjectTypeDatabaseTable,
  doc.DocLinkDirectionIsActive AS DocLinkDirectionIsActive,
  doc.IsDefaultDocument AS IsDefaultDocument,
  doc.DocInfoRecdIsMarkedForDeletion AS DocInfoRecdIsMarkedForDeletion,
  cast(doc.ManufacturingOrder as co_aufnr preserving type) AS ManufacturingOrder,
  cast(doc.ManufacturingOrderSequence as plnfolge preserving type) AS ManufacturingOrderSequence,
  cast(doc.ManufacturingOrderOperation as vornr_auf preserving type) AS ManufacturingOrderOperation,
  cast(doc.ManufacturingOrderOperation as vdm_vornr preserving type) AS ManufacturingOrderOperation_2,
  doc.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  doc.ManufacturingOrderType AS ManufacturingOrderType,
  doc._DocumentNumber AS _DocumentNumber,
  doc._DocumentType AS _DocumentType,
  doc._DocumentVersion AS _DocumentVersion,
  doc._DocumentPart AS _DocumentPart,
  doc._MfgOrderCategory AS _MfgOrderCategory,
  doc._MfgOrderType AS _MfgOrderType,
  doc._Text AS _Text
FROM P_MfgOrderDocInfoRecdObjLink AS doc
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderSequence AS _MfgOrderSequence ON ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperationBySemanKey AS _MfgOrderOperation ON ManufacturingOrder = _MfgOrderOperation.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOperation.ManufacturingOrderSequence AND ManufacturingOrderOperation = _MfgOrderOperation.ManufacturingOrderOperation  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperationBySemKey AS _MfgOrderOperation2 ON ManufacturingOrder = _MfgOrderOperation2.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOperation2.ManufacturingOrderSequence AND ManufacturingOrderOperation_2 = _MfgOrderOperation2.ManufacturingOrderOperation  -- association [1..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedUser ON CreatedByUser = _CreatedUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedUser ON ChangedBy = _ChangedUser.UserID  -- association [0..1]
;