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,
  BOOOperationInternalID,
  OpActyNtwkSegmentType,
  BillOfOperationsSequence,
  WorkCenter,
  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..*]
;