C_InspLotOpRsltRecg

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_InspLotOpRsltRecg.
-- 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.

CREATE VIEW C_InspLotOpRsltRecg AS
SELECT
  _InspectionLot.InspectionLot AS InspectionLot,
  _InspOperation.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  cast(_InspOperation.InspectionOperation as abap.char(4)) AS InspectionOperation,
  _InspectionLot.Material AS Material,
  _InspectionLot.Plant AS Plant,
  _InspectionLot.Batch AS Batch,
  _InspectionLot.InspectionLotOrigin AS InspectionLotOrigin,
  cast(_InspOperationAggregate.MaterialSampleCount as abap.int4 ) AS NumberOfMaterialSamples,
  cast( case when _InspectionLot.InspLotHasSubsets = 'X' then _InspOperationAggregate.InspSubsetCharcAcceptedCount + _InspOperationAggregate.InspSubsetCharcRejectedCount + _InspOperationAggregate.InspSubsetCharcOpenCount + _InspOperationAggregate.NumberOfSkipInspSubsetCharcs else _InspOperationAggregate.InspCharAcceptedCount + _InspOperationAggregate.InspCharRejectedCount + _InspOperationAggregate.InspCharOpenCount + _InspOperationAggregate.NumberOfSkipInspCharcs end as abap.int4) as InspCharacteristicCount AS int4asInspCharacteristicCount,
  case when _InspectionLot.InspLotHasSubsets = 'X' then _InspOperationAggregate.InspSubsetCharcOpenCount else _InspOperationAggregate.InspCharOpenCount end as InspCharOpenCount AS InspCharOpenCountendasInspCharOpenCount,
  dats_days_between(cast($session.system_date as abap.dats), _InspectionLot.InspectionLotEndDate) AS NumberOfDaysLeftForRsltRecg,
  _InspectionLot.InspectionLotEndDate AS InspectionLotEndDate,
  _InspectionLot.AccountingDocumentType AS AccountingDocumentType,
  _InspectionLot.BatchStorageLocation AS BatchStorageLocation,
  _InspectionLot.Customer AS Customer,
  _InspectionLot.DeliveryDocument AS DeliveryDocument,
  _InspectionLot.DeliveryDocumentItem AS DeliveryDocumentItem,
  cast(_InspOperationAggregate.InspCharAcceptedCount + _InspOperationAggregate.InspCharRejectedCount + _InspOperationAggregate.InspCharOpenCount as abap.int4) AS InspCharCount,
  _InspectionLot.InspLotCreatedOnLocalDate AS InspLotCreatedOnLocalDate,
  _InspectionLot.InspLotCreatedOnLocalTime AS InspLotCreatedOnLocalTime,
  _InspectionLot._InspLotUsageDecision.InspLotUsageDecisionValuation AS InspLotUsageDecisionValuation,
  _InspOperationUsageDecision.InspOpUsageDecidedOn AS InspOpUsageDecidedOnDte,
  _InspOperationUsageDecision.InspOpUsageDecisionChangedBy AS InspOpUsageDecisionChangedBy,
  _InspOperationUsageDecision.InspOpUsageDecisionChangedOn AS InspOpUsageDecisionChangedOn,
  _InspOperationUsageDecision.InspOpUsageDecisionTime AS InspOpUsageDecisionTime,
  _InspOperationUsageDecision.InspOpUsageDecisionValuation AS InspOpUsageDecisionValuation,
  _InspOperationUsageDecision.InspOpUsgeDcsnChangedTime AS InspOpUsgeDcsnChangedTime,
  _InspOperationUsageDecision.InspOpUsgeDcsnFollowUpAction AS InspOpUsgeDcsnFollowUpAction,
  _InspOperationUsageDecision.InspOpUsgeDcsnSelectedSet AS InspOpUsgeDcsnSelectedSet,
  _InspectionLot.InspectionLotChangeDate AS InspectionLotChangeDate,
  _InspectionLot.InspectionLotChangeTime AS InspectionLotChangeTime,
  _InspectionLot.InspectionLotChangedBy AS InspectionLotChangedBy,
  _InspectionLot.InspectionLotCreatedBy AS InspectionLotCreatedBy,
  _InspectionLot.InspectionLotCreatedOn AS InspectionLotCreatedOn,
  _InspectionLot.InspectionLotCreatedOnTime AS InspectionLotCreatedOnTime,
  _InspectionLot.InspectionLotHasPartialLots AS InspectionLotHasPartialLots,
  _InspectionLot.InspectionLotObjectText AS InspectionLotObjectText,
  _InspectionLot._InspectionLotOrigin._Text[1:Language=$session.system_language].InspectionLotOriginText AS InspectionLotOriginText,
  _InspOperationUsageDecision.InspectionLotQualityScore AS InspectionLotQualityScore,
  _InspectionLot.InspectionLotQuantity AS InspectionLotQuantity,
  _InspectionLot.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  _InspectionLot.InspectionLotStartDate AS InspectionLotStartDate,
  _InspectionLot.InspectionLotText AS InspectionLotText,
  _InspectionLot.InspectionLotType AS InspectionLotType,
  _InspectionLot._InspectionLotType._Text[1:Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  _InspOperationUsageDecision.InspectionOpUsageDecidedBy AS InspectionOpUsageDecidedBy,
  _InspectionLot.Manufacturer AS Manufacturer,
  _InspectionLot.ManufacturingOrder AS ManufacturingOrder,
  _InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _InspectionLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _InspOperation.OperationText AS OperationText,
  _InspectionLot.ProductionVersion AS ProductionVersion,
  _InspectionLot.PurchasingDocument AS PurchasingDocument,
  _InspectionLot.PurchasingDocumentItem AS PurchasingDocumentItem,
  _InspectionLot.QualityCostCollector AS QualityCostCollector,
  _InspectionLot.SalesOrder AS SalesOrder,
  _InspectionLot.SalesOrderItem AS SalesOrderItem,
  _InspectionLot.ScheduleLine AS ScheduleLine,
  _InspectionLot.Supplier AS Supplier,
  _InspOperationUsageDecision.UsageDecisionCode AS UsageDecisionCode,
  _InspOperationUsageDecision.UsageDecisionCodeGroup AS UsageDecisionCodeGroup,
  _InspOperation._WorkCenter.WorkCenter AS WorkCenter,
  _InspOperation._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterText
FROM I_InspectionLot AS _InspectionLot
INNER JOIN I_InspectionOperation AS _InspOperation ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspOperationAggregate AS _InspOperationAggregate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspOperationUsageDecision AS _InspOperationUsageDecision ON _InspOperation.InspectionLot = _InspOperationUsageDecision.InspectionLot AND _InspOperation.InspPlanOperationInternalID = _InspOperationUsageDecision.InspPlanOperationInternalID AND InspLotStatusCanceled.InspLotStatusCanceled = ''  -- association [1..1]
LEFT OUTER JOIN C_InspLotOpUnplndCharcRsltRecg AS _UnplannedChar ON Plant = _UnplannedChar.InspectionSpecificationPlant  -- association [0..*]
LEFT OUTER JOIN C_InspLotOpCharcRsltRecg AS _InspChar ON /* condition not available in parsed metadata */  -- association [0..*]
;