I_ChgRecdRefMasterRecipeTP

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_ChgRecdRefMasterRecipeTP.
-- 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: ICRREFMRCTP

CREATE VIEW I_ChgRecdRefMasterRecipeTP AS
SELECT
  masterRecipeReference.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  case when masterRecipeReference.Plant is null then cast(substring( masterRecipeReference.ChangeRecordReference, 52, 55) as werks_d) else cast(masterRecipeReference.Plant as werks_d) end as BillOfOperationsPlant AS Plantaswerks_dendasBillOfOperationsPlant,
  cast ('00000000' as cim_count ) AS BOOInternalVersionCounter,
  cast ('00000000' as plantext ) AS BillOfOperationsDesc,
  masterRecipeReference.ChangeRecordUUID AS ChangeRecordUUID,
  masterRecipeReference.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  masterRecipeReference.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  masterRecipeReference.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  masterRecipeReference.ChangeRecordReference AS ChangeRecordReference,
  masterRecipeReference.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  masterRecipeReference.IsMainReference AS IsMainReference,
  ChgRecdDescription,
  ChgRecdReasonForChange,
  ExpdCompltnDte,
  ChgRecdAuthznGrpText,
  ChgRecdNmbrChgSts,
  masterRecipeReference.CreatedByUser AS CreatedByUser,
  masterRecipeReference.CreationDateTime AS CreationDateTime,
  masterRecipeReference.LastChangedByUser AS LastChangedByUser,
  masterRecipeReference.LastChangeDateTime AS LastChangeDateTime,
  masterRecipeReference.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  masterRecipeReference.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  masterRecipeReference.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus,
  masterRecipeReference.ChgRecdCurrentItemProcgStatus AS ChgRecdCurrentItemProcgStatus,
  masterRecipeReference.ChangeNumber AS ChangeNumber,
  masterRecipeReference.ChgRecdItmTgtSts AS ChgRecdItmTgtSts,
  masterRecipeReference.ChgRecdItmDSgntr AS ChgRecdItmDSgntr,
  masterRecipeReference.ChangeRecordLifecycleStatus AS ChangeRecordLifecycleStatus,
  masterRecipeReference.ChangeRecordStatus AS ChangeRecordStatus
LEFT OUTER JOIN I_ChangeRecordDraftTP AS _ChangeRecordTP ON ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN E_ChgRecdRefMasterRecipeBsc AS _MasterRecipeExtension ON ChangeRecordReferenceUUID = _MasterRecipeExtension.ChangeRecordReferenceUUID  -- association [0..1]
;