C_QM_InspectionLotsByOperation

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_QM_InspectionLotsByOperation.
-- 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: CQMINSPLBOP

CREATE VIEW C_QM_InspectionLotsByOperation AS
SELECT
  _insplots.InspectionLot AS InspectionLot,
  _inspops.InspectionOperation AS InspectionOperation,
  cast(_inspoperaggrgt.MaterialSampleCount as abap.int4 ) AS MaterialSampleCount,
  _InspOperationUsageDecision.InspOpUsageDecisionValuation AS InspOpUsageDecisionValuation,
  cast( (case when _insplots._InspSubsetFieldCombination.SamplingProcedureInspSubset = '2' then _inspoperaggrgt.InspSubsetCharcAcceptedCount else _inspoperaggrgt.InspCharAcceptedCount end) as abap.int4 ) as InspCharAcceptedCount AS int4asInspCharAcceptedCount,
  cast( (case when _insplots._InspSubsetFieldCombination.SamplingProcedureInspSubset = '2' then _inspoperaggrgt.InspSubsetCharcRejectedCount else _inspoperaggrgt.InspCharRejectedCount end) as abap.int4 ) as InspCharRejectedCount AS int4asInspCharRejectedCount,
  cast( (case when _insplots._InspSubsetFieldCombination.SamplingProcedureInspSubset = '2' then _inspoperaggrgt.InspSubsetCharcOpenCount else _inspoperaggrgt.InspCharOpenCount end) as abap.int4 ) as InspCharOpenCount AS int4asInspCharOpenCount,
  cast(_inspoperaggrgt.InspCharAcceptedCount + _inspoperaggrgt.InspCharRejectedCount + _inspoperaggrgt.InspCharOpenCount as abap.int4) AS InspCharCount,
  _insplots.ManufacturingOrder AS ManufacturingOrder,
  _insplots.Plant AS Plant,
  _insplots.Material AS Material,
  _inspops._WorkCenter.WorkCenter AS WorkCenter,
  _inspops._WorkCenter.Plant AS MaintenanceWorkCenterPlant,
  _inspops._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterText,
  _InspLotUsageDecision.InspLotUsageDecisionValuation AS InspLotUsageDecisionValuation,
  _insplots.InspectionLotOrigin AS InspectionLotOrigin,
  _insplots._InspectionLotOrigin._Text[1:Language=$session.system_language].InspectionLotOriginText AS InspectionLotOriginText,
  _insplots.InspectionLotType AS InspectionLotType,
  _insplots.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _insplots._InspectionLotType._Text[1:Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  _inspops.OperationText AS OperationText,
  _insplots._Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  _insplots.Batch AS Batch,
  _insplots.InspectionLotObjectText AS InspectionLotObjectText,
  _insplots.InspLotCreatedOnLocalDate AS InspLotCreatedOnLocalDate,
  _insplots.InspLotCreatedOnLocalTime AS InspLotCreatedOnLocalTime,
  _insplots.InspectionLotCreatedBy AS InspectionLotCreatedBy,
  _insplots.InspectionLotCreatedOn AS InspectionLotCreatedOn,
  _insplots.InspectionLotCreatedOnTime AS InspectionLotCreatedOnTime,
  _insplots.InspectionLotChangedBy AS InspectionLotChangedBy,
  _insplots.InspectionLotChangeDate AS InspectionLotChangeDate,
  _insplots.InspectionLotChangeTime AS InspectionLotChangeTime,
  _insplots.InspectionLotStartDate AS InspectionLotStartDate,
  _insplots.InspectionLotEndDate AS InspectionLotEndDate,
  _insplots.ProductionVersion AS ProductionVersion,
  _insplots.Customer AS Customer,
  _insplots.Supplier AS Supplier,
  _insplots.Manufacturer AS Manufacturer,
  _insplots.MaterialRevisionLevel AS MaterialRevisionLevel,
  _insplots.BatchStorageLocation AS BatchStorageLocation,
  _insplots.PurchasingDocument AS PurchasingDocument,
  _insplots.PurchasingDocumentItem AS PurchasingDocumentItem,
  _insplots.ScheduleLine AS ScheduleLine,
  _insplots.AccountingDocumentType AS AccountingDocumentType,
  _insplots.MaterialDocumentYear AS MaterialDocumentYear,
  _insplots.MaterialDocument AS MaterialDocument,
  _insplots.MaterialDocumentItem AS MaterialDocumentItem,
  _insplots.DeliveryDocument AS DeliveryDocument,
  _insplots.DeliveryDocumentItem AS DeliveryDocumentItem,
  _insplots.InspectionLotText AS InspectionLotText,
  _insplots.InspectionLotQuantity AS InspectionLotQuantity,
  _insplots._InspectionLotQuantityUnit._Text[1:Language=$session.system_language].UnitOfMeasure_E AS InspectionLotQuantityUnit,
  _insplots.SalesOrder AS SalesOrder,
  _insplots.SalesOrderItem AS SalesOrderItem,
  _InspOperationUsageDecision.InspectionLotQualityScore AS InspectionLotQualityScore,
  _InspOperationUsageDecision.InspOpUsageDecisionCatalog AS InspOpUsageDecisionCatalog,
  _InspOperationUsageDecision.InspOpUsgeDcsnSelectedSet AS InspOpUsgeDcsnSelectedSet,
  _InspOperationUsageDecision.UsageDecisionCodeGroup AS UsageDecisionCodeGroup,
  _InspOperationUsageDecision.UsageDecisionCode AS UsageDecisionCode,
  _InspOperationUsageDecision.InspOpUsgeDcsnDynValuation AS InspOpUsgeDcsnDynValuation,
  _InspOperationUsageDecision.InspOpUsgeDcsnFollowUpAction AS InspOpUsgeDcsnFollowUpAction,
  _InspOperationUsageDecision.InspectionOpUsageDecidedBy AS InspectionOpUsageDecidedBy,
  _InspOperationUsageDecision.InspOpUsageDecidedOn AS InspOpUsageDecidedOn,
  _InspOperationUsageDecision.InspOpUsageDecisionTime AS InspOpUsageDecisionTime,
  _InspOperationUsageDecision.InspOpUsageDecisionChangedBy AS InspOpUsageDecisionChangedBy,
  _InspOperationUsageDecision.InspOpUsageDecisionChangedOn AS InspOpUsageDecisionChangedOn,
  _InspOperationUsageDecision.InspOpUsgeDcsnChangedTime AS InspOpUsgeDcsnChangedTime,
  _stsObjConcatActiveStsILL.ConcatenatedActiveSystStsName AS SystemStatus,
  _stsObjConcatActiveStsILL.ConcatenatedActiveUserStsName AS UserStatus,
  _insplots.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  cast('' as abap.char( 1 )) AS InspLotRsltRecgStatus,
  cast('' as abap.char( 15 )) AS BatchBySupplier,
  cast('' as abap.char( 1 )) AS InspLotIsStockPostingCompleted,
  cast('' as abap.char( 1 )) AS InspectionLotIsSkipped,
  cast('' as abap.char( 1 )) AS InspectionLotIsFullInspection,
  cast(0 as abap.int4) AS NumberOfSerialNumbers,
  cast('' as abap.char( 8 )) AS SmplDrawingProcedure,
  cast('' as abap.char( 1 )) AS SmplDrwgProcedIsConfRequired,
  cast('' as abap.char( 4 )) AS InspectionDynamicStage,
  cast('' as abap.char( 3 )) AS InspectionSeverity,
  _insplots.InspectionLotHasPartialLots AS InspectionLotHasPartialLots,
  cast('' as abap.char( 1 )) AS InspLotIsAutomUsgeDcsnPossible,
  cast('' as abap.char( 1 )) AS InspLotHasConfignSpecification,
  cast('' as abap.char( 1 )) AS InspLotIsTaskListRequired,
  cast('' as abap.char( 1 )) AS InspLotHasManualSampleSize,
  cast('' as abap.char( 1 )) AS InspLotHasMaterialSpec,
  cast('' as abap.char( 1 )) AS InspLotDigitalSgntrResultsRecg,
  cast('' as abap.char( 1 )) AS InspLotIsBatchRequired,
  cast('' as abap.char( 1 )) AS InspectionLotHasUsageDecision,
  _insplots.GoodsReceiptIsMovedToBlkdStock AS GoodsReceiptIsMovedToBlkdStock,
  _insplots.InspectionLotHasQuantity AS InspectionLotHasQuantity,
  _insplots.InspLotIsDocumentationRequired AS InspLotIsDocumentationRequired,
  _insplots.InspectionLotApproval AS InspectionLotApproval,
  _insplots.InspLotDigitalSgntrInUsgeDcsn AS InspLotDigitalSgntrInUsgeDcsn,
  _insplots.BillOfOperationsType AS BillOfOperationsType,
  _insplots.BillOfOperationsGroup AS BillOfOperationsGroup,
  _insplots.BillOfOperationsUsage AS BillOfOperationsUsage,
  _insplots.BillOfOperationsVariant AS BillOfOperationsVariant,
  _insplots.InspLotSelectionValidFromDate AS InspLotSelectionValidFromDate,
  _insplots.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  _insplots.MaterialIsBatchManaged AS MaterialIsBatchManaged,
  _insplots.MaterialCompIsSpecialStock AS MaterialCompIsSpecialStock,
  _insplots.PurchasingOrganization AS PurchasingOrganization,
  _insplots.GoodsMovementType AS GoodsMovementType,
  _insplots.InspectionLotPlant AS InspectionLotPlant,
  _insplots.InspectionLotStorageLocation AS InspectionLotStorageLocation,
  _insplots.Warehouse AS Warehouse,
  _insplots.StorageType AS StorageType,
  _insplots.StorageBin AS StorageBin,
  _insplots.InspectionDeliveryCategory AS DeliveryCategory,
  _insplots.Route AS Route,
  _insplots.BillToPartyCountry AS BillToPartyCountry,
  _insplots.SoldToParty AS SoldToParty,
  _insplots.SalesOrganization AS SalesOrganization,
  _insplots.MaterialByCustomer AS MaterialByCustomer,
  cast(_insplots.InspLotNmbrAddlRecordedCharc as abap.char( 6 )) AS InspLotNmbrAddlRecordedCharc,
  cast(_insplots.InspLotNmbrOpenShortTermCharc as abap.char( 6 )) AS InspLotNmbrOpenShortTermCharc,
  cast(_insplots.InspLotNmbrOpenLongTermCharc as abap.char( 6 )) AS InspLotNmbrOpenLongTermCharc,
  _insplots.MatlDocLatestPostgDate AS MatlDocLatestPostgDate,
  cast('' as abap.char( 24 ) ) AS SalesOrdStockWBSElement,
  _insplots.QualityCostCollector AS QualityCostCollector,
  _insplots.CostCenter AS CostCenter,
  _insplots.ProfitCenter AS ProfitCenter,
  _insplots.BusinessArea AS BusinessArea,
  _insplots.GLAccount AS GLAccount,
  _insplots.ControllingArea AS ControllingArea,
  _insplots.CompanyCode AS CompanyCode,
  _insplots.SerialNumberProfile AS SerialNumberProfile,
  _insplots.InspLotIsSerialNmbrPossible AS InspLotIsSerialNmbrPossible,
  _insplots.InspSubsetFieldCombination AS InspSubsetFieldCombination,
  cast('' as abap.char( 8 )) AS InspLotUsageDecisionCodeGroup,
  cast('' as abap.char( 4 )) AS InspectionLotUsageDecisionCode,
  cast('' as abap.char( 4 )) AS InspectionOperationPlant,
  cast('' as abap.char( 4 )) AS OperationControlProfile,
  cast('' as abap.char( 6 )) AS InspectionSubSystem,
  cast('' as abap.char( 10 )) AS OperationConfirmation,
  cast('' as abap.char( 4 )) AS InspectionCharacteristic,
  cast('' as abap.char( 1 )) AS InspectionCharacteristicStatus,
  cast('' as abap.char( 4 )) AS InspectionMethodPlant,
  cast('' as abap.char( 8 )) AS InspectionMethod,
  cast('' as abap.char( 4 )) AS InspectionSpecificationPlant,
  cast('' as abap.char( 8 )) AS InspectionSpecification,
  cast('' as abap.char( 2 )) AS InspSpecImportanceCode,
  cast('' as abap.char( 40 )) AS InspectionCharacteristicText,
  cast('' as abap.char( 5 )) AS InspectorQualification,
  cast('' as abap.char( 10 )) AS InspSpecInformationField1,
  cast('' as abap.char( 20 )) AS InspSpecInformationField2,
  cast('' as abap.char( 40 )) AS InspSpecInformationField3,
  cast('' as abap.char( 70 )) AS InspectionSubsetSortKey,
  cast('' as abap.char( 18 )) AS Equipment,
  cast('' as abap.char( 30 )) AS FunctionalLocation,
  cast('' as qphysprnr) AS MaterialSample,
  cast('' as abap.char( 18 )) AS InspectionSubsetLongCharKey,
  cast('' as abap.char( 10 )) AS InspectionSubsetShortCharKey,
  cast('' as abap.char( 10 )) AS InspSubsetLongNumericKey,
  cast('' as abap.char( 3 )) AS InspSubsetShortNumericKey,
  cast('' as abap.dats) AS InspectionSubsetDate,
  cast('' as abap.tims) AS InspectionSubsetTime,
  cast('' as abap.char( 8 )) AS InspSubsetUsageDcsnCodeGroup,
  cast('' as abap.char( 4 )) AS InspSubsetUsageDcsnCode,
  cast('' as abap.char( 1 )) AS InspSubsetUsageDcsnValuation,
  cast('' as abap.char( 2 )) AS MaterialSampleType,
  cast('' as abap.char( 1 )) AS MaterialSampleCategory,
  cast('' as abap.char( 4 )) AS StorageLocation,
  cast('' as abap.char( 12 )) AS MaterialSampleStorageLocation,
  cast('' as abap.char( 8 )) AS MaterialSampleChangedOn,
  cast('' as abap.char( 30 )) AS MaterialSampleDrawingLocation,
  cast('' as abap.char( 60 )) AS MatlSmplDrawingLocDescription,
  cast('' as abap.char( 8 )) AS MaterialSampleDrawingOnDate,
  cast('' as abap.char( 6 )) AS MaterialSampleDrawingOnTime,
  cast('' as abap.char( 20 )) AS MaterialSampleResponsibleName,
  cast('' as abap.char( 4 )) AS ProductionPlant,
  cast('' as abap.char( 40 )) AS InspectionSpecificationText
FROM I_InspectionLot AS _insplots
INNER JOIN I_InspectionOperation AS _inspops ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspOperationAggregate AS _inspoperaggrgt ON /* join condition not captured in parsed metadata */
;