I_InspectionLotFilter

DDL: I_INSPECTIONLOTFILTER SQL: IINSPLOTFIL Type: view COMPOSITE
137 Fields 3 Data Sources

Inspection Lot Filter

I_InspectionLotFilter is a Composite CDS View that provides data about "Inspection Lot Filter" in SAP S/4HANA. It reads from 3 data sources (I_InspectionLotWithStatus, I_InspectionLotAggregate, I_InspectionLotValueHelp) and exposes 137 fields with key fields InspectionLot, InspectionOperation, InspectionCharacteristic.

Data Sources (3)

SourceAliasJoin Type
I_InspectionLotWithStatus _InspectionLotWithStatus left_outer
I_InspectionLotAggregate _insplotaggrgt left_outer
I_InspectionLotValueHelp I_InspectionLotValueHelp from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IINSPLOTFIL view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Inspection Lot Filter view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (137)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot _insplots InspectionLot Inspection Lot
KEY InspectionOperation _insplots InspectionOperation
KEY InspectionCharacteristic _insplots InspectionCharacteristic
Material _insplots Material Vehicle Model
Batch _insplots Batch Lot No.
Plant _insplots Plant Valuation Area
InspectionLotOrigin _insplots InspectionLotOrigin
ManufacturingOrder _insplots ManufacturingOrder Order
InspectionLotText _insplots InspectionLotText
InspectionLotType _insplots InspectionLotType Inspection Type
InspectionLotQuantity _insplots InspectionLotQuantity
InspLotCreatedOnLocalDate
MaterialName _insplots MaterialName Material Description
InspectionLotHasUsageDecision _insplots InspectionLotHasUsageDecision
InspLotNmbrOpenLongTermCharc _insplots InspLotNmbrOpenLongTermCharc
InspectionLotObjectText _insplots InspectionLotObjectText
GoodsReceiptIsMovedToBlkdStock _insplots GoodsReceiptIsMovedToBlkdStock
InspectionLotHasQuantity _insplots InspectionLotHasQuantity
InspectionLotHasPartialLots _insplots InspectionLotHasPartialLots
InspLotIsDocumentationRequired _insplots InspLotIsDocumentationRequired
InspectionLotApproval _insplots InspectionLotApproval
InspLotDigitalSgntrInUsgeDcsn _insplots InspLotDigitalSgntrInUsgeDcsn
InspectionLotIsSkipped _insplots InspectionLotIsSkipped
InspectionLotIsFullInspection _insplots InspectionLotIsFullInspection
InspLotCreatedOnLocalTime
InspectionLotCreatedBy _insplots InspectionLotCreatedBy
InspectionLotCreatedOn
InspectionLotCreatedOnTime
InspectionLotChangedBy _insplots InspectionLotChangedBy
InspectionLotChangeDate
InspectionLotChangeTime
InspectionLotStartDate
InspectionLotStartTime
InspectionLotEndDate
InspectionLotEndTime
BillOfOperationsType _insplots BillOfOperationsType Task List Type
BillOfOperationsGroup _insplots BillOfOperationsGroup Group
BillOfOperationsUsage _insplots BillOfOperationsUsage
BillOfOperationsVariant _insplots BillOfOperationsVariant Group Counter
SmplDrawingProcedure _insplots SmplDrawingProcedure
SmplDrwgProcedIsConfRequired _insplots SmplDrwgProcedIsConfRequired
InspLotSelectionValidFromDate
ProductionVersion _insplots ProductionVersion Version ID
Customer _insplots Customer Sold-to Party
Supplier _insplots Supplier Supplier
Manufacturer _insplots Manufacturer Manufacturer
ManufacturerPartNmbr _insplots ManufacturerPartNmbr Mfr Part Number
MaterialRevisionLevel _insplots MaterialRevisionLevel Revision Level
MaterialIsBatchManaged _insplots MaterialIsBatchManaged
BatchStorageLocation _insplots BatchStorageLocation
MaterialCompIsSpecialStock _insplots MaterialCompIsSpecialStock
PurchasingOrganization _insplots PurchasingOrganization Purchasing Organization
PurchasingDocument _insplots PurchasingDocument Purchasing Document
AccountingDocumentType _insplots AccountingDocumentType Journal Entry Type
MaterialDocumentYear _insplots MaterialDocumentYear Material Document Year
MaterialDocument _insplots MaterialDocument Material Doc.
MatlDocLatestPostgDate
GoodsMovementType _insplots GoodsMovementType Movement Type
InspectionLotPlant _insplots InspectionLotPlant
InspectionLotStorageLocation _insplots InspectionLotStorageLocation
Warehouse _insplots Warehouse Warehouse No.
StorageType _insplots StorageType Storage Type
StorageBin _insplots StorageBin Storage Bin
SalesOrder _insplots SalesOrder SD Document
DeliveryDocument _insplots DeliveryDocument Outbound Delivery
DeliveryCategory _insplots InspectionDeliveryCategory
Route _insplots Route Vehicle route
BillToPartyCountry _insplots BillToPartyCountry Dst.CtryRg.Ord.
SoldToParty _insplots SoldToParty Sold-to Party
SalesOrganization _insplots SalesOrganization Sales Organization
MaterialByCustomer _insplots MaterialByCustomer Customer Mat.
InspLotNmbrAddlRecordedCharc _insplots InspLotNmbrAddlRecordedCharc
InspLotNmbrOpenShortTermCharc _insplots InspLotNmbrOpenShortTermCharc
InspectionDynamicStage _insplots InspectionDynamicStage
InspectionSeverity _insplots InspectionSeverity
QualityCostCollector _insplots QualityCostCollector
CostCenter _insplots CostCenter Cost Center
SalesOrdStockWBSElement _insplots SalesOrdStockWBSElement
ProfitCenter _insplots ProfitCenter Profit Center
BusinessArea _insplots BusinessArea Business Area
GLAccount _insplots GLAccount General Ledger
ControllingArea _insplots ControllingArea Controlling Area
CompanyCode _insplots CompanyCode Receiver Company Code
SerialNumberProfile _insplots SerialNumberProfile SerialNoProfile
NumberOfSerialNumbers _insplots NumberOfSerialNumbers No.serial no.
InspLotIsSerialNmbrPossible _insplots InspLotIsSerialNmbrPossible
BatchBySupplier _insplots BatchBySupplier Supplier Batch
InspLotIsAutomUsgeDcsnPossible _insplots InspLotIsAutomUsgeDcsnPossible
InspLotHasConfignSpecification _insplots InspLotHasConfignSpecification
InspLotIsTaskListRequired _insplots InspLotIsTaskListRequired
InspLotHasManualSampleSize _insplots InspLotHasManualSampleSize
InspLotHasMaterialSpec _insplots InspLotHasMaterialSpec
InspLotDigitalSgntrResultsRecg _insplots InspLotDigitalSgntrResultsRecg
InspLotIsBatchRequired _insplots InspLotIsBatchRequired
InspLotIsStockPostingCompleted _insplots InspLotIsStockPostingCompleted
IsBusinessPurposeCompleted _insplots IsBusinessPurposeCompleted Purpose Completed
MatlQualityAuthorizationGroup _insplots MatlQualityAuthorizationGroup QM Matl Auth.
InspectionOperationPlant _insplots InspectionOperationPlant
OperationControlProfile _insplots OperationControlProfile Control Key
OperationText _insplots OperationText Description
WorkCenter _insplots WorkCenter Work Center
OperationConfirmation _insplots OperationConfirmation
InspectionSubSystem _insplots InspectionSubSystem
InspectionSpecification _insplots InspectionSpecification Master IC
InspectionSpecificationText _insplots InspectionSpecificationText
InspectorQualification _insplots InspectorQualification
InspSpecInformationField1 _insplots InspSpecInformationField1
InspSpecInformationField2 _insplots InspSpecInformationField2
InspSpecInformationField3 _insplots InspSpecInformationField3
InspSpecImportanceCode _insplots InspSpecImportanceCode
InspectionMethod _insplots InspectionMethod Insp. Method
InspectionMethodPlant _insplots InspectionMethodPlant
InspectionSpecificationPlant _insplots InspectionSpecificationPlant
InspectionCharacteristicStatus _insplots InspectionCharacteristicStatus
InspectionSubsetSortKey _insplots InspectionSubsetSortKey
Equipment _insplots Equipment Equipment check
FunctionalLocation _insplots FunctionalLocation Object ID
InspSubsetUsageDcsnValuation _insplots InspSubsetUsageDcsnValuation
InspectionSubsetLongCharKey _insplots InspectionSubsetLongCharKey
InspectionSubsetShortCharKey _insplots InspectionSubsetShortCharKey
InspSubsetLongNumericKey _insplots InspSubsetLongNumericKey
InspSubsetShortNumericKey _insplots InspSubsetShortNumericKey
InspectionSubsetDate
InspectionSubsetTime
MaterialSample _insplots MaterialSample
InspSubsetUsageDcsnCodeGroup _insplots InspSubsetUsageDcsnCodeGroup
InspSubsetUsageDcsnCode _insplots InspSubsetUsageDcsnCode
MaterialSampleType _insplots MaterialSampleType
MaterialSampleCategory _insplots MaterialSampleCategory
StorageLocation _insplots StorageLocation StorageLocation
MaterialSampleStorageLocation _insplots MaterialSampleStorageLocation
MaterialSampleChangedOn
MaterialSampleDrawingLocation _insplots MaterialSampleDrawingLocation
MatlSmplDrawingLocDescription _insplots MatlSmplDrawingLocDescription
MaterialSampleDrawingOnDate
MaterialSampleDrawingOnTime
MaterialSampleResponsibleName _insplots MaterialSampleResponsibleName

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_InspectionLotFilter.
-- 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: IINSPLOTFIL

