I_MfgBuyOffList

DDL: I_MFGBUYOFFLIST SQL: IMFGBUYOFFLIST Type: view COMPOSITE Package: MPE_BUYOFF
23 Fields 3 Associations

Buy Off Cycle Inbox

I_MfgBuyOffList is a Composite CDS View that provides data about "Buy Off Cycle Inbox" in SAP S/4HANA. It has 3 associations to related views. Part of development package MPE_BUYOFF.

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_MfgBuyOffCycleStepTP _Step $projection.MfgBuyOffCycle = _Step.MfgBuyOffCycle and $projection.MfgBuyOffInternalID = _Step.MfgBuyOffInternalID
[1..1] I_MfgBuyOffCycleTP _Cycle $projection.MfgBuyOffCycle = _Cycle.MfgBuyOffCycle
[1..1] I_Material _Material $projection.material = _Material.Material

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMFGBUYOFFLIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Buy Off Cycle Inbox view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY MfgBuyOffCycle _BuyOff MfgBuyOffCycle Buyoff
KEY MfgBuyOffInternalID _BuyOff MfgBuyOffInternalID ID
KEY MfgBuyOffStatus _BuyOff MfgBuyOffStatus Status
CreationDateTime
CreationUserName _BuyOff CreationUserName User Name
RespyMgmtFunction _Step RespyMgmtFunction Function
RespyMgmtTeamID _Step RespyMgmtTeamID Team ID
Sequence _Step Sequence Visit Sequence
MfgBuyOffIsSkipped _Step MfgBuyOffIsSkipped Skip
MfgBuyOffPriority
MfgBuyOffInitiator _Cycle MfgBuyOffInitiator User Name
ProcessorendasProcessor
ShopFloorItem _Cycle ShopFloorItem Serial.Mat. ID
OpActyNtwkElement _Cycle OpActyNtwkElement Element Number
OpActyNtwkInstance _Cycle OpActyNtwkInstance Instance ID
OpActyNtwkElementElement _Cycle OpActyNtwkElementElement Operation Activity
OpActyNtwkElementExternalID
OpActyNtwkElementElmntVersCntr _Cycle OpActyNtwkElementElmntVersCntr OA Version
Material
_Material _Material
_Step _Step
_Status _BuyOff _Status
_TeamHeader _Step _TeamHeader

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_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: IMFGBUYOFFLIST

CREATE VIEW I_MfgBuyOffList AS
SELECT
  _BuyOff.MfgBuyOffCycle AS MfgBuyOffCycle,
  _BuyOff.MfgBuyOffInternalID AS MfgBuyOffInternalID,
  _BuyOff.MfgBuyOffStatus AS MfgBuyOffStatus,
  max(_BuyOff.CreationDateTime ) AS CreationDateTime,
  _BuyOff.CreationUserName AS CreationUserName,
  _Step.RespyMgmtFunction AS RespyMgmtFunction,
  _Step.RespyMgmtTeamID AS RespyMgmtTeamID,
  _Step.Sequence AS Sequence,
  _Step.MfgBuyOffIsSkipped AS MfgBuyOffIsSkipped,
  '' AS MfgBuyOffPriority,
  _Cycle.MfgBuyOffInitiator AS MfgBuyOffInitiator,
  case when MfgBuyOffStatus = '6' then CreationUserName else _Step.Processor end as Processor AS ProcessorendasProcessor,
  _Cycle.ShopFloorItem AS ShopFloorItem,
  _Cycle.OpActyNtwkElement AS OpActyNtwkElement,
  _Cycle.OpActyNtwkInstance AS OpActyNtwkInstance,
  _Cycle.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  _Cycle._OpActyNtwElement.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  _Cycle.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  _Cycle._SFI.Material AS Material,
  _BuyOff._Status AS _Status,
  _Step._TeamHeader AS _TeamHeader
LEFT OUTER JOIN I_MfgBuyOffCycleStepTP AS _Step ON MfgBuyOffCycle = _Step.MfgBuyOffCycle AND MfgBuyOffInternalID = _Step.MfgBuyOffInternalID  -- 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]
;

Learn More