C_QM_InspectionLots

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_InspectionLots.
-- 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: CQMINSPLOTS

CREATE VIEW C_QM_InspectionLots AS
SELECT
  _insplots.InspectionLot AS InspectionLot,
  cast(_insplotaggrgt.MaterialSampleCount as abap.int4 ) AS MaterialSampleCount,
  _insplots.ManufacturingOrder AS ManufacturingOrder,
  _insplots.Plant AS Plant,
  _insplots.Material AS Material,
  _InspLotUsageDecision.InspLotUsageDecisionValuation AS InspLotUsageDecisionValuation,
  _insplots.InspectionLotOrigin AS InspectionLotOrigin,
  _insplots._InspectionLotOrigin._Text[1:Language=$session.system_language].InspectionLotOriginText AS InspectionLotOriginText,
  _insplots.InspectionLotType AS InspectionLotType,
  _insplots._InspectionLotType._Text[1:Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  _insplots._Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  _insplots.Batch AS Batch,
  cast(0 as abap.int4) AS InspCharCount,
  _insplots.InspectionLotText AS InspectionLotText,
  _insplots.InspectionLotQuantity AS InspectionLotQuantity,
  _insplots.InspectionLotObjectText AS InspectionLotObjectText,
  _insplots.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _matlQualityAuthGroup._Text[1:Language=$session.system_language].MatlQltyAuthorizationGrpText AS MatlQltyAuthorizationGrpText,
  _insplots.GoodsReceiptIsMovedToBlkdStock AS GoodsReceiptIsMovedToBlkdStock,
  _insplots.InspectionLotHasQuantity AS InspectionLotHasQuantity,
  _insplots.InspectionLotApproval AS InspectionLotApproval,
  _insplots.InspLotDigitalSgntrResultsRecg AS InspLotDigitalSgntrResultsRecg,
  _insplots.InspLotDigitalSgntrInUsgeDcsn AS InspLotDigitalSgntrInUsgeDcsn,
  _insplots.InspectionLotCreatedBy AS InspectionLotCreatedBy,
  _insplots.InspectionLotChangedBy AS InspectionLotChangedBy,
  _insplots.InspectionLotChangeDate AS InspectionLotChangeDate,
  _insplots.InspectionLotChangeTime AS InspectionLotChangeTime,
  _insplots.InspectionLotStartDate AS InspectionLotStartDate,
  _insplots.InspectionLotEndDate AS InspectionLotEndDate,
  _insplots.BillOfOperationsType AS BillOfOperationsType,
  _billOfOperationsType._Text[1:Language=$session.system_language].BillOfOperationsTypeName AS BillOfOperationsTypeName,
  _insplots.BillOfOperationsGroup AS BillOfOperationsGroup,
  _insplots.BillOfOperationsUsage AS BillOfOperationsUsage,
  _billOfOperationsUsage._Text[1:Language=$session.system_language].BillOfOperationsUsageDesc AS BillOfOperationsUsageDesc,
  _insplots.BillOfOperationsVariant AS BillOfOperationsVariant,
  _insplots.InspLotSelectionValidFromDate AS InspLotSelectionValidFromDate,
  _insplots.ProductionVersion AS ProductionVersion,
  _insplots.Manufacturer AS Manufacturer,
  _insplots.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  _insplots.MaterialRevisionLevel AS MaterialRevisionLevel,
  _insplots.MaterialIsBatchManaged AS MaterialIsBatchManaged,
  _insplots.BatchStorageLocation AS BatchStorageLocation,
  _insplots.MaterialCompIsSpecialStock AS MaterialCompIsSpecialStock,
  _insplots.PurchasingOrganization AS PurchasingOrganization,
  _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.MatlDocLatestPostgDate AS MatlDocLatestPostgDate,
  _insplots.GoodsMovementType AS GoodsMovementType,
  _insplots.InspectionLotPlant AS InspectionLotPlant,
  _insplots.InspectionLotStorageLocation AS InspectionLotStorageLocation,
  _insplots.SalesOrder AS SalesOrder,
  _insplots.SalesOrderItem AS SalesOrderItem,
  _insplots.DeliveryDocument AS DeliveryDocument,
  _insplots.DeliveryDocumentItem AS DeliveryDocumentItem,
  _insplots.InspectionDeliveryCategory AS DeliveryCategory,
  _insplots.Route AS Route,
  _insplots.BillToPartyCountry AS BillToPartyCountry,
  _insplots.SalesOrganization AS SalesOrganization,
  _insplots.MaterialByCustomer AS MaterialByCustomer,
  InspOpAggr.InspCharOpenCount AS InspCharOpenCount,
  InspOpAggr.InspCharAcceptedCount AS InspCharAcceptedCount,
  InspOpAggr.InspCharRejectedCount AS InspCharRejectedCount,
  InspOpAggr.InspOpNmbrOfOpen AS InspOpNmbrOfOpen,
  InspOpAggr.InspOpNmbrOfRjctd AS InspOpNmbrOfRjctd,
  InspOpAggr.InspOpNmbrOfAccepted AS InspOpNmbrOfAccepted,
  InspOpAggr.InspOpNmbrOfAcceptedCmpltd AS InspOpNmbrOfAcceptedCmpltd,
  InspOpAggr.InspOpNmbrOfRjctdCmpltd AS InspOpNmbrOfRjctdCmpltd,
  InspOpAggr.InspOpNmbrOfOpenCmpltd AS InspOpNmbrOfOpenCmpltd,
  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._InspectionLotQuantityUnit._Text[1:Language=$session.system_language].UnitOfMeasure_E AS InspectionLotQuantityUnit,
  _insplots.InspectionLotContainer AS InspectionLotContainer,
  _insplots._InspectionLotContainerUnit._Text[1:Language=$session.system_language].UnitOfMeasure_E AS InspectionLotContainerUnit,
  _insplots.InspectionLotSampleQuantity AS InspectionLotSampleQuantity,
  _insplots._InspectionLotSampleUnit._Text[1:Language=$session.system_language].UnitOfMeasure_E AS InspectionLotSampleUnit,
  _insplots.InspLotQtyToFree AS InspLotQtyToFree,
  _insplots.InspLotQtyToScrap AS InspLotQtyToScrap,
  _insplots.InspLotQtyToSample AS InspLotQtyToSample,
  _insplots.InspLotQtyToBlocked AS InspLotQtyToBlocked,
  _insplots.InspLotQtyToReserves AS InspLotQtyToReserves,
  _insplots.InspLotQtyToAnotherMaterial AS InspLotQtyToAnotherMaterial,
  _insplots.InspLotMaterialPostedTo AS InspLotMaterialPostedTo,
  _insplots.InspLotBatchTransferredTo AS InspLotBatchTransferredTo,
  _insplots.InspLotQtyReturnedToSupplier AS InspLotQtyReturnedToSupplier,
  _insplots.InspLotQtyToSpecialStock AS InspLotQtyToSpecialStock,
  _insplots.InspLotQtyToOtherStock AS InspLotQtyToOtherStock,
  _insplots.InspLotQtyToBePosted AS InspLotQtyToBePosted,
  _insplots.InspLotSmplQtyForLongTermChar AS InspLotSmplQtyForLongTermChar,
  _insplots.InspLotQtyInspected AS InspLotQtyInspected,
  _insplots.InspLotQtyDestroyed AS InspLotQtyDestroyed,
  _insplots.InspectionLotActualQuantity AS InspectionLotActualQuantity,
  _insplots.InspectionLotDefectiveQuantity AS InspectionLotDefectiveQuantity,
  _insplots.InspectionLotScrapRatio AS InspectionLotScrapRatio,
  _insplots.QualityCostCollector AS QualityCostCollector,
  _insplots.AccountAssignmentCategory AS AccountAssignmentCategory,
  _insplots.CostCenter AS CostCenter,
  cast('' as abap.char( 24 ) ) AS SalesOrdStockWBSElement,
  _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.InspLotExternalNumber AS InspLotExternalNumber,
  _insplots.InspLotCreatedOnLocalDate AS InspLotCreatedOnLocalDate,
  _insplots.InspLotCreatedOnLocalTime AS InspLotCreatedOnLocalTime,
  _insplots.InspectionLotCreatedOn AS InspectionLotCreatedOn,
  _insplots.InspectionLotCreatedOnTime AS InspectionLotCreatedOnTime,
  _insplots.SoldToParty AS SoldToParty,
  _insplots.Customer AS Customer,
  _insplots.Supplier AS Supplier,
  _insplots.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _InspLotUsageDecision.InspectionLotQualityScore AS InspectionLotQualityScore,
  _InspLotUsageDecision.InspLotUsageDecisionCatalog AS InspLotUsageDecisionCatalog,
  _InspLotUsageDecision.InspLotUsgeDcsnSelectedSet AS InspLotUsgeDcsnSelectedSet,
  _InspLotUsageDecision.InspLotUsageDecisionCodeGroup AS InspLotUsageDecisionCodeGroup,
  _InspLotUsageDecision.InspectionLotUsageDecisionCode AS InspectionLotUsageDecisionCode,
  _InspLotUsageDecision.InspLotUsgeDcsnDynValuation AS InspLotUsgeDcsnDynValuation,
  _InspLotUsageDecision.InspLotUsgeDcsnFollowUpAction AS InspLotUsgeDcsnFollowUpAction,
  _InspLotUsageDecision.InspectionLotUsageDecidedBy AS InspectionLotUsageDecidedBy,
  _InspLotUsageDecision.InspectionLotUsageDecidedOn AS InspectionLotUsageDecidedOn,
  _InspLotUsageDecision.InspLotUsageDecisionTime AS InspLotUsageDecisionTime,
  _InspLotUsageDecision.InspLotUsageDecisionChangedBy AS InspLotUsageDecisionChangedBy,
  _InspLotUsageDecision.InspLotUsageDecisionChangedOn AS InspLotUsageDecisionChangedOn,
  _InspLotUsageDecision.InspLotUsgeDcsnChangedTime AS InspLotUsgeDcsnChangedTime,
  _insplots.BatchBySupplier AS BatchBySupplier,
  cast('' as abap.char( 24 ) ) AS InspLotCostCollectorWBSElement,
  _stsObjConcatActiveStsILL.ConcatenatedActiveSystStsName AS SystemStatus,
  _stsObjConcatActiveStsILL.ConcatenatedActiveUserStsName AS UserStatus,
  cast('' as abap.char( 1 )) AS InspLotRsltRecgStatus,
  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( 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 InspLotIsBatchRequired,
  cast('' as abap.char( 1 )) AS InspectionLotHasUsageDecision,
  cast('' as abap.char( 1 )) AS InspLotIsDocumentationRequired,
  cast('' as abap.tims) AS InspectionLotStartTime,
  cast('' as abap.tims) AS InspectionLotEndTime,
  _insplots.SmplDrawingProcedure AS SmplDrawingProcedure,
  _insplots.Warehouse AS Warehouse,
  _insplots.StorageType AS StorageType,
  _insplots.StorageBin AS StorageBin,
  cast('' as abap.char( 4 )) AS InspectionOperation,
  cast('' as abap.char( 4 )) AS InspectionOperationPlant,
  cast('' as abap.char( 4 )) AS OperationControlProfile,
  cast('' as abap.char( 40 )) AS OperationText,
  cast('' as abap.char( 6 )) AS InspectionSubSystem,
  cast('' as abap.char( 10 )) AS OperationConfirmation,
  cast('' as abap.char( 8 )) AS WorkCenter,
  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 C_Inspopers_Dstnct AS _inspops_dst ON /* join condition not captured in parsed metadata */
;