I_MfgWorkInstructionPRTInfoTP

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_MfgWorkInstructionPRTInfoTP.
-- 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: IEMBWIPRTINFOTP

CREATE VIEW I_MfgWorkInstructionPRTInfoTP AS
SELECT
  MfgWorkInstruction,
  MfgWorkInstructionVersCounter,
  MfgWorkInstructionVariable,
  ProdnRtgVersBOMInternalID,
  SelectedContextType,
  cast ('00000000' as cr_objid preserving type) AS ProductionResourceInternalID,
  cast (' ' as cr_objty preserving type) AS ProductionResourceType,
  cast (' ' as matnr preserving type ) AS Material,
  cast (' ' as maktx preserving type ) AS MaterialName,
  cast (' ' as equnr preserving type ) AS Equipment,
  cast (' ' as eqktu preserving type ) AS EquipmentName,
  cast (' ' as pzlfh ) AS ProdnRsceToolCounter,
  cast (' ' as fhktx preserving type ) AS ProductionResourceToolDesc,
  cast ('0000' as psnfh preserving type) AS ProdnRsceToolItemNumber,
  cast (' ' as mgeinh ) AS ProdnRsceToolStdWorkQtyUnit,
  cast (0 as mgvgw ) AS ProdnRsceToolStandardWorkQty,
  cast (' ' as mpe_prt_registrable preserving type ) AS ProdnRsceToolRegnIsAllowed,
  ' ' AS ProdnRsceToolCategory,
  cast(' ' as fhmar_ext preserving type ) AS ProdnRsceToolCategoryExtCode,
  cast(' ' as faktx preserving type ) AS ProdnRsceToolCategoryName,
  cast (' ' as fhmnr preserving type ) AS ProductionResourceTool,
  cast( 0 as tzntstmps ) AS CreationDateTime,
  cast( ' ' as usnam preserving type) AS ChangedBy,
  cast( 0 as tzntstmps ) AS LastChangeDateTime,
  cast(' ' as flag preserving type ) AS MfgIsItemSelected,
  cast(' ' as dokar preserving type ) AS DocumentType,
  cast( ' ' as doknr preserving type ) AS DocumentInfoRecord,
  cast(' ' as dokvr preserving type ) AS DocumentVersion,
  cast(' ' as doktl_d preserving type ) AS DocumentPart,
  cast( ' ' as doknr preserving type ) AS DocumentInfoRecordDocNumber,
  cast(' 'as mpe_is_referenced_in_cha preserving type ) AS PRTIsUsedAsTestEquipment
FROM I_MfgWorkInstructionVariable
LEFT OUTER JOIN I_OpActyWorkInstructionTP AS _OpActyWorkinstructionTP ON MfgWorkInstruction = _OpActyWorkinstructionTP.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _OpActyWorkinstructionTP.MfgWorkInstructionVersCounter  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StdWorkQtyUnit ON ProdnRsceToolStdWorkQtyUnit = _StdWorkQtyUnit.UnitOfMeasure  -- association [1..1]
;