C_Qm_InspectionlotsByMtrSmpl

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_InspectionlotsByMtrSmpl.
-- 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: CQMINSPLBMS

CREATE VIEW C_Qm_InspectionlotsByMtrSmpl AS
SELECT
  _insplots.InspectionLot AS InspectionLot,
  _inspmtrsplaggrgt.MaterialSample AS MaterialSample,
  _stsObjConcatActiveStsILL.ConcatenatedActiveSystStsName AS SystemStatus,
  _stsObjConcatActiveStsILL.ConcatenatedActiveUserStsName AS UserStatus,
  cast(_inspmtrsplaggrgt.InspCharAcceptedCount as abap.int4 ) AS InspCharAcceptedCount,
  cast(_inspmtrsplaggrgt.InspCharRejectedCount as abap.int4 ) AS InspCharRejectedCount,
  cast(_inspmtrsplaggrgt.InspCharOpenCount as abap.int4 ) AS InspCharOpenCount,
  cast(_inspmtrsplaggrgt.InspOperationCount as abap.int4 ) AS InspOperationCount,
  _insplots.ManufacturingOrder AS ManufacturingOrder,
  _insplots.Plant AS Plant,
  _insplots.Material AS Material,
  _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.InspectionLotObjectText AS InspectionLotObjectText,
  _insplots.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _insplots.InspLotIsDocumentationRequired AS InspLotIsDocumentationRequired,
  _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.SalesOperationsPlanningOrder AS SalesOperationsPlanningOrder,
  _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.SalesOrder AS SalesOrder,
  _insplots.SalesOrderItem AS SalesOrderItem,
  _insplots.DeliveryDocument AS DeliveryDocument,
  _insplots.DeliveryDocumentItem AS DeliveryDocumentItem,
  _insplots.InspectionLotText AS InspectionLotText,
  _insplots.InspectionLotQuantity AS InspectionLotQuantity,
  _insplots.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  _insplots.SerialNumberProfile AS SerialNumberProfile,
  _insplots.InspLotIsSerialNmbrPossible AS InspLotIsSerialNmbrPossible,
  _insplots.InspSubsetFieldCombination AS InspSubsetFieldCombination,
  _insplots.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  cast( _insplots._InspectionOperation.InspectionOperation as vdm_vornr preserving type ) AS InspectionOperation,
  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,
  cast('' as vdm_xchpf) AS MaterialIsBatchManaged,
  cast('' as abap.char( 4 )) AS PurchasingOrganization,
  cast('' as abap.dats) AS MatlDocLatestPostgDate,
  cast('' as abap.char( 3 )) AS GoodsMovementType,
  cast('' as abap.char( 40 )) AS ManufacturerPartNmbr,
  cast('' as abap.char( 1 )) AS GoodsReceiptIsMovedToBlkdStock,
  cast('' as abap.char( 1 )) AS InspectionLotHasQuantity,
  cast('' as abap.char( 3 )) AS Warehouse,
  cast('' as abap.char( 3 )) AS StorageType,
  cast('' as abap.char( 10 )) AS StorageBin,
  cast('' as abap.char( 1 )) AS MaterialCompIsSpecialStock,
  cast('' as abap.char( 4 )) AS InspectionLotStorageLocation,
  cast('' as abap.char( 10 )) AS SoldToParty,
  cast('' as abap.char( 3 )) AS DeliveryCategory,
  cast('' as abap.char( 6 )) AS Route,
  cast('' as abap.char( 3 )) AS BillToPartyCountry,
  cast('' as abap.char( 4 )) AS SalesOrganization,
  cast('' as abap.char( 35 )) AS MaterialByCustomer,
  cast('' as abap.char( 1 )) AS BillOfOperationsType,
  cast('' as abap.char( 8 )) AS BillOfOperationsGroup,
  cast('' as abap.char( 3 )) AS BillOfOperationsUsage,
  cast('' as abap.char( 20 )) AS BillOfOperationsVariant,
  cast('' as abap.char( 6 )) AS InspLotNmbrAddlRecordedCharc,
  cast('' as abap.char( 6 )) AS InspLotNmbrOpenShortTermCharc,
  cast('' as abap.char( 6 )) AS InspLotNmbrOpenLongTermCharc,
  cast('' as abap.char( 10 )) AS CostCenter,
  cast('' as abap.char( 24 )) AS SalesOrdStockWBSElement,
  cast('' as abap.char( 12 )) AS QualityCostCollector,
  cast('' as abap.char( 10 )) AS ProfitCenter,
  cast('' as abap.char( 4 )) AS BusinessArea,
  cast('' as abap.char( 10 )) AS GLAccount,
  cast('' as abap.char( 4 )) AS ControllingArea,
  cast('' as abap.char( 4 )) AS CompanyCode,
  cast('' as abap.char( 1 )) AS InspLotDigitalSgntrInUsgeDcsn,
  cast('' as abap.char( 8 )) AS WorkCenter,
  cast('' as abap.char( 8 )) AS InspLotUsageDecisionCodeGroup,
  cast('' as abap.char( 4 )) AS InspectionLotUsageDecisionCode,
  cast('' as abap.char( 4 )) AS StorageLocation,
  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( 20 )) AS OperationText,
  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 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( 4 )) AS ProductionPlant,
  cast('' as abap.char( 4 )) AS InspectionLotPlant,
  cast('' as abap.char( 40 )) AS InspectionSpecificationText,
  _mtrSample.MaterialSampleType AS MaterialSampleType,
  _mtrSample.MaterialSampleCategory AS MaterialSampleCategory,
  _mtrSample.MaterialSampleStorageLocation AS MaterialSampleStorageLocation,
  _mtrSample.MaterialSampleChangedOn AS MaterialSampleChangedOn,
  _mtrSample.MaterialSampleDrawingLocation AS MaterialSampleDrawingLocation,
  _mtrSample.MatlSmplDrawingLocDescription AS MatlSmplDrawingLocDescription,
  _mtrSample.MaterialSampleDrawingOnDate AS MaterialSampleDrawingOnDate,
  _mtrSample.MaterialSampleDrawingOnTime AS MaterialSampleDrawingOnTime,
  _mtrSample.MaterialSampleResponsibleName AS MaterialSampleResponsibleName,
  _mtrSample.MaterialSampleDrawing AS MaterialSampleDrawing
FROM I_InspectionLot AS _insplots
INNER JOIN I_InspMaterialSampleAggregate ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaterialSample ON /* join condition not captured in parsed metadata */
;