C_ShopFloorItemAtOpActyComp

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 C_ShopFloorItemAtOpActyComp.
-- 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: CMPESFIATOAC

CREATE VIEW C_ShopFloorItemAtOpActyComp AS
SELECT
  ShopFloorItemAtOpActyComp.ShopFloorItem AS ShopFloorItem,
  _ShopFloorItem.SerialNumber AS SerialNumber,
  ShopFloorItemAtOpActyComp.ProductionPlant AS ProductionPlant,
  ShopFloorItemAtOpActyComp.StorageLocation AS StorageLocation,
  OrderOperationBasic.WorkCenterInternalID AS WorkCenterInternalID,
  OrderOperationBasic.WorkCenterTypeCode AS WorkCenterTypeCode,
  _WorkCenter.WorkCenter AS WorkCenter,
  cast('2' as mpe_oan_segment_type preserving type) AS OpActyNtwkSegmentType,
  ShopFloorItemAtOpActyComp.AssemblySequenceNumber AS AssemblySequenceNumber,
  ShopFloorItemAtOpActyComp.BaseUnit AS BaseUnit,
  ShopFloorItemAtOpActyComp.MfgOrderComponentUsageQuantity AS MfgOrderComponentUsageQuantity,
  ShopFloorItemAtOpActyComp.MaterialComponentQuantity AS MaterialComponentQuantity,
  case when ShopFloorItemAtOpActyComp.MaterialComponentQuantity = 0 or ShopFloorItemAtOpActyComp.MaterialComponentQuantity is null then 0 AS MfgOrderComponentUsageNetQtythen1red,
  ShopFloorItemAtOpActyComp.SerialNumberProfile AS SerialNumberProfile,
  ShopFloorItemAtOpActyComp.StockCheckMessageType AS StockCheckMessageType,
  ShopFloorItemAtOpActyComp.IsBatchManagementRequired AS IsBatchManagementRequired,
  cast( ShopFloorItemAtOpActyComp.MatlCompIsMarkedForBackflush as boolean preserving type ) AS MatlCompIsMarkedForBackflush,
  ShopFloorItemAtOpActyComp.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  ShopFloorItemAtOpActyComp.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  ShopFloorItemAtOpActyComp.FormulaKey AS FormulaKey,
  ShopFloorItemAtOpActyComp.VariableSizeDimension1 AS VariableSizeDimension1,
  ShopFloorItemAtOpActyComp.VariableSizeDimension2 AS VariableSizeDimension2,
  ShopFloorItemAtOpActyComp.VariableSizeDimension3 AS VariableSizeDimension3,
  ShopFloorItemAtOpActyComp.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  cast('' as mpe_vsi_formatted_formula) AS VarblSizeCompFrmtdFormulaVal,
  ShopFloorItemAtOpActyComp.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  ShopFloorItemAtOpActyComp.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  ShopFloorItemAtOpActyComp.MatlCompAssembleControl AS MatlCompAssembleControl,
  ShopFloorItemAtOpActyComp._MatlCompAssembleControl._Text[1: Language=$session.system_language].MatlCompAssembleControlName AS MatlCompAssembleControlName,
  ShopFloorItemAtOpActyComp.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  ShopFloorItemAtOpActyComp.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  ShopFloorItemAtOpActyComp.AlternativeItemGroup AS AlternativeItemGroup,
  ShopFloorItemAtOpActyComp.AlternativeItemStrategy AS AlternativeItemStrategy,
  ShopFloorItemAtOpActyComp.AlternativeItemPriority AS AlternativeItemPriority,
  ShopFloorItemAtOpActyComp.UsageProbabilityPercent AS UsageProbabilityPercent,
  ShopFloorItemAtOpActyComp.OriginalReservation AS OriginalReservation,
  ShopFloorItemAtOpActyComp.OriginalReservationItem AS OriginalReservationItem,
  ShopFloorItemAtOpActyComp._BOMItemCategory._ItemCategoryT[1: Language=$session.system_language].BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  ShopFloorItemAtOpActyComp.RelatedReservationItem AS RelatedReservationItem,
  ShopFloorItemAtOpActyComp.RelatedRecordType AS RelatedRecordType,
  ShopFloorItemAtOpActyComp.RelatedOpActyNtwkInstance AS RelatedOpActyNtwkInstance,
  ShopFloorItemAtOpActyComp.RelatedOpActyNtwkElement AS RelatedOpActyNtwkElement,
  ShopFloorItemAtOpActyComp.LeadingReservation AS LeadingReservation,
  ShopFloorItemAtOpActyComp.LeadingReservationItem AS LeadingReservationItem,
  ShopFloorItemAtOpActyComp.LeadingReservationRecordType AS LeadingReservationRecordType,
  ShopFloorItemAtOpActyComp.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  ShopFloorItemAtOpActyComp.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  ShopFloorItemAtOpActyComp.BillOfMaterial AS BillOfMaterial,
  ShopFloorItemAtOpActyComp.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  ShopFloorItemAtOpActyComp.BillOfMaterialVariant AS BillOfMaterialVariant,
  ShopFloorItemAtOpActyComp.BillOfMaterialVersion AS BillOfMaterialVersion,
  ShopFloorItemAtOpActyComp.InheritedBOMItemNode AS InheritedBOMItemNode,
  ShopFloorItemAtOpActyComp.BOMItem AS BOMItem,
  ShopFloorItemAtOpActyComp.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  OpActyInstceOpActyNtwkElmnt.BillOfOperationsType AS BillOfOperationsType,
  OpActyInstceOpActyNtwkElmnt.BillOfOperationsGroup AS BillOfOperationsGroup,
  ShopFloorItemAtOpActyComp.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  ShopFloorItemAtOpActyComp.LogicalComponent AS LogicalComponent,
  ShopFloorItemAtOpActyComp.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  ShopFloorItemAtOpActyComp.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  ShopFloorItemAtOpActyComp.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementElement AS OperationActivity,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementElmntVersCntr AS OperationActyVersionCounter,
  OpActyInstceOpActyNtwkElmnt._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyInstceOpActyNtwkElmnt._OperationActivityInstance AS _OperationActivityInstance
