I_MasterRecipeOperationTP

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_MasterRecipeOperationTP.
-- 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: IMRCOPTP

CREATE VIEW I_MasterRecipeOperationTP AS
SELECT
  BillOfOperationsGroup AS MasterRecipeGroup,
  BillOfOperationsVariant AS MasterRecipe,
  BOOOperationInternalID AS MasterRecipeOperationIntID,
  BOOOpInternalVersionCounter AS MstrRcpOperationIntVersion,
  Operation,
  OperationText,
  LongTextLanguageCode,
  _LongText.PlainLongText AS PlainLongText,
  WorkCenterTypeCode,
  WorkCenterInternalID,
  OperationStandardTextCode,
  Plant,
  OperationControlProfile,
  OperationReferenceQuantity,
  OperationUnit,
  OpQtyToBaseQtyNmrtr,
  OpQtyToBaseQtyDnmntr,
  NumberOfTimeTickets,
  EmployeeWageType,
  EmployeeWageGroup,
  NumberOfConfirmationSlips,
  NumberOfEmployees,
  OperationCostingRelevancyType,
  BusinessProcess,
  OperationSetupType,
  OperationSetupGroupCategory,
  OperationSetupGroup,
  CapacityCategoryCode,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  _ActyTP.ChangedDateTime AS ChangedDateTime
FROM I_MasterRecipeOperation
LEFT OUTER JOIN I_MasterRecipePhaseTP AS _Phase ON MasterRecipeGroup = _Phase.MasterRecipeGroup AND MasterRecipe = _Phase.MasterRecipe AND MasterRecipeOperationIntID = _Phase.BOOPhaseSuperiorOpInternalID AND MstrRcpOperationIntVersion = _Phase.MstrRcpOperationIntVersion AND ValidityEndDate >= _Phase.ValidityStartDate AND ValidityStartDate <= _Phase.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_MasterRecipeOpCompAllocTP AS _OpCompAlloc ON MasterRecipeGroup = _OpCompAlloc.MasterRecipeGroup AND MasterRecipe = _OpCompAlloc.MasterRecipe AND MasterRecipeOperationIntID = _OpCompAlloc.MasterRecipeOperationIntID AND ValidityEndDate >= _OpCompAlloc.ValidityStartDate AND ValidityStartDate <= _OpCompAlloc.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_MasterRecipeOpSecdryRsceTP AS _OpSecdryRsce ON MasterRecipeGroup = _OpSecdryRsce.MasterRecipeGroup AND MasterRecipe = _OpSecdryRsce.MasterRecipe AND MstrRcpOperationIntVersion = _OpSecdryRsce.SuperiorOperationInternalID AND ValidityEndDate >= _OpSecdryRsce.ValidityStartDate AND ValidityStartDate <= _OpSecdryRsce.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN R_MasterRcpInspCharcsAssgmtTP AS _InspCharcsAssgmt ON MasterRecipeGroup = _InspCharcsAssgmt.MasterRecipeGroup AND MasterRecipe = _InspCharcsAssgmt.MasterRecipe AND MasterRecipeOperationIntID = _InspCharcsAssgmt.MasterRecipeOperationIntID AND ValidityEndDate >= _InspCharcsAssgmt.ValidityStartDate AND ValidityStartDate <= _InspCharcsAssgmt.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_TaskListOperationLongText AS _LongText ON MasterRecipeGroup = _LongText.TaskListGroup AND MasterRecipeOperationIntID = _LongText.BOOOperationInternalID AND MstrRcpOperationIntVersion = _LongText.BOOInternalVersionCounter AND LongTextLanguageCode is not null AND _LongText.TaskListType = '2'  -- association [0..1]
LEFT OUTER JOIN I_MasterRecipeHeaderTP AS _Header ON MasterRecipeGroup = _Header.MasterRecipeGroup AND MasterRecipe = _Header.MasterRecipe AND ValidityEndDate >= _Header.ValidityStartDate AND ValidityStartDate <= _Header.ValidityEndDate  -- association [1..*]
;