I_OpActyInstanceDetail

DDL: I_OPACTYINSTANCEDETAIL Type: view_entity COMPOSITE
48 Fields 2 Data Sources 1 Associations

Operation Activity Instance Details

I_OpActyInstanceDetail is a Composite CDS View that provides data about "Operation Activity Instance Details" in SAP S/4HANA. It reads from 2 data sources (I_OpActyInstceOpActyNtwkElmnt, I_OperationActivity) and exposes 48 fields with key fields OpActyNtwkInstance, OpActyNtwkElement. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_OpActyInstceOpActyNtwkElmnt OpActyInstceOpActyNtwkElmnt from
I_OperationActivity OperationActivity inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_OperationActivity _Extension $projection.OperationActivity = _Extension.OperationActivity and $projection.OperationActyVersionCounter = _Extension.OperationActyVersionCounter

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Operation Activity Instance Details view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_OpActyInstceOpActyNtwkElmnt OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElement Element Number
StatusAndActionSchema I_OpActyInstceOpActyNtwkElmnt StatusAndActionSchema
OpPlannedYieldQuantity I_OpActyInstceOpActyNtwkElmnt OpPlannedYieldQuantity
OpPlannedScrapQuantity I_OpActyInstceOpActyNtwkElmnt OpPlannedScrapQuantity
ProductionUnit I_OpActyInstceOpActyNtwkElmnt ProductionUnit
OpActyExpdExecDurnInSeconds I_OpActyInstceOpActyNtwkElmnt OpActyExpdExecDurnInSeconds
OpActyExpdExecLaborDurnInSecs I_OpActyInstceOpActyNtwkElmnt OpActyExpdExecLaborDurnInSecs
BillOfOperationsType I_OpActyInstceOpActyNtwkElmnt BillOfOperationsType Task List Type
BillOfOperationsGroup I_OpActyInstceOpActyNtwkElmnt BillOfOperationsGroup Group
BillOfOperationsVariant I_OpActyInstceOpActyNtwkElmnt BillOfOperationsVariant Group Counter
BOOOperationInternalID I_OpActyInstceOpActyNtwkElmnt BOOOperationInternalID Task list node
BillOfOperationsVersion I_OpActyInstceOpActyNtwkElmnt BillOfOperationsVersion Routing Version
OperationActivityNetwork I_OpActyInstceOpActyNtwkElmnt OperationActivityNetwork
OpActyNtwkVersionCounter I_OpActyInstceOpActyNtwkElmnt OpActyNtwkVersionCounter
ManufacturingOrder I_OpActyInstceOpActyNtwkElmnt ManufacturingOrder Order
OrderInternalID I_OpActyInstceOpActyNtwkElmnt OrderInternalID Plan No.f.Oper.
OrderOperationInternalID I_OpActyInstceOpActyNtwkElmnt OrderOperationInternalID
OpActyConfIsSFIBased I_OpActyInstceOpActyNtwkElmnt OpActyConfIsSFIBased
OpActyConfirmationIsAllowed I_OpActyInstceOpActyNtwkElmnt OpActyConfirmationIsAllowed
OpActyConfNotAllowedReason I_OpActyInstceOpActyNtwkElmnt OpActyConfNotAllowedReason
OpActyNtwkSegmentType I_OpActyInstceOpActyNtwkElmnt OpActyNtwkSegmentType
OpActyNtwkElementExternalID I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElementExternalID Op. Activity
OpActyNtwkElementElement I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElementElement Operation Activity
OperationActivity I_OpActyInstceOpActyNtwkElmnt OperationActivity Operation Activity
OpActyNtwkElementElmntVersCntr I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElementElmntVersCntr OA Version
OperationActyVersionCounter I_OpActyInstceOpActyNtwkElmnt OperationActyVersionCounter OA Version
OpActyNtwkElementType I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElementType
OANElementDisplaySqncNumber I_OpActyInstceOpActyNtwkElmnt OANElementDisplaySqncNumber
SFIStatusAndActionSchema I_OperationActivity SFIStatusAndActionSchema SAS Serialized Prod.
AssemblySqncCheckIsRequired I_OperationActivity AssemblySqncCheckIsRequired Assembly Sequence
OperationActivityName
_ManufacturingOrder I_OpActyInstceOpActyNtwkElmnt _ManufacturingOrder
_OANSegmentType I_OpActyInstceOpActyNtwkElmnt _OANSegmentType
_OpActyInstanceStatusBasic I_OpActyInstceOpActyNtwkElmnt _OpActyInstanceStatusBasic
_OpActyNtwkInstance I_OpActyInstceOpActyNtwkElmnt _OpActyNtwkInstance
_OpActyNtwkInstanceBasic I_OpActyInstceOpActyNtwkElmnt _OpActyNtwkInstanceBasic
_OpActyNtwkInternalId I_OpActyInstceOpActyNtwkElmnt _OpActyNtwkInternalId
_OperationActivity I_OpActyInstceOpActyNtwkElmnt _OperationActivity
_OperationActivityInstance I_OpActyInstceOpActyNtwkElmnt _OperationActivityInstance
_OperationActivityNetwork I_OpActyInstceOpActyNtwkElmnt _OperationActivityNetwork
_OperationActivityNtwkEvent I_OpActyInstceOpActyNtwkElmnt _OperationActivityNtwkEvent
_OperationActivityText I_OpActyInstceOpActyNtwkElmnt _OperationActivityText
_OrderOperation I_OpActyInstceOpActyNtwkElmnt _OrderOperation
_OrderOperationBasic I_OpActyInstceOpActyNtwkElmnt _OrderOperationBasic
_SASSchema I_OpActyInstceOpActyNtwkElmnt _SASSchema
_UnitOfMeasure I_OpActyInstceOpActyNtwkElmnt _UnitOfMeasure
_SASShopFloorItemOpAct I_OperationActivity _SASShopFloorItemOpAct

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_OpActyInstanceDetail.
-- 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 I_OpActyInstanceDetail AS
SELECT
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstceOpActyNtwkElmnt.StatusAndActionSchema AS StatusAndActionSchema,
  OpActyInstceOpActyNtwkElmnt.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
  OpActyInstceOpActyNtwkElmnt.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  OpActyInstceOpActyNtwkElmnt.ProductionUnit AS ProductionUnit,
  OpActyInstceOpActyNtwkElmnt.OpActyExpdExecDurnInSeconds AS OpActyExpdExecDurnInSeconds,
  OpActyInstceOpActyNtwkElmnt.OpActyExpdExecLaborDurnInSecs AS OpActyExpdExecLaborDurnInSecs,
  OpActyInstceOpActyNtwkElmnt.BillOfOperationsType AS BillOfOperationsType,
  OpActyInstceOpActyNtwkElmnt.BillOfOperationsGroup AS BillOfOperationsGroup,
  OpActyInstceOpActyNtwkElmnt.BillOfOperationsVariant AS BillOfOperationsVariant,
  OpActyInstceOpActyNtwkElmnt.BOOOperationInternalID AS BOOOperationInternalID,
  OpActyInstceOpActyNtwkElmnt.BillOfOperationsVersion AS BillOfOperationsVersion,
  OpActyInstceOpActyNtwkElmnt.OperationActivityNetwork AS OperationActivityNetwork,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  OpActyInstceOpActyNtwkElmnt.ManufacturingOrder AS ManufacturingOrder,
  OpActyInstceOpActyNtwkElmnt.OrderInternalID AS OrderInternalID,
  OpActyInstceOpActyNtwkElmnt.OrderOperationInternalID AS OrderOperationInternalID,
  OpActyInstceOpActyNtwkElmnt.OpActyConfIsSFIBased AS OpActyConfIsSFIBased,
  OpActyInstceOpActyNtwkElmnt.OpActyConfirmationIsAllowed AS OpActyConfirmationIsAllowed,
  OpActyInstceOpActyNtwkElmnt.OpActyConfNotAllowedReason AS OpActyConfNotAllowedReason,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  OpActyInstceOpActyNtwkElmnt.OperationActivity AS OperationActivity,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  OpActyInstceOpActyNtwkElmnt.OperationActyVersionCounter AS OperationActyVersionCounter,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementType AS OpActyNtwkElementType,
  OpActyInstceOpActyNtwkElmnt.OANElementDisplaySqncNumber AS OANElementDisplaySqncNumber,
  OperationActivity.SFIStatusAndActionSchema AS SFIStatusAndActionSchema,
  OperationActivity.AssemblySqncCheckIsRequired AS AssemblySqncCheckIsRequired,
  OperationActivity._Text[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  OpActyInstceOpActyNtwkElmnt._ManufacturingOrder AS _ManufacturingOrder,
  OpActyInstceOpActyNtwkElmnt._OANSegmentType AS _OANSegmentType,
  OpActyInstceOpActyNtwkElmnt._OpActyInstanceStatusBasic AS _OpActyInstanceStatusBasic,
  OpActyInstceOpActyNtwkElmnt._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyInstceOpActyNtwkElmnt._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic,
  OpActyInstceOpActyNtwkElmnt._OpActyNtwkInternalId AS _OpActyNtwkInternalId,
  OpActyInstceOpActyNtwkElmnt._OperationActivity AS _OperationActivity,
  OpActyInstceOpActyNtwkElmnt._OperationActivityInstance AS _OperationActivityInstance,
  OpActyInstceOpActyNtwkElmnt._OperationActivityNetwork AS _OperationActivityNetwork,
  OpActyInstceOpActyNtwkElmnt._OperationActivityNtwkEvent AS _OperationActivityNtwkEvent,
  OpActyInstceOpActyNtwkElmnt._OperationActivityText AS _OperationActivityText,
  OpActyInstceOpActyNtwkElmnt._OrderOperation AS _OrderOperation,
  OpActyInstceOpActyNtwkElmnt._OrderOperationBasic AS _OrderOperationBasic,
  OpActyInstceOpActyNtwkElmnt._SASSchema AS _SASSchema,
  OpActyInstceOpActyNtwkElmnt._UnitOfMeasure AS _UnitOfMeasure,
  OperationActivity._SASShopFloorItemOpAct AS _SASShopFloorItemOpAct
FROM I_OpActyInstceOpActyNtwkElmnt AS OpActyInstceOpActyNtwkElmnt
INNER JOIN I_OperationActivity AS OperationActivity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_OperationActivity AS _Extension ON OperationActivity = _Extension.OperationActivity AND OperationActyVersionCounter = _Extension.OperationActyVersionCounter  -- association [0..1]
;

Learn More