I_InspectionLot

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_InspectionLot.
-- 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: IINSPECTIONLOT

CREATE VIEW I_InspectionLot AS
SELECT
  qals.prueflos AS InspectionLot,
  qals.matnr AS Material,
  qals.charg AS Batch,
  qals.werk AS Plant,
  cast( qals.herkunft as vdm_qherk preserving type ) AS InspectionLotOrigin,
  qals.aufpl AS OrderInternalBillOfOperations,
  cast( qals.aufnr as vdm_qm_fertaufnr preserving type ) AS ManufacturingOrder,
  cast( qals.ktextlos as vdm_qplos_text preserving type ) AS InspectionLotText,
  qals.art AS InspectionLotType,
  cast( qals.losmenge as vdm_qlosmenge preserving type ) AS InspectionLotQuantity,
  cast( qals.lmengeist as vdm_qlmengeist preserving type ) AS InspectionLotActualQuantity,
  cast( qals.lmengesch as vdm_qlmengesch preserving type ) AS InspectionLotDefectiveQuantity,
  qals.mengeneinh AS InspectionLotQuantityUnit,
  qals.enstehdat AS InspLotCreatedOnLocalDate,
  qals.slwbez AS InspSubsetFieldCombination,
  cast( qals.offen_lzmk as vdm_qoffelzmk preserving type ) AS InspLotNmbrOpenLongTermCharc,
  qals.objnr AS StatusObject,
  qals.obtyp AS StatusObjectCategory,
  qals.ktextmat AS InspectionLotObjectText,
  qals.ls_equnr AS Equipment,
  qals.ls_tplnr AS FunctionalLocation,
  qals.stsma AS StatusProfile,
  cast( qals.qmatauth as vdm_qmatauth preserving type ) AS MatlQualityAuthorizationGroup,
  cast( qals.insmk as vdm_qvinsmk preserving type ) AS InspectionLotHasQuantity,
  qals.stat01 AS InspLotIsCreatedAutomatically,
  qals.stat02 AS InspectionLotHasPartialLots,
  qals.stat06 AS InspectionLotHasAppraisalCosts,
  qals.stat07 AS InspLotHasSubsets,
  cast( qals.stat08 as vdm_qauto_ve preserving type ) AS InspLotIsAutomUsgeDcsnPossible,
  qals.stat09 AS PurchasingDocumentCategory,
  qals.stat10 AS InspLotHasConfignSpecification,
  qals.stat11 AS GoodsReceiptIsMovedToBlkdStock,
  qals.stat18 AS InspLotSummaryControl,
  cast( qals.stat19 as vdm_qstat19 preserving type ) AS InspLotIsDocumentationRequired,
  cast( qals.stat20 as vdm_qstat20 preserving type ) AS InspLotIsTaskListRequired,
  qals.stat21 AS InspLotHasManualSampleSize,
  cast( qals.stat22 as vdm_qspezueber preserving type ) AS InspLotHasMaterialSpec,
  cast( qals.stat23 as vdm_qkzgenlos preserving type ) AS InspectionLotApproval,
  qals.stat24 AS InspLotDigitalSgntrResultsRecg,
  cast( qals.stat25 as vdm_qdgtlsgntrusgedcsn preserving type ) AS InspLotDigitalSgntrInUsgeDcsn,
  qals.stat26 AS InspLotIsBatchRequired,
  qals.stat32 AS InspLotUsageInStabilityStudy,
  qals.stat33 AS InspLotHasMultipleSpec,
  cast( qals.stat34 as vdm_qstat34 preserving type ) AS InspLotIsStockPostingCompleted,
  cast( qals.stat35 as vdm_qstat35 preserving type ) AS InspectionLotHasUsageDecision,
  qals.anzsn AS NumberOfSerialNumbers,
  qals.ein AS InspLotIsSerialNmbrPossible,
  cast( qals.kzskiplot as vdm_qkzskiplot preserving type ) AS InspectionLotIsSkipped,
  qals.hpz AS InspectionLotIsFullInspection,
  cast( qals.dynhead as vdm_qdynhead preserving type ) AS InspectionLotDynamicLevel,
  qals.stprver AS SamplingProcedure,
  cast( qals.entstezeit as vdm_qentstzeit preserving type ) AS InspLotCreatedOnLocalTime,
  qals.ersteller AS InspectionLotCreatedBy,
  qals.ersteldat AS InspectionLotCreatedOn,
  cast( qals.erstelzeit as vdm_qerstezeit preserving type ) AS InspectionLotCreatedOnTime,
  qals.aenderer AS InspectionLotChangedBy,
  qals.aenderdat AS InspectionLotChangeDate,
  cast( qals.aenderzeit as vdm_qaendezeit preserving type ) AS InspectionLotChangeTime,
  case qals.changeddatetime when 0 then cast( '19000101010101' as tzntstmps ) else qals.changeddatetime end as ChangedDateTime AS changeddatetimeendasChangedDateTime,
  qals.pastrterm AS InspectionLotStartDate,
  cast( qals.pastrzeit as vdm_qstartzeit preserving type ) AS InspectionLotStartTime,
  qals.paendterm AS InspectionLotEndDate,
  cast( qals.paendzeit as vdm_qendezeit preserving type ) AS InspectionLotEndTime,
  cast( qals.plnty as vdm_plnty preserving type ) AS BillOfOperationsType,
  cast( qals.plnnr as vdm_plnnr preserving type ) AS BillOfOperationsGroup,
  cast( qals.pplverw as vdm_pln_verwe preserving type ) AS BillOfOperationsUsage,
  cast( qals.plnal as vdm_plnal preserving type ) AS BillOfOperationsVariant,
  qals.zaehl AS BillOfOperationsChangeStateID,
  cast( qals.stat13 as vdm_qppkttyp preserving type ) AS InspectionSubsetType,
  cast( qals.prbnaverf as vdm_qprziehver preserving type ) AS SmplDrawingProcedure,
  qals.prbnavv AS SmplDrawingProcedureVersion,
  cast( qals.stat12 as vdm_qkzquit preserving type ) AS SmplDrwgProcedIsConfRequired,
  qals.selmatnr AS InspLotSelectionMaterial,
  qals.selrevlv AS InspLotSelMatlRevisionLvl,
  qals.selwerk AS InspLotSelectionPlant,
  qals.sellifnr AS InspLotSelectionSupplier,
  qals.selherst AS InspLotSelectionManufacturer,
  qals.selkunnr AS InspLotSelectionCustomer,
  qals.selpplverw AS InspLotSelBillOfOperationsUsge,
  qals.gueltigab AS InspLotSelectionValidFromDate,
  qals.verid AS ProductionVersion,
  cast( qals.sa_aufnr as vdm_sa_aufnr preserving type ) AS SalesOperationsPlanningOrder,
  qals.cvp_xblck AS IsBusinessPurposeCompleted,
  cast( qals.kunnr as vdm_qkunwe preserving type ) AS Customer,
  qals.lifnr AS Supplier,
  qals.lichn AS BatchBySupplier,
  qals.hersteller AS Manufacturer,
  cast( qals.ematnr as vdm_ematn preserving type ) AS ManufacturerPartNmbr,
  qals.revlv AS MaterialRevisionLevel,
  cast( qals.xchpf as vdm_xchpf preserving type ) AS MaterialIsBatchManaged,
  cast( qals.lagortchrg as vdm_qlgortchar preserving type ) AS BatchStorageLocation,
  qals.sobkz AS MaterialCompIsSpecialStock,
  cast( qals.ekorg as ekorg_ll preserving type ) AS PurchasingOrganization,
  cast( qals.ebeln as fis_ebeln preserving type ) AS PurchasingDocument,
  cast( qals.ebelp as vdm_ebelp preserving type ) AS PurchasingDocumentItem,
  qals.etenr AS ScheduleLine,
  cast( qals.blart as vdm_blart preserving type ) AS AccountingDocumentType,
  cast( qals.mjahr as vdm_mjahr preserving type ) AS MaterialDocumentYear,
  qals.mblnr AS MaterialDocument,
  cast( qals.zeile as vdm_mblpo preserving type ) AS MaterialDocumentItem,
  qals.budat AS MatlDocLatestPostgDate,
  qals.bwart AS GoodsMovementType,
  cast( qals.werkvorg as vdm_qwerkvorg preserving type ) AS InspectionLotPlant,
  cast( qals.lagortvorg as vdm_qlgortvorg preserving type ) AS InspectionLotStorageLocation,
  qals.lgnum AS Warehouse,
  qals.lgtyp AS StorageType,
  qals.lgpla AS StorageBin,
  qals.ls_kdauf AS SalesOrder,
  cast( qals.ls_kdpos as vdm_kdpos preserving type ) AS SalesOrderItem,
  cast( qals.ls_vbeln as vdm_deliverydocument preserving type ) AS DeliveryDocument,
  cast( qals.ls_posnr as vdm_posnr_vl preserving type ) AS DeliveryDocumentItem,
  qals.ls_abrvw AS DeliveryCategory,
  qals.ls_abrvw AS InspectionDeliveryCategory,
  qals.ls_route AS Route,
  qals.ls_lland AS BillToPartyCountry,
  cast( qals.ls_kunag as vdm_kunag preserving type ) AS SoldToParty,
  qals.ls_vkorg AS SalesOrganization,
  qals.ls_kdmat AS MaterialByCustomer,
  qals.sprache AS Language,
  qals.zusmkzaehl AS InspLotNmbrAddlRecordedCharc,
  qals.offennlzmk AS InspLotNmbrOpenShortTermCharc,
  qals.anzgeb AS InspectionLotContainer,
  qals.gebeh AS InspectionLotContainerUnit,
  qals.gesstichpr AS InspectionLotSampleQuantity,
  cast( qals.einhprobe as vdm_qprobemgeh preserving type ) AS InspectionLotSampleUnit,
  cast( qals.dynregel as vdm_qdynregel preserving type ) AS InspLotDynamicRule,
  qals.stat44 AS InspLotDynamicTrggrPoint,
  qals.prstufe AS InspectionDynamicStage,
  qals.prschaerfe AS InspectionSeverity,
  cast( qals.lmenge01 as vdm_qlmenge01f preserving type ) AS InspLotQtyToFree,
  cast( qals.lmenge02 as vdm_qlmenge02f preserving type ) AS InspLotQtyToScrap,
  qals.lmenge03 AS InspLotQtyToSample,
  cast( qals.lmenge04 as vdm_qlmenge04f preserving type ) AS InspLotQtyToBlocked,
  qals.lmenge05 AS InspLotQtyToReserves,
  cast( qals.lmenge06 as vdm_qlmenge06f preserving type ) AS InspLotQtyToAnotherMaterial,
  cast( qals.matnrneu as vdm_qmatnrneu preserving type ) AS InspLotMaterialPostedTo,
  cast( qals.chargneu as vdm_qchargneu preserving type ) AS InspLotBatchTransferredTo,
  cast( qals.lmenge07 as vdm_qlmenge07f preserving type ) AS InspLotQtyReturnedToSupplier,
  cast( qals.lmenge08 as vdm_qlmenge08f preserving type ) AS InspLotQtyToSpecialStock,
  cast( qals.lmenge09 as vdm_qlmenge09f preserving type ) AS InspLotQtyToOtherStock,
  cast( qals.lmengezub as vdm_qlmengezub preserving type ) AS InspLotQtyToBePosted,
  cast( qals.lmengelz as vdm_qlmengelz preserving type ) AS InspLotSmplQtyForLongTermChar,
  cast( qals.lmengepr as vdm_qlmengepr preserving type ) AS InspLotQtyInspected,
  cast( qals.lmengezer as vdm_qlmengezer preserving type ) AS InspLotQtyDestroyed,
  qals.anteil AS InspectionLotScrapRatio,
  qals.stat03 AS InspLotUsageDecisionTool,
  qals.qpmatlos AS InspectionLotAllowedScrapRatio,
  qals.aufnr_co AS QualityCostCollector,
  qals.kzvbr AS ConsumptionPosting,
  qals.knttp AS AccountAssignmentCategory,
  qals.pstyp AS PurchasingDocumentItemCategory,
  qals.stat05 AS InspLotAcctAssgmtKey,
  qals.kostl AS CostCenter,
  qals.aufps AS ReservationItem,
  qals.anln1 AS MasterFixedAsset,
  qals.anln2 AS FixedAsset,
  qals.ps_psp_pnr AS SalesOrdStockWBSElement,
  qals.nplnr AS ProjectNetwork,
  qals.aplzl AS NetworkActivityInternalID,
  cast( qals.kdauf as vdm_mat_kdauf preserving type ) AS InventorySpclStkSalesDocument,
  qals.kdpos AS InventorySpclStkSalesDocItm,
  cast( qals.paobjnr as rkeobjnr_char ) AS ProfitabilitySegment_2,
  qals.prctr AS ProfitCenter,
  qals.gsber AS BusinessArea,
  qals.konto AS GLAccount,
  qals.kokrs AS ControllingArea,
  qals.bukrs AS CompanyCode,
  qals.sernp AS SerialNumberProfile,
  qals.kont_kdauf AS InspLotCostCollectorSalesOrder,
  qals.kont_kdpos AS InspLotCostCollectorSlsOrdItem,
  qals.kont_pspnr AS InspLotCostCollectorWBSElement,
  cast( qals.insp_doc_number as vdm_qinsp_doc_number preserving type ) AS InspLotExternalNumber,
  qals.prio_punkte AS InspectionLotPriorityPoints,
  qals.warpl AS MaintenancePlan,
  qals.wapos AS MaintenancePlanItemIntID,
  qals.strat AS MaintenanceStrategy,
  qals.stat43 AS InspLotForFirstArticleInsp,
  lot_guid AS InspectionLotUUID,
  cast( qals.sign_type_ud as vdm_qsign_type_ud preserving type ) AS InspUsgeDcsnDgtlSgntrType,
  cast( qals.signstrat_ud as vdm_qsignstrat_ud preserving type ) AS InspUsgeDcsnDgtlSgntrStrgy
