C_ShopFloorItemAtOpActy

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_ShopFloorItemAtOpActy.
-- 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: CMPESFIATOA

CREATE VIEW C_ShopFloorItemAtOpActy AS
SELECT
  ShopFloorItemAtOpActy.ShopFloorItemExternalID AS ShopFloorItemExternalID,
  ShopFloorItemAtOpActy.ManufacturingOrderItem AS ManufacturingOrderItem,
  ShopFloorItemAtOpActy.ManufacturingOrderType AS ManufacturingOrderType,
  ShopFloorItemAtOpActy._MfgOrderType._Text[1: Language = $session.system_language].ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  ShopFloorItemAtOpActy.MfgOrderOperationText AS MfgOrderOperationText,
  ShopFloorItemAtOpActy.OrderInternalID AS OrderInternalID,
  ShopFloorItemAtOpActy.OrderOperationInternalID AS OrderOperationInternalID,
  cast(coalesce(ShopFloorItemAtOpActy._OperationControlProfile.OperationIsReworkOperation, '') as rework preserving type) AS OperationIsReworkOperation,
  ShopFloorItemAtOpActy.StatusAndActionSchemaStatus AS StatusAndActionSchemaStatus,
  cast(_SASStatusText[1: Language=$session.system_language].SASStatusName as mpe_sfi_status_description preserving type) AS SASStatusName,
  ShopFloorItemAtOpActy._OperationActivitySFIGroup.OpActySFIGroupName AS OpActySFIGroupName,
  OpActyInstceAggrgdConfdQts.OpActyExpdExecDurnInSeconds AS OpActyExpdExecDurnInSeconds,
  OpActyInstceAggrgdConfdQts.OpActyExpdExecLaborDurnInSecs AS OpActyExpdExecLaborDurnInSecs,
  OpActyInstanceStatusBasic.OpActyIsSeldForRtactvPostg AS OpActyIsSeldForRtactvPostg,
  OperationActivity.AssemblySqncCheckIsRequired AS AssemblySqncCheckIsRequired,
  OperationActivity.OpActyInspectionRelevance AS OpActyInspectionRelevance,
  ShopFloorItemAtOpActy._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  ShopFloorItemAtOpActy.ProductionPlant AS ProductionPlant,
  ShopFloorItemAtOpActy.OpActyNtwkElementElmntVersCntr AS OperationActyVersionCounter,
  ShopFloorItemAtOpActy.OpActyHasAssgdBuyOffs AS OpActyHasAssgdBuyOffs,
  ShopFloorItemAtOpActy.OpActyConfIsSFIBased AS OpActyConfIsSFIBased,
  _OpActyChgAlertAssgmt.OriginalChgAlertCount AS OriginalChgAlertCount,
  cast( '' as boolean preserving type ) AS OpActyChgAlertAcknIsRequired,
  ShopFloorItemAtOpActy.WorkCenterInternalID AS WorkCenterInternalID,
  ShopFloorItemAtOpActy.WorkCenterTypeCode AS WorkCenterTypeCode,
  ShopFloorItemAtOpActy.WorkCenter AS WorkCenter,
  ShopFloorItemAtOpActy._WorkCenter._Text[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  OpActyInstceAggrgdConfdQts.ConfirmationYieldQuantity AS ConfirmationYieldQuantity,
  1 AS Quantity,
  OpActyInstceAggrgdConfdQts.ProductionUnit AS ProductionUnit,
  ShopFloorItemAtOpActy.WorkInstruction AS WorkInstruction,
  ShopFloorItemAtOpActy.WorkInstructionVersionCounter AS WorkInstructionVersionCounter,
  _MfgWorkInstructionVersionTP.MfgWorkInstructionContent AS MfgWorkInstructionContent,
  ShopFloorItemAtOpActy.ShopFloorItemProductionStatus AS ShopFloorItemProductionStatus,
  ShopFloorItemAtOpActy.LaborTrackingIsRequired AS LaborTrackingIsRequired,
  ShopFloorItemAtOpActy.BillOfMaterial AS BillOfMaterial,
  ShopFloorItemAtOpActy.BillOfMaterialCategory AS BillOfMaterialCategory,
  ShopFloorItemAtOpActy.BillOfMaterialVariant AS BillOfMaterialVariant,
  ShopFloorItemAtOpActy.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ShopFloorItemAtOpActy.BillOfMaterialVersion AS BillOfMaterialVersion,
  ShopFloorItemAtOpActy.BillOfOperationsType AS BillOfOperationsType,
  ShopFloorItemAtOpActy.BillOfOperations AS BillOfOperations,
  ShopFloorItemAtOpActy.BillOfOperationsVariant AS BillOfOperationsVariant,
  ShopFloorItemAtOpActy.BillOfOperationsVersion AS BillOfOperationsVersion,
  cast(hextobin('00000000000000000000000000000000') as cs_guidb preserving type ) AS BillOfMaterialHeaderUUID,
  cast ('' as sdok_phid) AS PhysicalDocument,
  cast('' as doknr) AS DocumentInfoRecordDocNumber,
  cast('' as doktl_d) AS DocumentInfoRecordDocPart,
  cast('' as dokvr) AS DocumentInfoRecordDocVersion,
  ShopFloorItemAtOpActy.ProductConfiguration AS ProductConfiguration,
  _UnitizedMaterial.EffectivityType AS EffectivityType,
  ShopFloorItemAtOpActy._ProdnProcgFlexibilityIndTxt[1: Language=$session.system_language].ProdnProcgFlexibilityIndName AS ProdnProcgFlexibilityIndName,
  ShopFloorItemAtOpActy.OrderHeaderProductionPlant AS OrderHeaderProductionPlant,
  cast('' as mpe_effectivity_parameter_desc) AS EffectivityParameterDesc,
  cast('' as mpe_effecty_type_param_desc) AS EffctyTypeCnctntdParamDesc,
  _Equipment.Equipment AS Equipment,
  ShopFloorItemAtOpActy._MfgOrder AS _MfgOrder,
  ShopFloorItemAtOpActy._MfgOrderType AS _MfgOrderType,
  ShopFloorItemAtOpActy._BillOfMaterial AS _BillOfMaterial,
  ShopFloorItemAtOpActy._Material AS _Material,
  ShopFloorItemAtOpActy._OpActyNtwkInstance AS _OpActyNtwkInstance,
  ShopFloorItemAtOpActy._SASSchema AS _SASSchema,
  ShopFloorItemAtOpActy._SASStatus AS _SASStatus,
  ShopFloorItemAtOpActy._SASStatusCategory AS _SASStatusCategory,
  ShopFloorItemAtOpActy._SFIProductionStatus AS _SFIProductionStatus,
  ShopFloorItemAtOpActy._ShopFloorItem AS _ShopFloorItem,
  ShopFloorItemAtOpActy._OperationActivityInstance AS _OperationActivityInstance,
  ShopFloorItemAtOpActy._ProductionPlant AS _ProductionPlant,
  ShopFloorItemAtOpActy._OrderInternalID AS _OrderInternalID,
  ShopFloorItemAtOpActy._WorkCenter AS _WorkCenter,
  ShopFloorItemAtOpActy._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey,
  ShopFloorItemAtOpActy._WorkCenterType AS _WorkCenterType,
  ShopFloorItemAtOpActy._MfgOrderDocInfoRecdObjLink AS _MfgOrderDocInfoRecdObjLink,
  ShopFloorItemAtOpActy._MfgOrderOpDocInfoRecdObjLink AS _MfgOrderOpDocInfoRecdObjLink,
  ShopFloorItemAtOpActy._OpActyDocInfoRecdObjLink AS _OpActyDocInfoRecdObjLink,
  ShopFloorItemAtOpActy._SFIDocInfoRecdObjLink AS _SFIDocInfoRecdObjLink,
  ShopFloorItemAtOpActy._OrderItem AS _OrderItem
FROM I_ShopFloorItemAtOpActy AS ShopFloorItemAtOpActy
INNER JOIN I_OpActyInstceAggrgdConfdQts AS OpActyInstceAggrgdConfdQts ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationActivity AS OperationActivity ON /* join condition not captured in parsed metadata */
INNER JOIN I_OpActyInstanceStatusBasic AS OpActyInstanceStatusBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SASStatusText AS _SASStatusText ON StatusAndActionSchemaStatus = _SASStatusText.StatusAndActionSchemaStatus  -- association [0..*]
LEFT OUTER JOIN C_ShopFloorItemAtOpActyComp AS _ShopFloorItemAtOpActyComp ON ShopFloorItem = _ShopFloorItemAtOpActyComp.ShopFloorItem AND OpActyNtwkInstance = _ShopFloorItemAtOpActyComp.OpActyNtwkInstance AND OpActyNtwkElement = _ShopFloorItemAtOpActyComp.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_SFIAtOpActyPlndMatlRet AS _SFIAtOpActyPlndMatlRet ON ShopFloorItem = _SFIAtOpActyPlndMatlRet.ShopFloorItem AND OpActyNtwkInstance = _SFIAtOpActyPlndMatlRet.OpActyNtwkInstance AND OpActyNtwkElement = _SFIAtOpActyPlndMatlRet.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_SASAction AS _SASAction ON StatusAndActionSchema = _SASAction.StatusAndActionSchema AND StatusAndActionSchemaStatus = _SASAction.SASActionStartStatus AND ProductionPlant = _SASAction.Plant  -- association [0..*]
LEFT OUTER JOIN C_ManufacturingActionSetting AS _ManufacturingActionSetting ON ProductionPlant = _ManufacturingActionSetting.Plant AND _ManufacturingActionSetting.MfgObjectType = '004'  -- association [0..*]
LEFT OUTER JOIN I_OANSegmentType AS _OANSegmentType ON OpActyNtwkSegmentType = _OANSegmentType.OpActyNtwkSegmentType  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _OrderHeaderProductionPlant ON OrderHeaderProductionPlant = _OrderHeaderProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_SFIAssembledMaterial AS _SFIAssembledMaterial ON ShopFloorItem = _SFIAssembledMaterial.AssemblyShopFloorItem  -- association [0..*]
LEFT OUTER JOIN C_SFIAssembledComponent AS _SFIAssembledComponent ON ShopFloorItem = _SFIAssembledComponent.AssemblyShopFloorItem  -- association [0..*]
LEFT OUTER JOIN P_OpActyNrOfMandComponents AS _OpActyNrOfMandComponents ON OpActyNtwkInstance = _OpActyNrOfMandComponents.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyNrOfMandComponents.OpActyNtwkElement  -- association [0..1]
LEFT OUTER JOIN I_SFIAssldDgtlMockUpInstce AS _SFIAssldDgtlMockUpInstce ON ShopFloorItem = _SFIAssldDgtlMockUpInstce.AssemblyShopFloorItem  -- association [0..*]
LEFT OUTER JOIN I_OpActyChgAlertAssgmt AS _OpActyChgAlertAssgmt ON OperationActivity = _OpActyChgAlertAssgmt.OperationActivity AND OperationActyVersionCounter = _OpActyChgAlertAssgmt.OperationActyVersionCounter  -- association [0..1]
LEFT OUTER JOIN C_OperationActyPRTAssignment AS _OperationActyPRTAssignment ON OpActyNtwkInstance = _OperationActyPRTAssignment.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActyPRTAssignment.OpActyNtwkElement AND OrderInternalID = _OperationActyPRTAssignment.OrderInternalID  -- association [0..*]
LEFT OUTER JOIN C_SFIOpActyPRTAssignment AS _SFIOpActyPRTAssignment ON OpActyNtwkInstance = _SFIOpActyPRTAssignment.OpActyNtwkInstance AND OpActyNtwkElement = _SFIOpActyPRTAssignment.OpActyNtwkElement AND ShopFloorItem = _SFIOpActyPRTAssignment.ShopFloorItem  -- association [0..*]
LEFT OUTER JOIN I_MfgBuyOffCycleAggrg AS _MfgBuyOffCycleAggrg ON OpActyNtwkInstance = _MfgBuyOffCycleAggrg.OpActyNtwkInstance AND OpActyNtwkElement = _MfgBuyOffCycleAggrg.OpActyNtwkElement AND ShopFloorItem = _MfgBuyOffCycleAggrg.ShopFloorItem  -- association [0..1]
LEFT OUTER JOIN C_MfgQualifnOpActyAssgmt AS _MfgQualifnOpActyAssgmt ON OpActyNtwkInstance = _MfgQualifnOpActyAssgmt.OpActyNtwkInstance AND OpActyNtwkElement = _MfgQualifnOpActyAssgmt.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_MfgWorkInstructionVersionTP AS _MfgWorkInstructionVersionTP ON WorkInstruction = _MfgWorkInstructionVersionTP.MfgWorkInstruction AND WorkInstructionVersionCounter = _MfgWorkInstructionVersionTP.MfgWorkInstructionVersCounter  -- association [0..1]
LEFT OUTER JOIN C_MfgWorkInstructionVersion AS _MfgWorkInstructionVersion ON WorkInstruction = _MfgWorkInstructionVersion.WorkInstruction AND WorkInstructionVersionCounter = _MfgWorkInstructionVersion.WorkInstructionVersionCounter  -- association [0..*]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Material = _Equipment.Material AND SerialNumber = _Equipment.SerialNumber  -- association [0..1]
LEFT OUTER JOIN I_ProdMfgInfoCamera AS _ProdMfgInfoCamera ON ShopFloorItemAtOpActy.OpActyNtwkElementElement = _ProdMfgInfoCamera.OperationActivity AND ShopFloorItemAtOpActy.OpActyNtwkElementElmntVersCntr = _ProdMfgInfoCamera.OperationActyVersionCounter  -- association [0..*]
LEFT OUTER JOIN I_UnitizedMaterial AS _UnitizedMaterial ON Material = _UnitizedMaterial.Material  -- association [0..1]
LEFT OUTER JOIN C_MfgOrdVariantConfiguration AS _MfgOrdVariantConfiguration ON ManufacturingOrder = _MfgOrdVariantConfiguration.ManufacturingOrder  -- association [0..1]
;