I_QltyTaskFllwUpActionParamTP

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 I_QltyTaskFllwUpActionParamTP.
-- 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 I_QltyTaskFllwUpActionParamTP AS
SELECT
  QualityTaskInternalId,
  ItemCounter,
  QualityTask,
  QltyTaskFllwUpActionParam,
  QltyTskFllwUpActnParamType,
  DefectiveQuantity,
  DefectiveQuantityUnit,
  Material,
  Plant,
  StorageLocation,
  DefectAffectedObject,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsVersion,
  OrderInternalID,
  OrderOperationInternalID,
  _OrderInternalID.OrderID AS OrderID,
  cast(_OrderOperationBasic.Operation as mpe_vornr preserving type ) AS Operation,
  MfgReworkRoutingGroup,
  MfgReworkRoutingVariant,
  MfgNonConformanceRsnCodeCtlg,
  MfgNonConformanceRsnCodeGrp,
  MfgNonConformanceReasonCode,
  MfgNonConformanceNote,
  ChangeRecord,
  ChangeRecordType,
  ChgRecordDescriptionText,
  ProductionSupplyArea,
  CostCenter,
  SourceStorageBin,
  DefectUUID,
  StockItemUUID,
  ParentHandlingUnitUUID,
  QltyTaskStkSelInEWMIsProcd,
  DefectAffectedObjIsAddlParam,
  Batch,
  EWMWarehouse,
  QltyTaskEWMFollowUpAction,
  WarehouseLogicalSystem
FROM I_QltyTaskFllwUpActionParam
LEFT OUTER JOIN I_QualityTaskTP AS _QualityTaskTP ON QualityTaskInternalId = _QualityTaskTP.QualityTaskInternalId  -- association [1..1]
LEFT OUTER JOIN E_QltyTskFllwUpActnParam AS _Extension ON QualityTaskInternalId = _Extension.QualityNotification AND _Extension.QualityNotificationTask = '0000' AND ItemCounter = _Extension.ItemCounter  -- association [1..1]
;