FROM qals
LEFT OUTER JOIN I_InspectionLotType AS _InspectionLotType ON InspectionLotType = _InspectionLotType.InspectionLotType  -- association [1..1]
LEFT OUTER JOIN I_InspectionLotOrigin AS _InspectionLotOrigin ON InspectionLotOrigin = _InspectionLotOrigin.InspectionLotOrigin  -- association [1..1]
LEFT OUTER JOIN I_InspSubsetFieldCombination AS _InspSubsetFieldCombination ON InspSubsetFieldCombination = _InspSubsetFieldCombination.InspSubsetFieldCombination  -- association [0..1]
LEFT OUTER JOIN I_QltyMgmtPlantLvlConfign AS _QltyMgmtPlantLvlConfign ON Plant = _QltyMgmtPlantLvlConfign.Plant  -- association [0..1]
LEFT OUTER JOIN I_InspLotSummaryControl AS _InspLotSummaryControl ON InspLotSummaryControl = _InspLotSummaryControl.InspLotSummaryControl AND InspectionLotOrigin = _InspLotSummaryControl.InspectionLotOrigin  -- association [0..1]
LEFT OUTER JOIN I_InspectionOperation AS _InspectionOperation ON InspectionLot = _InspectionOperation.InspectionLot  -- association [0..*]
LEFT OUTER JOIN I_InspLotUsageDecision AS _InspLotUsageDecision ON InspectionLot = _InspLotUsageDecision.InspectionLot  -- association [0..1]
LEFT OUTER JOIN I_MaterialSampleDrawing AS _MaterialSampleDrawing ON InspectionLot = _MaterialSampleDrawing.InspectionLot  -- association [0..*]
LEFT OUTER JOIN I_InspLotMatlDocItem AS _InspLotMatlDocItem ON InspectionLot = _InspLotMatlDocItem.InspectionLot  -- association [0..*]
LEFT OUTER JOIN I_MatlQualityAuthGroup AS _MatlQualityAuthGroup ON MatlQualityAuthorizationGroup = _MatlQualityAuthGroup.MatlQualityAuthorizationGroup  -- association [0..1]
LEFT OUTER JOIN I_InspectionSubsetType AS _InspectionSubsetType ON InspectionSubsetType = _InspectionSubsetType.InspectionSubsetType  -- association [0..1]
LEFT OUTER JOIN I_InspectionSubsetTypeText AS _InspectionSubsetTypeText ON InspectionSubsetType = _InspectionSubsetTypeText.InspectionSubsetType  -- association [0..*]
LEFT OUTER JOIN I_InspectionLotApproval AS _InspectionLotApproval ON InspectionLotApproval = _InspectionLotApproval.InspectionLotApproval  -- association [0..1]
LEFT OUTER JOIN I_InspectionLotApprovalText AS _InspectionLotApprovalText ON InspectionLotApproval = _InspectionLotApprovalText.InspectionLotApproval  -- association [0..*]
LEFT OUTER JOIN I_InspLotSgntrInUsgeDcsn AS _InspLotSgntrInUsgeDcsn ON InspLotDigitalSgntrInUsgeDcsn = _InspLotSgntrInUsgeDcsn.InspLotDigitalSgntrInUsgeDcsn  -- association [0..1]
LEFT OUTER JOIN I_InspLotSgntrInUsgeDcsnText AS _InspLotSgntrInUsgeDcsnText ON InspLotDigitalSgntrInUsgeDcsn = _InspLotSgntrInUsgeDcsnText.InspLotDigitalSgntrInUsgeDcsn  -- association [0..*]
LEFT OUTER JOIN I_InspectionLotLongText AS _InspectionLotLongText ON InspectionLot = _InspectionLotLongText.InspectionLot  -- association [0..*]
LEFT OUTER JOIN I_InspectionLotAllLongText AS _InspectionLotAllLongText ON InspectionLot = _InspectionLotAllLongText.InspectionLot  -- association [0..*]
LEFT OUTER JOIN I_Indicator AS _InspectionLotHasQuantity ON InspectionLotHasQuantity = _InspectionLotHasQuantity.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_Indicatortext AS _InspectionLotHasQuantityT ON InspectionLotHasQuantity = _InspectionLotHasQuantityT.IndicatorValue  -- association [0..*]
LEFT OUTER JOIN I_Indicator AS _IsStockPostgCmpltd ON InspLotIsStockPostingCompleted = _IsStockPostgCmpltd.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_Indicatortext AS _IsStockPostgCmpltdTxt ON InspLotIsStockPostingCompleted = _IsStockPostgCmpltdTxt.IndicatorValue  -- association [0..*]
LEFT OUTER JOIN I_Indicator AS _SmplDrwgProcedIsConfRqd ON SmplDrwgProcedIsConfRequired = _SmplDrwgProcedIsConfRqd.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_Indicatortext AS _SmplDrwgProcedIsConfRqdTxt ON SmplDrwgProcedIsConfRequired = _SmplDrwgProcedIsConfRqdTxt.IndicatorValue  -- association [0..*]
LEFT OUTER JOIN I_Indicator AS _IsAutomUsgeDcsnPossible ON InspLotIsAutomUsgeDcsnPossible = _IsAutomUsgeDcsnPossible.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_Indicatortext AS _IsAutomUsgeDcsnPossibleTxt ON InspLotIsAutomUsgeDcsnPossible = _IsAutomUsgeDcsnPossibleTxt.IndicatorValue  -- association [0..*]
LEFT OUTER JOIN I_Indicator AS _IsDocumentationRqd ON InspLotIsDocumentationRequired = _IsDocumentationRqd.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_Indicatortext AS _IsDocumentationRqdTxt ON InspLotIsDocumentationRequired = _IsDocumentationRqdTxt.IndicatorValue  -- association [0..*]
LEFT OUTER JOIN I_Indicator AS _InspLotIsBatchRequired ON InspLotIsBatchRequired = _InspLotIsBatchRequired.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_Indicatortext AS _InspLotIsBatchRequiredTxt ON InspLotIsBatchRequired = _InspLotIsBatchRequiredTxt.IndicatorValue  -- association [0..*]
LEFT OUTER JOIN I_Indicator AS _InspectionLotHasUsgeDcsn ON InspectionLotHasUsageDecision = _InspectionLotHasUsgeDcsn.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_Indicatortext AS _InspectionLotHasUsgeDcsnTxt ON InspectionLotHasUsageDecision = _InspectionLotHasUsgeDcsnTxt.IndicatorValue  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Material AS _InspLotSelectionMaterial ON InspLotSelectionMaterial = _InspLotSelectionMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsChangeState AS _BillOfOperationsChangeState ON BillOfOperationsType = _BillOfOperationsChangeState.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsChangeState.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsChangeState.BillOfOperationsVariant AND BillOfOperationsChangeStateID = _BillOfOperationsChangeState.BOOInternalVersionCounter  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlan AS _MaintenancePlan ON MaintenancePlan = _MaintenancePlan.MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Manufacturer ON Manufacturer = _Manufacturer.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InspLotSelectionSupplier ON InspLotSelectionSupplier = _InspLotSelectionSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InspLotSelManufacturer ON InspLotSelectionManufacturer = _InspLotSelManufacturer.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _InspLotSelectionCustomer ON InspLotSelectionCustomer = _InspLotSelectionCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _SalesOrdStockWBSElement ON SalesOrdStockWBSElement = _SalesOrdStockWBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_User AS _InspectionLotCreatedBy ON InspectionLotCreatedBy = _InspectionLotCreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _InspectionLotChangedBy ON InspectionLotChangedBy = _InspectionLotChangedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _InspectionLotQuantityUnit ON InspectionLotQuantityUnit = _InspectionLotQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _InspectionLotSampleUnit ON InspectionLotSampleUnit = _InspectionLotSampleUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _InspectionLotContainerUnit ON InspectionLotContainerUnit = _InspectionLotContainerUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_Material AS _ManufacturerPartNmbr ON ManufacturerPartNmbr = _ManufacturerPartNmbr.Material  -- association [0..1]
LEFT OUTER JOIN E_InspectionLot AS _Extension ON InspectionLot = _Extension.InspectionLot  -- association [1..1]
;