C_MfgBuyOffCycleTimeLine

DDL: C_MFGBUYOFFCYCLETIMELINE SQL: CMFGBUYOFFCYCTL Type: view CONSUMPTION
20 Fields 1 Data Sources 4 Associations

Buy Off Cycle Timeline

C_MfgBuyOffCycleTimeLine is a Consumption CDS View that provides data about "Buy Off Cycle Timeline" in SAP S/4HANA. It reads from 1 data source (I_MfgBuyOffCycleTimeLine) and exposes 20 fields with key fields MfgBuyOffCycle, MfgBuyOffInternalID, MfgBuyOffStepCount. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgBuyOffCycleTimeLine TimeLine from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_MfgBuyOffStatus _Status $projection.MfgBuyOffStatus = _Status.MfgBuyOffStatus
[1..1] I_User _User $projection.Processor = _User.UserID
[1..1] I_MfgBuyOffStatusDisplayText _StatusDisplay $projection.MfgBuyOffStatus = _StatusDisplay.MfgBuyOffStatusDisplay and _StatusDisplay.Language = $session.system_language
[1..1] I_OpActyBuyOffText _Text TimeLine.OpActyNtwkElementElement = _Text.OperationActivity and TimeLine.OpActyNtwkElementElmntVersCntr = _Text.OperationActyVersionCounter and TimeLine.MfgBuyOffInternalID = _Text.MfgBuyOffInternalID and _Text.Language = $session.system_language

Annotations (9)

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

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY MfgBuyOffCycle I_MfgBuyOffCycleTimeLine MfgBuyOffCycle Buyoff
KEY MfgBuyOffInternalID I_MfgBuyOffCycleTimeLine MfgBuyOffInternalID ID
KEY MfgBuyOffStepCount I_MfgBuyOffCycleTimeLine MfgBuyOffStepCount
RespyMgmtFunction I_MfgBuyOffCycleTimeLine RespyMgmtFunction Function
RespyMgmtTeamID I_MfgBuyOffCycleTimeLine RespyMgmtTeamID Team ID
RespyMgmtTeamName I_MfgBuyOffCycleTimeLine RespyMgmtTeamName Team Name
CreationUserName I_MfgBuyOffCycleTimeLine CreationUserName User Name
Processor I_MfgBuyOffCycleTimeLine Processor User Name
UserDescription _User UserDescription Full Name
Sequence I_MfgBuyOffCycleTimeLine Sequence Visit Sequence
MfgBuyOffActionNote
MfgBuyOffStatus I_MfgBuyOffCycleTimeLine MfgBuyOffStatus Status
CreationDateTime I_MfgBuyOffCycleTimeLine CreationDateTime Timestamp
MfgBuyOffComment I_MfgBuyOffCycleTimeLine MfgBuyOffComment
MfgBuyOffIsRejectEnabled
RespyMgmtTeamDescription
RespyMgmtFunctionDescription
_Status _Status
_TeamHeader _TeamHeader
_User _User

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_MfgBuyOffCycleTimeLine.
-- 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: CMFGBUYOFFCYCTL

CREATE VIEW C_MfgBuyOffCycleTimeLine AS
SELECT
  TimeLine.MfgBuyOffCycle AS MfgBuyOffCycle,
  TimeLine.MfgBuyOffInternalID AS MfgBuyOffInternalID,
  TimeLine.MfgBuyOffStepCount AS MfgBuyOffStepCount,
  TimeLine.RespyMgmtFunction AS RespyMgmtFunction,
  TimeLine.RespyMgmtTeamID AS RespyMgmtTeamID,
  TimeLine.RespyMgmtTeamName AS RespyMgmtTeamName,
  TimeLine.CreationUserName AS CreationUserName,
  TimeLine.Processor AS Processor,
  _User.UserDescription AS UserDescription,
  TimeLine.Sequence AS Sequence,
  cast('' as abap.sstring(500)) AS MfgBuyOffActionNote,
  TimeLine.MfgBuyOffStatus AS MfgBuyOffStatus,
  TimeLine.CreationDateTime AS CreationDateTime,
  TimeLine.MfgBuyOffComment AS MfgBuyOffComment,
  cast(' ' as mpe_buyoff_skippable) AS MfgBuyOffIsRejectEnabled,
  TimeLine._TeamDescription.TeamDescription AS RespyMgmtTeamDescription,
  TimeLine._Function.RespyMgmtFunctionDescription AS RespyMgmtFunctionDescription
FROM I_MfgBuyOffCycleTimeLine AS TimeLine
LEFT OUTER JOIN I_MfgBuyOffStatus AS _Status ON MfgBuyOffStatus = _Status.MfgBuyOffStatus  -- association [1..1]
LEFT OUTER JOIN I_User AS _User ON Processor = _User.UserID  -- association [1..1]
LEFT OUTER JOIN I_MfgBuyOffStatusDisplayText AS _StatusDisplay ON MfgBuyOffStatus = _StatusDisplay.MfgBuyOffStatusDisplay AND _StatusDisplay.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_OpActyBuyOffText AS _Text ON TimeLine.OpActyNtwkElementElement = _Text.OperationActivity AND TimeLine.OpActyNtwkElementElmntVersCntr = _Text.OperationActyVersionCounter AND TimeLine.MfgBuyOffInternalID = _Text.MfgBuyOffInternalID AND _Text.Language = $session.system_language  -- association [1..1]
;

Learn More