C_InspectionLotQltyScore

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_InspectionLotQltyScore.
-- 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.
-- Parameters: hidden : true, P_StartDate : mm_a_delivery_date, hidden : true, P_EndDate : mm_a_delivery_date, P_DateFunction : vdm_qvedatum_dfid

CREATE VIEW C_InspectionLotQltyScore AS
SELECT
  hidden: true AS hiddentrueP_StartDatemm_a_delivery_date,
  hidden: true AS hiddentrueP_EndDatemm_a_delivery_date,
  valueHelpDefinition: [ { entity: { name: 'C_GregorianCalDateFuncVH', element: 'DateFunction' AS P_StartDate,
  InspectionLotType,
  _InspectionLotTypeText[1:Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  Material,
  _MaterialText[1:Language=$session.system_language].MaterialName AS MaterialName,
  Plant,
  _Plant.PlantName AS PlantName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  Customer,
  _Customer.CustomerFullName AS CustomerFullName,
  Manufacturer,
  _Manufacturer.SupplierName AS ManufacturerName,
  InspectionLotOrigin,
  InspectionLotCreatedOn,
  InspectionLotUsageDecidedOn,
  cast( InspectionLotQualityScore as vdm_qkennzahl ) AS MeanQualityScore,
  cast( _CalDteInspLotCrtedOn.CalendarQuarter as vdm_qminsplotcrtedqtr preserving type ) AS InspectionLotCreatedOnQuarter,
  _CalDteInspLotCrtedOn._CalendarQuarter._Text[1:Language=$session.system_language].CalendarQuarterName AS InspectionLotCreatedOnQtrName,
  cast( _CalDteInspLotCrtedOn.CalendarMonth as vdm_qminsplotcrtedmnth preserving type ) AS InspectionLotCreatedOnMonth,
  _CalDteInspLotCrtedOn._CalendarMonth._Text[1:Language=$session.system_language].CalendarMonthName AS InspectionLotCreatedOnMnthName,
  cast( _CalDteInspLotCrtedOn.CalendarWeek as vdm_qminsplotcrtedwk preserving type ) AS InspectionLotCreatedOnWeek,
  cast( _CalDteInspLotUsageDecidedOn.CalendarQuarter as vdm_qminsplotusgdcsnqtr preserving type ) AS InspLotUsgeDecidedOnQuarter,
  _CalDteInspLotUsageDecidedOn._CalendarQuarter._Text[1:Language=$session.system_language].CalendarQuarterName AS InspLotUsgeDecidedOnQtrName,
  cast( _CalDteInspLotUsageDecidedOn.CalendarMonth as vdm_qminsplotusgdcsnmnth preserving type ) AS InspLotUsgeDecidedOnMonth,
  _CalDteInspLotUsageDecidedOn._CalendarMonth._Text[1:Language=$session.system_language].CalendarMonthName AS InspLotUsgeDecidedOnMnthName,
  cast( _CalDteInspLotUsageDecidedOn.CalendarWeek as vdm_qminsplotusgdcsnwk preserving type ) AS InspLotUsgeDecidedOnWeek,
  IsBusinessPurposeCompleted
FROM I_InspectionLotQltyScoreCube
LEFT OUTER JOIN I_CalendarDate AS _CalDteInspLotCrtedOn ON InspectionLotCreatedOn = _CalDteInspLotCrtedOn.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _CalDteInspLotUsageDecidedOn ON InspectionLotUsageDecidedOn = _CalDteInspLotUsageDecidedOn.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_InspectionLotTypeText AS _InspectionLotTypeText ON InspectionLotType = _InspectionLotTypeText.InspectionLotType  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..1]
;