C_DfctRecdAvailSerialNumberVH

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_DfctRecdAvailSerialNumberVH.
-- 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_DfctRecdAvailSerialNumberVH AS
SELECT
  SerialNumber,
  InspectionLot,
  MaintenanceItemObjectList,
  MaintenanceItemObject,
  cast (' ' as manufacturingorder preserving type ) AS ManufacturingOrder,
  cast ('0000' as manufacturingorderitem preserving type ) AS ManufacturingOrderItem,
  cast (' ' as matnr preserving type ) AS Material,
  cast ('00' as manufacturingordercategory preserving type ) AS ManufacturingOrderCategory,
  cast (' ' as manufacturingordertype preserving type ) AS ManufacturingOrderType,
  cast (' ' as pwwrk preserving type ) AS ProductionPlant,
  cast (' ' as werks_d preserving type ) AS Plant,
  cast (' ' as charg_d preserving type ) AS Batch,
  cast (' ' as bukrs preserving type ) AS CompanyCode,
  cast ('I' as qdefsernumorigin preserving type ) AS DefectSerialNumberOrigin
FROM I_InspLotSerialNumber_2
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [0..1]
-- UNION with additional select branch(es): I_MfgOrderItemSerialNumber, I_EquipMatlSerialNumber
;