I_OpActyInstceComponentDetail

DDL: I_OPACTYINSTCECOMPONENTDETAIL Type: view_entity COMPOSITE
99 Fields 1 Data Sources

Component at Operation Activity Detail

I_OpActyInstceComponentDetail is a Composite CDS View that provides data about "Component at Operation Activity Detail" in SAP S/4HANA. It reads from 1 data source (P_OpActyInstceComponentDetail2) and exposes 99 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, Reservation, ReservationItem, RecordType.

Data Sources (1)

SourceAliasJoin Type
P_OpActyInstceComponentDetail2 OpActyInstceComponentDetail from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Component at Operation Activity Detail view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (99)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance P_OpActyInstceComponentDetail2 OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_OpActyInstceComponentDetail2 OpActyNtwkElement Element Number
KEY Reservation P_OpActyInstceComponentDetail2 Reservation Reservation
KEY ReservationItem P_OpActyInstceComponentDetail2 ReservationItem Reservation Item
KEY RecordType P_OpActyInstceComponentDetail2 RecordType Reservation Record Type
RequiredQuantity P_OpActyInstceComponentDetail2 RequiredQuantity Requirement qty
EntryUnit P_OpActyInstceComponentDetail2 EntryUnit Unit of Entry
ComponentQuantity P_OpActyInstceComponentDetail2 ComponentQuantity
MaterialCompOriginalQuantity P_OpActyInstceComponentDetail2 MaterialCompOriginalQuantity
BillOfMaterialItemNumber P_OpActyInstceComponentDetail2 BillOfMaterialItemNumber Item
AssemblySequenceNumber P_OpActyInstceComponentDetail2 AssemblySequenceNumber Assembly Sequence
BOOOpBOMItemInternalID P_OpActyInstceComponentDetail2 BOOOpBOMItemInternalID Allocation no.
LogicalComponent P_OpActyInstceComponentDetail2 LogicalComponent Logical Component
ComponentAssemblyType P_OpActyInstceComponentDetail2 ComponentAssemblyType
RelatedReservation P_OpActyInstceComponentDetail2 RelatedReservation
RelatedReservationItem P_OpActyInstceComponentDetail2 RelatedReservationItem
RelatedRecordType P_OpActyInstceComponentDetail2 RelatedRecordType
RelatedOpActyNtwkInstance P_OpActyInstceComponentDetail2 RelatedOpActyNtwkInstance
RelatedOpActyNtwkElement P_OpActyInstceComponentDetail2 RelatedOpActyNtwkElement
MatlCompInstceAssyIsRequired P_OpActyInstceComponentDetail2 MatlCompInstceAssyIsRequired Instances Exist
PlannedInventoryUsabilityCode P_OpActyInstceComponentDetail2 PlannedInventoryUsabilityCode
LeadingReservation P_OpActyInstceComponentDetail2 LeadingReservation
LeadingReservationItem P_OpActyInstceComponentDetail2 LeadingReservationItem
LeadingReservationRecordType P_OpActyInstceComponentDetail2 LeadingReservationRecordType
LeadingOpActyNtwkInstance P_OpActyInstceComponentDetail2 LeadingOpActyNtwkInstance
LeadingOpActyNtwkElement P_OpActyInstceComponentDetail2 LeadingOpActyNtwkElement
MfgRefStrucBOMLeafAssgmtUUID P_OpActyInstceComponentDetail2 MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID P_OpActyInstceComponentDetail2 MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual P_OpActyInstceComponentDetail2 MfgRefStrucItmDetIsContextual
MatlCompAssemblyIsNotRequired P_OpActyInstceComponentDetail2 MatlCompAssemblyIsNotRequired
ManufacturingOrder P_OpActyInstceComponentDetail2 ManufacturingOrder Order
OrderInternalBillOfOperations P_OpActyInstceComponentDetail2 OrderInternalBillOfOperations Order Internal Bill of Operations
OrderIntBillOfOperationsItem P_OpActyInstceComponentDetail2 OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
Material P_OpActyInstceComponentDetail2 Material Vehicle Model
Plant P_OpActyInstceComponentDetail2 Plant Valuation Area
StorageLocation P_OpActyInstceComponentDetail2 StorageLocation StorageLocation
BaseUnit P_OpActyInstceComponentDetail2 BaseUnit Unit of Measure
Batch P_OpActyInstceComponentDetail2 Batch Lot No.
QuantityIsFixed P_OpActyInstceComponentDetail2 QuantityIsFixed Qty. is fixed
MatlCompIsMarkedForDeletion P_OpActyInstceComponentDetail2 MatlCompIsMarkedForDeletion
DebitCreditCode P_OpActyInstceComponentDetail2 DebitCreditCode Single-Character Flag
IsBulkMaterialComponent P_OpActyInstceComponentDetail2 IsBulkMaterialComponent Bulk material
MatlCompIsMarkedForBackflush P_OpActyInstceComponentDetail2 MatlCompIsMarkedForBackflush Backflush
GoodsMovementIsAllowed P_OpActyInstceComponentDetail2 GoodsMovementIsAllowed Mvt Allowed
MaterialComponentIsMissing P_OpActyInstceComponentDetail2 MaterialComponentIsMissing
ReservationIsFinallyIssued P_OpActyInstceComponentDetail2 ReservationIsFinallyIssued Res Final Issue
MatlCompDiscontinuationType P_OpActyInstceComponentDetail2 MatlCompDiscontinuationType
EffectivityParameterVariant P_OpActyInstceComponentDetail2 EffectivityParameterVariant
Assembly P_OpActyInstceComponentDetail2 Assembly Pegged Reqmt
MaterialCompIsVariableSized P_OpActyInstceComponentDetail2 MaterialCompIsVariableSized Var-Sized Item
VariableSizeItemUnit P_OpActyInstceComponentDetail2 VariableSizeItemUnit VSI unit
FormulaKey P_OpActyInstceComponentDetail2 FormulaKey VSI Formula
VariableSizeDimension1 P_OpActyInstceComponentDetail2 VariableSizeDimension1 Size 1
VariableSizeDimension2 P_OpActyInstceComponentDetail2 VariableSizeDimension2 Size 2
VariableSizeDimension3 P_OpActyInstceComponentDetail2 VariableSizeDimension3 Size 3
VariableSizeDimensionUnit P_OpActyInstceComponentDetail2 VariableSizeDimensionUnit Size unit
VariableSizeComponentQuantity P_OpActyInstceComponentDetail2 VariableSizeComponentQuantity VSI Quantity
VariableSizeComponentUnit P_OpActyInstceComponentDetail2 VariableSizeComponentUnit VSI UoM
BillOfMaterialCategory P_OpActyInstceComponentDetail2 BillOfMaterialCategory BOM category
BOMItem P_OpActyInstceComponentDetail2 BOMItem
BOMItemInternalChangeCount P_OpActyInstceComponentDetail2 BOMItemInternalChangeCount Counter
BillOfMaterialInternalID
BOMItemCategory P_OpActyInstceComponentDetail2 BOMItemCategory Item Category
BillOfMaterialVariant P_OpActyInstceComponentDetail2 BillOfMaterialVariant AlternativeBOM
InheritedBOMItemNode P_OpActyInstceComponentDetail2 InheritedBOMItemNode
BillOfMaterialVersion P_OpActyInstceComponentDetail2 BillOfMaterialVersion BOM Version
OriginalReservation P_OpActyInstceComponentDetail2 OriginalReservation
OriginalReservationItem P_OpActyInstceComponentDetail2 OriginalReservationItem
AlternativeItemGroup P_OpActyInstceComponentDetail2 AlternativeItemGroup AltItemGroup
MaterialCompIsAlternativeItem P_OpActyInstceComponentDetail2 MaterialCompIsAlternativeItem
ComponentIsToBeReworked P_OpActyInstceComponentDetail2 ComponentIsToBeReworked
ManufacturingOrderOperation
MfgOrderOperationText P_OpActyInstceComponentDetail2 MfgOrderOperationText
_BOMItmMfgRefStrucItmAssgmt P_OpActyInstceComponentDetail2 _BOMItmMfgRefStrucItmAssgmt
_MfgRefHierItemWithDetails P_OpActyInstceComponentDetail2 _MfgRefHierItemWithDetails
_MfgRefStrucItemWithDetails P_OpActyInstceComponentDetail2 _MfgRefStrucItemWithDetails
_OpActyNtwkInstance P_OpActyInstceComponentDetail2 _OpActyNtwkInstance
_OpActyNtwkInstanceBasic P_OpActyInstceComponentDetail2 _OpActyNtwkInstanceBasic
_OperationActivityInstance P_OpActyInstceComponentDetail2 _OperationActivityInstance
_PlannedInventoryUsblyCode P_OpActyInstceComponentDetail2 _PlannedInventoryUsblyCode
_ReltdOpActyCompAssignment P_OpActyInstceComponentDetail2 _ReltdOpActyCompAssignment
_ReservationHeader P_OpActyInstceComponentDetail2 _ReservationHeader
_Reservation P_OpActyInstceComponentDetail2 _Reservation
_ReservationItem P_OpActyInstceComponentDetail2 _ReservationItem
_ReservationDocRecordType P_OpActyInstceComponentDetail2 _ReservationDocRecordType
_ManufacturingOrder P_OpActyInstceComponentDetail2 _ManufacturingOrder
_MfgOrderOperation P_OpActyInstceComponentDetail2 _MfgOrderOperation
_OrderInternalID P_OpActyInstceComponentDetail2 _OrderInternalID
_Product P_OpActyInstceComponentDetail2 _Product
_Material P_OpActyInstceComponentDetail2 _Material
_ProductPlantBasic P_OpActyInstceComponentDetail2 _ProductPlantBasic
_Plant P_OpActyInstceComponentDetail2 _Plant
_StorageLocation P_OpActyInstceComponentDetail2 _StorageLocation
_BOMItemCategory P_OpActyInstceComponentDetail2 _BOMItemCategory
_BaseUnit P_OpActyInstceComponentDetail2 _BaseUnit
_EntryUnit P_OpActyInstceComponentDetail2 _EntryUnit
_Batch P_OpActyInstceComponentDetail2 _Batch
_DebitCreditCode P_OpActyInstceComponentDetail2 _DebitCreditCode
_MatlCompDiscontinuationType P_OpActyInstceComponentDetail2 _MatlCompDiscontinuationType

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_OpActyInstceComponentDetail.
-- 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_OpActyInstceComponentDetail AS
SELECT
  OpActyInstceComponentDetail.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceComponentDetail.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstceComponentDetail.Reservation AS Reservation,
  OpActyInstceComponentDetail.ReservationItem AS ReservationItem,
  OpActyInstceComponentDetail.RecordType AS RecordType,
  OpActyInstceComponentDetail.RequiredQuantity AS RequiredQuantity,
  OpActyInstceComponentDetail.EntryUnit AS EntryUnit,
  OpActyInstceComponentDetail.ComponentQuantity AS ComponentQuantity,
  OpActyInstceComponentDetail.MaterialCompOriginalQuantity AS MaterialCompOriginalQuantity,
  OpActyInstceComponentDetail.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  OpActyInstceComponentDetail.AssemblySequenceNumber AS AssemblySequenceNumber,
  OpActyInstceComponentDetail.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OpActyInstceComponentDetail.LogicalComponent AS LogicalComponent,
  OpActyInstceComponentDetail.ComponentAssemblyType AS ComponentAssemblyType,
  OpActyInstceComponentDetail.RelatedReservation AS RelatedReservation,
  OpActyInstceComponentDetail.RelatedReservationItem AS RelatedReservationItem,
  OpActyInstceComponentDetail.RelatedRecordType AS RelatedRecordType,
  OpActyInstceComponentDetail.RelatedOpActyNtwkInstance AS RelatedOpActyNtwkInstance,
  OpActyInstceComponentDetail.RelatedOpActyNtwkElement AS RelatedOpActyNtwkElement,
  OpActyInstceComponentDetail.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  OpActyInstceComponentDetail.PlannedInventoryUsabilityCode AS PlannedInventoryUsabilityCode,
  OpActyInstceComponentDetail.LeadingReservation AS LeadingReservation,
  OpActyInstceComponentDetail.LeadingReservationItem AS LeadingReservationItem,
  OpActyInstceComponentDetail.LeadingReservationRecordType AS LeadingReservationRecordType,
  OpActyInstceComponentDetail.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  OpActyInstceComponentDetail.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  OpActyInstceComponentDetail.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyInstceComponentDetail.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyInstceComponentDetail.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyInstceComponentDetail.MatlCompAssemblyIsNotRequired AS MatlCompAssemblyIsNotRequired,
  OpActyInstceComponentDetail.ManufacturingOrder AS ManufacturingOrder,
  OpActyInstceComponentDetail.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  OpActyInstceComponentDetail.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  OpActyInstceComponentDetail.Material AS Material,
  OpActyInstceComponentDetail.Plant AS Plant,
  OpActyInstceComponentDetail.StorageLocation AS StorageLocation,
  OpActyInstceComponentDetail.BaseUnit AS BaseUnit,
  OpActyInstceComponentDetail.Batch AS Batch,
  OpActyInstceComponentDetail.QuantityIsFixed AS QuantityIsFixed,
  OpActyInstceComponentDetail.MatlCompIsMarkedForDeletion AS MatlCompIsMarkedForDeletion,
  OpActyInstceComponentDetail.DebitCreditCode AS DebitCreditCode,
  OpActyInstceComponentDetail.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  OpActyInstceComponentDetail.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  OpActyInstceComponentDetail.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  OpActyInstceComponentDetail.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  OpActyInstceComponentDetail.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  OpActyInstceComponentDetail.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  OpActyInstceComponentDetail.EffectivityParameterVariant AS EffectivityParameterVariant,
  OpActyInstceComponentDetail.Assembly AS Assembly,
  OpActyInstceComponentDetail.MaterialCompIsVariableSized AS MaterialCompIsVariableSized,
  OpActyInstceComponentDetail.VariableSizeItemUnit AS VariableSizeItemUnit,
  OpActyInstceComponentDetail.FormulaKey AS FormulaKey,
  OpActyInstceComponentDetail.VariableSizeDimension1 AS VariableSizeDimension1,
  OpActyInstceComponentDetail.VariableSizeDimension2 AS VariableSizeDimension2,
  OpActyInstceComponentDetail.VariableSizeDimension3 AS VariableSizeDimension3,
  OpActyInstceComponentDetail.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  OpActyInstceComponentDetail.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  OpActyInstceComponentDetail.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  OpActyInstceComponentDetail.BillOfMaterialCategory AS BillOfMaterialCategory,
  OpActyInstceComponentDetail.BOMItem AS BOMItem,
  OpActyInstceComponentDetail.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  cast(OpActyInstceComponentDetail.BillOfMaterialInternalID as mpe_exec_stnum preserving type ) AS BillOfMaterialInternalID,
  OpActyInstceComponentDetail.BOMItemCategory AS BOMItemCategory,
  OpActyInstceComponentDetail.BillOfMaterialVariant AS BillOfMaterialVariant,
  OpActyInstceComponentDetail.InheritedBOMItemNode AS InheritedBOMItemNode,
  OpActyInstceComponentDetail.BillOfMaterialVersion AS BillOfMaterialVersion,
  OpActyInstceComponentDetail.OriginalReservation AS OriginalReservation,
  OpActyInstceComponentDetail.OriginalReservationItem AS OriginalReservationItem,
  OpActyInstceComponentDetail.AlternativeItemGroup AS AlternativeItemGroup,
  OpActyInstceComponentDetail.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  OpActyInstceComponentDetail.ComponentIsToBeReworked AS ComponentIsToBeReworked,
  OpActyInstceComponentDetail.MfgOrderOperationText AS MfgOrderOperationText,
  OpActyInstceComponentDetail._BOMItmMfgRefStrucItmAssgmt AS _BOMItmMfgRefStrucItmAssgmt,
  OpActyInstceComponentDetail._MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails,
  OpActyInstceComponentDetail._MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails,
  OpActyInstceComponentDetail._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyInstceComponentDetail._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic,
  OpActyInstceComponentDetail._OperationActivityInstance AS _OperationActivityInstance,
  OpActyInstceComponentDetail._PlannedInventoryUsblyCode AS _PlannedInventoryUsblyCode,
  OpActyInstceComponentDetail._ReltdOpActyCompAssignment AS _ReltdOpActyCompAssignment,
  OpActyInstceComponentDetail._ReservationHeader AS _ReservationHeader,
  OpActyInstceComponentDetail._Reservation AS _Reservation,
  OpActyInstceComponentDetail._ReservationItem AS _ReservationItem,
  OpActyInstceComponentDetail._ReservationDocRecordType AS _ReservationDocRecordType,
  OpActyInstceComponentDetail._ManufacturingOrder AS _ManufacturingOrder,
  OpActyInstceComponentDetail._MfgOrderOperation AS _MfgOrderOperation,
  OpActyInstceComponentDetail._OrderInternalID AS _OrderInternalID,
  OpActyInstceComponentDetail._Product AS _Product,
  OpActyInstceComponentDetail._Material AS _Material,
  OpActyInstceComponentDetail._ProductPlantBasic AS _ProductPlantBasic,
  OpActyInstceComponentDetail._Plant AS _Plant,
  OpActyInstceComponentDetail._StorageLocation AS _StorageLocation,
  OpActyInstceComponentDetail._BOMItemCategory AS _BOMItemCategory,
  OpActyInstceComponentDetail._BaseUnit AS _BaseUnit,
  OpActyInstceComponentDetail._EntryUnit AS _EntryUnit,
  OpActyInstceComponentDetail._Batch AS _Batch,
  OpActyInstceComponentDetail._DebitCreditCode AS _DebitCreditCode,
  OpActyInstceComponentDetail._MatlCompDiscontinuationType AS _MatlCompDiscontinuationType
FROM P_OpActyInstceComponentDetail2 AS OpActyInstceComponentDetail
;

Learn More