C_MfgBuyOffList

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_MfgBuyOffList.
-- 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: CMFGBUYOFFLIST

CREATE VIEW C_MfgBuyOffList AS
SELECT
  BuyOff.MfgBuyOffCycle AS MfgBuyOffCycle,
  BuyOff.MfgBuyOffInternalID AS MfgBuyOffInternalID,
  BuyOff.MfgBuyOffStatus AS MfgBuyOffStatus,
  BuyOff.Sequence AS Sequence,
  BuyOff.RespyMgmtFunction AS RespyMgmtFunction,
  _Function.RespyMgmtFunctionDescription AS RespyMgmtFunctionDescription,
  BuyOff.Processor AS Processor,
  BuyOff._TeamHeader.RespyMgmtTeamName AS RespyMgmtTeamName,
  BuyOff._TeamHeader.RespyMgmtTeamDescription AS RespyMgmtTeamDescription,
  BuyOff.RespyMgmtTeamID AS RespyMgmtTeamID,
  MfgBuyOffPriority,
  BuyOff.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  _OAText.OperationActivityName AS OperationActivityName,
  cast(BuyOff.OpActyNtwkElementExternalID as mpe_oan_element_number_ext ) AS OperationActivity,
  cast ( '' as char30 ) AS MfgBuyOffWaitingTime,
  _ProductionOperator.UserDescription AS UserDescription,
  BuyOff.MfgBuyOffInitiator AS MfgBuyOffInitiator,
  _OANI.ManufacturingOrder AS ManufacturingOrder,
  cast(_OANI._MfgOrder.Material as matnr) AS Material,
  _OANI._MfgOrder.ProductionPlant AS ProductionPlant,
  _ShopFloorItem.SerialNumber AS SerialNumber,
  _Cycle.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  _Cycle.OpActySFIGroupName AS OpActySFIGroupName,
  BuyOff.ShopFloorItem AS ShopFloorItem,
  BuyOff.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  _OANI._OrderOperationBasic._WorkCenterByInternalID.WorkCenter AS WorkCenter,
  _OANI._OrderOperationBasic._WorkCenterByInternalID._Text[Language = $session.system_language].WorkCenterText AS WorkCenterText,
  _OANI._OrderOperationBasic.Operation AS ManufacturingOrderOperation,
  _OANI._OrderOperationBasic.OperationText AS MfgOrderOperationText,
  BuyOff.MfgBuyOffDescription AS MfgBuyOffDescription,
  cast ( BuyOff.CreationDateTime as mpe_create_timestampl) AS CreationDateTime,
  BuyOff.MfgBuyOffIsSkipped AS MfgBuyOffIsSkipped,
  BuyOff.OpActyNtwkInstance AS OpActyNtwkInstance,
  BuyOff.OpActyNtwkElement AS OpActyNtwkElement,
  cast ('' as mpe_buyoff_skippable ) AS MfgBuyOffIsRejectEnabled,
  cast ('' as mpe_buyoff_skippable ) AS MfgBuyOffIsUndoRejectEnbld,
  cast ('' as mpe_buyoff_skippable ) AS MfgBuyOffIsUndoApproveEnbld,
  _OpActyInstanceStatusBasic.OpActyIsSeldForRtactvPostg AS OpActyIsSeldForRtactvPostg,
  _OANI._MfgOrder._Plant AS _Plant
LEFT OUTER JOIN I_MfgBuyOffCycleTP AS _Cycle ON MfgBuyOffCycle = _Cycle.MfgBuyOffCycle  -- association [1..1]
LEFT OUTER JOIN I_MfgBuyOffCycleStep AS _Step ON MfgBuyOffCycle = _Step.MfgBuyOffCycle AND MfgBuyOffInternalID = _Step.MfgBuyOffInternalID  -- association [1..1]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_OperationActivity AS _OA ON OpActyNtwkElementElement = _OA.OperationActivity AND OpActyNtwkElementElmntVersCntr = _OA.OperationActyVersionCounter  -- association [1..1]
LEFT OUTER JOIN I_MfgBuyOffDetails AS _Details ON MfgBuyOffCycle = _Details.MfgBuyOffCycle AND MfgBuyOffInternalID = _Details.MfgBuyOffInternalID AND MfgBuyOffStatus = _Details.MfgBuyOffStatus  -- association [1..*]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN C_MfgBuyOffTeamVH AS _TeamVH ON RespyMgmtTeamID = _TeamVH.RespyMgmtTeamID AND RespyMgmtTeamName = _TeamVH.RespyMgmtTeamName AND RespyMgmtFunction = _TeamVH.RespyMgmtFunction  -- association [1..1]
LEFT OUTER JOIN C_MfgExecutionUserVH AS _ProcessorVH ON Processor = _ProcessorVH.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _ProductionOperator ON MfgBuyOffInitiator = _ProductionOperator.UserID  -- association [1..1]
LEFT OUTER JOIN C_MfgBuyOffCycleTimeLine AS _Timeline ON MfgBuyOffCycle = _Timeline.MfgBuyOffCycle  -- association [1..*]
LEFT OUTER JOIN I_RespyMgmtFunction AS _Function ON RespyMgmtFunction = _Function.RespyMgmtFunction  -- association [1..1]
;