P_OpActyInstceComponentDetail

DDL: P_OPACTYINSTCECOMPONENTDETAIL Type: view_entity COMPOSITE
100 Fields 1 Data Sources

P_OpActyInstceComponentDetail is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_OpActyInstanceComponent) and exposes 100 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, Reservation, ReservationItem, RecordType.

Data Sources (1)

SourceAliasJoin Type
I_OpActyInstanceComponent OpActyInstanceComponent from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (100)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_OpActyInstanceComponent OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OpActyInstanceComponent OpActyNtwkElement Element Number
KEY Reservation I_OpActyInstanceComponent Reservation Reservation
KEY ReservationItem I_OpActyInstanceComponent ReservationItem Reservation Item
KEY RecordType I_OpActyInstanceComponent RecordType Reservation Record Type
MfgOrderComponentUsageQuantity I_OpActyInstanceComponent MfgOrderComponentUsageQuantity
MfgOrderComponentUsageNetQty I_OpActyInstanceComponent MfgOrderComponentUsageNetQty
ComponentQuantity I_OpActyInstanceComponent RequiredQuantity Requirement qty
MaterialCompOriginalQuantity I_OpActyInstanceComponent MaterialCompOriginalQuantity
BillOfMaterialItemNumber I_OpActyInstanceComponent BillOfMaterialItemNumber Item
AssemblySequenceNumber I_OpActyInstanceComponent AssemblySequenceNumber Assembly Sequence
BOOOpBOMItemInternalID I_OpActyInstanceComponent BOOOpBOMItemInternalID Allocation no.
LogicalComponent I_OpActyInstanceComponent LogicalComponent Logical Component
ComponentAssemblyType I_OpActyInstanceComponent ComponentAssemblyType
RelatedReservation I_OpActyInstanceComponent RelatedReservation
RelatedReservationItem I_OpActyInstanceComponent RelatedReservationItem
RelatedRecordType I_OpActyInstanceComponent RelatedRecordType
RelatedOpActyNtwkInstance I_OpActyInstanceComponent RelatedOpActyNtwkInstance
RelatedOpActyNtwkElement I_OpActyInstanceComponent RelatedOpActyNtwkElement
MatlCompInstceAssyIsRequired I_OpActyInstanceComponent MatlCompInstceAssyIsRequired Instances Exist
PlannedInventoryUsabilityCode I_OpActyInstanceComponent PlannedInventoryUsabilityCode
LeadingReservation I_OpActyInstanceComponent LeadingReservation
LeadingReservationItem I_OpActyInstanceComponent LeadingReservationItem
LeadingReservationRecordType I_OpActyInstanceComponent LeadingReservationRecordType
LeadingOpActyNtwkInstance I_OpActyInstanceComponent LeadingOpActyNtwkInstance
LeadingOpActyNtwkElement I_OpActyInstanceComponent LeadingOpActyNtwkElement
MfgRefStrucBOMLeafAssgmtUUID I_OpActyInstanceComponent MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID I_OpActyInstanceComponent MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual I_OpActyInstanceComponent MfgRefStrucItmDetIsContextual
MatlCompAssemblyIsNotRequired I_OpActyInstanceComponent MatlCompAssemblyIsNotRequired
ManufacturingOrder I_OpActyInstanceComponent ManufacturingOrder Order
OrderInternalBillOfOperations I_OpActyInstanceComponent OrderInternalBillOfOperations Order Internal Bill of Operations
OrderIntBillOfOperationsItem I_OpActyInstanceComponent OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
Material I_OpActyInstanceComponent Material Vehicle Model
Plant I_OpActyInstanceComponent Plant Valuation Area
StorageLocation I_OpActyInstanceComponent StorageLocation StorageLocation
BaseUnit I_OpActyInstanceComponent BaseUnit Unit of Measure
EntryUnit I_OpActyInstanceComponent EntryUnit Unit of Entry
Batch I_OpActyInstanceComponent Batch Lot No.
QuantityIsFixed I_OpActyInstanceComponent QuantityIsFixed Qty. is fixed
MatlCompIsMarkedForDeletion
DebitCreditCode I_OpActyInstanceComponent DebitCreditCode Single-Character Flag
IsBulkMaterialComponent I_OpActyInstanceComponent IsBulkMaterialComponent Bulk material
MatlCompIsMarkedForBackflush I_OpActyInstanceComponent MatlCompIsMarkedForBackflush Backflush
GoodsMovementIsAllowed I_OpActyInstanceComponent GoodsMovementIsAllowed Mvt Allowed
MaterialComponentIsMissing I_OpActyInstanceComponent MaterialComponentIsMissing Missing Part
ReservationIsFinallyIssued I_OpActyInstanceComponent ReservationIsFinallyIssued Res Final Issue
MatlCompDiscontinuationType I_OpActyInstanceComponent MatlCompDiscontinuationType Share of scrap
EffectivityParameterVariant I_OpActyInstanceComponent EffectivityParameterVariant Tech st from
Assembly I_OpActyInstanceComponent Assembly Pegged Reqmt
MaterialCompIsVariableSized I_OpActyInstanceComponent MaterialCompIsVariableSized Var-Sized Item
VariableSizeItemUnit I_OpActyInstanceComponent VariableSizeItemUnit VSI unit
FormulaKey I_OpActyInstanceComponent FormulaKey VSI Formula
VariableSizeDimension1 I_OpActyInstanceComponent VariableSizeDimension1 Size 1
VariableSizeDimension2 I_OpActyInstanceComponent VariableSizeDimension2 Size 2
VariableSizeDimension3 I_OpActyInstanceComponent VariableSizeDimension3 Size 3
VariableSizeDimensionUnit I_OpActyInstanceComponent VariableSizeDimensionUnit Size unit
VariableSizeComponentQuantity I_OpActyInstanceComponent VariableSizeComponentQuantity VSI Quantity
VariableSizeComponentUnit I_OpActyInstanceComponent VariableSizeComponentUnit VSI UoM
BillOfMaterialCategory I_OpActyInstanceComponent BillOfMaterialCategory BOM category
BOMItem I_OpActyInstanceComponent BOMItem
BOMItemInternalChangeCount I_OpActyInstanceComponent BOMItemInternalChangeCount Counter
BillOfMaterialInternalID I_OpActyInstanceComponent BillOfMaterialInternalID
BOMItemCategory I_OpActyInstanceComponent BOMItemCategory Item Category
BillOfMaterialVariant I_OpActyInstanceComponent BillOfMaterialVariant AlternativeBOM
InheritedBOMItemNode I_OpActyInstanceComponent InheritedBOMItemNode Nodes
BillOfMaterialVersion I_OpActyInstanceComponent BillOfMaterialVersion BOM Version
OriginalReservation I_OpActyInstanceComponent OriginalReservation Origl.Resv.no.
OriginalReservationItem I_OpActyInstanceComponent OriginalReservationItem Origl. Item
AlternativeItemGroup I_OpActyInstanceComponent AlternativeItemGroup AltItemGroup
MaterialCompIsAlternativeItem I_OpActyInstanceComponent MaterialCompIsAlternativeItem Alternat. item
ComponentIsToBeReworked I_OpActyInstanceComponent ComponentIsToBeReworked
Operation_2asManufacturingOrderOperation
MfgOrderOperationText OrderOperation OperationText Description
_BOMItmMfgRefStrucItmAssgmt I_OpActyInstanceComponent _BOMItmMfgRefStrucItmAssgmt
_MfgRefHierItemWithDetails I_OpActyInstanceComponent _MfgRefHierItemWithDetails
_MfgRefStrucItemWithDetails I_OpActyInstanceComponent _MfgRefStrucItemWithDetails
_OpActyNtwkInstance I_OpActyInstanceComponent _OpActyNtwkInstance
_OpActyNtwkInstanceBasic I_OpActyInstanceComponent _OpActyNtwkInstanceBasic
_OperationActivityInstance I_OpActyInstanceComponent _OperationActivityInstance
_PlannedInventoryUsblyCode I_OpActyInstanceComponent _PlannedInventoryUsblyCode
_ReltdOpActyCompAssignment I_OpActyInstanceComponent _ReltdOpActyCompAssignment
_ReservationHeader I_OpActyInstanceComponent _ReservationHeader
_Reservation I_OpActyInstanceComponent _Reservation
_ReservationItem I_OpActyInstanceComponent _ReservationItem
_ReservationDocRecordType I_OpActyInstanceComponent _ReservationDocRecordType
_ManufacturingOrder I_OpActyInstanceComponent _ManufacturingOrder
_MfgOrderOperation I_OpActyInstanceComponent _MfgOrderOperation
_OrderInternalID I_OpActyInstanceComponent _OrderInternalID
_Product I_OpActyInstanceComponent _Product
_Material I_OpActyInstanceComponent _Material
_ProductPlantBasic I_OpActyInstanceComponent _ProductPlantBasic
_Plant I_OpActyInstanceComponent _Plant
_StorageLocation I_OpActyInstanceComponent _StorageLocation
_BOMItemCategory I_OpActyInstanceComponent _BOMItemCategory
_BaseUnit I_OpActyInstanceComponent _BaseUnit
_EntryUnit I_OpActyInstanceComponent _EntryUnit
_Batch I_OpActyInstanceComponent _Batch
_DebitCreditCode I_OpActyInstanceComponent _DebitCreditCode
_MatlCompDiscontinuationType I_OpActyInstanceComponent _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 P_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 P_OpActyInstceComponentDetail AS
SELECT
  OpActyInstanceComponent.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstanceComponent.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstanceComponent.Reservation AS Reservation,
  OpActyInstanceComponent.ReservationItem AS ReservationItem,
  OpActyInstanceComponent.RecordType AS RecordType,
  OpActyInstanceComponent.MfgOrderComponentUsageQuantity AS MfgOrderComponentUsageQuantity,
  OpActyInstanceComponent.MfgOrderComponentUsageNetQty AS MfgOrderComponentUsageNetQty,
  OpActyInstanceComponent.RequiredQuantity AS ComponentQuantity,
  OpActyInstanceComponent.MaterialCompOriginalQuantity AS MaterialCompOriginalQuantity,
  OpActyInstanceComponent.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  OpActyInstanceComponent.AssemblySequenceNumber AS AssemblySequenceNumber,
  OpActyInstanceComponent.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OpActyInstanceComponent.LogicalComponent AS LogicalComponent,
  OpActyInstanceComponent.ComponentAssemblyType AS ComponentAssemblyType,
  OpActyInstanceComponent.RelatedReservation AS RelatedReservation,
  OpActyInstanceComponent.RelatedReservationItem AS RelatedReservationItem,
  OpActyInstanceComponent.RelatedRecordType AS RelatedRecordType,
  OpActyInstanceComponent.RelatedOpActyNtwkInstance AS RelatedOpActyNtwkInstance,
  OpActyInstanceComponent.RelatedOpActyNtwkElement AS RelatedOpActyNtwkElement,
  OpActyInstanceComponent.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  OpActyInstanceComponent.PlannedInventoryUsabilityCode AS PlannedInventoryUsabilityCode,
  OpActyInstanceComponent.LeadingReservation AS LeadingReservation,
  OpActyInstanceComponent.LeadingReservationItem AS LeadingReservationItem,
  OpActyInstanceComponent.LeadingReservationRecordType AS LeadingReservationRecordType,
  OpActyInstanceComponent.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  OpActyInstanceComponent.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  OpActyInstanceComponent.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyInstanceComponent.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyInstanceComponent.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyInstanceComponent.MatlCompAssemblyIsNotRequired AS MatlCompAssemblyIsNotRequired,
  OpActyInstanceComponent.ManufacturingOrder AS ManufacturingOrder,
  OpActyInstanceComponent.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  OpActyInstanceComponent.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  OpActyInstanceComponent.Material AS Material,
  OpActyInstanceComponent.Plant AS Plant,
  OpActyInstanceComponent.StorageLocation AS StorageLocation,
  OpActyInstanceComponent.BaseUnit AS BaseUnit,
  OpActyInstanceComponent.EntryUnit AS EntryUnit,
  OpActyInstanceComponent.Batch AS Batch,
  OpActyInstanceComponent.QuantityIsFixed AS QuantityIsFixed,
  cast(OpActyInstanceComponent.MatlCompIsMarkedForDeletion as sa_loekz preserving type ) AS MatlCompIsMarkedForDeletion,
  OpActyInstanceComponent.DebitCreditCode AS DebitCreditCode,
  OpActyInstanceComponent.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  OpActyInstanceComponent.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  OpActyInstanceComponent.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  OpActyInstanceComponent.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  OpActyInstanceComponent.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  OpActyInstanceComponent.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  OpActyInstanceComponent.EffectivityParameterVariant AS EffectivityParameterVariant,
  OpActyInstanceComponent.Assembly AS Assembly,
  OpActyInstanceComponent.MaterialCompIsVariableSized AS MaterialCompIsVariableSized,
  OpActyInstanceComponent.VariableSizeItemUnit AS VariableSizeItemUnit,
  OpActyInstanceComponent.FormulaKey AS FormulaKey,
  OpActyInstanceComponent.VariableSizeDimension1 AS VariableSizeDimension1,
  OpActyInstanceComponent.VariableSizeDimension2 AS VariableSizeDimension2,
  OpActyInstanceComponent.VariableSizeDimension3 AS VariableSizeDimension3,
  OpActyInstanceComponent.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  OpActyInstanceComponent.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  OpActyInstanceComponent.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  OpActyInstanceComponent.BillOfMaterialCategory AS BillOfMaterialCategory,
  OpActyInstanceComponent.BOMItem AS BOMItem,
  OpActyInstanceComponent.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  OpActyInstanceComponent.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  OpActyInstanceComponent.BOMItemCategory AS BOMItemCategory,
  OpActyInstanceComponent.BillOfMaterialVariant AS BillOfMaterialVariant,
  OpActyInstanceComponent.InheritedBOMItemNode AS InheritedBOMItemNode,
  OpActyInstanceComponent.BillOfMaterialVersion AS BillOfMaterialVersion,
  OpActyInstanceComponent.OriginalReservation AS OriginalReservation,
  OpActyInstanceComponent.OriginalReservationItem AS OriginalReservationItem,
  OpActyInstanceComponent.AlternativeItemGroup AS AlternativeItemGroup,
  OpActyInstanceComponent.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  OpActyInstanceComponent.ComponentIsToBeReworked AS ComponentIsToBeReworked,
  OrderOperation.OperationText AS MfgOrderOperationText,
  OpActyInstanceComponent._BOMItmMfgRefStrucItmAssgmt AS _BOMItmMfgRefStrucItmAssgmt,
  OpActyInstanceComponent._MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails,
  OpActyInstanceComponent._MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails,
  OpActyInstanceComponent._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyInstanceComponent._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic,
  OpActyInstanceComponent._OperationActivityInstance AS _OperationActivityInstance,
  OpActyInstanceComponent._PlannedInventoryUsblyCode AS _PlannedInventoryUsblyCode,
  OpActyInstanceComponent._ReltdOpActyCompAssignment AS _ReltdOpActyCompAssignment,
  OpActyInstanceComponent._ReservationHeader AS _ReservationHeader,
  OpActyInstanceComponent._Reservation AS _Reservation,
  OpActyInstanceComponent._ReservationItem AS _ReservationItem,
  OpActyInstanceComponent._ReservationDocRecordType AS _ReservationDocRecordType,
  OpActyInstanceComponent._ManufacturingOrder AS _ManufacturingOrder,
  OpActyInstanceComponent._MfgOrderOperation AS _MfgOrderOperation,
  OpActyInstanceComponent._OrderInternalID AS _OrderInternalID,
  OpActyInstanceComponent._Product AS _Product,
  OpActyInstanceComponent._Material AS _Material,
  OpActyInstanceComponent._ProductPlantBasic AS _ProductPlantBasic,
  OpActyInstanceComponent._Plant AS _Plant,
  OpActyInstanceComponent._StorageLocation AS _StorageLocation,
  OpActyInstanceComponent._BOMItemCategory AS _BOMItemCategory,
  OpActyInstanceComponent._BaseUnit AS _BaseUnit,
  OpActyInstanceComponent._EntryUnit AS _EntryUnit,
  OpActyInstanceComponent._Batch AS _Batch,
  OpActyInstanceComponent._DebitCreditCode AS _DebitCreditCode,
  OpActyInstanceComponent._MatlCompDiscontinuationType AS _MatlCompDiscontinuationType
FROM I_OpActyInstanceComponent AS OpActyInstanceComponent
;

Learn More