I_SFIDocInfoRecdObjLink

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_SFIDocInfoRecdObjLink.
-- 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: IPPSFIDOCOBJL

CREATE VIEW I_SFIDocInfoRecdObjLink AS
SELECT
  doc.LinkedSAPObjectKey AS LinkedSAPObjectKey,
  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.ManufacturingOrderItem as pph_itemc preserving type) AS ManufacturingOrderItem,
  sfi.ShopFloorItem AS ShopFloorItem,
  cast(doc.ManufacturingOrderSequence as plnfolge preserving type) AS ManufacturingOrderSequence,
  cast(doc.ManufacturingOrderOperation as vornr_auf preserving type) AS ManufacturingOrderOperation,
  OA.OpActyNtwkInstance AS OpActyNtwkInstance,
  OA.OpActyNtwkElement AS OpActyNtwkElement,
  oan.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  doc.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  doc.ManufacturingOrderType AS ManufacturingOrderType,
  doc._CreatedUser AS _CreatedUser,
  doc._ChangedUser AS _ChangedUser,
  doc._DocumentNumber AS _DocumentNumber,
  doc._DocumentType AS _DocumentType,
  doc._DocumentVersion AS _DocumentVersion,
  doc._DocumentPart AS _DocumentPart,
  doc._MfgOrder AS _MfgOrder,
  doc._MfgOrderCategory AS _MfgOrderCategory,
  doc._MfgOrderType AS _MfgOrderType
FROM P_MfgOrderDocInfoRecdObjLink AS doc
INNER JOIN I_ShopFloorItem AS sfi ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MfgOrderItem AS _MfgOrderItem ON ManufacturingOrder = _MfgOrderItem.ManufacturingOrder AND ManufacturingOrderItem = _MfgOrderItem.ManufacturingOrderItem  -- association [0..1]
LEFT OUTER JOIN I_ShopFloorItem AS _ShopFloorItem ON ShopFloorItem = _ShopFloorItem.ShopFloorItem  -- association [1..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OpActyNtwkInstance ON OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance  -- association [0..1]
LEFT OUTER JOIN I_OperationActivityInstance AS _OperationActivityInstance ON OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderSequence 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_OANSegmentType AS _OANSegmentType ON OpActyNtwkSegmentType = _OANSegmentType.OpActyNtwkSegmentType  -- association [1..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [0..1]
;