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,
  _Team.RespyMgmtTeamName AS RespyMgmtTeamName,
  _Team.RespyMgmtTeamDescription AS RespyMgmtTeamDescription,
  BuyOff.RespyMgmtTeamID AS RespyMgmtTeamID,
  MfgBuyOffPriority,
  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,
  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,
  OpActyNtwkElementElmntVersCntr,
  _OANI._OrderOperationBasic._WorkCenterByInternalID.WorkCenter AS WorkCenter,
  _OANI._OrderOperationBasic.Operation AS ManufacturingOrderOperation,
  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_OpActyInstanceStatusBasic AS _OpActyInstanceStatusBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MfgBuyOffCycleStepTP AS _Step ON MfgBuyOffCycle = _Step.MfgBuyOffCycle AND MfgBuyOffInternalID = _Step.MfgBuyOffInternalID  -- association [1..1]
LEFT OUTER JOIN I_RespyMgmtTeamHeader AS _Team ON RespyMgmtTeamID = _Team.RespyMgmtTeamID  -- association [1..1]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON manufacturingorder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN C_MfgBuyOffVH AS _BuyOffVH ON MfgBuyOffCycle = _BuyOffVH.MfgBuyOffCycle  -- association [1..1]
LEFT OUTER JOIN C_MfgBuyOffMatlSrlNmbrVH AS _MatlSrlNmbrVH ON Material = _MatlSrlNmbrVH.Material AND serialnumber = _MatlSrlNmbrVH.SerialNumber  -- association [1..1]
LEFT OUTER JOIN C_MfgBuyOffMaterialVH AS _MaterialVH ON Material = _MaterialVH.Material  -- 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_MfgBuyOffProcessorTeamFunc AS _Proc ON _Proc.UserID = $session.user AND ( RespyMgmtFunction = _Proc.RespyMgmtFunction OR RespyMgmtTeamID = _Proc.RespyMgmtTeamID ) AND _Proc.UserID = $session.user  -- association [1..1]
LEFT OUTER JOIN I_MfgBuyOffCycleTP AS _Cycle ON MfgBuyOffCycle = _Cycle.MfgBuyOffCycle  -- association [1..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 I_MfgBusinessPartnerTP AS _ProcessorVH ON Processor = _ProcessorVH.UserID  -- association [1..1]
LEFT OUTER JOIN I_OperationActivityText AS _OAText ON OpActyNtwkElementElement = _OAText.OperationActivity AND OpActyNtwkElementElmntVersCntr = _OAText.OperationActyVersionCounter AND _OAText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ShopFloorItem AS _ShopFloorItem ON ShopFloorItem = _ShopFloorItem.ShopFloorItem  -- association [1..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OANI ON OpActyNtwkInstance = _OANI.OpActyNtwkInstance  -- 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]
;