R_OpActyInstceOutpReqItm

DDL: R_OPACTYINSTCEOUTPREQITM Type: view_entity COMPOSITE
33 Fields 2 Data Sources 2 Associations

OA Instance Output Request Item

R_OpActyInstceOutpReqItm is a Composite CDS View that provides data about "OA Instance Output Request Item" in SAP S/4HANA. It reads from 2 data sources (I_OpActyInstceOpActyNtwkElmnt, P_OpActyInstceOutpReqItm) and exposes 33 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, OutputRequestItem. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_OpActyInstceOpActyNtwkElmnt OpActyInstceOpActyNtwkElmnt inner
P_OpActyInstceOutpReqItm OpActyInstceOutpReqItm from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_OpActyInstceOutpReq _OpActyInstceOutpReq _OpActyInstceOutpReq.OpActyNtwkInstance = $projection.OpActyNtwkInstance and _OpActyInstceOutpReq.OpActyNtwkElement = $projection.OpActyNtwkElement
[0..1] I_MfgWorkInstrnPrntInfoText _MfgWorkInstrnPrntInfoText _MfgWorkInstrnPrntInfoText.MfgWrkInstrnPrntInfo = $projection.MfgWrkInstrnPrntInfo and _MfgWorkInstrnPrntInfoText.Language = $session.system_language

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label OA Instance Output Request Item view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name ProdnOrderOpActivityInstance view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_OpActyInstceOpActyNtwkElmnt OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElement Element Number
KEY OutputRequestItem P_OpActyInstceOutpReqItm OutputRequestItem
OutputRequestItemUUID P_OpActyInstceOutpReqItm OutputRequestItemUUID
OutputRequestUUID P_OpActyInstceOutpReqItm OutputRequestUUID
OutputControlApplObjectType P_OpActyInstceOutpReqItm OutputControlApplObjectType Appl. Object Type
OutputControlApplicationObject P_OpActyInstceOutpReqItm OutputControlApplicationObject Appl. Object ID
ManufacturingOrder I_OpActyInstceOpActyNtwkElmnt ManufacturingOrder Order
OpActyNtwkElementExternalID I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElementExternalID Op. Activity
OperationActivityName
ManufacturingOrderOperation
MfgOrderOperationText
OutputRequestItemStatus P_OpActyInstceOutpReqItm OutputRequestItemStatus
OutputDocumentType P_OpActyInstceOutpReqItm OutputDocumentType
OutputChannel P_OpActyInstceOutpReqItm OutputChannel
PrintQueue P_OpActyInstceOutpReqItm PrintQueue Print Queue
FormTemplateLanguage P_OpActyInstceOutpReqItm FormTemplateLanguage
FormTemplate P_OpActyInstceOutpReqItm FormTemplate Name
LastChangeDateTime P_OpActyInstceOutpReqItm LastChangeDateTime Timestamp
DispatchTime P_OpActyInstceOutpReqItm DispatchTime
PrintCopyNumber P_OpActyInstceOutpReqItm PrintCopyNumber
Plant
WorkCenter
OpActyNtwkSegmentType I_OpActyInstceOpActyNtwkElmnt OpActyNtwkSegmentType
WorkInstruction OpActyWorkInstructionAssgmt WorkInstruction
WorkInstructionVersionCounter OpActyWorkInstructionAssgmt WorkInstructionVersionCounter
MfgWorkInstructionMode MfgWorkInstruction MfgWorkInstructionMode
_OpActyInstceOutpReq _OpActyInstceOutpReq
_OutputRequestItemStatus P_OpActyInstceOutpReqItm _OutputRequestItemStatus
_Language P_OpActyInstceOutpReqItm _Language
_DispatchTime P_OpActyInstceOutpReqItm _DispatchTime
_MfgWorkInstrnPrntInfoText _MfgWorkInstrnPrntInfoText
_OpActyNtwkInstanceBasic I_OpActyInstceOpActyNtwkElmnt _OpActyNtwkInstanceBasic

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 R_OpActyInstceOutpReqItm.
-- 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.

CREATE VIEW R_OpActyInstceOutpReqItm AS
SELECT
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstceOutpReqItm.OutputRequestItem AS OutputRequestItem,
  OpActyInstceOutpReqItm.OutputRequestItemUUID AS OutputRequestItemUUID,
  OpActyInstceOutpReqItm.OutputRequestUUID AS OutputRequestUUID,
  OpActyInstceOutpReqItm.OutputControlApplObjectType AS OutputControlApplObjectType,
  OpActyInstceOutpReqItm.OutputControlApplicationObject AS OutputControlApplicationObject,
  OpActyInstceOpActyNtwkElmnt.ManufacturingOrder AS ManufacturingOrder,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  OpActyInstceOpActyNtwkElmnt._OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  OpActyInstceOpActyNtwkElmnt._OrderOperationBasic.Operation_2 AS ManufacturingOrderOperation,
  OpActyInstceOpActyNtwkElmnt._OrderOperationBasic.OperationText AS MfgOrderOperationText,
  OpActyInstceOutpReqItm.OutputRequestItemStatus AS OutputRequestItemStatus,
  OpActyInstceOutpReqItm.OutputDocumentType AS OutputDocumentType,
  OpActyInstceOutpReqItm.OutputChannel AS OutputChannel,
  OpActyInstceOutpReqItm.PrintQueue AS PrintQueue,
  OpActyInstceOutpReqItm.FormTemplateLanguage AS FormTemplateLanguage,
  OpActyInstceOutpReqItm.FormTemplate AS FormTemplate,
  OpActyInstceOutpReqItm.LastChangeDateTime AS LastChangeDateTime,
  OpActyInstceOutpReqItm.DispatchTime AS DispatchTime,
  OpActyInstceOutpReqItm.PrintCopyNumber AS PrintCopyNumber,
  OpActyInstceOpActyNtwkElmnt._OrderOperationBasic.Plant AS Plant,
  OpActyInstceOpActyNtwkElmnt._OrderOperationBasic._WorkCenterByInternalID.WorkCenter AS WorkCenter,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  OpActyWorkInstructionAssgmt.WorkInstruction AS WorkInstruction,
  OpActyWorkInstructionAssgmt.WorkInstructionVersionCounter AS WorkInstructionVersionCounter,
  MfgWorkInstruction.MfgWorkInstructionMode AS MfgWorkInstructionMode,
  OpActyInstceOutpReqItm._OutputRequestItemStatus AS _OutputRequestItemStatus,
  OpActyInstceOutpReqItm._Language AS _Language,
  OpActyInstceOutpReqItm._DispatchTime AS _DispatchTime,
  OpActyInstceOpActyNtwkElmnt._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic
FROM P_OpActyInstceOutpReqItm AS OpActyInstceOutpReqItm
INNER JOIN I_OpActyInstceOpActyNtwkElmnt AS OpActyInstceOpActyNtwkElmnt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_OpActyInstceOutpReq AS _OpActyInstceOutpReq ON _OpActyInstceOutpReq.OpActyNtwkInstance = OpActyNtwkInstance AND _OpActyInstceOutpReq.OpActyNtwkElement = OpActyNtwkElement  -- association [1..1]
LEFT OUTER JOIN I_MfgWorkInstrnPrntInfoText AS _MfgWorkInstrnPrntInfoText ON _MfgWorkInstrnPrntInfoText.MfgWrkInstrnPrntInfo = MfgWrkInstrnPrntInfo AND _MfgWorkInstrnPrntInfoText.Language = $session.system_language  -- association [0..1]
;

Learn More