P_InspLotResultRecording

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 P_InspLotResultRecording.
-- 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: PINSPLOTRESREC
-- Parameters: P_endDate : abap.dats

CREATE VIEW P_InspLotResultRecording AS
SELECT
  _InspectionLot.InspectionLot AS InspectionLot,
  _InspectionLot.InspectionLotEndDate AS InspectionLotEndDate,
  _InspectionLot.Plant AS Plant,
  _InspectionLot.InspectionLotOrigin AS InspectionLotOrigin,
  _InspectionLot.InspectionLotType AS InspectionLotType,
  _InspectionLot.Material AS Material,
  _InspectionLot.InspectionLotStorageLocation AS InspectionLotStorageLocation,
  _InspectionLot.BatchStorageLocation AS BatchStorageLocation,
  _InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _InspectionLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _InspectionLot.Supplier AS Supplier,
  _InspectionLot.Manufacturer AS Manufacturer,
  _InspectionLot.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  _InspectionLot.PurchasingOrganization AS PurchasingOrganization,
  cast( _InspectionLot.InspectionLotHasQuantity as xfeld ) AS InspectionLotHasQuantity,
  _InspectionLot.Customer AS Customer,
  _InspectionLot.SoldToParty AS SoldToParty,
  _InspectionLot.SalesOrganization AS SalesOrganization,
  cast('' as abap.char( 1 )) AS InspectionLotHasUsageDecision,
  cast('' as abap.char( 1 )) AS InspLotIsTaskListRequired,
  cast('' as abap.char( 1 )) AS InspLotHasMaterialSpec,
  cast(_InspectionLot.InspLotNmbrOpenLongTermCharc as abap.char( 6 )) AS InspLotNmbrOpenLongTermCharc,
  _InspectionLot.InspLotUsageDecisionValuation AS InspLotUsageDecisionValuation
LEFT OUTER JOIN I_InspLotEndDateGrp AS _InspLotEndDateGrp ON InspLotEndDateGrp = _InspLotEndDateGrp.InspLotEndDateGrp  -- association [1..1]
LEFT OUTER JOIN I_InspectionLotWithStatus AS _InspectionLotWithStatus ON InspectionLot = _InspectionLotWithStatus.InspectionLot  -- association [1..1]
;