C_MfgBuyOffCycleStepTP

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_MfgBuyOffCycleStepTP.
-- 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: CMFGBUYOFFFSTEP

CREATE VIEW C_MfgBuyOffCycleStepTP AS
SELECT
  MfgBuyOffCycle,
  MfgBuyOffInternalID,
  RespyMgmtFunction,
  Processor,
  _User.UserDescription AS UserDescription,
  Sequence,
  MfgBuyOffReferencedStep,
  MfgBuyOffStatus,
  RespyMgmtTeamID,
  RespyMgmtTeamName,
  RespyMgmtFunctionDescription,
  RespyMgmtTeamDescription,
  OpActyNtwkElementElement,
  OpActyNtwkElementElmntVersCntr,
  MfgBuyOffAdhocStepDescription,
  MfgBuyOffStatusName
FROM I_MfgBuyOffCycleStepTP
LEFT OUTER JOIN I_RespyMgmtTeamHeader AS _TeamHeader ON RespyMgmtTeamID = _TeamHeader.RespyMgmtTeamID  -- association [1..1]
LEFT OUTER JOIN C_MfgBuyOffCycleTP AS _Cycle ON MfgBuyOffCycle = _Cycle.MfgBuyOffCycle  -- association [1..1]
LEFT OUTER JOIN C_MfgBuyOffCycleTimeLine AS _TimeLine ON MfgBuyOffCycle = _TimeLine.MfgBuyOffCycle AND MfgBuyOffInternalID = _TimeLine.MfgBuyOffInternalID  -- association [1..*]
LEFT OUTER JOIN C_MfgBuyOffList AS _List ON MfgBuyOffCycle = _List.MfgBuyOffCycle AND MfgBuyOffInternalID = _List.MfgBuyOffInternalID  -- association [1..*]
LEFT OUTER JOIN I_MfgBuyOffStatus AS _Status ON MfgBuyOffStatus = _Status.MfgBuyOffStatus  -- association [1..1]
LEFT OUTER JOIN I_OpActyBuyOffText AS _Text ON OpActyNtwkElementElement = _Text.OperationActivity AND OpActyNtwkElementElmntVersCntr = _Text.OperationActyVersionCounter AND MfgBuyOffInternalID = _Text.MfgBuyOffInternalID AND _Text.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_User AS _User ON Processor = _User.UserID  -- association [1..1]
LEFT OUTER JOIN I_MfgBuyOffTeamVH1 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]
;