C_Insplotmng

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_Insplotmng.
-- 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: CINSPLOTMNG

CREATE VIEW C_Insplotmng AS
SELECT
  _InspLot.InspectionLot AS InspectionLot,
  _InspLot.StatusProfile AS StatusProfile,
  _InspLotApprovalStatus.StatusShortName AS StatusShortName,
  _InspLotApprovalStatus.StatusCode AS StatusCode,
  _InspLot.InspectionLotOrigin AS InspectionLotOrigin,
  _InspLot._InspectionLotOrigin._Text[1:Language=$session.system_language].InspectionLotOriginText AS InspectionLotOriginText,
  _InspLot.Plant AS Plant,
  _InspLot.Material AS Material,
  _InspectionLotApproval._Text[1:Language=$session.system_language].InspectionLotApprovalText AS InspectionLotApprovalText,
  _InspLot.InspectionLotApproval AS InspectionLotApproval,
  _InspLot.InspectionLotEndDate AS InspectionLotEndDate,
  _InspLot.InspectionLotText AS InspectionLotText,
  _InspLot.InspectionLotType AS InspectionLotType,
  _InspLot.Batch AS Batch,
  cast( concat_with_space (concat (cast (_InspLotAgg.InspCharRejectedCount as abap.char( 20 )),' / '), cast (_InspLotAgg.InspCharacteristicCount as abap.char( 20 )), 1) as vdm_inspcharcount) AS InspCharCount,
  cast (_InspLotAgg.InspCharacteristicCount as vdm_inspcharacteristiccount) AS InspCharacteristicCount,
  cast (_InspLotDefectCount.NumberOfDefects as vdm_numberofdefects preserving type ) AS NumberOfDefects,
  _InspLot.InspectionLotStartDate AS InspectionLotStartDate,
  _InspLot.SalesOrdStockWBSElement AS SalesOrdStockWBSElement,
  _InspLot._SalesOrdStockWBSElement.WBSDescription AS WBSDescription,
  cast ( _InspLot.InventorySpclStkSalesDocument as vdm_mat_kdauf preserving type ) AS InventorySpclStkSalesDocument,
  _InspLot.QualityCostCollector AS QualityCostCollector,
  _InspLot.CostCenter AS CostCenter,
  _InspLot.ProfitCenter AS ProfitCenter,
  cast( _InspLot.InspLotIsAutomUsgeDcsnPossible as vdm_qauto_ve preserving type ) AS InspLotIsAutomUsgeDcsnPossible,
  cast( _InspLot.InspLotIsDocumentationRequired as vdm_qstat19 preserving type ) AS InspLotIsDocumentationRequired,
  _InspLot._InspLotSgntrInUsgeDcsn._InspLotSgntrInUsgeDcsnText[1:Language=$session.system_language].InspLotDgtlSgntrInUsgeDcsnTxt AS InspLotDgtlSgntrInUsgeDcsnTxt,
  _InspLot.InspLotDigitalSgntrInUsgeDcsn AS InspLotDigitalSgntrInUsgeDcsn,
  cast( _InspLot.MaterialIsBatchManaged as vdm_xchpf preserving type ) AS InspLotIsBatchRequired,
  cast( _InspLot.InspectionLotHasUsageDecision as vdm_qstat35 preserving type ) AS InspectionLotHasUsageDecision,
  cast( _InspLot.InspectionLotHasQuantity as vdm_qvinsmk preserving type ) AS InspectionLotHasQuantity,
  cast( _InspLot.InspLotIsStockPostingCompleted as vdm_qstat34 preserving type ) AS InspLotIsStockPostingCompleted,
  _InspLot.MaterialDocumentYear AS MaterialDocumentYear,
  _InspLot.MaterialDocument AS MaterialDocument,
  _InspLot.BatchStorageLocation AS BatchStorageLocation,
  _InspLot.InspectionLotStorageLocation AS InspectionLotStorageLocation,
  _InspLot.InspLotCreatedOnLocalDate AS InspLotCreatedOnLocalDate,
  _InspLot.InspectionLotCreatedBy AS InspectionLotCreatedBy,
  _InspLot.InspectionLotCreatedOn AS InspectionLotCreatedOn,
  _InspLot.InspectionLotChangedBy AS InspectionLotChangedBy,
  _InspLot.InspectionLotChangeDate AS InspectionLotChangeDate,
  _Batch.BatchBySupplier AS BatchBySupplier,
  _InspLot.InspectionLotObjectText AS InspectionLotObjectText,
  _InspLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _InspLot.Supplier AS Supplier,
  _InspLot._Supplier.SupplierName AS SupplierName,
  _InspLot.Manufacturer AS Manufacturer,
  _InspLot._Manufacturer.SupplierName AS ManufacturerName,
  _InspLot.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  _InspLot._ManufacturerPartNmbr._Text[1:Language=$session.system_language].MaterialName AS ManufacturerPartNmbrText,
  _InspLot.PurchasingOrganization AS PurchasingOrganization,
  _InspLot._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _InspLot.PurchasingDocument AS PurchasingDocument,
  _InspLot.AccountingDocumentType AS AccountingDocumentType,
  _InspLot.SalesOperationsPlanningOrder AS SalesOperationsPlanningOrder,
  _InspLot.ProductionVersion AS ProductionVersion,
  _InspLot.ManufacturingOrder AS ManufacturingOrder,
  _InspLot.Customer AS Customer,
  _InspLot._Customer.CustomerName AS CustomerName,
  _InspLot.SalesOrder AS SalesOrder,
  _InspLot.DeliveryDocument AS DeliveryDocument,
  _InspLot.SoldToParty AS SoldToParty,
  _InspLot._SoldToParty.CustomerName AS SoldToPartyName,
  _InspLot.SalesOrganization AS SalesOrganization,
  _InspLot._SalesOrganization._Text[1:Language=$session.system_language].SalesOrganizationName AS SalesOrganizationName,
  _InspLot.MaterialByCustomer AS MaterialByCustomer,
  cast( _InspLot.SmplDrwgProcedIsConfRequired as vdm_qkzquit preserving type ) AS SmplDrwgProcedIsConfRequired,
  _InspLot._InspLotUsageDecision._UsageDecisionValuation._Text[1:Language=$session.system_language].InspLotUsgeDcsnValuationText AS InspLotUsgeDcsnValuationText,
  _InspUsageDec.InspectionLotQualityScore AS InspectionLotQualityScore,
  cast (_InspUsageDec.InspLotUsageDecisionCodeGroup as vdm_qvgruppe preserving type ) AS InspLotUsageDecisionCodeGroup,
  _InspUsageDec._UsageDecisionCodeGroup._Text[1:Language=$session.system_language].UsageDecisionCodeGroupText AS UsageDecisionCodeGroupText,
  _InspUsageDec.InspectionLotUsageDecisionCode AS InspectionLotUsageDecisionCode,
  _InspUsageDec._UsageDecisionCode._Text[1:Language=$session.system_language].UsageDecisionCodeText AS UsageDecisionCodeText,
  _InspUsageDec.InspLotUsgeDcsnFollowUpAction AS InspLotUsgeDcsnFollowUpAction,
  _InspUsageDec.InspectionLotUsageDecidedBy AS InspectionLotUsageDecidedBy,
  cast (_InspUsageDec.InspectionLotUsageDecidedOn as vdm_qvedatum) AS InspectionLotUsageDecidedOn,
  _InspUsageDec.InspLotUsageDecisionChangedBy AS InspLotUsageDecisionChangedBy,
  _InspUsageDec.InspLotUsageDecisionChangedOn AS InspLotUsageDecisionChangedOn,
  _InspLot._Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  _InspLot._InspectionLotType._Text[1:Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  _InspLot._Plant.PlantName AS PlantName,
  cast( _InspLot.InspectionLotIsSkipped as vdm_qkzskiplot preserving type ) AS InspectionLotIsSkipped,
  cast( _InspLot.InspLotIsTaskListRequired as vdm_qstat20 preserving type ) AS InspLotIsTaskListRequired,
  _InspLot.Equipment AS Equipment,
  _InspLot.FunctionalLocation AS FunctionalLocation,
  _InspLot.InspLotCreatedOnLocalTime AS InspLotCreatedOnLocalTime,
  _InspLot.InspectionLotCreatedOnTime AS InspectionLotCreatedOnTime,
  _InspLot.InspectionLotChangeTime AS InspectionLotChangeTime,
  _InspLot.InspectionLotStartTime AS InspectionLotStartTime,
  _InspLot.InspectionLotEndTime AS InspectionLotEndTime,
  cast( _InspLot.InspLotSelectionMaterial as vdm_selmatnr preserving type ) AS InspLotSelectionMaterial,
  _InspLot.MaterialRevisionLevel AS MaterialRevisionLevel,
  _InspLot.MaterialCompIsSpecialStock AS MaterialCompIsSpecialStock,
  _InspLot.PurchasingDocumentItem AS PurchasingDocumentItem,
  _InspLot.ScheduleLine AS ScheduleLine,
  _InspLot.MaterialDocumentItem AS MaterialDocumentItem,
  _InspLot.MatlDocLatestPostgDate AS MatlDocLatestPostgDate,
  _InspLot.InspectionLotPlant AS InspectionLotPlant,
  _InspLot.SalesOrderItem AS SalesOrderItem,
  _InspLot.DeliveryDocumentItem AS DeliveryDocumentItem,
  _InspLot.BillToPartyCountry AS BillToPartyCountry,
  _InspLot.InspLotNmbrOpenLongTermCharc AS InspLotNmbrOpenLongTermCharc,
  _InspLot.InspectionLotQuantity AS InspectionLotQuantity,
  _InspLot.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  _InspLot.InspectionLotContainer AS InspectionLotContainer,
  _InspLot.InspectionLotContainerUnit AS InspectionLotContainerUnit,
  _InspLot.InspectionLotSampleQuantity AS InspectionLotSampleQuantity,
  _InspLot.InspectionLotSampleUnit AS InspectionLotSampleUnit,
  _InspLot.InspLotQtyToFree AS InspLotQtyToFree,
  _InspLot.InspLotQtyToScrap AS InspLotQtyToScrap,
  _InspLot.InspLotQtyToSample AS InspLotQtyToSample,
  _InspLot.InspLotQtyToBlocked AS InspLotQtyToBlocked,
  _InspLot.InspLotQtyToReserves AS InspLotQtyToReserves,
  _InspLot.InspLotQtyToAnotherMaterial AS InspLotQtyToAnotherMaterial,
  _InspLot.InspLotMaterialPostedTo AS InspLotMaterialPostedTo,
  _InspLot.InspLotBatchTransferredTo AS InspLotBatchTransferredTo,
  _InspLot.InspLotQtyReturnedToSupplier AS InspLotQtyReturnedToSupplier,
  _InspLot.InspLotQtyToSpecialStock AS InspLotQtyToSpecialStock,
  _InspLot.InspLotQtyToOtherStock AS InspLotQtyToOtherStock,
  _InspLot.InspLotQtyToBePosted AS InspLotQtyToBePosted,
  _InspLot.InspLotSmplQtyForLongTermChar AS InspLotSmplQtyForLongTermChar,
  _InspLot.InspLotQtyInspected AS InspLotQtyInspected,
  _InspLot.InspLotQtyDestroyed AS InspLotQtyDestroyed,
  _InspLot.InspectionLotActualQuantity AS InspectionLotActualQuantity,
  _InspLot.InspectionLotDefectiveQuantity AS InspectionLotDefectiveQuantity,
  _InspLot.InspectionLotScrapRatio AS InspectionLotScrapRatio,
  _InspLot.InspLotExternalNumber AS InspLotExternalNumber,
  _InspUsageDec.InspLotUsgeDcsnChangedTime AS InspLotUsgeDcsnChangedTime,
  _InspUsageDec.InspLotUsgeDcsnSelectedSet AS InspLotUsgeDcsnSelectedSet,
  _InspUsageDec.InspLotUsageDecisionTime AS InspLotUsageDecisionTime,
  _InspLot.InspLotNmbrOpenShortTermCharc AS InspLotNmbrOpenShortTermCharc,
  _InspLot.InspLotHasSubsets AS InspLotHasSubsets,
  _InspLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  SerialNumberProfile,
  InspLotIsSerialNmbrPossible,
  cast('' as gernr) AS SerialNumber,
  _InspLot.InspLotForFirstArticleInsp AS InspLotForFirstArticleInsp,
  _InspLotForFirstArticleInspVH.InspLotForFirstArticleInspText AS InspLotForFirstArticleInspText
FROM I_InspectionLot AS _InspLot
LEFT OUTER JOIN I_InspectionLotType AS _InspectionLotType ON InspectionLotType = _InspectionLotType.InspectionLotType  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Batch = _Batch.Batch AND Material = _Batch.Material AND Plant = _Batch.Plant  -- association [0..1]
LEFT OUTER JOIN I_InspectionLotAggregate AS _InspLotAgg ON InspectionLot = _InspLotAgg.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspLotUsageDecision AS _InspUsageDec ON InspectionLot = _InspUsageDec.InspectionLot  -- association [1..1]
LEFT OUTER JOIN C_InspectionLotApprFltT AS _InspectionLotApprFltT ON InspectionLotApproval = _InspectionLotApprFltT.InspectionLotApproval  -- association [0..1]
LEFT OUTER JOIN I_InspectionLotWithStatus AS _InspectionLotWithStatus ON InspectionLot = _InspectionLotWithStatus.InspectionLot  -- association [1..1]
LEFT OUTER JOIN C_InspLotDigiSgntrInUsgeDcsnT AS _InspLotDigiSgntrInUsgeDcsnT ON InspLotDigitalSgntrInUsgeDcsn = _InspLotDigiSgntrInUsgeDcsnT.InspLotDigitalSgntrInUsgeDcsn  -- association [0..1]
LEFT OUTER JOIN C_InspLotRsltRecgStatusT AS _InspLotRsltRecgStatusT ON InspLotRsltRecgStatus = _InspLotRsltRecgStatusT.InspLotRsltRecgStatus  -- association [0..1]
LEFT OUTER JOIN C_InspLotCompltnStatusT AS _InspLotCompltnStatusT ON InspLotCompltnStatus = _InspLotCompltnStatusT.InspLotCompltnStatus  -- association [0..1]
LEFT OUTER JOIN C_InspLotDefectCount AS _InspLotDefectCount ON InspectionLot = _InspLotDefectCount.InspectionLot  -- association [0..1]
LEFT OUTER JOIN E_InspectionLot AS _Extension ON InspectionLot = _Extension.InspectionLot  -- association [1..1]
LEFT OUTER JOIN C_InspLotMngSerialNumber AS _InspLotSerialNumber ON InspectionLot = _InspLotSerialNumber.InspectionLot  -- association [0..*]
LEFT OUTER JOIN I_InspectionLotApprovalStatus AS _InspLotApprovalStatus ON InspectionLot = _InspLotApprovalStatus.InspectionLot  -- association [0..1]
LEFT OUTER JOIN I_StatusCodeText AS _InspLotApprovalStatusT ON StatusProfile = _InspLotApprovalStatusT.StatusProfile AND statuscode = _InspLotApprovalStatusT.StatusCode AND _InspLotApprovalStatusT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_InspLotForFirstArticleInspVH AS _InspLotForFirstArticleInspVH ON InspLotForFirstArticleInsp = _InspLotForFirstArticleInspVH.InspLotForFirstArticleInsp  -- association [0..1]
;