I_QltyTaskFllwUpActionParam

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_QltyTaskFllwUpActionParam.
-- 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: IQLTYTSKFOAPRM

CREATE VIEW I_QltyTaskFllwUpActionParam AS
SELECT
  cast( qmsm_foa_param.qmnum as qtaskinternalid preserving type ) AS QualityTaskInternalId,
  qmsm_foa_param.counter AS ItemCounter,
  cast( substring(qmsm_foa_param.qmnum,2,11) as qtaskid preserving type ) AS QualityTask,
  qmsm_foa_param.counter AS QltyTaskFllwUpActionParam,
  qmsm_foa_param.paramtype AS QltyTskFllwUpActnParamType,
  qmsm_foa_param.menge AS DefectiveQuantity,
  qmsm_foa_param.mgein AS DefectiveQuantityUnit,
  qmsm_foa_param.matnr AS Material,
  qmsm_foa_param.werks AS Plant,
  qmsm_foa_param.lgort AS StorageLocation,
  qmsm_foa_param.affctd_obj_counter AS DefectAffectedObject,
  qmsm_foa_param.plnty AS BillOfOperationsType,
  qmsm_foa_param.plnnr AS BillOfOperationsGroup,
  qmsm_foa_param.plnal AS BillOfOperationsVariant,
  qmsm_foa_param.plnversn AS BillOfOperationsVersion,
  qmsm_foa_param.aufpl AS OrderInternalID,
  qmsm_foa_param.aplzl AS OrderOperationInternalID,
  qmsm_foa_param.mfgrewrkroutplnnr AS MfgReworkRoutingGroup,
  qmsm_foa_param.mfgrewrkroutplnal AS MfgReworkRoutingVariant,
  qmsm_foa_param.mpe_nc_rsn_code_ctlg AS MfgNonConformanceRsnCodeCtlg,
  qmsm_foa_param.mpe_nc_rsn_code_grp AS MfgNonConformanceRsnCodeGrp,
  qmsm_foa_param.mpe_nc_rsn_code AS MfgNonConformanceReasonCode,
  qmsm_foa_param.mpe_nc_note AS MfgNonConformanceNote,
  qmsm_foa_param.chg_rec_id AS ChangeRecord,
  qmsm_foa_param.chg_rec_type AS ChangeRecordType,
  qmsm_foa_param.chg_rec_desc AS ChgRecordDescriptionText,
  qmsm_foa_param.prvbe AS ProductionSupplyArea,
  qmsm_foa_param.kostl AS CostCenter,
  qmsm_foa_param.vlpla AS SourceStorageBin,
  qmsm_foa_param.defectuuid AS DefectUUID,
  qmsm_foa_param.ewm_guid_stock AS StockItemUUID,
  qmsm_foa_param.ewm_guid_parent AS ParentHandlingUnitUUID,
  qmsm_foa_param.ewm_stock_sel_is_proc AS QltyTaskStkSelInEWMIsProcd,
  qmsm_foa_param.def_aff_obj_is_add_param AS DefectAffectedObjIsAddlParam,
  qmsm_foa_param.batch AS Batch,
  qmsm_foa_param.lgnum AS EWMWarehouse,
  qmsm_foa_param.ewm_followup_action AS QltyTaskEWMFollowUpAction,
  qmsm_foa_param.warehouselogicalsystem AS WarehouseLogicalSystem
FROM qmsm_foa_param
LEFT OUTER JOIN I_QualityTask AS _QualityTask ON QualityTaskInternalId = _QualityTask.QualityTaskInternalId  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID AND OrderInternalID <> '0000000000'  -- association [0..1]
LEFT OUTER JOIN I_OrderOperationBasic AS _OrderOperationBasic ON OrderInternalID = _OrderOperationBasic.OrderInternalID AND OrderOperationInternalID = _OrderOperationBasic.OrderOperationInternalID AND OrderInternalID <> '0000000000'  -- association [0..1]
LEFT OUTER JOIN I_MfgActionReasonCodeGroup AS _MfgActionReasonCodeGroup ON MfgNonConformanceRsnCodeCtlg = _MfgActionReasonCodeGroup.MfgActionReasonCodeGroupCtlg AND MfgNonConformanceRsnCodeGrp = _MfgActionReasonCodeGroup.MfgActionReasonCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_MfgActionReasonCode AS _MfgActionReasonCode ON MfgNonConformanceRsnCodeCtlg = _MfgActionReasonCode.MfgActionReasonCodeGroupCtlg AND MfgNonConformanceRsnCodeGrp = _MfgActionReasonCode.MfgActionReasonCodeGroup AND MfgNonConformanceReasonCode = _MfgActionReasonCode.ManufacturingActionReasonCode AND _MfgActionReasonCode.Version = '0000'  -- association [0..1]
LEFT OUTER JOIN I_ChangeRecordBsc AS _ChangeRecordBsc ON ChangeRecord = _ChangeRecordBsc.ChangeRecord AND ChangeRecordType = _ChangeRecordBsc.ChangeRecordType  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _ProductionSupplyArea ON ProductionSupplyArea = _ProductionSupplyArea.ProductionSupplyArea AND Plant = _ProductionSupplyArea.Plant  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseNumber AS _EWM_WarehouseNumber ON EWMWarehouse = _EWM_WarehouseNumber.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON DefectiveQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN E_QltyTskFllwUpActnParam AS _Extension ON QualityTaskInternalId = _Extension.QualityNotification AND _Extension.QualityNotificationTask = '0000' AND ItemCounter = _Extension.ItemCounter  -- association [1..1]
;