I_MfgBuyOffCycleStepTP

DDL: I_MFGBUYOFFCYCLESTEPTP SQL: IMFGBUYOFFSTEP Type: view TRANSACTIONAL
24 Fields 1 Data Sources 6 Associations

Buy Off Cycle Steps

I_MfgBuyOffCycleStepTP is a Transactional CDS View that provides data about "Buy Off Cycle Steps" in SAP S/4HANA. It reads from 1 data source (mpe_buyoffsteps) and exposes 24 fields with key fields MfgBuyOffCycle, MfgBuyOffInternalID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
mpe_buyoffsteps mpe_buyoffsteps from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_MfgBuyOffCycleTP _Cycle $projection.MfgBuyOffCycle = _Cycle.MfgBuyOffCycle
[1..1] I_RespyMgmtTeamHeader _TeamHeader $projection.RespyMgmtTeamID = _TeamHeader.RespyMgmtTeamID
[1..1] I_OpActyBuyOffText _Text $projection.OpActyNtwkElementElement = _Text.OperationActivity and $projection.OpActyNtwkElementElmntVersCntr = _Text.OperationActyVersionCounter and $projection.MfgBuyOffInternalID = _Text.MfgBuyOffInternalID and _Text.Language = $session.system_language
[1..1] I_RespyMgmtFunction _Function $projection.RespyMgmtFunction = _Function.RespyMgmtFunction
[1..1] I_MfgBuyOffStatusText _StatusText $projection.MfgBuyOffStatus = _StatusText.MfgBuyOffStatus and _StatusText.Language = $session.system_language
[1..1] I_User _User $projection.Processor = _User.UserID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IMFGBUYOFFSTEP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Buy Off Cycle Steps view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.writeActivePersistence MPE_BUYOFFSTEPS view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.representativeKey MfgBuyOffCycle view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY MfgBuyOffCycle mfgbuyoffcycle Buyoff
KEY MfgBuyOffInternalID mfgbuyoffinternalid ID
RespyMgmtFunction respymgmtfunction Function
Processor processor User Name
Sequence sequence Visit Sequence
MfgBuyOffReferencedStep mfgbuyoffreferencedstep ID
MfgBuyOffStatus mfgbuyoffstatus Status
RespyMgmtTeamID respymgmtteamid Team ID
RespyMgmtTeamDescription _TeamHeader RespyMgmtTeamDescription
RespyMgmtTeamName _TeamHeader RespyMgmtTeamName Team Name
UserDescription _User UserDescription Full Name
MfgBuyOffCertChkIsRqd mfgbuyoffcertchkisrqd Qual. Check
MfgBuyOffIsSkipped mfgbuyoffisskipped Skip
MfgBuyOffAdhocStepDescription mfgbuyoffadhocstepdescription Buyoff Description
OpActyNtwkElementElement _Cycle OpActyNtwkElementElement Operation Activity
OpActyNtwkElementElmntVersCntr _Cycle OpActyNtwkElementElmntVersCntr OA Version
RespyMgmtFunctionDescription _Function RespyMgmtFunctionDescription
MfgBuyOffStatusName _StatusText MfgBuyOffStatusName
IsMarkedForDeletion ismarkedfordeletion Purch.org. data
_Cycle _Cycle
_TeamHeader _TeamHeader
_Text _Text
_Function _Function
_StatusText _StatusText

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

CREATE VIEW I_MfgBuyOffCycleStepTP AS
SELECT
  MfgBuyOffCycle,
  MfgBuyOffInternalID,
  RespyMgmtFunction,
  Processor,
  Sequence,
  MfgBuyOffReferencedStep,
  MfgBuyOffStatus,
  RespyMgmtTeamID,
  _TeamHeader.RespyMgmtTeamDescription AS RespyMgmtTeamDescription,
  _TeamHeader.RespyMgmtTeamName AS RespyMgmtTeamName,
  _User.UserDescription AS UserDescription,
  MfgBuyOffCertChkIsRqd,
  MfgBuyOffIsSkipped,
  MfgBuyOffAdhocStepDescription,
  _Cycle.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  _Cycle.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  _Function.RespyMgmtFunctionDescription AS RespyMgmtFunctionDescription,
  _StatusText.MfgBuyOffStatusName AS MfgBuyOffStatusName,
  IsMarkedForDeletion
FROM mpe_buyoffsteps
LEFT OUTER JOIN I_MfgBuyOffCycleTP AS _Cycle ON MfgBuyOffCycle = _Cycle.MfgBuyOffCycle  -- association [1..1]
LEFT OUTER JOIN I_RespyMgmtTeamHeader AS _TeamHeader ON RespyMgmtTeamID = _TeamHeader.RespyMgmtTeamID  -- 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_RespyMgmtFunction AS _Function ON RespyMgmtFunction = _Function.RespyMgmtFunction  -- association [1..1]
LEFT OUTER JOIN I_MfgBuyOffStatusText AS _StatusText ON MfgBuyOffStatus = _StatusText.MfgBuyOffStatus AND _StatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_User AS _User ON Processor = _User.UserID  -- association [1..1]
;

Learn More