C_OpActyWorkInstructionTP

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_OpActyWorkInstructionTP.
-- 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: CEMBOAWITP

CREATE VIEW C_OpActyWorkInstructionTP AS
SELECT
  MfgWorkInstruction,
  MfgWorkInstructionVersCounter,
  OpActyNtwkVersionCounter,
  OpActyNtwkElement,
  OperationActivity,
  OperationActyVersionCounter,
  Plant,
  MfgWorkInstructionContent,
  Language,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsVersion,
  ProdnRtgVersBOMInternalID,
  BillOfMaterial,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  MfgWorkInstructionMode,
  SelectedContextType,
  SessionID,
  BillOfOperationsGroupIsForMES,
  EffectivityType,
  EngineeringChangeDocument,
  ManufacturingOrder,
  CreationUserName,
  LastChangeDateTime,
  LastChangedByUser
FROM I_OpActyWorkInstructionTP
LEFT OUTER JOIN C_MfgWorkInstrnBOMAssgmtTP AS _MfgWorkInstrnBOMAssgmtTP ON MfgWorkInstruction = _MfgWorkInstrnBOMAssgmtTP.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _MfgWorkInstrnBOMAssgmtTP.MfgWorkInstructionVersCounter  -- association [0..*]
LEFT OUTER JOIN C_MfgWorkInstrnComponentInfoTP AS _WorkInstrnComponentInfoTP ON MfgWorkInstruction = _WorkInstrnComponentInfoTP.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _WorkInstrnComponentInfoTP.MfgWorkInstructionVersCounter  -- association [0..*]
LEFT OUTER JOIN C_MfgWorkInstrnLgclCompInfoTP AS _WorkInstrnLgclCompInfoTP ON MfgWorkInstruction = _WorkInstrnLgclCompInfoTP.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _WorkInstrnLgclCompInfoTP.MfgWorkInstructionVersCounter  -- association [0..*]
LEFT OUTER JOIN C_MfgWorkInstructionPRTInfoTP AS _WorkInstrnProdnRsceToolInfoTP ON MfgWorkInstruction = _WorkInstrnProdnRsceToolInfoTP.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _WorkInstrnProdnRsceToolInfoTP.MfgWorkInstructionVersCounter  -- association [0..*]
LEFT OUTER JOIN C_MfgWrkInstrnInspCharcInfoTP AS _MfgWrkInstrnInspCharcInfoTP ON MfgWorkInstruction = _MfgWrkInstrnInspCharcInfoTP.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _MfgWrkInstrnInspCharcInfoTP.MfgWorkInstructionVersCounter  -- association [0..*]
LEFT OUTER JOIN C_MfgWorkInstrnPlaceHolderTP AS _WorkInstructionPlaceHolderTP ON MfgWorkInstruction = _WorkInstructionPlaceHolderTP.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _WorkInstructionPlaceHolderTP.MfgWorkInstructionVersCounter  -- association [0..*]
LEFT OUTER JOIN C_MfgWrkInstrnVarblAttributeVH AS _MfgWrkInstrnVarblAttributeVH ON SelectedContextType = _MfgWrkInstrnVarblAttributeVH.MfgWrkInstrnVariableType  -- association [0..*]
LEFT OUTER JOIN C_MfgWorkInstrnStdTextRefTP AS _WorkInstrnStdTextRefTP ON MfgWorkInstruction = _WorkInstrnStdTextRefTP.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _WorkInstrnStdTextRefTP.MfgWorkInstructionVersCounter  -- association [0..*]
LEFT OUTER JOIN C_MfgWrkInstrnCameraViewInfoTP AS _MfgWrkInstrnCameraViewInfoTP ON MfgWorkInstruction = _MfgWrkInstrnCameraViewInfoTP.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _MfgWrkInstrnCameraViewInfoTP.MfgWorkInstructionVersCounter  -- association [0..*]
LEFT OUTER JOIN C_MfgWorkInstrnProdMfgInfoTP AS _MfgWorkInstrnProdMfgInfoTP ON MfgWorkInstruction = _MfgWorkInstrnProdMfgInfoTP.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _MfgWorkInstrnProdMfgInfoTP.MfgWorkInstructionVersCounter  -- association [0..*]
;