CREATE VIEW I_InspectionLotFilter AS
SELECT
  _insplots.InspectionLot AS InspectionLot,
  _insplots.InspectionOperation AS InspectionOperation,
  _insplots.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,
  cast(_insplots.InspLotCreatedOnLocalDate as abap.char( 8 )) AS InspLotCreatedOnLocalDate,
  _insplots.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.InspectionDeliveryCategory AS DeliveryCategory,
  _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.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _insplots.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _insplots.InspectionOperationPlant AS InspectionOperationPlant,
  _insplots.OperationControlProfile AS OperationControlProfile,
  _insplots.OperationText AS OperationText,
  _insplots.WorkCenter AS WorkCenter,
  _insplots.OperationConfirmation AS OperationConfirmation,
  _insplots.InspectionSubSystem AS InspectionSubSystem,
  _insplots.InspectionSpecification AS InspectionSpecification,
  _insplots.InspectionSpecificationText AS InspectionSpecificationText,
  _insplots.InspectorQualification AS InspectorQualification,
  _insplots.InspSpecInformationField1 AS InspSpecInformationField1,
  _insplots.InspSpecInformationField2 AS InspSpecInformationField2,
  _insplots.InspSpecInformationField3 AS InspSpecInformationField3,
  _insplots.InspSpecImportanceCode AS InspSpecImportanceCode,
  _insplots.InspectionMethod AS InspectionMethod,
  _insplots.InspectionMethodPlant AS InspectionMethodPlant,
  _insplots.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  _insplots.InspectionCharacteristicStatus AS InspectionCharacteristicStatus,
  _insplots.InspectionSubsetSortKey AS InspectionSubsetSortKey,
  _insplots.Equipment AS Equipment,
  _insplots.FunctionalLocation AS FunctionalLocation,
  _insplots.InspSubsetUsageDcsnValuation AS InspSubsetUsageDcsnValuation,
  _insplots.InspectionSubsetLongCharKey AS InspectionSubsetLongCharKey,
  _insplots.InspectionSubsetShortCharKey AS InspectionSubsetShortCharKey,
  _insplots.InspSubsetLongNumericKey AS InspSubsetLongNumericKey,
  _insplots.InspSubsetShortNumericKey AS InspSubsetShortNumericKey,
  cast(_insplots.InspectionSubsetDate as abap.char( 8 )) AS InspectionSubsetDate,
  cast(_insplots.InspectionSubsetTime as abap.char( 6 )) AS InspectionSubsetTime,
  _insplots.MaterialSample AS MaterialSample,
  _insplots.InspSubsetUsageDcsnCodeGroup AS InspSubsetUsageDcsnCodeGroup,
  _insplots.InspSubsetUsageDcsnCode AS InspSubsetUsageDcsnCode,
  _insplots.MaterialSampleType AS MaterialSampleType,
  _insplots.MaterialSampleCategory AS MaterialSampleCategory,
  _insplots.StorageLocation AS StorageLocation,
  _insplots.MaterialSampleStorageLocation AS MaterialSampleStorageLocation,
  cast(_insplots.MaterialSampleChangedOn as abap.char( 8 )) AS MaterialSampleChangedOn,
  _insplots.MaterialSampleDrawingLocation AS MaterialSampleDrawingLocation,
  _insplots.MatlSmplDrawingLocDescription AS MatlSmplDrawingLocDescription,
  cast(_insplots.MaterialSampleDrawingOnDate as abap.char( 8 )) AS MaterialSampleDrawingOnDate,
  cast(_insplots.MaterialSampleDrawingOnTime as abap.char( 6 )) AS MaterialSampleDrawingOnTime,
  _insplots.MaterialSampleResponsibleName AS MaterialSampleResponsibleName
FROM I_InspectionLotValueHelp
LEFT OUTER JOIN I_InspectionLotAggregate AS _insplotaggrgt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspectionLotWithStatus AS _InspectionLotWithStatus ON /* join condition not captured in parsed metadata */
;

Learn More