P_MfgOrderDocInfoRecdObjLink

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 P_MfgOrderDocInfoRecdObjLink.
-- 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: PPPMFGORDDOCOBJL

CREATE VIEW P_MfgOrderDocInfoRecdObjLink AS
SELECT
  link.LinkedSAPObjectKey AS LinkedSAPObjectKey,
  link.LinkedSAPObject AS LinkedSAPObject,
  link.DocumentInfoRecordDocType AS DocumentType,
  link.DocumentInfoRecordDocNumber AS DocumentInfoRecord,
  link.DocumentInfoRecordDocPart AS DocumentPart,
  link.DocumentInfoRecordDocVersion AS DocumentVersion,
  link.CreationDateTime AS CreationDateTime,
  link.CreatedByUser AS CreatedByUser,
  link.ChangedDateTime AS ChangedDateTime,
  link.LastChangedByUser AS LastChangedByUser,
  docu.InternalDocumentStatus AS InternalDocumentStatus,
  docu.ChangeNumber AS ChangeNumber,
  docu.AuthorizationGroup AS AuthorizationGroup,
  docu.ResponsiblePersonName AS ResponsiblePersonName,
  docu.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  docu.Plant AS Plant,
  link.DocInfoRecdLinkStatus AS DocInfoRecdLinkStatus,
  link.DocInfoRecdObjectLinkStatus AS DocInfoRecdObjectLinkStatus,
  link.ObjectTypeDatabaseTable AS ObjectTypeDatabaseTable,
  link.IsDefaultDocument AS IsDefaultDocument,
  link.DocInfoRecdIsMarkedForDeletion AS DocInfoRecdIsMarkedForDeletion,
  ord.ManufacturingOrder AS ManufacturingOrder,
  substring(link.LinkedSAPObjectKey, 13, 1) AS MfgOrderLinkedObjType,
  substring(link.LinkedSAPObjectKey, 14, 4) AS ManufacturingOrderItem,
  substring(link.LinkedSAPObjectKey, 18, 6) AS ManufacturingOrderSequence,
  substring(link.LinkedSAPObjectKey, 24, 4) AS ManufacturingOrderOperation,
  substring(link.LinkedSAPObjectKey, 28, 8) AS OrderOperationInternalID,
  substring(link.LinkedSAPObjectKey, 41,10) AS OpActyNtwkElementExternalID,
  substring(link.LinkedSAPObjectKey, 51,18) AS SerialNumber,
  ord.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  ord.ManufacturingOrderType AS ManufacturingOrderType,
  ord._MfgOrderCategory AS _MfgOrderCategory,
  ord._MfgOrderType AS _MfgOrderType,
  link._DocumentInfoRecordDesc AS _Text
FROM P_MfgOrdLinkedSAPObjKeyRnge AS ord
INNER JOIN I_DocumentInfoRecordObjectLink AS link ON /* join condition not captured in parsed metadata */
INNER JOIN I_DocumentInfoRecord AS docu ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocType AS _DocumentType ON DocumentType = _DocumentType.DocumentInfoRecordDocType  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocNumber AS _DocumentNumber ON DocumentType = _DocumentNumber.DocumentInfoRecordDocType AND DocumentInfoRecord = _DocumentNumber.DocumentInfoRecordDocNumber  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocVersion AS _DocumentVersion ON DocumentType = _DocumentVersion.DocumentInfoRecordDocType AND DocumentInfoRecord = _DocumentVersion.DocumentInfoRecordDocNumber AND DocumentVersion = _DocumentVersion.DocumentInfoRecordDocVersion  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocPrt AS _DocumentPart ON DocumentType = _DocumentPart.DocumentInfoRecordDocType AND DocumentInfoRecord = _DocumentPart.DocumentInfoRecordDocNumber AND DocumentVersion = _DocumentPart.DocumentInfoRecordDocVersion AND DocumentPart = _DocumentPart.DocumentInfoRecordDocPart  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocStatus AS _DocumentStatus ON DocumentType = _DocumentStatus.DocumentInfoRecordDocType AND InternalDocumentStatus = _DocumentStatus.InternalDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordDesc AS _DocumentText ON DocumentType = _DocumentText.DocumentInfoRecordDocType AND DocumentInfoRecord = _DocumentText.DocumentInfoRecordDocNumber AND DocumentVersion = _DocumentText.DocumentInfoRecordDocVersion AND DocumentPart = _DocumentText.DocumentInfoRecordDocPart  -- association [0..*]
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 LastChangedByUser = _ChangedUser.UserID  -- association [0..1]
;