I_MasterRecipeHeader

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_MasterRecipeHeader.
-- 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: IMSTRRECPHDR

CREATE VIEW I_MasterRecipeHeader AS
SELECT
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BOOInternalVersionCounter,
  cast( ValidityStartDate as vdm_datuv ) AS ValidityStartDate,
  cast( ValidityEndDate as vdm_datub ) AS ValidityEndDate,
  ChangeNumber,
  IsMarkedForDeletion,
  IsDeleted,
  IsImplicitlyDeleted,
  BillOfOperationsDesc,
  LongTextLanguageCode,
  Plant,
  BillOfOperationsUsage,
  BillOfOperationsStatus,
  ResponsiblePlannerGroup,
  BillOfOperationsProfile,
  MinimumLotSizeQuantity,
  MaximumLotSizeQuantity,
  BillOfOperationsUnit,
  cast( CreationDate as vdm_andat ) AS CreationDate,
  cast( CreatedByUser as vdm_annam ) AS CreatedByUser,
  cast( LastChangeDate as vdm_aedat ) AS LastChangeDate,
  cast( LastChangedByUser as vdm_aenam ) AS LastChangedByUser,
  ChangedDateTime,
  _LongText.PlainLongText AS PlainLongText,
  OperationReferenceQuantity,
  OperationUnit,
  OpQtyToBaseQtyNmrtr,
  OpQtyToBaseQtyDnmntr
FROM I_MfgBillOfOperationsChgSt
LEFT OUTER JOIN I_TaskListLongText AS _LongText ON BillOfOperationsType = _LongText.TaskListType AND BillOfOperationsGroup = _LongText.TaskListGroup AND BillOfOperationsVariant = _LongText.TaskListGroupCounter AND BOOInternalVersionCounter = _LongText.TaskListVersionCounter AND LongTextLanguageCode is not null  -- association [0..1]
;