FROM P_ShopFloorItemAtOpActyComp2 AS ShopFloorItemAtOpActyComp
INNER JOIN I_OpActyInstceNtwkElmntBasic AS OpActyInstceOpActyNtwkElmnt ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperationBasic AS OrderOperationBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ShopFloorItem AS _ShopFloorItem ON ShopFloorItem = _ShopFloorItem.ShopFloorItem  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND ProductionPlant = _ProductPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [1..1]
LEFT OUTER JOIN C_MfgOrderCompAssemblyAggrgn AS _MfgOrderCompAssemblyAggrgn ON Reservation = _MfgOrderCompAssemblyAggrgn.Reservation AND ReservationItem = _MfgOrderCompAssemblyAggrgn.ReservationItem AND RecordType = _MfgOrderCompAssemblyAggrgn.RecordType AND OpActyNtwkInstance = _MfgOrderCompAssemblyAggrgn.OpActyNtwkInstance AND OpActyNtwkElement = _MfgOrderCompAssemblyAggrgn.OpActyNtwkElement AND Material = _MfgOrderCompAssemblyAggrgn.Material AND ShopFloorItem = _MfgOrderCompAssemblyAggrgn.AssemblyShopFloorItem AND _MfgOrderCompAssemblyAggrgn.MaterialComponentQuantity <> 0  -- association [0..*]
LEFT OUTER JOIN I_OpActyCompInstceAssignment AS _OpActyCompInstceAssignment ON Reservation = _OpActyCompInstceAssignment.Reservation AND ReservationItem = _OpActyCompInstceAssignment.ReservationItem AND RecordType = _OpActyCompInstceAssignment.RecordType AND OpActyNtwkInstance = _OpActyCompInstceAssignment.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyCompInstceAssignment.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN I_OpActyBOOOpBOMIndivItmAssgmt AS _OpActyBOOOpBOMIndivItmAssgmt ON OperationActivity = _OpActyBOOOpBOMIndivItmAssgmt.OperationActivity AND OperationActyVersionCounter = _OpActyBOOOpBOMIndivItmAssgmt.OperationActyVersionCounter AND BillOfOperationsType = _OpActyBOOOpBOMIndivItmAssgmt.BillOfOperationsType AND BillOfOperationsGroup = _OpActyBOOOpBOMIndivItmAssgmt.BillOfOperationsGroup AND BOOOpBOMItemInternalID = _OpActyBOOOpBOMIndivItmAssgmt.BOOOpBOMItemInternalID  -- association [0..*]
LEFT OUTER JOIN I_BillOfMaterialItemBasic AS _BillOfMaterialItemBasic ON BillOfMaterialCategory = _BillOfMaterialItemBasic.BillOfMaterialCategory AND BillOfMaterial = _BillOfMaterialItemBasic.BillOfMaterial AND BOMItem = _BillOfMaterialItemBasic.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItemBasic.BOMItemInternalChangeCount  -- association [0..1]
LEFT OUTER JOIN I_MfgBOMItemWithPhantomHier AS _MfgBOMItemWithPhantomHier ON BillOfMaterialCategory = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialCategory AND BillOfMaterialInternalID = _MfgBOMItemWithPhantomHier.MfgBillOfMaterial AND BillOfMaterialVariant = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVariant AND BillOfMaterialVersion = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVersion AND InheritedBOMItemNode = _MfgBOMItemWithPhantomHier.MfgBOMItmInhtdNodeNmbr  -- association [0..1]
LEFT OUTER JOIN E_BillOfMaterialItemTP AS _BillOfMaterialItemExtension ON BillOfMaterialCategory = _BillOfMaterialItemExtension.BillOfMaterialCategory AND BillOfMaterialInternalID = _BillOfMaterialItemExtension.BillOfMaterial AND BOMItem = _BillOfMaterialItemExtension.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItemExtension.BOMItemInternalChangeCount  -- association [0..1]
LEFT OUTER JOIN E_ReservationDocumentItem AS _ReservationDocumentItem ON Reservation = _ReservationDocumentItem.Reservation AND ReservationItem = _ReservationDocumentItem.ReservationItem AND RecordType = _ReservationDocumentItem.RecordType  -- association [1..1]
;