P_OperationActivityInstanceBsc

DDL: P_OPERATIONACTIVITYINSTANCEBSC SQL: PMPEOAIOANIBSC Type: view BASIC
36 Fields 2 Data Sources

P_OperationActivityInstanceBsc is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_OperationActivityInstance, I_OpActyNtwkInstanceBasic) and exposes 36 fields with key fields OpActyNtwkInstance, OpActyNtwkElement.

Data Sources (2)

SourceAliasJoin Type
I_OperationActivityInstance oai from
I_OpActyNtwkInstanceBasic oani inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMPEOAIOANIBSC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.compiler.compareFilter true view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_OperationActivityInstance OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OperationActivityInstance OpActyNtwkElement Element Number
StatusAndActionSchema I_OperationActivityInstance StatusAndActionSchema Status Action Schema
OpPlannedYieldQuantity I_OperationActivityInstance OpPlannedYieldQuantity OA Expected Yield
OpPlannedScrapQuantity I_OperationActivityInstance OpPlannedScrapQuantity OA Expected Scrap
ProductionUnit I_OperationActivityInstance ProductionUnit UoM: Conv. to
OpActyExpdExecDurnInSeconds I_OperationActivityInstance OpActyExpdExecDurnInSeconds Target Time (s)
OpActyExpdExecLaborDurnInSecs I_OperationActivityInstance OpActyExpdExecLaborDurnInSecs Target Time (s)
BillOfOperationsType I_OperationActivityInstance BillOfOperationsType Task List Type
BillOfOperationsGroup I_OperationActivityInstance BillOfOperationsGroup Group
BillOfOperationsVariant I_OperationActivityInstance BillOfOperationsVariant Group Counter
BOOOperationInternalID I_OperationActivityInstance BOOOperationInternalID Task list node
BillOfOperationsVersion I_OperationActivityInstance BillOfOperationsVersion Routing Version
OperationActivityNetwork I_OpActyNtwkInstanceBasic OperationActivityNetwork Object ID
OpActyNtwkVersionCounter I_OpActyNtwkInstanceBasic OpActyNtwkVersionCounter Object Version
ManufacturingOrder I_OpActyNtwkInstanceBasic ManufacturingOrder Order
OrderInternalID I_OpActyNtwkInstanceBasic OrderInternalID Plan No.f.Oper.
OrderOperationInternalID I_OpActyNtwkInstanceBasic OrderOperationInternalID Plan No.f.Oper.
OpActyConfIsSFIBased I_OpActyNtwkInstanceBasic OpActyConfIsSFIBased Mat. Confirmation
OpActyConfirmationIsAllowed I_OpActyNtwkInstanceBasic OpActyConfirmationIsAllowed Configurable Item
OpActyConfNotAllowedReason I_OpActyNtwkInstanceBasic OpActyConfNotAllowedReason Conf.notAllwd Reason
OANIsNotRelevantForExecution I_OpActyNtwkInstanceBasic OANIsNotRelevantForExecution
OANNotRlvtForExecutionReason I_OpActyNtwkInstanceBasic OANNotRlvtForExecutionReason
_OpActyInstanceStatusBasic I_OperationActivityInstance _OpActyInstanceStatusBasic
_OpActyNtwkInstance I_OperationActivityInstance _OpActyNtwkInstance
_OpActyNtwkInstanceBasic I_OperationActivityInstance _OpActyNtwkInstanceBasic
_SASSchema I_OperationActivityInstance _SASSchema
_UnitOfMeasure I_OperationActivityInstance _UnitOfMeasure
_MfgOrder I_OpActyNtwkInstanceBasic _MfgOrder
_ManufacturingOrder I_OpActyNtwkInstanceBasic _ManufacturingOrder
_MfgOrderOperation I_OpActyNtwkInstanceBasic _MfgOrderOperation
_OrderOperation I_OpActyNtwkInstanceBasic _OrderOperation
_OrderOperationBasic I_OpActyNtwkInstanceBasic _OrderOperationBasic
_OpActyNtwkInternalId I_OpActyNtwkInstanceBasic _OpActyNtwkInternalId
_OperationActivityNetwork I_OpActyNtwkInstanceBasic _OperationActivityNetwork
_OrderInternalID I_OpActyNtwkInstanceBasic _OrderInternalID

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 P_OperationActivityInstanceBsc.
-- 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: PMPEOAIOANIBSC

CREATE VIEW P_OperationActivityInstanceBsc AS
SELECT
  oai.OpActyNtwkInstance AS OpActyNtwkInstance,
  oai.OpActyNtwkElement AS OpActyNtwkElement,
  oai.StatusAndActionSchema AS StatusAndActionSchema,
  oai.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
  oai.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  oai.ProductionUnit AS ProductionUnit,
  oai.OpActyExpdExecDurnInSeconds AS OpActyExpdExecDurnInSeconds,
  oai.OpActyExpdExecLaborDurnInSecs AS OpActyExpdExecLaborDurnInSecs,
  oai.BillOfOperationsType AS BillOfOperationsType,
  oai.BillOfOperationsGroup AS BillOfOperationsGroup,
  oai.BillOfOperationsVariant AS BillOfOperationsVariant,
  oai.BOOOperationInternalID AS BOOOperationInternalID,
  oai.BillOfOperationsVersion AS BillOfOperationsVersion,
  oani.OperationActivityNetwork AS OperationActivityNetwork,
  oani.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  oani.ManufacturingOrder AS ManufacturingOrder,
  oani.OrderInternalID AS OrderInternalID,
  oani.OrderOperationInternalID AS OrderOperationInternalID,
  oani.OpActyConfIsSFIBased AS OpActyConfIsSFIBased,
  oani.OpActyConfirmationIsAllowed AS OpActyConfirmationIsAllowed,
  oani.OpActyConfNotAllowedReason AS OpActyConfNotAllowedReason,
  oani.OANIsNotRelevantForExecution AS OANIsNotRelevantForExecution,
  oani.OANNotRlvtForExecutionReason AS OANNotRlvtForExecutionReason,
  oai._OpActyInstanceStatusBasic AS _OpActyInstanceStatusBasic,
  oai._OpActyNtwkInstance AS _OpActyNtwkInstance,
  oai._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic,
  oai._SASSchema AS _SASSchema,
  oai._UnitOfMeasure AS _UnitOfMeasure,
  oani._MfgOrder AS _MfgOrder,
  oani._ManufacturingOrder AS _ManufacturingOrder,
  oani._MfgOrderOperation AS _MfgOrderOperation,
  oani._OrderOperation AS _OrderOperation,
  oani._OrderOperationBasic AS _OrderOperationBasic,
  oani._OpActyNtwkInternalId AS _OpActyNtwkInternalId,
  oani._OperationActivityNetwork AS _OperationActivityNetwork,
  oani._OrderInternalID AS _OrderInternalID
FROM I_OperationActivityInstance AS oai
INNER JOIN I_OpActyNtwkInstanceBasic AS oani ON /* join condition not captured in parsed metadata */
;

Learn More