I_InspectionLotValueHelp

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 I_InspectionLotValueHelp.
-- 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: IINSPLOTVALHLP

CREATE VIEW I_InspectionLotValueHelp AS
SELECT
  _insplots.InspectionLot AS InspectionLot,
  I_InspectionOperation.InspectionOperation AS InspectionOperation,
  I_InspectionCharacteristic.InspectionCharacteristic AS InspectionCharacteristic,
  _insplots.Material AS Material,
  _insplots.Batch AS Batch,
  _insplots.Plant AS Plant,
  _insplots.InspectionLotOrigin AS InspectionLotOrigin,
  _insplots.ManufacturingOrder AS ManufacturingOrder,
  _insplots.InspectionLotText AS InspectionLotText,
  _insplots.InspectionLotType AS InspectionLotType,
  _insplots.InspectionLotQuantity AS InspectionLotQuantity,
  _insplots.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  cast(_insplots.InspLotCreatedOnLocalDate as abap.char( 8 )) AS InspLotCreatedOnLocalDate,
  _insplots._Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  _insplots.InspectionLotHasUsageDecision AS InspectionLotHasUsageDecision,
  _insplots.InspLotNmbrOpenLongTermCharc AS InspLotNmbrOpenLongTermCharc,
  _insplots.InspectionLotObjectText AS InspectionLotObjectText,
  _insplots.GoodsReceiptIsMovedToBlkdStock AS GoodsReceiptIsMovedToBlkdStock,
  _insplots.InspectionLotHasQuantity AS InspectionLotHasQuantity,
  _insplots.InspectionLotHasPartialLots AS InspectionLotHasPartialLots,
  _insplots.InspLotIsDocumentationRequired AS InspLotIsDocumentationRequired,
  _insplots.InspectionLotApproval AS InspectionLotApproval,
  _insplots.InspLotDigitalSgntrInUsgeDcsn AS InspLotDigitalSgntrInUsgeDcsn,
  _insplots.InspectionLotIsSkipped AS InspectionLotIsSkipped,
  _insplots.InspectionLotIsFullInspection AS InspectionLotIsFullInspection,
  cast(_insplots.InspLotCreatedOnLocalTime as abap.char( 6 )) AS InspLotCreatedOnLocalTime,
  _insplots.InspectionLotCreatedBy AS InspectionLotCreatedBy,
  cast(_insplots.InspectionLotCreatedOn as abap.char( 8 )) AS InspectionLotCreatedOn,
  cast(_insplots.InspectionLotCreatedOnTime as abap.char( 6 )) AS InspectionLotCreatedOnTime,
  _insplots.InspectionLotChangedBy AS InspectionLotChangedBy,
  cast(_insplots.InspectionLotChangeDate as abap.char( 8 )) AS InspectionLotChangeDate,
  cast(_insplots.InspectionLotChangeTime as abap.char( 6 )) AS InspectionLotChangeTime,
  cast(_insplots.InspectionLotStartDate as abap.char( 8 )) AS InspectionLotStartDate,
  cast(_insplots.InspectionLotStartTime as abap.char( 6 )) AS InspectionLotStartTime,
  cast(_insplots.InspectionLotEndDate as abap.char( 8 )) AS InspectionLotEndDate,
  cast(_insplots.InspectionLotEndTime as abap.char( 6 )) AS InspectionLotEndTime,
  _insplots.BillOfOperationsType AS BillOfOperationsType,
  _insplots.BillOfOperationsGroup AS BillOfOperationsGroup,
  _insplots.BillOfOperationsUsage AS BillOfOperationsUsage,
  _insplots.BillOfOperationsVariant AS BillOfOperationsVariant,
  _insplots.SmplDrawingProcedure AS SmplDrawingProcedure,
  _insplots.SmplDrwgProcedIsConfRequired AS SmplDrwgProcedIsConfRequired,
  cast(_insplots.InspLotSelectionValidFromDate as abap.char( 8 )) AS InspLotSelectionValidFromDate,
  _insplots.ProductionVersion AS ProductionVersion,
  _insplots.Customer AS Customer,
  _insplots.Supplier AS Supplier,
  _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.AccountingDocumentType AS AccountingDocumentType,
  _insplots.MaterialDocumentYear AS MaterialDocumentYear,
  _insplots.MaterialDocument AS MaterialDocument,
  cast(_insplots.MatlDocLatestPostgDate as abap.char( 8 )) AS MatlDocLatestPostgDate,
  _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.SalesOrder AS SalesOrder,
  _insplots.DeliveryDocument AS DeliveryDocument,
  _insplots.DeliveryCategory AS DeliveryCategory,
  _insplots.InspectionDeliveryCategory AS InspectionDeliveryCategory,
  _insplots.Route AS Route,
  _insplots.BillToPartyCountry AS BillToPartyCountry,
  _insplots.SoldToParty AS SoldToParty,
  _insplots.SalesOrganization AS SalesOrganization,
  _insplots.MaterialByCustomer AS MaterialByCustomer,
  _insplots.InspLotNmbrAddlRecordedCharc AS InspLotNmbrAddlRecordedCharc,
  _insplots.InspLotNmbrOpenShortTermCharc AS InspLotNmbrOpenShortTermCharc,
  _insplots.InspectionDynamicStage AS InspectionDynamicStage,
  _insplots.InspectionSeverity AS InspectionSeverity,
  _insplots.QualityCostCollector AS QualityCostCollector,
  _insplots.CostCenter AS CostCenter,
  _insplots.SalesOrdStockWBSElement 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.NumberOfSerialNumbers AS NumberOfSerialNumbers,
  _insplots.InspLotIsSerialNmbrPossible AS InspLotIsSerialNmbrPossible,
  _insplots.BatchBySupplier AS BatchBySupplier,
  _insplots.InspLotIsAutomUsgeDcsnPossible AS InspLotIsAutomUsgeDcsnPossible,
  _insplots.InspLotHasConfignSpecification AS InspLotHasConfignSpecification,
  _insplots.InspLotIsTaskListRequired AS InspLotIsTaskListRequired,
  _insplots.InspLotHasManualSampleSize AS InspLotHasManualSampleSize,
  _insplots.InspLotHasMaterialSpec AS InspLotHasMaterialSpec,
  _insplots.InspLotDigitalSgntrResultsRecg AS InspLotDigitalSgntrResultsRecg,
  _insplots.InspLotIsBatchRequired AS InspLotIsBatchRequired,
  _insplots.InspLotIsStockPostingCompleted AS InspLotIsStockPostingCompleted,
  _insplots.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _insplots.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_InspectionOperation.InspectionOperationPlant AS InspectionOperationPlant,
  I_InspectionOperation.OperationControlProfile AS OperationControlProfile,
  I_InspectionOperation.OperationText AS OperationText,
  I_InspectionOperation._WorkCenter.WorkCenter AS WorkCenter,
  I_InspectionOperation.OperationConfirmation AS OperationConfirmation,
  I_InspectionOperation.InspectionSubSystem AS InspectionSubSystem,
  I_InspectionCharacteristic.InspectionSpecification AS InspectionSpecification,
  I_InspectionCharacteristic.InspectionSpecificationText AS InspectionSpecificationText,
  I_InspectionCharacteristic.InspectorQualification AS InspectorQualification,
  I_InspectionCharacteristic.InspSpecInformationField1 AS InspSpecInformationField1,
  I_InspectionCharacteristic.InspSpecInformationField2 AS InspSpecInformationField2,
  I_InspectionCharacteristic.InspSpecInformationField3 AS InspSpecInformationField3,
  I_InspectionCharacteristic.InspSpecImportanceCode AS InspSpecImportanceCode,
  I_InspectionCharacteristic.InspectionMethod AS InspectionMethod,
  I_InspectionCharacteristic.InspectionMethodPlant AS InspectionMethodPlant,
  I_InspectionCharacteristic.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  I_InspectionCharacteristic.InspectionCharacteristicStatus AS InspectionCharacteristicStatus,
  I_InspectionSubset.InspectionSubsetSortKey AS InspectionSubsetSortKey,
  I_InspectionSubset.Equipment AS Equipment,
  I_InspectionSubset.FunctionalLocation AS FunctionalLocation,
  I_InspectionSubset.InspSubsetUsageDcsnValuation AS InspSubsetUsageDcsnValuation,
  I_InspectionSubset.InspectionSubsetLongCharKey AS InspectionSubsetLongCharKey,
  I_InspectionSubset.InspectionSubsetShortCharKey AS InspectionSubsetShortCharKey,
  I_InspectionSubset.InspSubsetLongNumericKey AS InspSubsetLongNumericKey,
  I_InspectionSubset.InspSubsetShortNumericKey AS InspSubsetShortNumericKey,
  cast(I_InspectionSubset.InspectionSubsetDate as abap.char( 8 )) AS InspectionSubsetDate,
  cast(I_InspectionSubset.InspectionSubsetTime as abap.char( 6 )) AS InspectionSubsetTime,
  I_InspectionSubset.MaterialSample AS MaterialSample,
  I_InspectionSubset.InspSubsetUsageDcsnCodeGroup AS InspSubsetUsageDcsnCodeGroup,
  I_InspectionSubset.InspSubsetUsageDcsnCode AS InspSubsetUsageDcsnCode,
  I_MaterialSample.MaterialSampleType AS MaterialSampleType,
  I_MaterialSample.MaterialSampleCategory AS MaterialSampleCategory,
  I_MaterialSample.StorageLocation AS StorageLocation,
  I_MaterialSample.MaterialSampleStorageLocation AS MaterialSampleStorageLocation,
  cast(I_MaterialSample.MaterialSampleChangedOn as abap.char( 8 )) AS MaterialSampleChangedOn,
  I_MaterialSample.MaterialSampleDrawingLocation AS MaterialSampleDrawingLocation,
  I_MaterialSample.MatlSmplDrawingLocDescription AS MatlSmplDrawingLocDescription,
  cast(I_MaterialSample.MaterialSampleDrawingOnDate as abap.char( 8 )) AS MaterialSampleDrawingOnDate,
  cast(I_MaterialSample.MaterialSampleDrawingOnTime as abap.char( 6 )) AS MaterialSampleDrawingOnTime,
  I_MaterialSample.MaterialSampleResponsibleName AS MaterialSampleResponsibleName
FROM I_InspectionLot
INNER JOIN I_InspectionOperation ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspectionCharacteristic ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaterialSample ON /* join condition not captured in parsed metadata */
;